Home

Filer ID: 1285451

Table: cvr_lobby_disclosure
filing_id   1284613   1189392   1235337   1262446   1214883   1349221   1330124   1298005   1312434   1377553   1453210   1437768   1422015   1397928   1422015   1508559   1485636   1464890   1569525   1540961   1609024   1622971   1592070   1635808   1708452   1677817   1657621   1739334   1765883   1765883   1782863   1765883   1815948   1801267   1801267   1845649   1868433   1765883   1911016   1845649   1964255   1964255   1982142   1933787   1997199   2062275   2037548   2037548   2010728   2102222   2037548   2157988   2175160   2157988   2128125   2275691   2193363   2210385   2157988   2241853   2381071   2346348   2320816   2443246   2419051   2399121   2470527   2554820   2484603   2531023   2580132   2601183   2625120   2707183   2643517   2677676   2748107
amend_id   0   0   0   0   0   0   0   0   0   0   0   0   0   0   1   0   0   0   0   0   0   0   0   0   0   0   0   0   1   2   0   0   0   1   0   0   0   3   0   1   0   1   0   0   0   0   0   1   0   0   2   1   0   0   0   0   0   0   2   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0
rec_type   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR
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
sender_id   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451
filer_id   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451
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
filer_naml   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000
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
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
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
report_num   000   000   000   000   000   000   000   000   000   000   000   000   000   000   001   000   000   000   000   000   000   000   000   000   000   000   000   000   001   002   000   000   000   001   000   000   000   003   000   001   000   001   000   000   000   000   000   001   000   000   002   001   000   000   000   000   000   000   002   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000
rpt_date   2007-07-31 00:00:00   2006-07-28 00:00:00   2007-01-30 00:00:00   2007-04-30 00:00:00   2006-10-30 00:00:00   2008-07-30 00:00:00   2008-04-30 00:00:00   2007-10-31 00:00:00   2008-01-31 00:00:00   2008-10-31 00:00:00   2009-11-02 00:00:00   2009-07-31 00:00:00   2009-04-30 00:00:00   2009-02-02 00:00:00   2009-06-08 00:00:00   2010-08-02 00:00:00   2010-04-30 00:00:00   2010-02-01 00:00:00   2010-01-01 00:00:00   2010-11-01 00:00:00   2011-08-01 00:00:00   2011-10-31 00:00:00   2011-05-02 00:00:00   2012-01-31 00:00:00   2012-10-31 00:00:00   2012-07-30 00:00:00   2012-04-30 00:00:00   2013-01-31 00:00:00   2013-07-11 00:00:00   2013-07-12 00:00:00   2013-07-19 00:00:00   2013-04-29 00:00:00   2014-01-27 00:00:00   2014-01-23 00:00:00   2013-10-30 00:00:00   2014-04-29 00:00:00   2014-07-25 00:00:00   2014-04-01 00:00:00   2014-10-30 00:00:00   2014-11-17 00:00:00   2015-04-28 00:00:00   2015-05-28 00:00:00   2015-07-30 00:00:00   2015-01-28 00:00:00   2015-10-28 00:00:00   2016-07-29 00:00:00   2016-05-02 00:00:00   2016-06-20 00:00:00   2016-01-28 00:00:00   2016-10-31 00:00:00   2017-03-21 00:00:00   2017-05-31 00:00:00   2017-07-28 00:00:00   2017-05-01 00:00:00   2017-01-30 00:00:00   2018-07-26 00:00:00   2017-10-30 00:00:00   2018-01-30 00:00:00   2017-12-13 00:00:00   2018-04-30 00:00:00   2019-04-26 00:00:00   2019-01-28 00:00:00   2018-10-31 00:00:00   2020-01-31 00:00:00   2019-10-30 00:00:00   2019-07-30 00:00:00   2020-04-23 00:00:00   2021-02-01 00:00:00   2020-07-29 00:00:00   2020-11-02 00:00:00   2021-04-30 00:00:00   2021-07-28 00:00:00   2021-11-01 00:00:00   2022-08-01 00:00:00   2022-01-28 00:00:00   2022-05-02 00:00:00   2022-10-31 00:00:00
from_date   2007-04-01 00:00:00   2006-04-01 00:00:00   2006-10-01 00:00:00   2007-01-01 00:00:00   2006-07-01 00:00:00   2008-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-07-01 00:00:00   2009-04-01 00:00:00   2009-01-01 00:00:00   2008-10-01 00:00:00   2009-01-01 00:00:00   2010-04-01 00:00:00   2010-01-01 00:00:00   2009-10-01 00:00:00   2010-10-01 00:00:00   2010-07-01 00:00:00   2011-04-01 00:00:00   2011-07-01 00:00:00   2011-01-01 00:00:00   2011-10-01 00:00:00   2012-07-01 00:00:00   2012-04-01 00:00:00   2012-01-01 00:00:00   2012-10-01 00:00:00   2013-01-01 00:00:00   2013-01-01 00:00:00   2013-04-01 00:00:00   2013-01-01 00:00:00   2013-10-01 00:00:00   2013-07-01 00:00:00   2013-07-01 00:00:00   2014-01-01 00:00:00   2014-04-01 00:00:00   2013-01-01 00:00:00   2014-07-01 00:00:00   2014-01-01 00:00:00   2015-01-01 00:00:00   2015-01-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   2016-01-01 00:00:00   2015-10-01 00:00:00   2016-07-01 00:00:00   2016-01-01 00:00:00   2017-01-01 00:00:00   2017-04-01 00:00:00   2017-01-01 00:00:00   2016-10-01 00:00:00   2018-04-01 00:00:00   2017-07-01 00:00:00   2017-10-01 00:00:00   2017-01-01 00:00:00   2018-01-01 00:00:00   2019-01-01 00:00:00   2018-10-01 00:00:00   2018-07-01 00:00:00   2019-10-01 00:00:00   2019-07-01 00:00:00   2019-04-01 00:00:00   2020-01-01 00:00:00   2020-10-01 00:00:00   2020-04-01 00:00:00   2020-07-01 00:00:00   2021-01-01 00:00:00   2021-04-01 00:00:00   2021-07-01 00:00:00   2022-04-01 00:00:00   2021-10-01 00:00:00   2022-01-01 00:00:00   2022-07-01 00:00:00
thru_date   2007-06-30 00:00:00   2006-06-30 00:00:00   2006-12-31 00:00:00   2007-03-31 00:00:00   2006-09-30 00:00:00   2008-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-09-30 00:00:00   2009-06-30 00:00:00   2009-03-31 00:00:00   2008-12-31 00:00:00   2009-03-31 00:00:00   2010-06-30 00:00:00   2010-03-31 00:00:00   2009-12-31 00:00:00   2010-12-31 00:00:00   2010-09-30 00:00:00   2011-06-30 00:00:00   2011-09-30 00:00:00   2011-03-31 00:00:00   2011-12-31 00:00:00   2012-09-30 00:00:00   2012-06-30 00:00:00   2012-03-31 00:00:00   2012-12-31 00:00:00   2013-03-31 00:00:00   2013-03-31 00:00:00   2013-06-30 00:00:00   2013-03-31 00:00:00   2013-12-31 00:00:00   2013-09-30 00:00:00   2013-09-30 00:00:00   2014-03-31 00:00:00   2014-06-30 00:00:00   2013-03-31 00:00:00   2014-09-30 00:00:00   2014-03-31 00:00:00   2015-03-31 00:00:00   2015-03-31 00:00:00   2015-06-30 00:00:00   2014-12-31 00:00:00   2015-09-30 00:00:00   2016-06-30 00:00:00   2016-03-31 00:00:00   2016-03-31 00:00:00   2015-12-31 00:00:00   2016-09-30 00:00:00   2016-03-31 00:00:00   2017-03-31 00:00:00   2017-06-30 00:00:00   2017-03-31 00:00:00   2016-12-31 00:00:00   2018-06-30 00:00:00   2017-09-30 00:00:00   2017-12-31 00:00:00   2017-03-31 00:00:00   2018-03-31 00:00:00   2019-03-31 00:00:00   2018-12-31 00:00:00   2018-09-30 00:00:00   2019-12-31 00:00:00   2019-09-30 00:00:00   2019-06-30 00:00:00   2020-03-31 00:00:00   2020-12-31 00:00:00   2020-06-30 00:00:00   2020-09-30 00:00:00   2021-03-31 00:00:00   2021-06-30 00:00:00   2021-09-30 00:00:00   2022-06-30 00:00:00   2021-12-31 00:00:00   2022-03-31 00:00:00   2022-09-30 00:00:00
cum_beg_dt   2007-01-01 00:00:00   2006-04-01 00:00:00   2006-04-01 00:00:00   2007-01-01 00:00:00   2006-04-01 00:00:00   2007-01-01 00:00:00   2007-01-01 00:00:00   2007-01-01 00:00:00   2007-01-01 00:00:00   2007-01-01 00:00:00   2009-01-01 00:00:00   2009-01-01 00:00:00   2009-01-01 00:00:00   2007-01-01 00:00:00   2009-01-01 00:00:00   2009-01-01 00:00:00   2009-01-01 00:00:00   2009-01-01 00:00:00   2009-01-01 00:00:00   2009-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   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   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   2015-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   2017-01-01 00:00:00   2017-01-01 00:00:00   2017-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   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   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   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   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451
firm_name   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000
firm_city   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento
firm_st   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA
firm_zip4   95816   95814   95814   95816   95814   95816   95816   95816   95816   95816   95816   95816   95816   95816   95816   95816   95816   95816   95816   95816   95816   95816   95816   95816   95816   95816   95816   95816   95811   95811   95811   95811   95811   95811   95811   95811   95811   95811   95811   95811   95811   95811   95811   95811   95811   95811   95811   95811   95811   95811   95811   95811   95811   95811   95811   95811   95811   95811   95811   95811   95811   95811   95811   95811   95811   95811   95811   95811   95811   95811   95811   95811   95811   95811   95811   95811   95811
firm_phon   (916) 554-1234   (916) 552-5581   (916) 552-5581   (916) 554-1234   (916) 552-5581   (916) 554-1234   (916) 554-1234   (916) 554-1234   (916) 554-1234   (916) 554-1234   (916) 554-1234   (916) 554-1234   (916) 554-1234   (916) 554-1234   (916) 554-1234   (916) 554-1234   (916) 554-1234   (916) 554-1234   (916) 554-1234   (916) 554-1234   (916) 554-1234   (916) 554-1234   (916) 554-1234   (916) 554-1234   (916) 554-1234   (916) 554-1234   (916) 554-1234   (916) 554-1234   916 554-1234   916 554-1234   916 554-1234   916 554-1234   916 554-1234   916 554-1234   916 554-1234   916 554-1234   916 554-1234   916 554-1234   916 554-1234   916 554-1234   (866) 471-7348   (866) 471-7348   (866) 471-7348   (866) 471-7348   (866) 471-7348   (866) 471-7348   (866) 471-7348   (866) 471-7348   (866) 471-7348   (866) 471-7348   (866) 471-7348   (866) 471-7348   (866) 471-7348   (866) 471-7348   (866) 471-7348   (866) 471-7348   (866) 471-7348   (866) 471-7348   (866) 471-7348   (866) 471-7348   (866) 471-7348   (866) 471-7348   (866) 471-7348   (866) 471-7348   (866) 471-7348   (866) 471-7348   (866) 471-7348   (866) 471-7348   (866) 471-7348   (866) 471-7348   (866) 471-7348   (866) 471-7348   (866) 471-7348   (866) 471-7348   (866) 471-7348   (866) 471-7348   (866) 471-7348
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
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
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
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
sig_date   2007-07-31 00:00:00   2006-07-25 00:00:00   2007-01-30 00:00:00   2007-04-30 00:00:00   2006-10-20 00:00:00   2008-07-29 00:00:00   2008-04-30 00:00:00   2007-10-31 00:00:00   2008-01-31 00:00:00   2008-10-30 00:00:00   2009-11-02 00:00:00   2009-07-31 00:00:00   2009-04-30 00:00:00   2009-02-02 00:00:00   2009-03-30 00:00:00   2010-08-02 00:00:00   2010-04-30 00:00:00   2010-02-01 00:00:00   2010-01-28 00:00:00   2010-10-30 00:00:00   2011-08-01 00:00:00   2011-10-31 00:00:00   2011-05-02 00:00:00   2012-01-31 00:00:00   2012-10-30 00:00:00   2012-07-27 00:00:00   2012-04-30 00:00:00   2013-01-30 00:00:00   2013-04-29 00:00:00   2013-04-29 00:00:00   2013-07-19 00:00:00   2013-04-29 00:00:00   2014-01-27 00:00:00   2013-10-30 00:00:00   2013-10-30 00:00:00   2014-04-29 00:00:00   2014-07-25 00:00:00   2014-03-28 00:00:00   2014-10-30 00:00:00   2014-11-17 00:00:00   2015-04-28 00:00:00   2015-04-28 00:00:00   2015-07-30 00:00:00   2015-01-28 00:00:00   2015-10-28 00:00:00   2016-07-29 00:00:00   2016-05-02 00:00:00   2016-06-20 00:00:00   2016-01-28 00:00:00   2016-10-31 00:00:00   2017-03-21 00:00:00   2017-05-31 00:00:00   2017-07-28 00:00:00   2017-05-01 00:00:00   2017-01-30 00:00:00   2018-07-26 00:00:00   2017-10-30 00:00:00   2018-01-30 00:00:00   2017-12-13 00:00:00   2018-04-30 00:00:00   2019-04-26 00:00:00   2019-01-28 00:00:00   2018-10-31 00:00:00   2020-01-28 00:00:00   2019-10-28 00:00:00   2019-07-30 00:00:00   2020-04-23 00:00:00   2021-02-01 00:00:00   2020-07-29 00:00:00   2020-11-02 00:00:00   2021-04-30 00:00:00   2021-07-28 00:00:00   2021-11-01 00:00:00   2022-08-01 00:00:00   2022-01-28 00:00:00   2022-05-02 00:00:00   2022-10-31 00:00:00
sig_loc   Sacramento, CA   Sacramento, CA   Sacramento, CA   Sacramento, CA   Sacramento, CA   Sacramento, CA   Sacramento, CA   Sacramento, CA   Sacramento, CA   Sacramento, CA   Sacramento, CA   Sacramento, CA   Sacramento, CA   Sacramento, CA   Sacramento, CA   Sacramento, CA   Sacramento, CA   Sacramento, CA   Sacramento, CA   Sacramento, CA   Sacramento, CA   Sacramento, CA   Sacramento, CA   Sacramento, CA   Sacramento, CA   Sacramento, CA   Sacramento, CA   Sacramento, CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA
sig_naml   Chung   Zimmerman   Zimmerman   Chung   Zimmerman   Baratz   Zimmerman   Baratz   Zimmerman   Zimmerman   Zimmerman   Zimmerman   Zimmerman   Zimmerman   Zimmerman   Zimmerman   Zimmerman   Zimmerman   Zimmerman   Zimmerman   Zimmerman   Zimmerman   Zimmerman   Zimmerman   Zimmerman   Zimmerman   Zimmerman   Zimmerman   Zimmerman   Zimmerman   Zimmerman   Zimmerman   Zimmerman   Zimmerman   Zimmerman   Schmidt   Schmidt   Schmidt   Schmidt   Schmidt   Schmidt   Schmidt   Schmidt   Schmidt   Hernandez   Hernandez   Hernandez   Hernandez   Hernandez   Hernandez   Hernandez   Hernandez   Hernandez   Hernandez   Hernandez   Hernandez   Hernandez   Hernandez   Hernandez   Hernandez   Schmidt   Hernandez   Hernandez   Farias Womack   Farias Womack   Hernandez   Farias Womack   Lopez   Farias Womack   Lopez   Lopez   Lopez   Brewer   Brewer   Brewer   Brewer   Brewer-Gonzalez
sig_namf   Candice   Sarah   Sarah   Candice   Sarah   Michael   Sarah   Michael   Sarah   Sarah   Sarah   Sarah   Sarah   Sarah   Sarah   Sarah   Sarah   Sarah   Sarah   Sarah   Sarah   Sarah   Sarah   Sarah   Sarah   Sarah   Sarah   Sarah   Sarah   Sarah   Sarah   Sarah   Sarah   Sarah   Sarah   Steve   Steve   Steve   Steve   Steve   Steve   Steve   Steve   Steve   Mary   Mary   Mary   Mary   Mary   Mary   Mary   Mary   Mary   Mary   Mary   Mary   Mary   Mary   Mary   Mary   Steve   Mary   Mary   Nancy   Nancy   Mary   Nancy   Deema   Nancy   Deema   Deema   Deema   Omega   Omega   Omega   Omega   Omega
sig_namt   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
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
prn_naml   Chung   Zimmerman   Zimmerman   Chung   Zimmerman   Baratz   Zimmerman   Baratz   Zimmerman   Zimmerman   Zimmerman   Zimmerman   Zimmerman   Zimmerman   Zimmerman   Zimmerman   Zimmerman   Zimmerman   Zimmerman   Zimmerman   Zimmerman   Zimmerman   Zimmerman   Zimmerman   Zimmerman   Zimmerman   Zimmerman   Zimmerman   Zimmerman   Zimmerman   Zimmerman   Zimmerman   Zimmerman   Zimmerman   Zimmerman   Schmidt   Schmidt   Schmidt   Schmidt   Schmidt   Schmidt   Schmidt   Schmidt   Schmidt   Hernandez   Hernandez   Hernandez   Hernandez   Hernandez   Hernandez   Hernandez   Hernandez   Hernandez   Hernandez   Hernandez   Hernandez   Hernandez   Hernandez   Hernandez   Hernandez   Schmidt   Hernandez   Hernandez   Farias Womack   Farias Womack   Hernandez   Farias Womack   Lopez   Farias Womack   Lopez   Lopez   Lopez   Brewer   Brewer   Brewer   Brewer   Brewer-Gonzalez
prn_namf   Candice   Sarah   Sarah   Candice   Sarah   Michael   Sarah   Michael   Sarah   Sarah   Sarah   Sarah   Sarah   Sarah   Sarah   Sarah   Sarah   Sarah   Sarah   Sarah   Sarah   Sarah   Sarah   Sarah   Sarah   Sarah   Sarah   Sarah   Sarah   Sarah   Sarah   Sarah   Sarah   Sarah   Sarah   Steve   Steve   Steve   Steve   Steve   Steve   Steve   Steve   Steve   Mary   Mary   Mary   Mary   Mary   Mary   Mary   Mary   Mary   Mary   Mary   Mary   Mary   Mary   Mary   Mary   Steve   Mary   Mary   Nancy   Nancy   Mary   Nancy   Deema   Nancy   Deema   Deema   Deema   Omega   Omega   Omega   Omega   Omega
prn_namt   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
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
sig_title   Lobbyist   Director of Research & Government Affairs   Director of Research & Government Affairs   Lobbyist   Director of Research & Government Affairs   None   Deputy Chief of Staff   None   Deputy Chief of Staff   Deputy Chief of Staff   Deputy Chief of Staff   Deputy Chief of Staff   Deputy Chief of Staff   Deputy Chief of Staff   Deputy Chief of Staff   Deputy Chief of Staff   Deputy Chief of Staff   Deputy Chief of Staff   Deputy Chief of Staff   Deputy Chief of Staff   Deputy Chief of Staff   Deputy Chief of Staff   Deputy Chief of Staff   Deputy Chief of Staff   Deputy Chief of Staff   Deputy Chief of Staff   Deputy Chief of Staff   Deputy Chief of Staff   Deputy Chief of Staff   Deputy Chief of Staff   Deputy Chief of Staff   Deputy Chief of Staff   Deputy Chief of Staff   Deputy Chief of Staff   Deputy Chief of Staff   Controller   Controller   Controller   Controller   Controller   Controller   Controller   Controller   Controller   Government Relations Deputy Chief of Staff   Government Relations Deputy Chief of Staff   Government Relations Deputy Chief of Staff   Government Relations Deputy Chief of Staff   Government Relations Deputy Chief of Staff   Government Relations Deputy Chief of Staff   Government Relations Deputy Chief of Staff   Government Relations Deputy Chief of Staff   Government Relations Deputy Chief of Staff   Government Relations Deputy Chief of Staff   Government Relations Deputy Chief of Staff   Deputy Chief of Staff Government Affairs   Deputy Chief of Staff Government Affairs   Deputy Chief of Staff Government Affairs   Deputy Chief of Staff Government Affairs   Deputy Chief of Staff Government Affairs   Controller   Executive Director   Deputy Chief of Staff Government Affairs   Director of Government Relations   Director of Government Relations   Executive Director   Director of Government Relations   Director of Government Relations   Director of Government Relations   Director of Government Relations   Director of Government Relations   Director of Government Relations   Governmental Affairs Coordinator   Governmental Affairs Coordinator   Governmental Affairs Coordinator   Governmental Affairs Coordinator   Governmental Affairs Coordinator
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
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
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
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
ctrib_n_cb   None   None   X   None   None   None   None   None   None   None   None   None   X   None   X   None   None   None   None   None   None   X   None   None   None   None   None   None   X   None   None   None   None   X   X   None   None   None   None   None   None   None   None   None   X   None   None   None   None   None   None   X   None   X   None   None   None   None   X   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   X   None
ctrib_y_cb   X   X   None   X   X   X   X   X   X   X   X   X   None   X   None   X   X   X   X   X   X   None   X   X   X   X   X   X   None   X   X   X   X   None   None   X   X   X   X   X   X   X   X   X   None   X   X   X   X   X   X   None   X   None   X   X   X   X   None   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   None   X
lby_actvty   AB 76; SB 263; Legislature, Dept of Mental Health, Employment Development Agency, Dept of Development Services, CA Youth Authority, Dept Juvenile Justice, Dept of Justice, Dept of Motor Vehicles, Dept of Health Services: State Budget; CALPERS: Healthcare rates   AB 2066, 143, 583, 1801, 1802, 1803, 1804, 1805, 1806, 1807, 1808, 1809, 1811, 2025, 2902, 2782, 1880, 1369; SB 750, 162, 1734, 1541, 1207 803, 1589, 1132, 1137; CalPERS Bd of Administration: Proposed Board Action on Health Benefits; Dept of Insurance: Regulations re Auto Insurance Rating Factors   None.   AB 76, 77, 461, 735, 549, 510, 613, 1525, 507, 1212, 515, 537, 1296, 1523; SB 957, 174, 903, 175, 263, 823, 936, 727   AB 2066, 143, 583, 1801, 1802, 1803, 1804, 1805, 1806, 1807, 1808, 1809, 1811, 2025, 2902, 2782, 1880, 1369, 32, 861, 1369, 1708, 1796, 1897, 1922, 1951, 2016, 2068, 2125, 2241, 2308, 2543, 2703, 2782, 3041; SB 750, 162, 1734, 1541, 1207, 803, 1589, 1132, 1137, 293, 371, 1041, 1161, 1301, 1437, 1441, 1452, 1574, 1759; ABX2 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18;   AB 730, 865, 1029, 1779, 1831, 1843, 1874, 1958, 2202, 2567, 2600, 2603, 2635, 2746, 3034, 3040, 3041, 3042, 3043, 3045, 1829, 1840, 1925, 1956, 1965, 2461, 2727, 2914; ACR 104; SB 364, 110, 1115, 1145, 1158, 1183, 1331, 1472, 1656, 1679, 823, 1193, 1417, 1484, 1610; SCA 24; Legislature: tax gap, budget, nurse parity, CA Dept of Corrections & Rehabilitation librarians, (see memo)   ACR 104; AB 1831, 1840, 1843, 1925, 1956, 1965, 2461, 2600, 2603, 2727, 2746, 3040, 3041, 3042, 3043, 507, 531, 696, 730, 865, 1779, 1906, 2005, 1844, 1848, 1874, 2114, 2202, 2567, 2635; SB 1158, 1193, 1331, 1656, 1679, 364, 375, 1115, 1145, 1183, 1699; SJR 18; SCR 102; Legislature, Dept of Social Services, Dept of Health Services, Dept of Finance, Dept of Developmental Services, (see memo)   AB 754, 756, 8; SB 263, 81; Legislature, Dept of Mental Health, Employment Development Agency, Dept of Development Services, CA Youth Authority, Dept of Juvenile Justice, Dept of Justice, Dept of Motor Vehicles, Dept of Health Services: State Budget; CALPERS: Healthcare rates   AB 754, 756; Legislature, Dept of Social Services, Dept of Health Services, Dept of Finance, Dept of Developmental Services, CA Dept of Corrections and Rehabilitation, State Personnel Board, Dept of Personnel and Administration, Board of Equalization, CA Dept of Education, Legislative Analyst's Office: State Budget   AB 730, 865, 1029, 1656, 1829, 1831, 1840, 1844, 1874, 1925, 2600, 2603, 2746, 2914, 3040, 3041, 3042, 3043; ABX3, 22, 23; SB 110, 823, 1145, 1158, 1193, 1484, 1610, 1656, 1679, 1705; SCA 24; Legislature, Dept. of Social Services, Dept. of Health Services, Dept. of Finance, Dept. of Developmental Services, CA Dept. of Corrections and Rehabilitation, State Personnel Board, (See Memo)   AB 48, 88, 567, 755, 756, 964, 999, 1053, 1182, 1547, 22, 1447, 1117, 33, 266, 400, 402, 469, 484, 579, 759, 857, 930, 944, 966, 1125, 1329, 1557, 181, 1215; SB 441, 599, 220, 402, 570, 37, 257, 623, 641; ABX3 14; ABX4 12; SBX3 18; State Budget (see memo)   AB 43, 48, 266, 347, 400, 469, 484, 592, 755, 756, 759, 820, 857, 930, 944, 964, 999, 1053, 1117, 1125, 1266, 1289, 1362, 1447, 1547, 1557; SB 20, 37, 60, 220, 257, 292, 489, 570, 623, 738 (See Memo)   AB 48, 347, 592, 755, 756, 964, 489; SBX3 1, 2, 7, 8; ACAX3 1; SBX2 4; ABX2 8; State Budget; Dept. of Corrections & Rehabilitation: educational and rehabilitation issues; Dept. of Personnel Administration, Legislative Analyst's Office, Dept. of Finance: SEIU 1000 contracts; Legislature: disability determination services; Dept. of Motor Vehicles: equal rights issues; (see memo)   ABX1 3, 4, 5, 6, 7, 10, 12; SBX1 3, 4, 5, 6, 7, 9, 11; AB 730, 1029, 1831, 1840, 1925, 2603, 2914, 3040, 3041; ABX3 22, 23; SB 110, 823, 1158, 1193, 1484, 1610, 1679, 1705; SCA 24; Legislature, Dept. of Social Services, Dept. of Health Services, Dept. of Finance, Dept. of Developmental Services, CA Dept. of Corrections and Rehabilitation, State Personnel Board, (See Memo)   AB 48, 347, 592, 755, 756, 964, 489; SBX3 1, 2, 7, 8; ACAX3 1; SBX2 4; ABX2 8; State Budget; Dept. of Corrections & Rehabilitation: educational and rehabilitation issues; Dept. of Personnel Administration, Legislative Analyst's Office, Dept. of Finance: SEIU 1000 contracts; Legislature: disability determination services; Dept. of Motor Vehicles: equal rights issues; (see memo)   AB 552, 633, 999, 1239, 1678, 1785, 1889, 1899, 1900, 1961, 2262, 2290, 2326, 2372, 2438, 2459; SB 441, 962, 1067, 1130, 1147, 1266, 1399; Legislature: State Budget; Legislature, Governor's Office, Dept. of Finance, Dept. of Corrections and Rehabilitation, State Personnel Board, Dept. of Personnel Administration, CA Dept. of Education, Dept. of General Services, (see memo)   AB 2494, 1899, 1897, 1827, 2608, 964, 88, 1215, 48, 1125, 790, 1699, 2764, 2109, 1765, 2058, 1779, 1746, 1737, 1693, 2246, 1744, 1590, 142, 1590, 1703; SB 402, 55, 1055, 1425, 1262; SBX8 29; State Budget; Legislature: Governor's Executive Order on Furloughs and Pension reform issues; Joint Leg. Audit Cmte., Assembly Accountability & Administrative Review Cmte.: contracting out issues (see memo)   AB 48, 88, 181, 641, 964, 755, 756, 1125, 1215, 857; SB 55, 402, 599, 641; CalPERS: health care premiums, long term care premiums, pension reform; State Compensation Insurance Fund Board: furloughs, fiscal matters; State Personnel Board: visiting educators, state employee matters; Lottery Commission: state employee matters; Legislature: Veterans' affairs, lottery, pension reform, (See Memo)   AB 88, 151, 633, 790, 1130, 1239, 1602, 1699, 1760, 1765, 1799, 1889, 1827, 1897, 1899, 1900, 2008, 2048, 2058, 2143, 2290, 2326, 2372, 2494, 2608, 2109, 2764; SB 55, 837, 879, 900, 919, 962, 1005, 1067, 1055, 1020, 1266, 1399; SBX8 29; (see memo)   AB 48, 88, 151, 633, 790, 964, 999, 1125, 1130, 1140, 1215, 1239, 1602, 1625, 1699, 1760, 1765, 1779, 1827, 1889, 1897, 1899, 1900, 2008, 2048, 2058, 2109, 2143, 2262, 2290, 2326, 2372, 2494, 2605, 2608, 2764; SB 55, 402, 441, 837, 879, 900, 919, 962, 1005, 1020, 1055, 1067, 1130, 1266, 1399, 1425; SBX8 29;   AB 155, 166, 174, 200, 290, 294, 297, 314, 318, 324, 338, 342, 345, 352, 369, 371, 377, 381, 385, 386, 391, 393, 399, 400, 406, 407, 415, 423, 425, 427, 429, 448, 457, 471, 493, 500, 508, 509, 510, 514, 524, 528, 530, 535, 551, 554, 572, 632, 675, 774, 894, 917, 927, 951, 957, 958, 988, 991, 998, 1003, 1051, 1068, 1087, 1115, 1123, 1143, 1157, 1179, 1207, 1213, 1269, 1273, 1381, 1386; (see memo)   AB 8, 44, 52, 155, 166, 172, 174, 200, 202, 219, 290, 294, 297, 314, 318, 324, 338, 342, 345, 352, 366, 369, 371, 377, 381, 385, 386, 391, 393, 399, 400, 406, 407, 415, 420, 423, 425, 427, 429, 448, 457, 471, 493, 500, 508, 509, 510, 514, 524, 528, 530, 535, 551, 554, 568, 572, 632, 675, 727, 740, 774, 894, 917, 922, 927, 933, 951, 957, 958 988, 991, 998; (see memo)   AB 155, 166, 174, 200, 290, 294, 297, 314, 318, 324, 342, 345, 352, 369, 371, 377, 381, 385, 386, 391, 393, 399, 400, 406, 407, 415, 423, 425, 427, 429, 448, 457, 471, 493, 500, 508, 509, 510, 514, 524, 528, 530, 535, 551, 554, 572, 632, 675, 774, 894, 917, 927, 951, 957, 958, 988, 991, 998, 1003, 1051, 1068, 1087, 1115, 1123, 1143, 1157, 1179, 1207, 1213, 1269, 1273, 1381, 1386; (see memo)   AB 8, 92, 172, 202, 420, 568, 740; ABX1 17; SB 9, 14, 601, 700; Little Hoover Commission: Regulation and Energy Governance Studies and Reorganizations; High Speed Rail Commission: staffing plan/business plan; California Technology Agency: state budget and oversight issues; Joint Legislative Audit Committee and Employment Development Department: audits related to transportation; (see memo)   AB 340, 826, 1831, 2508, 2530; SB 9, 301, 863, 1062, 1121, 1148, 1234, 1318; CA Public Employees Retirement System Board: pernsion reform, transgender healthcare reform, responsible investment policy; State Compensation Insurance Board: re-organization, transparency, outsourcing, Mitchell contract; Board of Equalization: jobs (see memo)   AB 278, 378, 900, 1358, 1466, 1468, 1471, 1473, 1474, 1476, 1478, 1480, 1481, 1482, 1483, 1484, 1493, 1494, 1496, 1497, 1498, 1499, 1502, 1507, 1577, 1602, 1655, 1763, 1831, 1958, 2083, 2314, 2397, 2399, 2425, 2508, 2530, 2576, 2610; SB 9, 113, 252, 900, 1013, 1014, 1016, 1020, 1021, 1022, 1034, 1037, 1038, 1041, 1062, 1121, 1162, 1208, 1234, 1308, 1318, 1406, 1472, 1474, 1513; (see memo)   AB 1358, 1507, 1577, 1655, 1831, 2083, 2397, 2576; SB 9, 1062, 1121, 1162, 1234, 1308, 1309, 1318, 1406, 1513; Little Hoover Commission: Property Management and Community Colleges and Reorganizations; High Speed Rail Commission; California Technology Agency: state budget and oversight issues; (see memo)   AB 2508, 2530; SB 9, 1121; Legislature, Governor, Dept. of Finance, Dept. of Correction and Rehabilitation, CA Human Resources, State Personnel Board, Legislative Analyst Office, Health Exchange, Health and Human Services Agency, Managed Risk Medical Insurance Board: state budget, all state budget bills, educational and rehabilitation issues, Healthy Families, (see memo)   See attachment 'Part 1'   See attachment 'Part 1'   See attachment 'Part 1'   See attachment 'Part 1'   See attachment 'Part 1'   See attachment 'Part 1'   See attachment 'Part 1'   See attachment 'Part 1'   See attachment 'Part 1'   See attachment 'Part 1'   See attachment 'Part 1'   See attachment 'Part 1'   See attachment 'Part 1'   See attachment 'Part 1'   See attachment 'Part 1'   See attachment 'Part 1'   See attachment 'Part 1'   See attachment 'Part 1'   See attachment 'Part 1'   See attachment 'Part 1'   See attachment 'Part 1'   See attachment 'Part 1'   See attachment 'Part 1'   See attachment 'Part 1'   See attachment 'Part 1'   See attachment 'Part 1'   See attachment 'Part 1'   See attachment 'Part 1'   See attachment 'Part 1'   SB 716; CalPERS: health and pension benefits, outsourcing, discount rate and the asset liability management process; State Treasurer's Office: secure choice retirement board; State Bar: executive compensation.   See attachment 'Part 1'   See attachment 'Part 1'   See attachment 'Part 1'   See attachment 'Part 1'   See attachment 'Part 1'   See attachment 'Part 1'   See attachment 'Part 1'   See attachment 'Part 1'   See attachment 'Part 1'   Labor and Workforce Development Agency, Community College Chancellors Office, Health and Human Services Agency, California Department of Corrections and Rehabilitation, California Department of Education, Department of Consumer Affairs, Legislature; California Public Relations Board, Department of Industrial Relations, Governor's Office: Board Appointments.   See attachment 'Part 1'   See attachment 'Part 1'   AB 4, 1130; SB 56, 95, 211, 416, 692; Governor's Office: Center for Data Insights and Innovation, Cradle to Career, Board of Registered Nursing Appointment, Board of Vocational Nursing & Psychiatric Technicians, Office of Health Care Affordability, CalAIM.   AB 4, 105, 1130; SB 56, 211;Legislature: EDD Budget, EDD deferred/prospective workloads budget request; Office of Statewide Health planning and Development: Office of Health Care Affordability.   SB 211, 270; Legislature, Governor's Office: Hazard Pay, Sick Leave Extension; Governor's Office: state employee COVID-19 vaccine mandate; Department of Corrections and Rehabilitation: deactivation of Correctional Center in Susanville.   Senate Rules Committee Members in Support of the Confirmation of George Cardona as the Chief Trial Counsel to the State Bar of California.   Legislature: Telework and recognition pay.   California Department of Public Health funding as part of budget process.   AB 152, 158, 1655, 2011, 2596, 2958; SB: 136, 140.
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
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
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
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
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
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
rcpcmte_nm   Service Employees International Union Local 1000 Candidate PAC   Service Employees International Union Local 1000 Candidate PAC   None   None   Service Employees International Union Local 1000 Candidate PAC   Service Employees International Union Local 1000 Candidate PAC   Service Employees International Union Local 1000 Candidate PAC   Service Employees International Union Local 1000 Candidate PAC   Service Employees International Union Local 1000 Candidate PAC   Service Employees International Union Local 1000 Candidate PAC   None   Service Employees International Union Local 1000 Candidate PAC   None   Service Employees Internationl Union Local 1000 Candidate PAC   None   Service Employees International Union Local 1000 Candidate PAC   Service Employees International Union Local 1000 Candidate PAC   Service Employees International Union Local 1000 Candidate PAC   Service Employees International Union Local 1000 Candidate PAC   Service Employees International Union Local 1000 Candidate PAC   Service Employees International Union Local 1000 Candidate PAC   None   Service Employees International Union Local 1000 Candidate PAC   Service Employees International Union Local 1000 Candidate PAC   Service Employees International Union Local 1000 Candidate PAC   Service Employees International Union Local 1   Service Employees International Union Local 1000 Candidate PAC   SEIU Local 1000 Candidate PAC (1273063); SEIU Local 1000 Issues Account (1271482)   Service Employees International Union Local 1000 Candidate PAC   Service Employees International Union Local 1000 Candidate PAC   Service Employees International Union Local 1000 Candidate PAC   Service Employees International Union Local 1000 Candidate PAC   Service Employees International Union, Local 1000   None   None   Service Employees International Union Local 1000 Candidate PAC   Service Employees International Union Local 1000 Candidate PAC   Service Employees International Union Local 1000 Candidate PAC   Service Employees International Union Local 1000 Candidate PAC   Service Employees International Union Local 1000 Candidate PAC   None   None   Service Employees International Union Local 1000 Candidate PAC   Service Employees International Union Local 1000 Candidate PAC   None   Service Employees International Union Local 1000 Candidate PAC   Service Employees International Union Local 1000 Candidate PAC   Service Employees International Union Local 1000 Candidate PAC   Service Employees International Union Local 1000 Candidate PAC   Service Employees International Union Local 1000 Candidate PAC   Service Employees International Union Local 1000 Candidate PAC   None   Service Employees International Union Local 1000 Candidate PAC   None   Service Employees International Union Local 1000 Candidate PAC   Service Employees International Union Local 1000 Candidate PAC   Service Employees International Union Local 1000 Candidate PAC   Service Employees International Union Local 1000 Candidate PAC   None   Service Employees International Union Local 1000 Candidate PAC   Service Employees International Union Local 1000 Candidate PAC   Service Employees International Union Local 1000 Candidate PAC   Service Employees International Union Local 1000 Candidate PAC   Service Employees International Union Local 1000 Candidate PAC   Service Employees International Union Local 1000 Candidate PAC   Service Employees International Union Local 1000 Candidate PAC   Service Employees International Union Local 1000 Candidate PAC   Service Employees International Union Local 1000 Candidate PAC   Service Employees International Union Local 1000 Candidate PAC   Service Employees International Union Local 1000 Candidate PAC   None   Service Employees International Union Local 1000 Candidate PAC   Service Employees International Union Local 1000 Candidate PAC   Service Employees International Union Local 1000 Candidate PAC   Service Employees International Union Local 1000 Candidate PAC   None   Service Employees International Union Local 1000 Candidate PAC
rcpcmte_id   1273063   1273063   None   None   1273063   1273063   1273063   1273063   1273063   1273063   None   1273063   None   1273063   None   1273063   1273063   1273063   1273063   1273063   1273063   None   1273063   1273063   1273063   1273063   1273063   None   1273063   1273063   1273063   1273063   1285451   None   None   1273063   1273063   1273063   1273063   1273063   None   None   1273063   1273063   None   1273063   1273063   1273063   1273063   1273063   1273063   None   1273063   None   1273063   1273063   1273063   1273063   None   1273063   1273063   1273063   1273063   1273063   1273063   1273063   1273063   1273063   1273063   1273063   None   1273063   1273063   1273063   1273063   None   1273063
Table: cvr_registration
filing_id   1162337   1224341   1224341   1224341   1224341   1224341   1224341   1291827   1224341   1224341   1224341   1224341   1384915   1385443   1384915   1384915   1384915   1551827   1557708   1683738   1551827   1551827   1720331   1720971   1720331   1720331   1720331   1720331   1919062   1920453   1919062   2111528   1919062   1919062   2113902   2113902   2113902   2113902   2328306   2329314   2329314   2329314   2329314   2329314   2329314   2538128   2538128   2538128   2538128   2538128
amend_id   0   0   2   1   3   4   5   0   8   9   7   6   0   0   2   1   3   0   0   0   2   1   0   0   1   2   3   4   0   0   1   0   2   3   0   2   1   3   0   0   1   2   3   4   5   0   3   1   2   4
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
form_type   F603   F603   F603   F603   F603   F603   F603   F602   F603   F603   F603   F603   F603   F602   F603   F603   F603   F603   F602   F606   F603   F603   F603   F602   F603   F603   F603   F603   F603   F602   F603   F602   F603   F603   F603   F603   F603   F603   F602   F603   F603   F603   F603   F603   F603   F603   F603   F603   F603   F603
sender_id   1285451   1285451   1285451   1285451   1285451   1285451   1285451   F24903   1285451   1285451   1285451   1285451   1285451   F24903   1285451   1285451   1285451   1285451   F24903   1285451   1285451   1285451   1285451   F24903   1285451   1285451   1285451   1285451   1285451   F24903   1285451   F24903   1285451   1285451   1285451   1285451   1285451   1285451   F24903   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451
filer_id   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451
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
filer_naml   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   SERVICE EMPLOYEES INTERNATIONAL UNION LOCAL 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   SERVICE EMPLOYEES INTERNATIONAL UNION LOCAL 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   SERVICE EMPLOYEES INTERNATIONAL UNION LOCAL 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   SERVICE EMPLOYEES INTERNATIONAL UNION LOCAL 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   SERVICE EMPLOYEES INTERNATIONAL UNION LOCAL 1000   Service Employees International Union, Local 1000   SERVICE EMPLOYEES INTERNATIONAL UNION LOCAL 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   SERVICE EMPLOYEES INTERNATIONAL UNION LOCAL 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000   Service Employees International Union, Local 1000
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
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
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
report_num   000   000   002   001   003   004   005   000   008   009   007   006   000   000   002   001   003   000   000   000   002   001   000   000   001   002   003   004   000   000   001   000   002   003   000   002   001   003   000   000   001   002   003   004   005   000   003   001   002   004
rpt_date   2006-04-14 00:00:00   2006-12-21 00:00:00   2007-05-01 00:00:00   2007-02-15 00:00:00   2007-10-11 00:00:00   2007-10-11 00:00:00   2007-12-21 00:00:00   2007-10-01 00:00:00   2008-12-05 00:00:00   2008-12-05 00:00:00   2008-10-31 00:00:00   2008-07-31 00:00:00   2008-12-22 00:00:00   2008-12-19 00:00:00   2009-07-08 00:00:00   2009-06-22 00:00:00   2009-11-12 00:00:00   2010-12-17 00:00:00   2011-01-05 00:00:00   2012-08-09 00:00:00   2012-10-03 00:00:00   2012-08-09 00:00:00   2013-01-01 00:00:00   2012-12-10 00:00:00   2013-01-14 00:00:00   2013-01-25 00:00:00   2013-06-18 00:00:00   2014-02-25 00:00:00   2015-01-01 00:00:00   2014-12-12 00:00:00   2015-07-30 00:00:00   2016-12-09 00:00:00   2016-10-21 00:00:00   2016-12-08 00:00:00   2018-12-31 00:00:00   2017-09-11 00:00:00   2017-07-27 00:00:00   2018-09-27 00:00:00   2018-12-10 00:00:00   2020-12-31 00:00:00   2019-03-31 00:00:00   2019-08-23 00:00:00   2019-08-23 00:00:00   2020-01-23 00:00:00   2020-09-05 00:00:00   2022-12-31 00:00:00   2022-02-14 00:00:00   2021-10-14 00:00:00   2021-10-27 00:00:00   2022-08-04 00:00:00
ls_beg_yr   2006   2007   2007   2007   2007   2007   2007   2007   2007   2007   2007   2007   2009   2009   2009   2009   2009   2011   2011   2011   2011   2011   2013   2013   2013   2013   2013   2013   2015   2015   2015   2017   2015   2015   2017   2017   2017   2017   2019   2019   2019   2019   2019   2019   2019   2021   2021   2021   2021   2021
ls_end_yr   2006   2008   2008   2008   2008   2008   2008   2008   2008   2008   2008   2008   2010   2010   2010   2010   2010   2012   2012   2012   2012   2012   2014   2014   2014   2014   2014   2014   2016   2016   2016   2018   2016   2016   2018   2018   2018   2018   2020   2020   2020   2020   2020   2020   2020   2022   2022   2022   2022   2022
qual_date   2006-04-10 00:00:00   2006-04-10 00:00:00   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
eff_date   None   None   None   None   None   None   None   2007-10-01 00:00:00   None   None   None   None   None   2009-01-01 00:00:00   None   None   None   None   2011-01-07 00:00:00   2012-07-06 00:00:00   None   None   None   2013-01-01 00:00:00   None   None   None   None   None   2015-01-01 00:00:00   None   2017-01-01 00:00:00   None   None   None   None   None   None   2019-01-01 00:00:00   None   None   None   None   None   None   None   None   None   None   None
bus_city   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   SACRAMENTO   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   SACRAMENTO   Sacramento   Sacramento   Sacramento   Sacramento   SACRAMENTO   Sacramento   Sacramento   Sacramento   Sacramento   SACRAMENTO   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   SACRAMENTO   Sacramento   SACRAMENTO   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   SACRAMENTO   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento
bus_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
bus_zip4   95814   95814   95816   95814   95816   95816   95816   95814   95816   95816   95816   95816   95816   95814   95816   95816   95816   95811   95811   95811   95811   95811   95811   95811   95811   95811   95811   95811   95811   95811   95811   95811   95811   95811   95811   95811   95811   95811   95811   95811   95811   95811   95811   95811   95811   95811   95811   95811   95811   95811
bus_phon   (916) 552-5581   (916) 552-5581   (916) 554-1234   (916) 552-5581   (916) 554-1234   (916) 554-1234   (916) 554-1234   916-554-1200   (916) 554-1234   (916) 554-1234   (916) 554-1234   (916) 554-1234   (916) 554-1234   916-554-1200   (916) 554-1234   (916) 554-1234   (916) 554-1234   916 554-1234   916-554-1200   916 554-1234   916 554-1234   916 554-1234   916 554-1234   916-554-1200   916 554-1234   916 554-1234   916 554-1234   916 554-1234   (866) 471-7348   916-554-1200   (866) 471-7348   916-554-1200   (866) 471-7348   (866) 471-7348   (866) 471-7348   (866) 471-7348   (866) 471-7348   (866) 471-7348   916-554-1200   (866) 471-7348   (866) 471-7348   (866) 471-7348   (866) 471-7348   (866) 471-7348   (866) 471-7348   (866) 471-7348   (866) 471-7348   (866) 471-7348   (866) 471-7348   (866) 471-7348
bus_fax   (916) 326-4339   (916) 326-4339   (916) 326-4339   (916) 326-4339   (916) 326-4339   (916) 326-4339   (916) 326-4339   None   (916) 326-4339   (916) 326-4339   (916) 326-4339   (916) 326-4339   (916) 326-4339   None   (916) 326-4339   (916) 326-4339   (916) 326-4339   916 326-4339   None   916 326-4339   916 326-4339   916 326-4339   916 326-4339   None   916 326-4339   916 326-4339   916 326-4339   916 326-4339   (916) 554-1273   None   (916) 554-1273   None   (916) 554-1273   (916) 554-1273   (916) 554-1273   (916) 554-1273   (916) 554-1273   (916) 554-1273   None   (916) 554-1273   (916) 554-1273   (916) 554-1273   (916) 554-1273   (916) 554-1273   (916) 554-1273   (916) 554-1273   (916) 554-1273   (916) 554-1273   (916) 554-1273   (916) 554-1273
bus_email   None   None   None   None   None   None   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 protected]   None   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   None   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]
mail_city   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   Sacramento   None   Sacramento   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
mail_st   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   CA   None   CA   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
mail_zip4   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   95811   None   95811   None   None   None   None   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
sig_date   2006-04-11 00:00:00   2006-12-18 00:00:00   2007-04-30 00:00:00   2007-02-01 00:00:00   2007-10-02 00:00:00   2007-10-02 00:00:00   2007-12-11 00:00:00   2007-10-01 00:00:00   2008-11-08 00:00:00   2008-11-08 00:00:00   2008-10-30 00:00:00   2008-07-29 00:00:00   2008-12-16 00:00:00   2008-12-19 00:00:00   2009-06-29 00:00:00   2009-06-17 00:00:00   2009-11-02 00:00:00   2010-12-14 00:00:00   2011-01-05 00:00:00   2012-07-30 00:00:00   2012-10-03 00:00:00   2012-08-06 00:00:00   2012-12-18 00:00:00   2012-12-10 00:00:00   2013-01-17 00:00:00   2013-01-24 00:00:00   2013-06-26 00:00:00   2014-02-25 00:00:00   2014-12-17 00:00:00   2014-12-12 00:00:00   2015-07-30 00:00:00   2016-12-09 00:00:00   2016-11-04 00:00:00   2016-11-28 00:00:00   2016-12-16 00:00:00   2017-09-11 00:00:00   2017-07-24 00:00:00   2018-09-27 00:00:00   2018-12-10 00:00:00   2018-12-21 00:00:00   2019-04-22 00:00:00   2019-08-23 00:00:00   2019-10-22 00:00:00   2020-01-17 00:00:00   2020-09-08 00:00:00   2020-11-17 00:00:00   2022-06-08 00:00:00   2021-10-14 00:00:00   2021-10-27 00:00:00   2022-08-08 00:00:00
sig_loc   None   None   None   None   None   None   None   SACRAMENTO CALIFORNIA   None   None   None   None   None   SACRAMENTO CALIFORNIA   None   None   None   Sacramento CA   SACRAMENTO CALIFORNIA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   SACRAMENTO CALIFORNIA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   SACRAMENTO CALIFORNIA   Sacramento CA   SACRAMENTO CALIFORNIA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   SACRAMENTO CALIFORNIA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA   Sacramento CA
sig_naml   Zimmerman   Zimmerman   Chung   Zimmerman   Zimmerman   Zimmerman   Zimmerman   ZIMMERMAN   Zimmerman   Zimmerman   Zimmerman   Baratz   Zimmerman   ZIMMERMAN   Zimmerman   Zimmerman   Zimmerman   Zimmerman   FARIAS   Farias   Zimmerman   Zimmerman   Zimmerman   HERNANDEZ   Zimmerman   Zimmerman   Zimmerman   Schmidt   Schmidt   HERNANDEZ   Schmidt   HERNANDEZ   Hernandez   Hernandez   Hernandez   Hernandez   Hernandez   Hernandez   HERNANDEZ   Hernandez   Schmidt   Walker   Farias Womack   Farias Womack   Lopez   Lopez   Brewer   Brewer   Brewer   Brewer-Gonzalez
sig_namf   Sarah   Sarah   Candice   Sarah   Sarah   Sarah   Sarah   SARAH   Sarah   Sarah   Sarah   Michael   Sarah   SARAH   Sarah   Sarah   Sarah   Sarah   NANCY   Nancy   Sarah   Sarah   Sarah   MARY   Sarah   Sarah   Sarah   Steve   Steve   MARY   Steve   MARY   Mary   Mary   Mary   Mary   Mary   Mary   MARY   Mary   Steve   Yvonne   Nancy   Nancy   Deema   Deema   Omega   Omega   Omega   Omega
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
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
prn_naml   Zimmerman   Zimmerman   Chung   Zimmerman   Zimmerman   Zimmerman   Zimmerman   None   Zimmerman   Zimmerman   Zimmerman   Baratz   Zimmerman   None   Zimmerman   Zimmerman   Zimmerman   Zimmerman   None   Farias   Zimmerman   Zimmerman   Zimmerman   None   Zimmerman   Zimmerman   Zimmerman   Schmidt   Schmidt   None   Schmidt   None   Hernandez   Hernandez   Hernandez   Hernandez   Hernandez   Hernandez   None   Hernandez   Schmidt   Walker   Farias Womack   Farias Womack   Lopez   Lopez   Brewer   Brewer   Brewer   Brewer-Gonzalez
prn_namf   Sarah   Sarah   Candice   Sarah   Sarah   Sarah   Sarah   None   Sarah   Sarah   Sarah   Michael   Sarah   None   Sarah   Sarah   Sarah   Sarah   None   Nancy   Sarah   Sarah   Sarah   None   Sarah   Sarah   Sarah   Steve   Steve   None   Steve   None   Mary   Mary   Mary   Mary   Mary   Mary   None   Mary   Steve   Yvonne   Nancy   Nancy   Deema   Deema   Omega   Omega   Omega   Omega
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
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
sig_title   Director of Government Affairs   Director of Government Affairs   Government Relations Advocate   Director of Government Affairs   Director of Government Affairs   Director of Government Affairs   Deputy Chief of Staff   DIRECTOR OF GOVERNMENT AFFAIRS   Deputy Chief of Staff   Deputy Chief of Staff   Deputy Chief of Staff   Chief of Staff   Deputy Chief of Staff   DIRECTOR OF GOVERNMENT AFFAIRS   Deputy Chief of Staff   Deputy Chief of Staff   Deputy Chief of Staff   Deputy Chief of Staff   DIRECTOR OF GOVERNMENT AFFAIRS   lobbyist   Deputy Chief of Staff   Deputy Chief of Staff   Deputy Chief of Staff   GOVERNMENT RELATIONS DIRECTOR   Deputy Chief of Staff   Deputy Chief of Staff   Deputy Chief of Staff   Controller   Controller   GOVERNMENT RELATIONS DEPUTY CHIEF OF STAFF   Controller   GOVERNMENT RELATIONS DEPUTY CHIEF OF STAFF   Government Relations Deputy Chief of Staff   Government Relations Deputy Chief of Staff   Government Relations Deputy Chief of Staff   Deputy Chief of Staff Government Affairs   Government Relations Deputy Chief of Staff   Deputy Chief of Staff Government Affairs   GOVERNMENT RELATIONS DEPUTY CHIEF OF STAFF   Executive Director   Controller   President   Director of Government Relations   Director of Government Relations   Director of Government Relations   Director of Government Relations   Governmental Affairs Coordinator   Governmental Affairs Coordinator   Governmental Affairs Coordinator   Government Affairs Director
stmt_firm   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   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   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   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   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   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   None   None   None   None   X   None   None   X   X   X   None   X   X   X   X   X   None   X   None   X   None   None   None   None   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   X   X   X   X   None   X   None   None   None   None   X   None   None   None   None   None   X   None   X   None   X   X   X   X   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   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   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   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   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   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   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   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
descrip_1   Labor Union   Labor Union   Labor Union   Labor Union   Labor Union   Labor Union   Labor Union   LABOR UNION   Labor Union   Labor Union   Labor Union   Labor Union   Labor Union   LABOR UNION   Labor Union   Labor Union   Labor Union   Labor union which represents state employees.   LABOR UNION   None   Labor union which represents state employees.   Labor union which represents state employees.   Labor union which represents state employees.   LABOR UNION   Labor union which represents state employees.   Labor union which represents state employees.   Labor union which represents state employees.   Labor union which represents state employees.   Labor union which represents state employees.   LABOR UNION   Labor union which represents state employees.   LABOR UNION   Labor union which represents state employees.   Labor Organization   Labor Organization   Labor Organization   Labor Organization   Labor Organization   LABOR UNION   Labor Organization   Labor Organization   Labor Organization   Labor Organization   Labor Organization   Labor Organization   Labor Organization   Labor Organization   Labor Organization   Labor Organization   Labor Organization
descrip_2   N/A   N/A   N/A   N/A   N/A   N/A   N/A   N/A   N/A   N/A   N/A   N/A   N/A   N/A   N/A   N/A   N/A   N/A   N/A   None   N/A   N/A   N/A   N/A   N/A   N/A   N/A   N/A   N/A   N/A   N/A   N/A   N/A   State Employees   State Employees   State Employees   State Employees   State Employees   N/A   State Employees   State Employees   State Employees   State Employees   State Employees   State Employees   State Employees   State Employees   State Employees   State Employees   State Employees
c_less50   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   X   None   None   X   X   X   None   X   X   X   X   None   None   None   None   None   None   None   None   None   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   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   X   None   X   None   X   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
ind_class   LAB   LAB   LAB   LAB   LAB   LAB   LAB   LAB   LAB   LAB   LAB   LAB   LAB   LAB   LAB   LAB   LAB   LAB   LAB   None   LAB   LAB   LAB   LAB   LAB   LAB   LAB   LAB   LAB   LAB   LAB   LAB   LAB   LAB   LAB   LAB   LAB   LAB   LAB   LAB   LAB   LAB   LAB   LAB   LAB   LAB   LAB   LAB   LAB   LAB
ind_descr   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   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   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
bus_descr   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
auth_name   None   None   None   None   None   None   None   HR DOWDEN & ASSOCIATES   None   None   None   None   None   HR DOWDEN & ASSOCIATES   None   None   None   None   HR DOWDEN & ASSOCIATES   None   None   None   None   HR DOWDEN & ASSOCIATES   None   None   None   None   None   HR DOWDEN & ASSOCIATES   None   HR DOWDEN & ASSOCIATES   None   None   None   None   None   None   HR DOWDEN & ASSOCIATES   None   None   None   None   None   None   None   None   None   None   None
auth_city   None   None   None   None   None   None   None   SACRAMENTO   None   None   None   None   None   SACRAMENTO   None   None   None   None   SACRAMENTO   None   None   None   None   SACRAMENTO   None   None   None   None   None   SACRAMENTO   None   SACRAMENTO   None   None   None   None   None   None   SACRAMENTO   None   None   None   None   None   None   None   None   None   None   None
auth_st   None   None   None   None   None   None   None   CA   None   None   None   None   None   CA   None   None   None   None   CA   None   None   None   None   CA   None   None   None   None   None   CA   None   CA   None   None   None   None   None   None   CA   None   None   None   None   None   None   None   None   None   None   None
auth_zip4   None   None   None   None   None   None   None   95814   None   None   None   None   None   95814   None   None   None   None   95814   None   None   None   None   95814   None   None   None   None   None   95814   None   95814   None   None   None   None   None   None   95814   None   None   None   None   None   None   None   None   None   None   None
lobby_int   Issues affecting state employees.   Issues affecting state employees.   Issues affecting state employees.   Issues affecting state employees.   Issues affecting state employees.   Issues affecting state employees.   Issues affecting state employees.   None   Issues affecting state employees.   Issues affecting state employees.   Issues affecting state employees.   Issues affecting state employees.   Issues affecting state employees.   None   Issues affecting state employees.   Issues affecting state employees.   Issues affecting state employees.   Issues affecting state employees.   None   None   Issues affecting state employees.   Issues affecting state employees.   Issues affecting state employees and state programs.   None   Issues affecting state employees and state programs.   Issues affecting state employees and state programs.   Issues affecting state employees and state programs.   Issues affecting state employees and state programs.   Issues affecting state employees and state programs.   None   Issues affecting state employees and state programs.   None   Issues affecting state employees and state programs.   Issues affecting state employees and state programs.   Issues affecting state employees and state programs.   Issues affecting state employees and state programs.   Issues affecting state employees and state programs.   Issues affecting state employees and state programs.   None   Issues affecting state employees and state programs.   Issues affecting state employees and state programs.   Issues affecting state employees and state programs.   Issues affecting state employees and state programs.   Issues affecting state employees and state programs.   Issues affecting state employees and state programs.   Issues affecting state employees and state programs.   Issues affecting state employees and state programs.   Issues affecting state employees and state programs.   Issues affecting state employees and state programs.   Issues affecting state employees and state programs.
influen_yn   Y   Y   Y   Y   Y   Y   Y   None   Y   Y   Y   Y   Y   None   Y   Y   Y   Y   None   None   Y   Y   Y   None   Y   Y   Y   Y   Y   None   Y   None   Y   Y   Y   Y   Y   Y   None   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   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   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   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   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   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   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   None   None   None   None   None   None   None   None   None   None   None   None   None   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_reg_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
lby_604_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
st_leg_yn   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   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   None   None   None   None   None   None   None   None   None   None   None   None   None   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_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
l_firm_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
Table: filer_acronyms
acronym   SEIU
filer_id   1285451
Table: filer_address
filer_id   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451
adrid   2101691   2113436   2122929   2159822   2203349   2413721   2506416   2467241   2276656   2546282   2338931
effect_dt   2006-04-10 00:00:00   2007-01-01 00:00:00   2007-04-30 00:00:00   2009-01-01 00:00:00   2011-01-01 00:00:00   2017-01-01 00:00:00   2021-01-01 00:00:00   2019-01-01 00:00:00   2013-01-01 00:00:00   2023-01-01 00:00:00   2015-01-01 00:00:00
add_type   7051   7051   7051   7051   7051   7051   7051   7051   7051   7051   7051
session_id   2005   2007   2007   2009   2011   2017   2021   2019   2013   2023   2015
Table: filer_filings
filer_id   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451
filing_id   1162337   1189392   1162307   1214883   1224341   1224341   1235337   1229265   1256272   1284613   1264647   1262446   1246243   1224341   1298005   1292712   1291805   1291827   1301508   1224341   1224341   1224341   1765883   1765883   1782863   1720331   1982142   1964255   1964255   1868433   1801267   1773122   1933787   1952687   1911016   1292541   1312434   1330124   1351762   1349221   1224341   1224341   1224341   1379939   1384915   1377553   1385443   1384776   1383664   1383670   1224341   1414768   1430061   1384915   1422015   1422015   1427856   1384915   1397928   1384915   1453210   1437768   1454466   1485636   1464890   1508559   1540961   1551827   1565078   1569525   1557708   1551689   1592070   1609024   1622971   1635808   1657621   1677817   1720331   1829902   1801267   1815948   1694519   1551827   1551827   1683738   1688201   1845649   1919062   1920453   1922621   1708452   1720971   1723261   1720331   1739334   1723307   1720331   1720331   1845649   1765883   1754362   1754363   1765883   1997199   1919062   2410816   2329314   2484603   2357794   2382995   2329314   1988805   2010728   2037548   2037548   2062275   1919062   2103918   2111528   2128125   2102222   2121635   2121638   2121651   2107631   2109653   2113902   1919062   2175160   2178808   2113902   2141347   2157988   2037548   2157988   2346348   2399121   2335779   2321647   2329314   2328306   2241853   2320816   2531023   2329314   2329314   2443246   2113902   2601183   2210385   2185728   2554820   2329314   2113902   2275691   2538128   2435948   2420441   2419051   2381071   2193363   2157988   2513248   2470527   2713240   2538128   2677676   2707183   2546979   2538128   2580132   2538128   2620579   2694009   2628975   2643517   2538128   2625120   2748107
period_id   186   186   None   187   188   189   188   None   None   190   None   189   None   190   191   None   None   192   None   192   192   192   213   213   214   214   222   221   221   218   215   None   220   None   219   None   192   193   None   194   195   196   196   None   196   195   196   None   None   None   196   None   None   199   197   197   None   198   196   200   199   198   None   201   200   202   203   204   None   204   205   None   205   206   207   208   209   210   217   None   215   216   None   212   211   211   None   217   221   220   None   211   212   None   213   212   None   213   213   217   213   None   None   213   223   223   None   244   242   None   None   239   None   224   225   225   226   228   None   228   228   227   None   None   None   None   None   236   228   230   None   231   None   229   225   229   236   238   None   None   237   236   233   235   243   241   243   240   231   246   232   None   244   239   235   234   252   None   None   239   237   231   229   None   241   None   251   249   250   None   248   245   248   None   None   None   248   249   247   251
form_id   F603   F635   F603   F635   F603   F603   F635   F603   F605   F635   F605   F635   F605   F603   F635   F605   F602   F602   F605   F603   F603   F603   F635   F635   F635   F603   F635   F635   F635   F635   F635   F605   F635   F602   F635   F605   F635   F635   F605   F635   F603   F603   F603   F605   F603   F635   F602   F603   F605   F605   F603   F602   F605   F603   F635   F635   F605   F603   F635   F603   F635   F635   F605   F635   F635   F635   F635   F603   F602   F635   F602   F603   F635   F635   F635   F635   F635   F635   F603   F605   F635   F635   F605   F603   F603   F606   F605   F635   F603   F602   F603   F635   F602   F603   F603   F635   F602   F603   F603   F635   F635   F605   F605   F635   F635   F603   F605   F603   F635   F602   F605   F603   F605   F635   F635   F635   F635   F603   F605   F602   F635   F635   F603   F603   F605   F605   F605   F603   F603   F635   F605   F603   F602   F635   F635   F635   F635   F635   F603   F605   F603   F602   F635   F635   F635   F603   F603   F635   F603   F635   F635   F605   F635   F603   F603   F635   F603   F605   F605   F635   F635   F635   F635   F605   F635   F605   F603   F635   F635   F603   F603   F635   F603   F605   F605   F605   F635   F603   F635   F635
filing_sequence   0   0   0   0   0   1   0   0   0   0   0   0   0   2   0   0   0   0   0   3   5   4   2   1   0   3   0   0   1   0   0   0   0   0   0   0   0   0   0   0   6   8   9   0   0   0   0   0   0   0   7   0   0   2   1   0   0   1   0   3   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   4   0   1   0   0   2   1   0   0   1   0   0   0   0   0   0   0   0   0   2   1   0   3   0   0   0   0   1   0   0   0   0   0   3   0   0   0   1   0   2   0   0   0   0   0   0   0   0   0   0   3   0   0   1   0   0   2   1   0   0   0   0   1   0   0   0   0   4   5   0   2   0   0   0   0   2   3   0   0   0   0   0   0   0   2   0   0   0   4   0   0   0   1   0   2   0   0   0   0   3   0   0
filing_date   2006-04-14 00:00:00   2006-07-28 00:00:00   2006-04-13 00:00:00   2006-10-30 00:00:00   2006-12-21 00:00:00   2007-02-15 00:00:00   2007-01-30 00:00:00   2006-12-21 00:00:00   2007-02-01 00:00:00   2007-07-31 00:00:00   2007-05-01 00:00:00   2007-04-30 00:00:00   2007-01-01 00:00:00   2007-05-01 00:00:00   2007-10-31 00:00:00   2007-10-11 00:00:00   2007-10-01 00:00:00   2007-10-02 00:00:00   2007-12-19 00:00:00   2007-10-11 00:00:00   2007-12-21 00:00:00   2007-10-11 00:00:00   2013-07-12 00:00:00   2013-07-11 00:00:00   2013-07-31 00:00:00   2013-06-26 00:00:00   2015-07-31 00:00:00   2015-04-29 00:00:00   2015-06-01 00:00:00   2014-07-29 00:00:00   2013-10-31 00:00:00   2013-06-26 00:00:00   2015-01-30 00:00:00   2014-12-26 00:00:00   2014-10-31 00:00:00   2007-10-10 00:00:00   2008-01-31 00:00:00   2008-04-30 00:00:00   2008-07-30 00:00:00   2008-07-30 00:00:00   2008-07-31 00:00:00   2008-12-05 00:00:00   2008-12-05 00:00:00   2008-10-31 00:00:00   2008-12-22 00:00:00   2008-10-31 00:00:00   2008-12-24 00:00:00   2008-12-19 00:00:00   2008-12-05 00:00:00   2008-12-05 00:00:00   2008-10-31 00:00:00   2008-12-24 00:00:00   2009-07-07 00:00:00   2009-07-08 00:00:00   2009-06-08 00:00:00   2009-04-30 00:00:00   2009-06-22 00:00:00   2009-06-22 00:00:00   2009-02-02 00:00:00   2009-11-12 00:00:00   2009-11-02 00:00:00   2009-07-31 00:00:00   2009-11-12 00:00:00   2010-04-30 00:00:00   2010-02-01 00:00:00   2010-08-02 00:00:00   2010-11-01 00:00:00   2010-12-17 00:00:00   2011-01-06 00:00:00   2011-01-29 00:00:00   2011-01-06 00:00:00   2010-12-16 00:00:00   2011-05-02 00:00:00   2011-08-01 00:00:00   2011-10-31 00:00:00   2012-01-31 00:00:00   2012-04-30 00:00:00   2012-07-30 00:00:00   2014-03-11 00:00:00   2014-03-11 00:00:00   2014-01-30 00:00:00   2014-01-30 00:00:00   2012-10-01 00:00:00   2012-10-03 00:00:00   2012-08-09 00:00:00   2012-08-09 00:00:00   2012-08-09 00:00:00   2014-12-01 00:00:00   2014-12-19 00:00:00   2014-12-23 00:00:00   2014-12-18 00:00:00   2012-10-31 00:00:00   2012-12-27 00:00:00   2012-12-26 00:00:00   2012-12-26 00:00:00   2013-01-31 00:00:00   2012-12-28 00:00:00   2013-01-25 00:00:00   2013-01-24 00:00:00   2014-04-30 00:00:00   2014-04-01 00:00:00   2013-01-24 00:00:00   2013-01-25 00:00:00   2013-04-30 00:00:00   2015-10-30 00:00:00   2015-08-05 00:00:00   2019-09-17 00:00:00   2018-12-21 00:00:00   2020-07-30 00:00:00   2018-12-17 00:00:00   2019-04-30 00:00:00   2019-10-31 00:00:00   2015-08-05 00:00:00   2016-01-29 00:00:00   2016-05-02 00:00:00   2016-06-29 00:00:00   2016-07-29 00:00:00   2016-11-07 00:00:00   2016-10-28 00:00:00   2016-12-16 00:00:00   2017-01-30 00:00:00   2016-10-31 00:00:00   2016-12-23 00:00:00   2017-01-20 00:00:00   2016-11-30 00:00:00   2016-11-03 00:00:00   2016-11-30 00:00:00   2016-12-23 00:00:00   2016-12-08 00:00:00   2017-07-31 00:00:00   2017-08-01 00:00:00   2017-08-01 00:00:00   2016-12-16 00:00:00   2017-05-01 00:00:00   2017-05-22 00:00:00   2017-06-16 00:00:00   2019-01-30 00:00:00   2019-07-31 00:00:00   2018-12-19 00:00:00   2018-10-31 00:00:00   2019-04-30 00:00:00   2018-12-17 00:00:00   2018-04-30 00:00:00   2018-10-31 00:00:00   2020-11-02 00:00:00   2020-01-23 00:00:00   2020-10-03 00:00:00   2020-01-31 00:00:00   2017-09-29 00:00:00   2021-07-30 00:00:00   2018-01-31 00:00:00   2017-09-27 00:00:00   2021-02-01 00:00:00   2019-09-18 00:00:00   2018-10-31 00:00:00   2018-07-31 00:00:00   2020-12-23 00:00:00   2020-01-23 00:00:00   2019-10-31 00:00:00   2019-10-31 00:00:00   2019-04-30 00:00:00   2017-10-31 00:00:00   2018-01-02 00:00:00   2020-09-28 00:00:00   2020-04-30 00:00:00   2022-08-15 00:00:00   2022-08-15 00:00:00   2022-05-02 00:00:00   2022-08-01 00:00:00   2020-12-22 00:00:00   2021-10-14 00:00:00   2021-04-30 00:00:00   2021-11-03 00:00:00   2021-10-14 00:00:00   2022-06-13 00:00:00   2021-11-03 00:00:00   2022-01-31 00:00:00   2022-06-13 00:00:00   2021-11-01 00:00:00   2022-10-31 00:00:00
stmnt_type   10001   10001   10005   10001   10001   10002   10001   10005   10005   10001   10005   10001   10005   10002   10001   10005   10005   10001   10005   10002   10002   10002   10002   10002   10001   10002   10001   10001   10002   10001   10001   10006   10001   10005   10001   10005   10001   10001   10005   10001   10002   10002   10002   10005   10001   10001   10001   10005   10005   10005   10002   10005   10005   10002   10002   10001   10006   10002   10001   10002   10001   10001   10006   10001   10001   10001   10001   10001   10005   10001   10001   10005   10001   10001   10001   10001   10001   10001   10002   10006   10002   10001   10006   10002   10002   10001   10006   10002   10001   10001   10005   10001   10001   10005   10001   10001   10005   10002   10002   10001   10002   10005   10005   10001   10001   10002   10005   10001   10001   10005   10006   10002   10006   10001   10001   10002   10001   10002   10006   10001   10001   10001   10005   10006   10006   10006   10006   10001   10002   10001   10005   10002   10005   10001   10002   10002   10001   10001   10005   10005   10002   10001   10001   10001   10001   10002   10002   10001   10002   10001   10001   10006   10001   10002   10002   10001   10001   10005   10005   10001   10001   10001   10002   10005   10001   10002   10002   10001   10001   10005   10002   10001   10002   10002   10002   10002   10001   10002   10001   10001
stmnt_status   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11003   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11003   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11003   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11003   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11003   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11003   11003   11001   11003   11001   11003   11001   11001   11001   11001   11001   11001   11003
session_id   2006   2005   2005   2005   2007   2007   2005   2007   2007   2007   2007   2007   2007   2007   2007   2007   2007   2007   2007   2007   2007   2007   2013   2013   2013   2013   2015   2015   2015   2013   2013   2013   2013   2015   2013   2007   2007   2007   2007   2007   2007   2007   2007   2007   2009   2007   2009   2009   2007   2007   2007   2009   2009   2009   2009   2009   2009   2009   2007   2009   2009   2009   2009   2009   2009   2009   2009   2011   2011   2009   2011   2011   2011   2011   2011   2011   2011   2011   2013   2013   2013   2013   2011   2011   2011   2011   2011   2013   2015   2015   2015   2011   2013   2013   2013   2011   2013   2013   2013   2013   2013   2013   2013   2013   2015   2015   2019   2019   2019   2019   2019   2019   2015   2015   2015   2015   2015   2015   2015   2017   2015   2015   2017   2017   2017   2015   2015   2017   2015   2017   2017   2017   2017   2017   2015   2017   2017   2019   2019   2017   2019   2019   2017   2017   2019   2019   2019   2019   2017   2021   2017   2017   2019   2019   2017   2017   2021   2019   2019   2019   2019   2017   2017   2019   2019   2021   2021   2021   2021   2021   2021   2021   2021   2021   2021   2021   2021   2021   2021   2021
user_id   YRODRIGU   LTHIBAUL   GPEREZ   LTHIBAUL   YRODRIGU   YRODRIGU   LTHIBAUL   PBANFORD   CFLAGG   LTHIBAUL   SARRIAGA   LTHIBAUL   GKURIMOT   YRODRIGU   YRODRIGU   GPEREZ   SARRIAGA   YRODRIGU   GPEREZ   YRODRIGU   YRODRIGU   YRODRIGU   AGLADNEY   AGLADNEY   AGLADNEY   YRODRIGU   AGLADNEY   AGLADNEY   AGLADNEY   ASAETERN   ASAETERN   YRODRIGU   AGLADNEY   YRODRIGU   AGLADNEY   GPEREZ   LTHIBAUL   LTHIBAUL   LTHIBAUL   LTHIBAUL   YRODRIGU   YRODRIGU   YRODRIGU   YRODRIGU   YRODRIGU   ASAETERN   YRODRIGU   CFLAGG   YRODRIGU   YRODRIGU   YRODRIGU   MMORENO   CFLAGG   YRODRIGU   MGUERRA   MGUERRA   PBANFORD   PBANFORD   ASAETERN   YRODRIGU   MGUERRA   MGUERRA   YRODRIGU   ASAETERN   MGUERRA   ASAETERN   ASAETERN   PBANFORD   SARRIAGA   AGLADNEY   YRODRIGU   ASAETERN   AGLADNEY   AGLADNEY   ASAETERN   ASAETERN   ASAETERN   AGLADNEY   YRODRIGU   PBANFORD   AGLADNEY   ASAETERN   YRODRIGU   YRODRIGU   YRODRIGU   YRODRIGU   YRODRIGU   AGLADNEY   YRODRIGU   YRODRIGU   YRODRIGU   AGLADNEY   YRODRIGU   PBANFORD   PBANFORD   AGLADNEY   GKURIMOT   YRODRIGU   YRODRIGU   AGLADNEY   CAFILER   SARRIAGA   SARRIAGA   AGLADNEY   AGLADNEY   YRODRIGU   GPEREZ   GPEREZ   CVANLIEW   GPEREZ   YRODRIGU   GPEREZ   YRODRIGU   AGLADNEY   AGLADNEY   AGLADNEY   AGLADNEY   YRODRIGU   YRODRIGU   YRODRIGU   AGLADNEY   AGLADNEY   YRODRIGU   YRODRIGU   YRODRIGU   YRODRIGU   YRODRIGU   YRODRIGU   YRODRIGU   AGLADNEY   GPEREZ   GPEREZ   YRODRIGU   AGLADNEY   CAFILER   AGLADNEY   AGLADNEY   AGLADNEY   DMCCASTL   GPEREZ   YRODRIGU   GPEREZ   AGLADNEY   AGLADNEY   GTAYLOR   GPEREZ   CAFILER   AGLADNEY   GPEREZ   CHATRIDGE   AGLADNEY   YRODRIGU   GTAYLOR   GPEREZ   GPEREZ   AGLADNEY   MMERCHANT   GPEREZ   GPEREZ   SUSHAKOV   GTAYLOR   AGLADNEY   AGLADNEY   CVANLIEW   SUSHAKOV   NKRESTOFF   NKRESTOFF   CAFILER   CAFILER   MMERCHANT   CAFILER   CHATRIDGE   CAFILER   JMENDOZA   MMERCHANT   JMENDOZA   RATTIYEH   MMERCHANT   CHATRIDGE   CAFILER
special_audit   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   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   11001   11003   11003   11003   11001   11001   11003   11003   11003   11003   11003   11003   11003   11001   11003   11003   11003   11001   11003   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11003   11003   11003   11003   11003   11001   11001   11001   11001   11001   11001   11001   11003   11001   11001   11001   11003   11003   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11003   11001   11001   11003   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11003   11003   11003   11001   11001   11001   11003   11003   11001   11003   11003   11003   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11003   11003   11001   11001   11003   11001   11001   11001   11001   11003   11003   11003   11001   11001   11003   11003   11003   11001   11003   11001   11001   11001   11001   11003   11003   11001   11003   11003   11003   11001   11001   11001   11001   11003   11001   11003   11003   11003   11003   11003   11003   11001   11003   11003   11003   11003   11001   11003   11001   11003
rpt_start   2006-04-14 00:00:00   2006-04-01 00:00:00   1900-01-01 00:00:00   2006-07-01 00:00:00   2006-12-21 00:00:00   2007-02-15 00:00:00   2006-10-01 00:00:00   1900-01-01 00:00:00   1900-01-01 00:00:00   2007-04-01 00:00:00   1900-01-01 00:00:00   2007-01-01 00:00:00   1900-01-01 00:00:00   2007-05-01 00:00:00   2007-07-01 00:00:00   1900-01-01 00:00:00   1900-01-01 00:00:00   2007-10-01 00:00:00   1900-01-01 00:00:00   2007-10-11 00:00:00   2007-12-21 00:00:00   2007-10-11 00:00:00   2013-01-01 00:00:00   2013-01-01 00:00:00   2013-04-01 00:00:00   2013-06-18 00:00:00   2015-04-01 00:00:00   2015-01-01 00:00:00   2015-01-01 00:00:00   2014-04-01 00:00:00   2013-07-01 00:00:00   1900-01-01 00:00:00   2014-10-01 00:00:00   1900-01-01 00:00:00   2014-07-01 00:00:00   1900-01-01 00:00:00   2007-10-01 00:00:00   2008-01-01 00:00:00   1900-01-01 00:00:00   2008-04-01 00:00:00   2008-07-31 00:00:00   2008-12-05 00:00:00   2008-12-05 00:00:00   1900-01-01 00:00:00   2008-12-22 00:00:00   2008-07-01 00:00:00   2008-12-19 00:00:00   1900-01-01 00:00:00   1900-01-01 00:00:00   1900-01-01 00:00:00   2008-10-31 00:00:00   1900-01-01 00:00:00   1900-01-01 00:00:00   2009-07-08 00:00:00   2009-01-01 00:00:00   2009-01-01 00:00:00   1900-01-01 00:00:00   2009-06-22 00:00:00   2008-10-01 00:00:00   2009-11-12 00:00:00   2009-07-01 00:00:00   2009-04-01 00:00:00   1900-01-01 00:00:00   2010-01-01 00:00:00   2009-10-01 00:00:00   2010-04-01 00:00:00   2010-07-01 00:00:00   2010-12-17 00:00:00   1900-01-01 00:00:00   2010-10-01 00:00:00   2011-01-05 00:00:00   1900-01-01 00:00:00   2011-01-01 00:00:00   2011-04-01 00:00:00   2011-07-01 00:00:00   2011-10-01 00:00:00   2012-01-01 00:00:00   2012-04-01 00:00:00   2014-02-25 00:00:00   1900-01-01 00:00:00   2013-07-01 00:00:00   2013-10-01 00:00:00   1900-01-01 00:00:00   2012-10-03 00:00:00   2012-08-09 00:00:00   2012-08-09 00:00:00   1900-01-01 00:00:00   2014-01-01 00:00:00   2015-01-01 00:00:00   2014-12-12 00:00:00   1900-01-01 00:00:00   2012-07-01 00:00:00   2012-12-10 00:00:00   1900-01-01 00:00:00   2013-01-01 00:00:00   2012-10-01 00:00:00   1900-01-01 00:00:00   2013-01-25 00:00:00   2013-01-14 00:00:00   2014-01-01 00:00:00   2013-01-01 00:00:00   1900-01-01 00:00:00   1900-01-01 00:00:00   2013-01-01 00:00:00   2015-07-01 00:00:00   2015-07-30 00:00:00   1900-01-01 00:00:00   2020-12-31 00:00:00   2020-04-01 00:00:00   1900-01-01 00:00:00   1900-01-01 00:00:00   2019-08-23 00:00:00   1900-01-01 00:00:00   2015-10-01 00:00:00   2016-01-01 00:00:00   2016-01-01 00:00:00   2016-04-01 00:00:00   2016-10-21 00:00:00   1900-01-01 00:00:00   2016-12-09 00:00:00   2016-10-01 00:00:00   2016-07-01 00:00:00   1900-01-01 00:00:00   1900-01-01 00:00:00   1900-01-01 00:00:00   1900-01-01 00:00:00   1900-01-01 00:00:00   2018-12-31 00:00:00   2016-12-08 00:00:00   2017-04-01 00:00:00   1900-01-01 00:00:00   2017-07-27 00:00:00   1900-01-01 00:00:00   2017-01-01 00:00:00   2016-01-01 00:00:00   2017-01-01 00:00:00   2018-10-01 00:00:00   2019-04-01 00:00:00   1900-01-01 00:00:00   1900-01-01 00:00:00   2019-03-31 00:00:00   2018-12-10 00:00:00   2018-01-01 00:00:00   2018-07-01 00:00:00   2020-07-01 00:00:00   2020-01-23 00:00:00   2020-09-05 00:00:00   2019-10-01 00:00:00   2017-09-11 00:00:00   2021-04-01 00:00:00   2017-10-01 00:00:00   1900-01-01 00:00:00   2020-10-01 00:00:00   2019-08-23 00:00:00   2018-09-27 00:00:00   2018-04-01 00:00:00   2022-12-31 00:00:00   1900-01-01 00:00:00   1900-01-01 00:00:00   2019-07-01 00:00:00   2019-01-01 00:00:00   2017-07-01 00:00:00   2017-01-01 00:00:00   1900-01-01 00:00:00   2020-01-01 00:00:00   1900-01-01 00:00:00   2022-08-04 00:00:00   2022-01-01 00:00:00   2022-04-01 00:00:00   1900-01-01 00:00:00   2021-10-14 00:00:00   2021-01-01 00:00:00   2021-10-27 00:00:00   1900-01-01 00:00:00   1900-01-01 00:00:00   1900-01-01 00:00:00   2021-10-01 00:00:00   2022-02-14 00:00:00   2021-07-01 00:00:00   2022-07-01 00:00:00
rpt_end   2006-04-14 00:00:00   2006-06-30 00:00:00   1900-01-01 00:00:00   2006-09-30 00:00:00   2006-12-21 00:00:00   2007-02-15 00:00:00   2006-12-31 00:00:00   1900-01-01 00:00:00   1900-01-01 00:00:00   2007-06-30 00:00:00   1900-01-01 00:00:00   2007-03-31 00:00:00   1900-01-01 00:00:00   2007-05-01 00:00:00   2007-09-30 00:00:00   1900-01-01 00:00:00   1900-01-01 00:00:00   2007-10-01 00:00:00   1900-01-01 00:00:00   2007-10-11 00:00:00   2007-12-21 00:00:00   2007-10-11 00:00:00   2013-03-31 00:00:00   2013-03-31 00:00:00   2013-06-30 00:00:00   2013-06-18 00:00:00   2015-06-30 00:00:00   2015-03-31 00:00:00   2015-03-31 00:00:00   2014-06-30 00:00:00   2013-09-30 00:00:00   1900-01-01 00:00:00   2014-12-31 00:00:00   1900-01-01 00:00:00   2014-09-30 00:00:00   1900-01-01 00:00:00   2007-12-31 00:00:00   2008-03-31 00:00:00   1900-01-01 00:00:00   2008-06-30 00:00:00   2008-07-31 00:00:00   2008-12-05 00:00:00   2008-12-05 00:00:00   1900-01-01 00:00:00   2008-12-22 00:00:00   2008-09-30 00:00:00   2008-12-19 00:00:00   1900-01-01 00:00:00   1900-01-01 00:00:00   1900-01-01 00:00:00   2008-10-31 00:00:00   1900-01-01 00:00:00   1900-01-01 00:00:00   2009-07-08 00:00:00   2009-03-31 00:00:00   2009-03-31 00:00:00   1900-01-01 00:00:00   2009-06-22 00:00:00   2008-12-31 00:00:00   2009-11-12 00:00:00   2009-09-30 00:00:00   2009-06-30 00:00:00   1900-01-01 00:00:00   2010-03-31 00:00:00   2009-12-31 00:00:00   2010-06-30 00:00:00   2010-09-30 00:00:00   2010-12-17 00:00:00   1900-01-01 00:00:00   2010-12-31 00:00:00   2011-01-05 00:00:00   1900-01-01 00:00:00   2011-03-31 00:00:00   2011-06-30 00:00:00   2011-09-30 00:00:00   2011-12-31 00:00:00   2012-03-31 00:00:00   2012-06-30 00:00:00   2014-02-25 00:00:00   1900-01-01 00:00:00   2013-09-30 00:00:00   2013-12-31 00:00:00   1900-01-01 00:00:00   2012-10-03 00:00:00   2012-08-09 00:00:00   2012-08-09 00:00:00   1900-01-01 00:00:00   2014-03-31 00:00:00   2015-01-01 00:00:00   2014-12-12 00:00:00   1900-01-01 00:00:00   2012-09-30 00:00:00   2012-12-10 00:00:00   1900-01-01 00:00:00   2013-01-01 00:00:00   2012-12-31 00:00:00   1900-01-01 00:00:00   2013-01-25 00:00:00   2013-01-14 00:00:00   2014-03-31 00:00:00   2013-03-31 00:00:00   1900-01-01 00:00:00   1900-01-01 00:00:00   2013-03-31 00:00:00   2015-09-30 00:00:00   2015-07-30 00:00:00   1900-01-01 00:00:00   2020-12-31 00:00:00   2020-06-30 00:00:00   1900-01-01 00:00:00   1900-01-01 00:00:00   2019-08-23 00:00:00   1900-01-01 00:00:00   2015-12-31 00:00:00   2016-03-31 00:00:00   2016-03-31 00:00:00   2016-06-30 00:00:00   2016-10-21 00:00:00   1900-01-01 00:00:00   2016-12-09 00:00:00   2016-12-31 00:00:00   2016-09-30 00:00:00   1900-01-01 00:00:00   1900-01-01 00:00:00   1900-01-01 00:00:00   1900-01-01 00:00:00   1900-01-01 00:00:00   2018-12-31 00:00:00   2016-12-08 00:00:00   2017-06-30 00:00:00   1900-01-01 00:00:00   2017-07-27 00:00:00   1900-01-01 00:00:00   2017-03-31 00:00:00   2016-03-31 00:00:00   2017-03-31 00:00:00   2018-12-31 00:00:00   2019-06-30 00:00:00   1900-01-01 00:00:00   1900-01-01 00:00:00   2019-03-31 00:00:00   2018-12-10 00:00:00   2018-03-31 00:00:00   2018-09-30 00:00:00   2020-09-30 00:00:00   2020-01-23 00:00:00   2020-09-05 00:00:00   2019-12-31 00:00:00   2017-09-11 00:00:00   2021-06-30 00:00:00   2017-12-31 00:00:00   1900-01-01 00:00:00   2020-12-31 00:00:00   2019-08-23 00:00:00   2018-09-27 00:00:00   2018-06-30 00:00:00   2022-12-31 00:00:00   1900-01-01 00:00:00   1900-01-01 00:00:00   2019-09-30 00:00:00   2019-03-31 00:00:00   2017-09-30 00:00:00   2017-03-31 00:00:00   1900-01-01 00:00:00   2020-03-31 00:00:00   1900-01-01 00:00:00   2022-08-04 00:00:00   2022-03-31 00:00:00   2022-06-30 00:00:00   1900-01-01 00:00:00   2021-10-14 00:00:00   2021-03-31 00:00:00   2021-10-27 00:00:00   1900-01-01 00:00:00   1900-01-01 00:00:00   1900-01-01 00:00:00   2021-12-31 00:00:00   2022-02-14 00:00:00   2021-09-30 00:00:00   2022-09-30 00:00:00
rpt_date   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   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   22001   None   22001   22001   22001   22001   None   None   22001   None   22001   None   22001   22001   None   None   22001   None   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   None   22001   None   22001   None   22001   22001   None   22001   22001   22001   22001   None   22001   22001   22001   None   None   None   22001   None   None   22001   22001   22001   None   22001   22001   22001   22001   22001   None   22001   22001   22001   22001   22001   None   22001   22001   None   22001   22001   22001   22001   22001   22001   22001   None   22001   22001   None   22001   22001   22001   None   22001   22001   22001   None   22001   22001   None   22001   22001   None   22001   22001   22001   22001   None   None   22001   22001   22001   None   22001   22001   None   None   22001   None   22001   22001   22001   22001   22001   None   22001   22001   22001   None   None   None   None   None   22001   22001   22001   None   22001   None   22001   22001   22001   22001   22001   None   None   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   None   22001   22001   22001   22001   22001   None   None   22001   22001   22001   22001   None   22001   None   22001   22001   22001   None   22001   22001   22001   None   None   None   22001   22001   22001   22001
Table: filer_interests
filer_id   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451
session_id   2009   2007   2005   2013   2011   2017   2021   2019   2015   2023
interest_cd   40307   40307   40307   40307   40307   40307   40307   40307   40307   40307
effect_date   2009-01-01 00:00:00   2007-01-01 00:00:00   2006-04-10 00:00:00   2013-01-01 00:00:00   2011-01-01 00:00:00   2017-01-01 00:00:00   2021-01-01 00:00:00   2019-01-01 00:00:00   2015-01-01 00:00:00   2023-01-01 00:00:00
Table: filer_to_filer_type
filer_id   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451
filer_type   2   2   2   2   2   1   2   1   2   2   2   2   2   2
active   Y   Y   Y   Y   Y   Y   Y   Y   Y   Y   Y   Y   Y   N
race   0   0   0   None   None   0   None   0   0   None   None   None   None   None
session_id   2005   2007   2007   2011   2013   2007   2009   2007   2007   2019   2015   2021   2017   2023
category   0   0   0   None   None   0   None   0   0   None   None   None   None   None
category_type   0   0   0   None   None   0   None   0   0   None   None   None   None   None
sub_category   0   0   0   None   None   0   None   0   0   None   None   None   None   None
effect_dt   2006-04-10 00:00:00   2007-01-01 00:00:00   2007-11-26 00:00:00   2011-01-01 00:00:00   2013-01-01 00:00:00   2007-10-01 00:00:00   2009-01-01 00:00:00   2008-09-26 00:00:00   2008-11-05 00:00:00   2019-01-01 00:00:00   2015-01-01 00:00:00   2021-01-01 00:00:00   2017-01-01 00:00:00   2023-01-01 00:00:00
sub_category_type   0   0   0   None   None   0   None   0   0   None   None   None   None   None
election_type   0   0   0   None   None   0   None   0   0   None   None   None   None   None
sub_category_a   None   None   None   None   None   None   None   None   None   None   None   None   None   None
nyq_dt   2006-04-14 00:00:00   2006-04-14 00:00:00   2006-04-14 00:00:00   None   None   2006-04-14 00:00:00   None   2006-04-14 00:00:00   2006-04-14 00:00:00   None   None   None   None   None
party_cd   0   0   0   None   None   0   None   0   0   None   None   None   None   None
county_cd   0   0   0   None   None   0   None   0   0   None   None   None   None   None
district_cd   0   0   0   None   None   0   None   0   0   None   None   None   None   None
Table: filer_xref
filer_id   1285451
xref_id   1285451
effect_dt   2006-04-14 00:00:00
migration_source   CLAIMS
Table: filername
xref_filer_id   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451
filer_id   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451
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   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   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE   INACTIVE
effect_dt   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00
naml   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000
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   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   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
nams   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
adr1   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
adr2   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
city   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO   SACRAMENTO
st   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA
zip4   95814   95814   95816   95816   95811   95811   95811   95811   95811   95811   95811   95814   95814   95816   95816   95811   95811   95811   95811   95811   95811   95811   95814   95814   95816   95816   95811   95811   95811   95811   95811   95811   95811   95814   95814   95816   95816   95811   95811   95811   95811   95811   95811   95811   95814   95814   95816   95816   95811   95811   95811   95811   95811   95811   95811   95814   95814   95816   95816   95811   95811   95811   95811   95811   95811   95811   95814   95814   95816   95816   95811   95811   95811   95811   95811   95811   95811   95814   95814   95816   95816   95811   95811   95811   95811   95811   95811   95811   95814   95814   95816   95816   95811   95811   95811   95811   95811   95811   95811   95814   95814   95816   95816   95811   95811   95811   95811   95811   95811   95811
phon   9165525581   9165525581   9165541234   9165541234   9165541234   9165541234   8664717348   8664717348   8664717348   8664717348   8664717348   9165525581   9165525581   9165541234   9165541234   9165541234   9165541234   8664717348   8664717348   8664717348   8664717348   8664717348   9165525581   9165525581   9165541234   9165541234   9165541234   9165541234   8664717348   8664717348   8664717348   8664717348   8664717348   9165525581   9165525581   9165541234   9165541234   9165541234   9165541234   8664717348   8664717348   8664717348   8664717348   8664717348   9165525581   9165525581   9165541234   9165541234   9165541234   9165541234   8664717348   8664717348   8664717348   8664717348   8664717348   9165525581   9165525581   9165541234   9165541234   9165541234   9165541234   8664717348   8664717348   8664717348   8664717348   8664717348   9165525581   9165525581   9165541234   9165541234   9165541234   9165541234   8664717348   8664717348   8664717348   8664717348   8664717348   9165525581   9165525581   9165541234   9165541234   9165541234   9165541234   8664717348   8664717348   8664717348   8664717348   8664717348   9165525581   9165525581   9165541234   9165541234   9165541234   9165541234   8664717348   8664717348   8664717348   8664717348   8664717348   9165525581   9165525581   9165541234   9165541234   9165541234   9165541234   8664717348   8664717348   8664717348   8664717348   8664717348
fax   9163264339   9163264339   9163264339   9163264339   9163264339   9163264339   9165541273   9165541273   9165541273   9165541273   9165541273   9163264339   9163264339   9163264339   9163264339   9163264339   9163264339   9165541273   9165541273   9165541273   9165541273   9165541273   9163264339   9163264339   9163264339   9163264339   9163264339   9163264339   9165541273   9165541273   9165541273   9165541273   9165541273   9163264339   9163264339   9163264339   9163264339   9163264339   9163264339   9165541273   9165541273   9165541273   9165541273   9165541273   9163264339   9163264339   9163264339   9163264339   9163264339   9163264339   9165541273   9165541273   9165541273   9165541273   9165541273   9163264339   9163264339   9163264339   9163264339   9163264339   9163264339   9165541273   9165541273   9165541273   9165541273   9165541273   9163264339   9163264339   9163264339   9163264339   9163264339   9163264339   9165541273   9165541273   9165541273   9165541273   9165541273   9163264339   9163264339   9163264339   9163264339   9163264339   9163264339   9165541273   9165541273   9165541273   9165541273   9165541273   9163264339   9163264339   9163264339   9163264339   9163264339   9163264339   9165541273   9165541273   9165541273   9165541273   9165541273   9163264339   9163264339   9163264339   9163264339   9163264339   9163264339   9165541273   9165541273   9165541273   9165541273   9165541273
email   None   None   None   None   None   None   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   None   None   None   None   None   None   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   None   None   None   None   None   None   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   None   None   None   None   None   None   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   None   None   None   None   None   None   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   None   None   None   None   None   None   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   None   None   None   None   None   None   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   None   None   None   None   None   None   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   None   None   None   None   None   None   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   None   None   None   None   None   None   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]
Table: filers
filer_id   1285451
Table: lobbying_chg_log
filer_id   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451
change_no   0   2   1   5   4   3   10   11   7   6   12   13   14   15   16   17   18   19   20   22   21
session_id   2007   2005   2005   2007   2007   2007   2007   2007   2007   2007   2009   2009   2009   2011   2011   2013   2013   2017   2017   2019   2017
log_dt   2007-10-01 00:00:00   2006-04-13 00:00:00   2006-04-13 00:00:00   2007-02-01 00:00:00   2007-10-11 00:00:00   2007-02-01 00:00:00   2008-12-05 00:00:00   2008-12-05 00:00:00   2008-10-31 00:00:00   2007-12-19 00:00:00   2009-06-22 00:00:00   2009-07-07 00:00:00   2009-11-12 00:00:00   2012-08-09 00:00:00   2012-10-01 00:00:00   2013-01-25 00:00:00   2013-01-24 00:00:00   2017-08-01 00:00:00   2017-09-27 00:00:00   2019-10-31 00:00:00   2018-10-31 00:00:00
filer_type   2   2   2   1   2   2   2   2   2   2   2   2   2   2   2   2   2   2   2   2   2
correction_flg   Y   None   None   Y   Y   Y   Y   Y   Y   Y   Y   Y   Y   None   None   Y   Y   Y   Y   None   None
action   ADDED   IN SUSPENSE   CHANGED   ADDED   TERMINATED   DELETED   ADDED   ADDED   DELETED   ADDED   ADDED   ADDED   TERMINATED   DELETED   DELETED   ADDED   ADDED   DELETED   ADDED   DELETED   DELETED
attribute_changed   FIRM      RESPONSIBLE OFFICER   LOBBYIST   LOBBYIST   LOBBYIST   LOBBYIST   LOBBYIST   LOBBYIST   LOBBYIST   LOBBYIST   LOBBYIST   LOBBYIST   LOBBYIST   LOBBYIST   LOBBYIST   LOBBYIST   LOBBYIST   LOBBYIST   LOBBYIST   LOBBYIST
ethics_dt   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
interests   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
filer_full_name   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000   SERVICE EMPLOYEES INTERNATIONAL UNION, LOCAL 1000
filer_city   None   None   None   SACRAMENTO   None   None   SACRAMENTO   SACRAMENTO   None   SACRAMENTO   SACRAMENTO   SACRAMENTO   None   None   None   None   SACRAMENTO   None   SACRAMENTO   None   None
filer_st   None   None   None   CA   None   None   CA   CA   None   CA   CA   CA   None   None   None   None   CA   None   CA   None   None
filer_zip   None   None   None   95814   None   None   95814   95814   None   95814   95814   95814   None   None   None   None   95814   None   95814   None   None
filer_phone   None   None   None   9165525581   None   None   9165525581   9165525581   None   9165525581   9165525581   9165525581   None   None   None   None   9165525581   None   9165525581   None   None
entity_type   3   2   20   4   4   4   4   4   4   4   4   4   4   4   4   4   4   4   4   4   4
entity_name   DOWDEN AND ASSOCIATES; HR   None   DIRECTOR, GOVERNMENT AFFAIRS SARAH ZIMMERMAN   CHUNG, CANDICE   CHUNG, CANDICE L.   GOLKA, JOSHUA P.   BURRI, STEPHANIE I.   CHEEK, RANDALL F.   GIN, JOANNA   GIN, JOANNA   FARIAS, NANCY   HERNANDEZ, MARY A.   HERNANDEZ, MARY A.   NANCY FARIAS   STEPHANIE I. BURRI   GUERRERO, MARIO   MARTINEZ, ASHLEY T.   GUERRERO, MARIO   WOMACK, NANCY F.   MARY HERNANDEZ   ASHLEY T. MARTINEZ
entity_city   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
entity_st   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
entity_zip   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
entity_phone   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
entity_id   1147771   0   1285452   None   1295286   1255631   None   None   1303008   None   None   None   1262045   1319016   1237154   1365123   None   1324291   None   1262045   1355001
responsible_officer   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
effect_dt   2007-10-01 00:00:00   2006-04-10 00:00:00   2006-04-10 00:00:00   2007-01-23 00:00:00   2007-09-21 00:00:00   2007-02-03 00:00:00   2008-11-05 00:00:00   2008-11-05 00:00:00   2008-09-26 00:00:00   2007-11-26 00:00:00   2009-05-18 00:00:00   2009-06-22 00:00:00   2009-10-07 00:00:00   2012-07-06 00:00:00   2012-09-07 00:00:00   2013-01-16 00:00:00   2013-01-14 00:00:00   2017-07-27 00:00:00   2017-09-11 00:00:00   2019-08-23 00:00:00   2018-09-07 00:00:00
Table: received_filings
filer_id   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451   1285451
filing_file_name   512890.cal   1189392_0.cal   1330124_0.cal   1397928_0.cal   1508559_0.cal   1453210_0.cal   1214883_0.cal   1235337_0.cal   451883.cal   1464890_0.cal   1262446_0.cal   1437768_0.cal   1422015_0.cal   1422015_1.cal   1284613_0.cal   1312434_0.cal   254876.cal   254887.cal   253047.cal   1377553_0.cal   1485636_0.cal   1765883_1.cal   1765883_2.cal   1739334_0.cal   395145.cal   1677817_0.cal   158440.cal   1540961_0.cal   10281.cal   11000.cal   10053.cal   10992.cal   31214.cal   31254.cal   9944.cal   10347.cal   1592070_0.cal   1569525_0.cal   1635808_0.cal   1609024_0.cal   1765883_0.cal   1622971_0.cal   1708452_0.cal   1657621_0.cal   1868433_0.cal   1982142_0.cal   1997199_0.cal   2010728_0.cal   2062275_0.cal   1911016_0.cal   1933787_0.cal   2175160_0.cal   2381071_0.cal   2346348_0.cal   2470527_0.cal   2443246_0.cal   2484603_0.cal   2210385_0.cal   2193363_0.cal   2677676_0.cal   2707183_0.cal   2643517_0.cal
received_date   2006-04-14 00:00:00   2006-07-28 00:00:00   2008-04-30 00:00:00   2009-02-02 00:00:00   2010-08-02 00:00:00   2009-11-02 00:00:00   2006-10-30 00:00:00   2007-01-30 00:00:00   2007-02-15 00:00:00   2010-02-01 00:00:00   2007-04-30 00:00:00   2009-07-31 00:00:00   2009-04-30 00:00:00   2009-06-08 00:00:00   2007-07-31 00:00:00   2008-01-31 00:00:00   2008-01-31 00:00:00   2008-01-31 00:00:00   2008-01-31 00:00:00   2008-10-31 00:00:00   2010-04-30 00:00:00   2013-07-11 00:00:00   2013-07-12 00:00:00   2013-01-31 00:00:00   2013-01-25 00:00:00   2012-07-30 00:00:00   2014-04-01 00:00:00   2010-11-01 00:00:00   2012-10-02 00:00:00   2012-10-02 00:00:00   2012-10-02 00:00:00   2012-10-02 00:00:00   2012-10-03 00:00:00   2012-10-03 00:00:00   2012-10-02 00:00:00   2012-10-02 00:00:00   2011-05-02 00:00:00   2011-01-29 00:00:00   2012-01-31 00:00:00   2011-08-01 00:00:00   2013-04-30 00:00:00   2011-10-31 00:00:00   2012-10-31 00:00:00   2012-04-30 00:00:00   2014-07-29 00:00:00   2015-07-31 00:00:00   2015-10-30 00:00:00   2016-01-29 00:00:00   2016-07-29 00:00:00   2014-10-31 00:00:00   2015-01-30 00:00:00   2017-07-31 00:00:00   2019-04-30 00:00:00   2019-01-30 00:00:00   2020-04-30 00:00:00   2020-01-31 00:00:00   2020-07-30 00:00:00   2018-01-31 00:00:00   2017-10-31 00:00:00   2022-05-02 00:00:00   2022-08-01 00:00:00   2022-01-31 00:00:00
filing_directory   /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/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/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/temp   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/temp   /cafiler/disclose/ca99/temp   /cafiler/disclose/ca99/temp   /cafiler/disclose/ca99/temp   /cafiler/disclose/ca99/temp   /cafiler/disclose/ca99/temp   /cafiler/disclose/ca99/temp   /cafiler/disclose/ca99/temp   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal
filing_id   None   1189392   1330124   1397928   1508559   1453210   1214883   1235337   None   1464890   1262446   1437768   1422015   1422015   1284613   1312434   None   None   None   1377553   1485636   1765883   1765883   1739334   None   1677817   None   1540961   None   None   None   None   None   None   None   None   1592070   1569525   1635808   1609024   1765883   1622971   1708452   1657621   1868433   1982142   1997199   2010728   2062275   1911016   1933787   2175160   2381071   2346348   2470527   2443246   2484603   2210385   2193363   2677676   2707183   2643517
form_id   None   F635   F635   F635   F635   F635   F635   F635   None   F635   F635   F635   F635   F635   F635   F635   None   None   None   F635   F635   F635   F635   F635   None   F635   None   F635   None   None   None   None   None   None   None   None   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
receive_comment   Filing passed validation, but failed DB constraints   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing did not pass validation   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing did not pass validation   Filing did not pass validation   Filing did not pass validation   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing did not pass validation   Filing accepted   Filing passed validation, but failed DB constraints   Filing accepted   Filing passed validation, but failed DB constraints   Filing passed validation, but failed DB constraints   Filing passed validation, but failed DB constraints   Filing passed validation, but failed DB constraints   Filing passed validation, but failed DB constraints   Filing passed validation, but failed DB constraints   Filing passed validation, but failed DB constraints   Filing passed validation, but failed DB constraints   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted