Home

Filer ID: 1236649

Table: cvr_lobby_disclosure
filing_id   789326   811062   1285060   1262809   1238554   1216966   1285060   1312525   1351915   1297996   1330232   1374222   1452364   1420561   1438678   1396099   1485594   1500082   1465342   1569611   1541162   1621633   1609145   1598871   1637519   1680607   1658259   1740691   1710349   1800520   1783810   1766278   1783810   1871301   1908310   1846248   1818387   1980449   1995925   1966305   1937484   1980449   2038764   2064569   2038764   2010890   2102605   2168795   2156818   2126267   2193849   2241035   2276712   2211712   2314313   2393277   2379110   2349974   2415307   2444147   2471399   2525587   2553857   2486729   2624364   2603692   2580311   2702417   2643269   2740863   2676451
amend_id   0   0   1   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   1   0   0   0   0   0   0   0   0   1   1   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0
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
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
sender_id   1236649   1236649   F00741   F00741   F00741   F00741   F00741   F00741   F00741   F00741   F00741   F00741   F00741   F00741   F00741   F00741   F00741   F00741   F00741   F00741   F00741   F00741   F00741   F00741   F00741   F00741   F00741   F00741   F00741   F00741   F00741   F00741   F00741   F00741   F00741   F00741   F00741   F00741   F00741   F00741   F00741   F00741   F00741   F00741   F00741   F00741   F00741   F00741   F00741   F00741   F00741   F00741   F00741   F00741   F00741   F00741   F00741   F00741   F00741   F00741   F00741   F00741   F00741   F00741   F00741   F00741   F00741   F00741   F00741   F00741   F00741
filer_id   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649
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
filer_naml   Multi-State Associates Inc. on behalf of Plumbing Manufacturers Institute   Plumbing Manufacturers Institute   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL
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
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
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
report_num   000   000   001   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   001   000   000   000   000   000   000   000   000   001   001   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000
rpt_date   2001-10-25 00:00:00   2002-01-28 00:00:00   2007-07-31 00:00:00   2007-04-30 00:00:00   2007-01-31 00:00:00   2006-10-31 00:00:00   2007-07-31 00:00:00   2008-01-31 00:00:00   2008-07-31 00:00:00   2007-10-31 00:00:00   2008-04-30 00:00:00   2008-10-28 00:00:00   2009-10-30 00:00:00   2009-04-29 00:00:00   2009-07-31 00:00:00   2009-01-30 00:00:00   2010-04-30 00:00:00   2010-07-12 00:00:00   2010-02-01 00:00:00   2011-01-29 00:00:00   2010-11-01 00:00:00   2011-10-28 00:00:00   2011-08-01 00:00:00   2011-07-06 00:00:00   2012-01-31 00:00:00   2012-07-31 00:00:00   2012-04-30 00:00:00   2013-01-31 00:00:00   2012-10-31 00:00:00   2013-10-30 00:00:00   2013-07-31 00:00:00   2013-04-30 00:00:00   2013-07-31 00:00:00   2014-07-30 00:00:00   2014-10-29 00:00:00   2014-04-30 00:00:00   2014-01-31 00:00:00   2015-07-30 00:00:00   2015-10-28 00:00:00   2015-04-30 00:00:00   2015-02-02 00:00:00   2015-07-30 00:00:00   2016-05-02 00:00:00   2016-08-01 00:00:00   2016-05-02 00:00:00   2016-01-29 00:00:00   2016-10-31 00:00:00   2017-07-19 00:00:00   2017-04-28 00:00:00   2017-01-27 00:00:00   2017-10-31 00:00:00   2018-04-30 00:00:00   2018-07-31 00:00:00   2018-01-31 00:00:00   2018-10-26 00:00:00   2019-07-25 00:00:00   2019-04-29 00:00:00   2019-01-31 00:00:00   2019-10-24 00:00:00   2020-01-31 00:00:00   2020-04-30 00:00:00   2020-10-28 00:00:00   2021-02-01 00:00:00   2020-07-31 00:00:00   2021-11-01 00:00:00   2021-08-02 00:00:00   2021-04-30 00:00:00   2022-07-27 00:00:00   2022-01-31 00:00:00   2022-10-25 00:00:00   2022-05-02 00:00:00
from_date   2001-07-01 00:00:00   2001-10-01 00:00:00   2007-04-01 00:00:00   2007-01-01 00:00:00   2006-10-01 00:00:00   2006-07-01 00:00:00   2007-04-01 00:00:00   2007-10-01 00:00:00   2008-04-01 00:00:00   2007-07-01 00:00:00   2008-01-01 00:00:00   2008-07-01 00:00:00   2009-07-01 00:00:00   2009-01-01 00:00:00   2009-04-01 00:00:00   2008-10-01 00:00:00   2010-01-01 00:00:00   2010-04-01 00:00:00   2009-10-01 00:00:00   2010-10-01 00:00:00   2010-07-01 00:00:00   2011-07-01 00:00:00   2011-04-01 00:00:00   2011-01-01 00:00:00   2011-10-01 00:00:00   2012-04-01 00:00:00   2012-01-01 00:00:00   2012-10-01 00:00:00   2012-07-01 00:00:00   2013-07-01 00:00:00   2013-04-01 00:00:00   2013-01-01 00:00:00   2013-04-01 00:00:00   2014-04-01 00:00:00   2014-07-01 00:00:00   2014-01-01 00:00:00   2013-10-01 00:00:00   2015-04-01 00:00:00   2015-07-01 00:00:00   2015-01-01 00:00:00   2014-10-01 00:00:00   2015-04-01 00:00:00   2016-01-01 00:00:00   2016-04-01 00:00:00   2016-01-01 00:00:00   2015-10-01 00:00:00   2016-07-01 00:00:00   2017-04-01 00:00:00   2017-01-01 00:00:00   2016-10-01 00:00:00   2017-07-01 00:00:00   2018-01-01 00:00:00   2018-04-01 00:00:00   2017-10-01 00:00:00   2018-07-01 00:00:00   2019-04-01 00:00:00   2019-01-01 00:00:00   2018-10-01 00:00:00   2019-07-01 00:00:00   2019-10-01 00:00:00   2020-01-01 00:00:00   2020-07-01 00:00:00   2020-10-01 00:00:00   2020-04-01 00:00:00   2021-07-01 00:00:00   2021-04-01 00:00:00   2021-01-01 00:00:00   2022-04-01 00:00:00   2021-10-01 00:00:00   2022-07-01 00:00:00   2022-01-01 00:00:00
thru_date   2001-09-30 00:00:00   2001-12-31 00:00:00   2007-06-30 00:00:00   2007-03-31 00:00:00   2006-12-31 00:00:00   2006-09-30 00:00:00   2007-06-30 00:00:00   2007-12-31 00:00:00   2008-06-30 00:00:00   2007-09-30 00:00:00   2008-03-31 00:00:00   2008-09-30 00:00:00   2009-09-30 00:00:00   2009-03-31 00:00:00   2009-06-30 00:00:00   2008-12-31 00:00:00   2010-03-31 00:00:00   2010-06-30 00:00:00   2009-12-31 00:00:00   2010-12-31 00:00:00   2010-09-30 00:00:00   2011-09-30 00:00:00   2011-06-30 00:00:00   2011-03-31 00:00:00   2011-12-31 00:00:00   2012-06-30 00:00:00   2012-03-31 00:00:00   2012-12-31 00:00:00   2012-09-30 00:00:00   2013-09-30 00:00:00   2013-06-30 00:00:00   2013-03-31 00:00:00   2013-06-30 00:00:00   2014-06-30 00:00:00   2014-09-30 00:00:00   2014-03-31 00:00:00   2013-12-31 00:00:00   2015-06-30 00:00:00   2015-09-30 00:00:00   2015-03-31 00:00:00   2014-12-31 00:00:00   2015-06-30 00:00:00   2016-03-31 00:00:00   2016-06-30 00:00:00   2016-03-31 00:00:00   2015-12-31 00:00:00   2016-09-30 00:00:00   2017-06-30 00:00:00   2017-03-31 00:00:00   2016-12-31 00:00:00   2017-09-30 00:00:00   2018-03-31 00:00:00   2018-06-30 00:00:00   2017-12-31 00:00:00   2018-09-30 00:00:00   2019-06-30 00:00:00   2019-03-31 00:00:00   2018-12-31 00:00:00   2019-09-30 00:00:00   2019-12-31 00:00:00   2020-03-31 00:00:00   2020-09-30 00:00:00   2020-12-31 00:00:00   2020-06-30 00:00:00   2021-09-30 00:00:00   2021-06-30 00:00:00   2021-03-31 00:00:00   2022-06-30 00:00:00   2021-12-31 00:00:00   2022-09-30 00:00:00   2022-03-31 00:00:00
cum_beg_dt   2001-04-01 00:00:00   2001-04-01 00:00:00   2007-01-01 00:00:00   2007-01-01 00:00:00   2005-01-01 00:00:00   2005-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   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   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   2014-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   2016-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   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   2019-01-01 00:00:00   2017-01-01 00:00:00   2019-01-01 00:00:00   2019-01-01 00:00:00   2019-01-01 00:00:00   2019-01-01 00:00:00   2019-01-01 00:00:00   2019-01-01 00:00:00   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   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649
firm_name   Multi-State Associates Inc. on behalf of Plumbing Manufacturers Institute   Plumbing Manufacturers Institute   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL
firm_city   Alexandria   Alexandria   SHAUMBURG   SHAUMBURG   SHAUMBURG   SHAUMBURG   SHAUMBURG   SHAUMBURG   SHAUMBURG   SHAUMBURG   SHAUMBURG   SHAUMBURG   Rolling Meadows   Rolling Meadows   Rolling Meadows   SHAUMBURG   Rolling Meadows   Rolling Meadows   Rolling Meadows   Rolling Meadows   Rolling Meadows   ROLLING MEADOWS   ROLLING MEADOWS   Rolling Meadows   ROLLING MEADOWS   ROLLING MEADOWS   ROLLING MEADOWS   ROLLING MEADOWS   ROLLING MEADOWS   ROLLING MEADOWS   ROLLING MEADOWS   ROLLING MEADOWS   ROLLING MEADOWS   ROLLING MEADOWS   ROLLING MEADOWS   ROLLING MEADOWS   ROLLING MEADOWS   ROLLING MEADOWS   ROLLING MEADOWS   ROLLING MEADOWS   ROLLING MEADOWS   ROLLING MEADOWS   ROLLING MEADOWS   ROLLING MEADOWS   ROLLING MEADOWS   ROLLING MEADOWS   ROLLING MEADOWS   ROLLING MEADOWS   ROLLING MEADOWS   ROLLING MEADOWS   ROLLING MEADOWS   ROLLING MEADOWS   McLean   ROLLING MEADOWS   McLean   McLean   McLean   McLean   McLean   McLean   McLean   McLean   McLean   McLean   McLean   McLean   McLean   McLean   McLean   McLean   McLean
firm_st   VA   VA   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   IL   VA   IL   VA   VA   VA   VA   VA   VA   VA   VA   VA   VA   VA   VA   VA   VA   VA   VA   VA
firm_zip4   22314   22314   60173   60173   60173   60173   60173   60173   60173   60173   60173   60173   60008   60008   60008   60173   60008   60008   60008   60008   60008   60008   60008   60008   60008   60008   60008   60008   60008   60008   60008   60008   60008   60008   60008   60008   60008   60008   60008   60008   60008   60008   60008   60008   60008   60008   60008   60008   60008   60008   60008   60008   22102   60008   22102   22102   22102   22102   22102   22102   22102   22102   22102   22102   22102   22102   22102   22102   22102   22102   22102
firm_phon   703/684-1110   703/684-1110   (847) 884-9764   (847) 884-9764   (847) 884-9764   (847) 884-9764   (847) 884-9764   (847) 884-9764   (847) 884-9764   (847) 884-9764   (847) 884-9764   (847) 884-9764   847.481.5500   847.481.5500   847.481.5500   (847) 884-9764   847.481.5500   847.481.5500   847.481.5500   847.481.5500   847.481.5500   916.441.4166   916.441.4166   847.481.5500   916.441.4166   916.441.4166   916.441.4166   916.441.4166   916.441.4166   916.441.4166   916.441.4166   916.441.4166   916.441.4166   916.441.4166   916.441.4166   916.441.4166   916.441.4166   916.441.4166   916.441.4166   916.441.4166   916.441.4166   916.441.4166   916.441.4166   916.441.4166   916.441.4166   916.441.4166   916.441.4166   916.441.4166   916.441.4166   916.441.4166   916.441.4166   916.441.4166   847-481-5500   916.441.4166   847-481-5500   847-481-5500   847-481-5500   847-481-5500   847-481-5500   847-481-5500   847-481-5500   847-481-5500   847-481-5500   847-481-5500   847-481-5500   847-481-5500   847-481-5500   847-481-5500   847-481-5500   847-481-5500   847-481-5500
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
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
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
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
sig_date   2001-10-23 00:00:00   2002-01-23 00:00:00   2007-10-04 00:00:00   2007-05-01 00:00:00   2007-01-31 00:00:00   2006-10-31 00:00:00   2007-07-31 00:00:00   2008-01-31 00:00:00   2008-07-31 00:00:00   2007-10-31 00:00:00   2008-04-30 00:00:00   2008-10-28 00:00:00   2009-10-30 00:00:00   2009-04-29 00:00:00   2009-07-31 00:00:00   2009-01-30 00:00:00   2010-04-30 00:00:00   2010-07-12 00:00:00   2010-02-01 00:00:00   2011-01-29 00:00:00   2010-11-01 00:00:00   2011-10-30 00:00:00   2011-08-01 00:00:00   2011-07-06 00:00:00   2012-01-31 00:00:00   2012-07-31 00:00:00   2012-04-30 00:00:00   2013-01-31 00:00:00   2012-10-31 00:00:00   2013-10-31 00:00:00   2013-07-31 00:00:00   2013-04-30 00:00:00   2014-01-30 00:00:00   2014-07-31 00:00:00   2014-10-29 00:00:00   2014-04-30 00:00:00   2014-01-31 00:00:00   2015-07-30 00:00:00   2015-10-29 00:00:00   2015-04-30 00:00:00   2015-02-02 00:00:00   2015-11-10 00:00:00   2016-07-28 00:00:00   2016-08-01 00:00:00   2016-05-02 00:00:00   2016-01-29 00:00:00   2016-10-31 00:00:00   2017-07-19 00:00:00   2017-04-30 00:00:00   2017-01-29 00:00:00   2017-10-31 00:00:00   2018-04-30 00:00:00   2018-07-31 00:00:00   2018-01-31 00:00:00   2018-10-26 00:00:00   2019-07-25 00:00:00   2019-04-29 00:00:00   2019-01-31 00:00:00   2019-10-24 00:00:00   2020-01-31 00:00:00   2020-04-30 00:00:00   2020-10-28 00:00:00   2021-02-01 00:00:00   2020-07-31 00:00:00   2021-11-01 00:00:00   2021-08-02 00:00:00   2021-04-30 00:00:00   2022-07-27 00:00:00   2022-01-31 00:00:00   2022-10-25 00:00:00   2022-05-02 00:00:00
sig_loc   Alexandria VA   Alexandria, VA   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   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   Hallman   Hallman   Desmond Jr.   Desmond Jr.   Desmond   Desmond   Desmond Jr.   Desmond Jr.   Desmond Jr.   Desmond Jr.   Desmond Jr.   Desmond Jr.   Desmond Jr.   Desmond Jr.   Desmond Jr.   Desmond Jr.   Desmond Jr.   Desmond Jr.   Desmond Jr.   Desmond Jr.   Desmond Jr.   Desmond Jr.   Desmond Jr.   Desmond Jr.   Desmond Jr.   Desmond Jr   Desmond Jr   Desmond Jr   Desmond Jr.   Desmond Jr.   Desmond Jr   Desmond Jr   Desmond Jr   Desmond Jr   Desmond Jr   Desmond Jr   Desmond Jr   Desmond Jr   Desmond Jr   Desmond Jr   Desmond Jr   Desmond Jr   Desmond Jr   Desmond Jr   Desmond Jr   Desmond Jr   Desmond Jr   Desmond Jr   Desmond Jr   Desmond Jr   Desmond Jr   Desmond Jr   Desmond Jr   Desmond Jr   Desmond Jr   Desmond Jr   Desmond Jr   Desmond Jr   Desmond Jr   Desmond Jr   Desmond Jr   Desmond Jr   Desmond Jr   Desmond Jr   Desmond Jr   Desmond Jr   Desmond Jr   Desmond Jr   Desmond Jr   Desmond Jr   Desmond Jr
sig_namf   Paul W.   Paul W.   Jerry   Gerald J.   Jerry   Gerald J.   Gerald J.   Jerry   Jerry   Gerald   Jerry   Jerry   Jerry   Jerry   Jerry   Jerry   Jerry   Jerry   Jerry   Jerry   Jerry   Jerry   Jerry   Jerry   Jerry   Jerry   Jerry   Jerry   Jerry   Jerry   Jerry   Jerry   Jerry   Jerry   Jerry   Jerry   Jerry   Jerry   Gerald J   Gerald   Jerry   Gerald J   Gerald   Gerald   Gerald   Gerald J   Gerald J.   Gerald J   Gerald J   Gerald J   Gerald J   Gerald J   Gerald J   Gerald J   Gerald J   Gerald J   Gerald J   Gerald   Gerald J   Gerald J   Gerald J   Gerald J   Gerald J   Gerald J   Gerald J   Gerald J   Gerald J   Gerald J   Gerald J   Gerald J   Gerald J
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
sig_nams   None   None   None   None   Jr.   Jr.   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   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   Hallman   Hallman   Desmond Jr.   Desmond Jr.   Desmond   Desmond   Desmond Jr.   Desmond Jr.   Desmond Jr.   Desmond Jr.   Desmond Jr.   Desmond Jr.   Desmond Jr.   Desmond Jr.   Desmond Jr.   Desmond Jr.   Desmond Jr.   Desmond Jr.   Desmond Jr.   Desmond Jr.   Desmond Jr.   Desmond Jr.   Desmond Jr.   Desmond Jr.   Desmond Jr.   Desmond Jr   Desmond Jr   Desmond Jr   Desmond Jr.   Desmond Jr.   Desmond Jr   Desmond Jr   Desmond Jr   Desmond Jr   Desmond Jr   Desmond Jr   Desmond Jr   Desmond Jr   Desmond Jr   Desmond Jr   Desmond Jr   Desmond Jr   Desmond Jr   Desmond Jr   Desmond Jr   Desmond Jr   Desmond Jr   Desmond Jr   Desmond Jr   Desmond Jr   Desmond Jr   Desmond Jr   Desmond Jr   Desmond Jr   Desmond Jr   Desmond Jr   Desmond Jr   Desmond Jr   Desmond Jr   Desmond Jr   Desmond Jr   Desmond Jr   Desmond Jr   Desmond Jr   Desmond Jr   Desmond Jr   Desmond Jr   Desmond Jr   Desmond Jr   Desmond Jr   Desmond Jr
prn_namf   Paul W.   Paul W.   Jerry   Gerald J.   Jerry   Gerald J.   Gerald J.   Jerry   Jerry   Gerald   Jerry   Jerry   Jerry   Jerry   Jerry   Jerry   Jerry   Jerry   Jerry   Jerry   Jerry   Jerry   Jerry   Jerry   Jerry   Jerry   Jerry   Jerry   Jerry   Jerry   Jerry   Jerry   Jerry   Jerry   Jerry   Jerry   Jerry   Jerry   Gerald J   Gerald   Jerry   Gerald J   Gerald   Gerald   Gerald   Gerald J   Gerald J.   Gerald J   Gerald J   Gerald J   Gerald J   Gerald J   Gerald J   Gerald J   Gerald J   Gerald J   Gerald J   Gerald   Gerald J   Gerald J   Gerald J   Gerald J   Gerald J   Gerald J   Gerald J   Gerald J   Gerald J   Gerald J   Gerald J   Gerald J   Gerald J
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
prn_nams   None   None   None   None   Jr.   Jr.   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
sig_title   None   None   Attorney   Attorney   Attorney   Attorney   Attorney   Attorney   Attorney   Attorney   Partner   Attorney   Attorney   Attorney   Attorney   Attorney   Attorney   Attorney   Attorney   Attorney   Attorney   Attorney   Attorney   Attorney   Attorney   Attorney   Attorney   Attorney   Attorney   Attorney   Attorney   Attorney   Attorney   Attorney   Attorney   Attorney   Attorney   Esq.   Attorney   Advocate   Attorney   Attorney   Attorney   Attorney   Attorney   Attorney   Attorney   Attorney   Attorney   Attorney   Attorney   Attorney   Attorney   Attorney   Attorney   Attorney   Manager   Attorney   Manager   Manager   Manager   Manager   Manager   Manager   Manager   Manager   Manager   Manager   Manager   Manager   Manager
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
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
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
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
ctrib_n_cb   None   None   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X   X
ctrib_y_cb   X   X   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
lby_actvty   California Energy Commission: Plumbing regulations   none   See attached:   See attached: 2   None   AB 1953 AB 2160 AB 2228 AB 2402 AB 2496 AB 2515 AB 2710 AB 2861 AB 2901 SB 1379 SB 1774   See attached:   See attached:   See attached:   See attached:   See attached:   See attached:   None   None   None   Building Standards Commission - Green Building Regulations and Plumbing Code Regulations Housing and Community Development - Green Building and Plumbing Code Regulations Dept of Toxic Substances Control - Regulations re Plumbing Products and Fixtures Green Chemistry Regulations   None   None   None   See attached   None   See attached   None   None   Plumbing Manufacturers International - See attached   Plumbing Manufacturers International - See attached   Plumbing Manufacturers International - See attached   Plumbing Manufacturers International - See attached   Plumbing Manufacturers International - See attached   Plumbing Manufacturers International - See attached   Plumbing Manufacturers International - See attached   Plumbing Manufacturers International - See attached   Plumbing Manufacturers International - See attached   Plumbing Manufacturers International - See attached   Plumbing Manufacturers International - See attached   Plumbing Manufacturers International - See attached   Plumbing Manufacturers International - See attached   Plumbing Manufacturers International - See attached   Plumbing Manufacturers International - See attached   Plumbing Manufacturers International - See attached   Plumbing Manufacturers International - See attached   Plumbing Manufacturers International - See attached   Plumbing Manufacturers International - See attached   Plumbing Manufacturers International - See attached   Plumbing Manufacturers International - See attached   Plumbing Manufacturers International - See attached   Plumbing Manufacturers International - See attached   Plumbing Manufacturers International - See attached   Plumbing Manufacturers International - See attached   Plumbing Manufacturers International - See attached   Plumbing Manufacturers International - See attached   Plumbing Manufacturers International - See attached   Plumbing Manufacturers International - See attached   Plumbing Manufacturers International - See attached   Plumbing Manufacturers International - See attached   Plumbing Manufacturers International - See attached   Plumbing Manufacturers International - See attached   Plumbing Manufacturers International - See attached   Plumbing Manufacturers International - See attached   Plumbing Manufacturers International - See attached   Plumbing Manufacturers International - See attached   Plumbing Manufacturers International - See attached   Plumbing Manufacturers International - See attached   Plumbing Manufacturers International - See attached   Plumbing Manufacturers International - See attached   Plumbing Manufacturers International - See attached   Plumbing Manufacturers International - See attached   Plumbing Manufacturers International - See attached   Plumbing Manufacturers International - See attached   Plumbing Manufacturers International - See attached   Plumbing Manufacturers International - See attached
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
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
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
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
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
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
rcpcmte_nm   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
rcpcmte_id   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
Table: cvr_registration
filing_id   1151997   1224889   1385853   1553699   1385853   1553699   1721408   1921225   2110851   2328061   2541665
amend_id   0   0   0   0   1   1   0   0   0   0   0
rec_type   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR
form_type   F602   F602   F602   F602   F602   F602   F602   F602   F602   F602   F602
sender_id   F00741   F00741   F00741   F00741   F00741   F00741   F00741   F00741   F00741   F00741   F00741
filer_id   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649
entity_cd   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM   LEM
filer_naml   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   Plumbing Manufacturers International   Plumbing Manufacturers International   Plumbing Manufacturers International   Plumbing Manufacturers International   Plumbing Manufacturers International   Plumbing Manufacturers International   Plumbing Manufacturers International   Plumbing Manufacturers International
filer_namf   None   None   None   None   None   None   None   None   None   None   None
filer_namt   None   None   None   None   None   None   None   None   None   None   None
filer_nams   None   None   None   None   None   None   None   None   None   None   None
report_num   000   000   000   000   001   001   000   000   000   000   000
rpt_date   2006-02-14 00:00:00   2006-12-27 00:00:00   2008-12-01 00:00:00   2010-12-23 00:00:00   2011-07-07 00:00:00   2011-07-07 00:00:00   2012-12-28 00:00:00   2014-12-29 00:00:00   2016-12-13 00:00:00   2018-12-13 00:00:00   2020-12-31 00:00:00
ls_beg_yr   2005   2007   2008   2010   2008   2010   2012   2015   2017   2019   2021
ls_end_yr   2006   2008   2010   2012   2010   2012   2014   2016   2018   2020   2022
qual_date   None   None   None   None   None   None   None   None   None   None   None
eff_date   2006-02-12 00:00:00   2006-12-04 00:00:00   2008-12-01 00:00:00   2010-12-06 00:00:00   2010-12-01 00:00:00   2010-12-06 00:00:00   2012-12-03 00:00:00   2014-12-01 00:00:00   2016-12-05 00:00:00   2018-12-03 00:00:00   2020-12-07 00:00:00
bus_city   SHAUMBURG   SHAUMBURG   Rolling Meadows   Rolling Meadows   Rolling Meadows   Rolling Meadows   Rolling Meadows   Rolling Meadows   Rolling Meadows   McLean   McLean
bus_st   IL   IL   IL   IL   IL   IL   IL   IL   IL   VA   VA
bus_zip4   60173   60173   60008   60008   60008   60008   60008   60008   60008   22102   22102
bus_phon   847-884-9764   847-884-9764   847.481.5500   847.481.5500   847.481.5500   847.481.5500   847.481.5500   847.481.5500   847.481.5500   847.481.5500   847.481.5500
bus_fax   None   None   847.481.5501   847.481.5501   847.481.5501   847.481.5501   847.481.5501   847.481.5501   847.481.5501   None   None
bus_email   None   None   None   None   None   None   None   None   None   None   None
mail_city   None   None   None   None   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento
mail_st   None   None   None   None   CA   CA   CA   CA   CA   CA   CA
mail_zip4   None   None   None   None   95814   95814   95814   95814   95814   95814   95814
mail_phon   None   None   None   None   916.441.4166   916.441.4166   916.441.4166   916.441.4166   916.441.4166   916.441.4166   916.441.4166
sig_date   2006-02-07 00:00:00   2006-11-15 00:00:00   2008-12-15 00:00:00   2010-12-06 00:00:00   2011-07-07 00:00:00   2011-07-07 00:00:00   2012-12-03 00:00:00   2014-12-01 00:00:00   2016-11-29 00:00:00   2018-12-17 00:00:00   2020-12-08 00:00:00
sig_loc   Shaumburg IL   Shaumburg IL   Rolling Meadows IL   Rolling Meadows IL   Sacramento CA   Sacramento CA   Rolling Meadows IL   Rolling Meadows IL   Rolling Meadows IL   McLean Virginia   McLean Virginia
sig_naml   Higgens   Higgens   Higgens   Higgens   Desmond Jr.   Desmond Jr.   Higgens   Higgens   Higgens   Stackpole   Stackpole
sig_namf   Barbara   Barbara   Barbara   Barbara   Jerry   Jerry   Barbara   Barbara   Barbara   Kerry   Kerry
sig_namt   None   None   None   None   None   None   None   None   None   None   None
sig_nams   None   None   None   None   None   None   None   None   None   None   None
prn_naml   None   None   None   None   None   None   None   None   None   None   None
prn_namf   None   None   None   None   None   None   None   None   None   None   None
prn_namt   None   None   None   None   None   None   None   None   None   None   None
prn_nams   None   None   None   None   None   None   None   None   None   None   None
sig_title   Executive Director   Executive Director   Executive Director   Executive Director   Attorney   Attorney   Executive Director   CEO/Executive Director   CEO/Executive Director   CEO/Executive Director   CEO/Executive Director
stmt_firm   None   None   None   None   None   None   None   None   None   None   None
ind_cb   None   None   None   None   None   None   None   None   None   None   None
bus_cb   None   None   None   None   None   None   None   None   None   None   None
trade_cb   X   X   X   X   X   X   X   X   X   X   X
oth_cb   None   None   None   None   None   None   None   None   None   None   None
a_b_name   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
a_b_st   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
descrip_1   Plumbing Products Manufacturers   Plumbing Products Manufacturers   Plumbing products manufacturers.   Plumbing products manufacturers.   Plumbing products manufacturers.   Plumbing products manufacturers.   Plumbing products manufacturers.   Plumbing products manufacturers.   Plumbing products manufacturers.   Plumbing products manufacturers.   Plumbing products manufacturers.
descrip_2   The member companies produce most of the nation's plumbing products.   The member companies produce most of the nation's plumbing products.   The member companies produce most of the nation's plumbing products.   The member companies produce most of the nation's plumbing products.   The member companies produce most of the nation's plumbing products.   The member companies produce most of the nation's plumbing products.   The member companies produce most of the nation's plumbing products.   N/A   N/A   N/A   N/A
c_less50   X   X   X   X   X   X   X   X   X   X   X
c_more50   None   None   None   None   None   None   None   None   None   None   None
ind_class   OTH   OTH   OTH   OTH   OTH   OTH   OTH   OTH   OTH   OTH   OTH
ind_descr   Manufacturing   Manufacturing   Manufacturing   Manufacturing   Manufacturing   Manufacturing   Manufacturing   Manufacturing   Manufacturing   Manufacturing   Manufacturing
bus_class   MAN   MAN   MAN   MAN   MAN   MAN   MAN   MAN   MAN   MAN   MAN
bus_descr   None   None   None   None   None   None   None   None   None   None   None
auth_name   Desmond & Desmond   Desmond & Desmond   Desmond and Desmond   Desmond and Desmond   Desmond and Desmond   Desmond and Desmond   Desmond and Desmond   Desmond & Desmond LLC   Desmond & Desmond LLC   Desmond & Desmond LLC   Desmond & Desmond LLC
auth_city   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento   Sacramento
auth_st   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA
auth_zip4   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814   95814
lobby_int   None   None   None   None   None   None   None   None   None   None   None
influen_yn   None   None   None   None   None   None   None   None   None   None   None
firm_name   None   None   None   None   None   None   None   None   None   None   None
newcert_cb   None   None   None   None   None   None   None   None   None   None   None
rencert_cb   None   None   None   None   None   None   None   None   None   None   None
complet_dt   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
lby_604_cb   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
st_agency   None   None   None   None   None   None   None   None   None   None   None
lobby_cb   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
Table: efs_filing_log
filing_date   2001-10-25 00:00:00   2001-10-25 00:00:00   2002-01-28 00:00:00   2002-01-28 00:00:00
filingstatus   1   0   1   0
vendor   RACE-TRAX FOR LOBBYISTS   RACE-TRAX FOR LOBBYISTS   RACE-TRAX FOR LOBBYISTS   RACE-TRAX FOR LOBBYISTS
filer_id   1236649   1236649   1236649   1236649
form_type   F635   F635   F635   F635
error_no   ACCEPTED   ACCEPTED   ACCEPTED   ACCEPTED
Table: filer_address
filer_id   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649
adrid   2018279   2098062   2116019   2163368   2206515   2217356   2416952   2416951   2510557   2510558   2553953   2553954   2276148   2276149   2456782   2297296   2468769   2468770   2343845   2343846
effect_dt   2001-06-09 00:00:00   2006-02-12 00:00:00   2007-01-01 00:00:00   2009-01-01 00:00:00   2011-01-01 00:00:00   2011-01-01 00:00:00   2017-01-01 00:00:00   2017-01-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2013-01-01 00:00:00   2013-01-01 00:00:00   2018-07-17 00:00:00   2013-08-30 00:00:00   2019-01-01 00:00:00   2019-01-01 00:00:00   2015-01-01 00:00:00   2015-01-01 00:00:00
add_type   7051   7051   7051   7051   7051   7082   7082   7051   7051   7082   7051   7082   7051   7082   7051   7051   7051   7082   7051   7082
session_id   2001   2005   2007   2009   2011   2011   2017   2017   2021   2021   2023   2023   2013   2013   2017   2013   2019   2019   2015   2015
Table: filer_filings
filer_id   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649
filing_id   771647   773608   789326   782218   811062   803942   797355   800382   824057   1151997   1167573   1152051   1192136   1224889   1216966   1238554   1285060   1234040   1262809   1297996   1285060   1783810   1980449   1966305   1800520   1937484   1946971   1908310   1330232   1312525   1351915   1374222   1396099   1385853   1420561   1413246   1438678   1452364   1465342   1500082   1485594   1541162   1553699   1555533   1569611   1609145   1598871   1385853   1553699   1621633   1637519   1658259   1818387   1783810   1680607   1921225   1710349   1871301   1740691   1742516   1721408   1846248   1766278   1995925   2241035   2582504   2349974   2415307   2314313   2193849   1980449   2010890   2038764   2064569   2038764   2102605   2126267   2110851   2141190   2168795   2156818   2379110   2393277   2357463   2211712   2276712   2525587   2486729   2541665   2328061   2553857   2444147   2471399   2676451   2643269   2603692   2624364   2580311   2702417   2740863
period_id   None   None   167   None   168   None   None   None   None   185   185   None   186   188   187   188   190   None   189   191   190   214   222   221   215   220   None   219   193   192   194   195   196   196   197   None   198   199   200   202   201   203   204   None   204   206   205   207   207   207   208   209   216   214   210   220   211   218   212   None   212   217   213   223   233   None   236   239   235   231   222   224   225   226   225   227   228   228   None   230   229   237   238   None   232   234   243   242   244   236   244   240   241   249   248   246   247   245   250   251
form_id   F602   F999   F635   F635   F635   F690   F635   F635   F635   F602   F635   F602   F635   F602   F635   F635   F635   F602   F635   F635   F635   F635   F635   F635   F635   F635   F602   F635   F635   F635   F635   F635   F635   F602   F635   F602   F635   F635   F635   F635   F635   F635   F602   F602   F635   F635   F635   F602   F602   F635   F635   F635   F635   F635   F635   F602   F635   F635   F635   F602   F602   F635   F635   F635   F635   F602   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F602   F602   F635   F635   F635   F635   F602   F635   F635   F635   F635   F602   F602   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635
filing_sequence   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   1   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   1   1   0   0   0   0   1   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   1   0   0   0   1   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0
filing_date   2001-07-27 00:00:00   2001-08-01 00:00:00   2001-10-25 00:00:00   2001-07-27 00:00:00   2002-01-28 00:00:00   2001-11-20 00:00:00   2001-10-25 00:00:00   2001-11-20 00:00:00   2002-01-25 00:00:00   2006-02-14 00:00:00   2006-05-01 00:00:00   2006-02-14 00:00:00   2006-07-31 00:00:00   2006-12-27 00:00:00   2006-10-31 00:00:00   2007-01-31 00:00:00   2007-07-31 00:00:00   2006-12-29 00:00:00   2007-05-01 00:00:00   2007-10-31 00:00:00   2007-10-04 00:00:00   2013-07-31 00:00:00   2015-07-30 00:00:00   2015-04-30 00:00:00   2013-10-31 00:00:00   2015-02-02 00:00:00   2014-12-30 00:00:00   2014-10-29 00:00:00   2008-04-30 00:00:00   2008-01-31 00:00:00   2008-07-31 00:00:00   2008-10-28 00:00:00   2009-01-30 00:00:00   2008-12-29 00:00:00   2009-04-29 00:00:00   2008-12-30 00:00:00   2009-07-31 00:00:00   2009-10-30 00:00:00   2010-02-01 00:00:00   2010-07-12 00:00:00   2010-04-30 00:00:00   2010-11-01 00:00:00   2010-12-23 00:00:00   2010-12-24 00:00:00   2011-01-29 00:00:00   2011-08-01 00:00:00   2011-07-06 00:00:00   2011-07-07 00:00:00   2011-07-07 00:00:00   2011-10-30 00:00:00   2012-01-31 00:00:00   2012-04-30 00:00:00   2014-01-31 00:00:00   2014-01-30 00:00:00   2012-07-31 00:00:00   2014-12-29 00:00:00   2012-10-31 00:00:00   2014-07-31 00:00:00   2013-01-31 00:00:00   2012-12-31 00:00:00   2012-12-28 00:00:00   2014-04-30 00:00:00   2013-04-30 00:00:00   2015-10-29 00:00:00   2018-04-30 00:00:00   2021-01-05 00:00:00   2019-01-31 00:00:00   2019-10-24 00:00:00   2018-10-26 00:00:00   2017-10-31 00:00:00   2015-11-10 00:00:00   2016-01-29 00:00:00   2016-05-02 00:00:00   2016-08-01 00:00:00   2016-07-28 00:00:00   2016-10-31 00:00:00   2017-01-29 00:00:00   2016-12-13 00:00:00   2016-12-15 00:00:00   2017-07-19 00:00:00   2017-04-30 00:00:00   2019-04-29 00:00:00   2019-07-25 00:00:00   2018-12-26 00:00:00   2018-01-31 00:00:00   2018-07-31 00:00:00   2020-10-28 00:00:00   2020-07-31 00:00:00   2020-12-31 00:00:00   2018-12-13 00:00:00   2021-02-01 00:00:00   2020-01-31 00:00:00   2020-04-30 00:00:00   2022-05-02 00:00:00   2022-01-31 00:00:00   2021-08-02 00:00:00   2021-11-01 00:00:00   2021-04-30 00:00:00   2022-07-27 00:00:00   2022-10-25 00:00:00
stmnt_type   10005   10005   10001   10005   10001   10005   10005   10006   10005   10001   10001   10005   10001   10001   10001   10001   10001   10005   10001   10001   10002   10001   10001   10001   10001   10001   10005   10001   10001   10001   10001   10001   10001   10001   10001   10005   10001   10001   10001   10001   10001   10001   10001   10005   10001   10001   10001   10002   10002   10001   10001   10001   10001   10002   10001   10001   10001   10001   10001   10005   10001   10001   10001   10001   10001   10005   10001   10001   10001   10001   10002   10001   10001   10001   10002   10001   10001   10001   10005   10001   10001   10001   10001   10005   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001
stmnt_status   11001   11001   11003   11001   11003   11001   11001   11003   11001   11003   11001   11001   11001   11003   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11003   11001   11003   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11003   11001   11001   11001   11001   11003   11003
session_id   2001   2001   2001   2001   2001   2001   2001   2001   2001   2005   2005   2005   2005   2007   2005   2005   2007   2007   2007   2007   2007   2013   2015   2015   2013   2013   2015   2013   2007   2007   2007   2007   2007   2008   2009   2009   2009   2009   2009   2009   2009   2009   2010   2011   2009   2011   2011   2008   2010   2011   2011   2011   2013   2013   2011   2015   2011   2013   2011   2013   2012   2013   2013   2015   2017   2021   2017   2019   2017   2017   2015   2015   2015   2015   2015   2015   2015   2017   2017   2017   2017   2019   2019   2019   2017   2017   2019   2019   2021   2019   2019   2019   2019   2021   2021   2021   2021   2021   2021   2021
user_id   GPEREZ   GPEREZ   *   YBONILLA   *   LTHIBAUL   LTHIBAUL   DBARRICK   LTHIBAUL   *   LTHIBAUL   CFLAGG   LTHIBAUL   *   LTHIBAUL   LTHIBAUL   YRODRIGU   SARRIAGA   LTHIBAUL   YRODRIGU   YRODRIGU   AGLADNEY   AGLADNEY   AGLADNEY   ASAETERN   AGLADNEY   YRODRIGU   AGLADNEY   SMCCABE   LTHIBAUL   LTHIBAUL   ASAETERN   ASAETERN   *   MGUERRA   MMORENO   MGUERRA   MGUERRA   MGUERRA   ASAETERN   ASAETERN   ASAETERN   YRODRIGU   SARRIAGA   AGLADNEY   AGLADNEY   ASAETERN   YRODRIGU   YRODRIGU   AGLADNEY   AGLADNEY   AGLADNEY   ASAETERN   ASAETERN   AGLADNEY   YRODRIGU   ASAETERN   AGLADNEY   ASAETERN   GKURIMOT   GKURIMOT   ASAETERN   AGLADNEY   AGLADNEY   AGLADNEY   SARRIAGA   AGLADNEY   SUSHAKOV   AGLADNEY   AGLADNEY   AGLADNEY   AGLADNEY   AGLADNEY   AGLADNEY   AGLADNEY   AGLADNEY   AGLADNEY   YRODRIGU   YRODRIGU   AGLADNEY   MPACHECO   GTAYLOR   VUKSTINA   GPEREZ   AGLADNEY   AGLADNEY   GTAYLOR   CVANLIEW   SARRIAGA   GPEREZ   JMAVES   AGLADNEY   VUKSTINA   CAFILER   RATTIYEH   GTAYLOR   CHATRIDGE   GTAYLOR   CAFILER   CAFILER
special_audit   11003   11003   11003   11003   11003   11003   11003   11003   11002   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003
fine_audit   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11001   11001   11001   11001   11001   11001   11001   11001   11003   11003   11001   11001   11003   11001   11003   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   11003   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11003   11001   11001   11001   11001   11003   11003   11001   11001   11001   11003   11001   11001   11001   11001   11003   11003
rpt_start   1900-01-01 00:00:00   1900-01-01 00:00:00   2001-07-01 00:00:00   2001-04-01 00:00:00   2001-10-01 00:00:00   2001-04-01 00:00:00   2001-07-01 00:00:00   2001-01-01 00:00:00   2001-10-01 00:00:00   2006-02-14 00:00:00   2006-01-01 00:00:00   1900-01-01 00:00:00   2006-04-01 00:00:00   2006-12-27 00:00:00   2006-07-01 00:00:00   2006-10-01 00:00:00   2007-04-01 00:00:00   1900-01-01 00:00:00   2007-01-01 00:00:00   2007-07-01 00:00:00   2007-04-01 00:00:00   2013-04-01 00:00:00   2015-04-01 00:00:00   2015-01-01 00:00:00   2013-07-01 00:00:00   2014-10-01 00:00:00   1900-01-01 00:00:00   2014-07-01 00:00:00   2008-01-01 00:00:00   2007-10-01 00:00:00   2008-04-01 00:00:00   2008-07-01 00:00:00   2008-10-01 00:00:00   2008-12-01 00:00:00   2009-01-01 00:00:00   1900-01-01 00:00:00   2009-04-01 00:00:00   2009-07-01 00:00:00   2009-10-01 00:00:00   2010-04-01 00:00:00   2010-01-01 00:00:00   2010-07-01 00:00:00   2010-12-23 00:00:00   1900-01-01 00:00:00   2010-10-01 00:00:00   2011-04-01 00:00:00   2011-01-01 00:00:00   2011-07-07 00:00:00   2011-07-07 00:00:00   2011-07-01 00:00:00   2011-10-01 00:00:00   2012-01-01 00:00:00   2013-10-01 00:00:00   2013-04-01 00:00:00   2012-04-01 00:00:00   2014-12-29 00:00:00   2012-07-01 00:00:00   2014-04-01 00:00:00   2012-10-01 00:00:00   1900-01-01 00:00:00   2012-12-28 00:00:00   2014-01-01 00:00:00   2013-01-01 00:00:00   2015-07-01 00:00:00   2018-01-01 00:00:00   1900-01-01 00:00:00   2018-10-01 00:00:00   2019-07-01 00:00:00   2018-07-01 00:00:00   2017-07-01 00:00:00   2015-04-01 00:00:00   2015-10-01 00:00:00   2016-01-01 00:00:00   2016-04-01 00:00:00   2016-01-01 00:00:00   2016-07-01 00:00:00   2016-10-01 00:00:00   2016-12-13 00:00:00   1900-01-01 00:00:00   2017-04-01 00:00:00   2017-01-01 00:00:00   2019-01-01 00:00:00   2019-04-01 00:00:00   1900-01-01 00:00:00   2017-10-01 00:00:00   2018-04-01 00:00:00   2020-07-01 00:00:00   2020-04-01 00:00:00   2020-12-31 00:00:00   2018-12-13 00:00:00   2020-10-01 00:00:00   2019-10-01 00:00:00   2020-01-01 00:00:00   2022-01-01 00:00:00   2021-10-01 00:00:00   2021-04-01 00:00:00   2021-07-01 00:00:00   2021-01-01 00:00:00   2022-04-01 00:00:00   2022-07-01 00:00:00
rpt_end   1900-01-01 00:00:00   1900-01-01 00:00:00   2001-09-30 00:00:00   2001-06-30 00:00:00   2001-12-31 00:00:00   2001-06-30 00:00:00   2001-09-30 00:00:00   2001-06-30 00:00:00   2001-12-31 00:00:00   2006-02-14 00:00:00   2006-03-31 00:00:00   1900-01-01 00:00:00   2006-06-30 00:00:00   2006-12-27 00:00:00   2006-09-30 00:00:00   2006-12-31 00:00:00   2007-06-30 00:00:00   1900-01-01 00:00:00   2007-03-31 00:00:00   2007-09-30 00:00:00   2007-06-30 00:00:00   2013-06-30 00:00:00   2015-06-30 00:00:00   2015-03-31 00:00:00   2013-09-30 00:00:00   2014-12-31 00:00:00   1900-01-01 00:00:00   2014-09-30 00:00:00   2008-03-31 00:00:00   2007-12-31 00:00:00   2008-06-30 00:00:00   2008-09-30 00:00:00   2008-12-31 00:00:00   2008-12-01 00:00:00   2009-03-31 00:00:00   1900-01-01 00:00:00   2009-06-30 00:00:00   2009-09-30 00:00:00   2009-12-31 00:00:00   2010-06-30 00:00:00   2010-03-31 00:00:00   2010-09-30 00:00:00   2010-12-23 00:00:00   1900-01-01 00:00:00   2010-12-31 00:00:00   2011-06-30 00:00:00   2011-03-31 00:00:00   2011-07-07 00:00:00   2011-07-07 00:00:00   2011-09-30 00:00:00   2011-12-31 00:00:00   2012-03-31 00:00:00   2013-12-31 00:00:00   2013-06-30 00:00:00   2012-06-30 00:00:00   2014-12-29 00:00:00   2012-09-30 00:00:00   2014-06-30 00:00:00   2012-12-31 00:00:00   1900-01-01 00:00:00   2012-12-28 00:00:00   2014-03-31 00:00:00   2013-03-31 00:00:00   2015-09-30 00:00:00   2018-03-31 00:00:00   1900-01-01 00:00:00   2018-12-31 00:00:00   2019-09-30 00:00:00   2018-09-30 00:00:00   2017-09-30 00:00:00   2015-06-30 00:00:00   2015-12-31 00:00:00   2016-03-31 00:00:00   2016-06-30 00:00:00   2016-03-31 00:00:00   2016-09-30 00:00:00   2016-12-31 00:00:00   2016-12-13 00:00:00   1900-01-01 00:00:00   2017-06-30 00:00:00   2017-03-31 00:00:00   2019-03-31 00:00:00   2019-06-30 00:00:00   1900-01-01 00:00:00   2017-12-31 00:00:00   2018-06-30 00:00:00   2020-09-30 00:00:00   2020-06-30 00:00:00   2020-12-31 00:00:00   2018-12-13 00:00:00   2020-12-31 00:00:00   2019-12-31 00:00:00   2020-03-31 00:00:00   2022-03-31 00:00:00   2021-12-31 00:00:00   2021-06-30 00:00:00   2021-09-30 00:00:00   2021-03-31 00:00:00   2022-06-30 00:00:00   2022-09-30 00:00:00
rpt_date   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
filing_type   None   None   None   None   None   None   None   None   None   22001   22001   None   22001   22001   22001   22001   22001   None   22001   22001   22001   22001   22001   22001   22001   22001   None   22001   22001   22001   22001   22001   22001   22001   22001   None   22001   22001   22001   22001   22001   22001   22001   None   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   None   22001   22001   22001   22001   22001   None   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   None   22001   22001   22001   22001   None   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001   22001
Table: filer_interests
filer_id   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649
session_id   2001   2009   2017   2007   2013   2005   2011   2019   2015   2023   2021
interest_cd   40310   40310   40310   40310   40310   40310   40310   40310   40310   40310   40310
effect_date   2001-06-09 00:00:00   2009-01-01 00:00:00   2017-01-01 00:00:00   2007-01-01 00:00:00   2013-01-01 00:00:00   2006-02-12 00:00:00   2011-01-01 00:00:00   2019-01-01 00:00:00   2015-01-01 00:00:00   2023-01-01 00:00:00   2021-01-01 00:00:00
Table: filer_to_filer_type
filer_id   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649
filer_type   1   1   1   1   1   1   1   1   1   1   1   1
active   Y   T   Y   Y   Y   Y   Y   Y   Y   Y   Y   N
race   0   0   0   0   None   None   None   None   None   None   None   None
session_id   2001   2001   2005   2007   2013   2009   2011   2017   2019   2021   2015   2023
category   0   0   0   0   None   None   None   None   None   None   None   None
category_type   0   0   0   0   None   None   None   None   None   None   None   None
sub_category   0   0   0   0   None   None   None   None   None   None   None   None
effect_dt   2001-06-09 00:00:00   2001-12-31 00:00:00   2006-02-12 00:00:00   2007-01-01 00:00:00   2013-01-01 00:00:00   2009-01-01 00:00:00   2011-01-01 00:00:00   2017-01-01 00:00:00   2019-01-01 00:00:00   2021-01-01 00:00:00   2015-01-01 00:00:00   2023-01-01 00:00:00
sub_category_type   0   0   0   0   None   None   None   None   None   None   None   None
election_type   0   0   0   0   None   None   None   None   None   None   None   None
sub_category_a   None   None   None   None   None   None   None   None   None   None   None   None
nyq_dt   None   None   2001-07-01 00:00:00   2001-07-01 00:00:00   None   None   None   None   None   None   None   None
party_cd   0   0   0   0   None   None   None   None   None   None   None   None
county_cd   0   0   0   0   None   None   None   None   None   None   None   None
district_cd   0   0   0   0   None   None   None   None   None   None   None   None
Table: filer_xref
filer_id   1236649
xref_id   1236649
effect_dt   2001-07-30 00:00:00
migration_source   CLAIMS
Table: filername
xref_filer_id   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649
filer_id   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649
filer_type   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT   CLIENT
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   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   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   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   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   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INTERNATIONAL   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE
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   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   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   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
nams   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
adr1   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
adr2   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   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   ALEXANDRIA   SHAUMBURG   SHAUMBURG   ROLLING MEADOWS   ROLLING MEADOWS   SACRAMENTO   ROLLING MEADOWS   SACRAMENTO   SACRAMENTO   ROLLING MEADOWS   SACRAMENTO   ROLLING MEADOWS   SACRAMENTO   MC LEAN   MC LEAN   SACRAMENTO   MC LEAN   SACRAMENTO   MC LEAN   SACRAMENTO   ALEXANDRIA   SHAUMBURG   SHAUMBURG   ROLLING MEADOWS   ROLLING MEADOWS   SACRAMENTO   ROLLING MEADOWS   SACRAMENTO   SACRAMENTO   ROLLING MEADOWS   SACRAMENTO   ROLLING MEADOWS   SACRAMENTO   MC LEAN   MC LEAN   SACRAMENTO   MC LEAN   SACRAMENTO   MC LEAN   SACRAMENTO   ALEXANDRIA   SHAUMBURG   SHAUMBURG   ROLLING MEADOWS   ROLLING MEADOWS   SACRAMENTO   ROLLING MEADOWS   SACRAMENTO   SACRAMENTO   ROLLING MEADOWS   SACRAMENTO   ROLLING MEADOWS   SACRAMENTO   MC LEAN   MC LEAN   SACRAMENTO   MC LEAN   SACRAMENTO   MC LEAN   SACRAMENTO   ALEXANDRIA   SHAUMBURG   SHAUMBURG   ROLLING MEADOWS   ROLLING MEADOWS   SACRAMENTO   ROLLING MEADOWS   SACRAMENTO   SACRAMENTO   ROLLING MEADOWS   SACRAMENTO   ROLLING MEADOWS   SACRAMENTO   MC LEAN   MC LEAN   SACRAMENTO   MC LEAN   SACRAMENTO   MC LEAN   SACRAMENTO   ALEXANDRIA   SHAUMBURG   SHAUMBURG   ROLLING MEADOWS   ROLLING MEADOWS   SACRAMENTO   ROLLING MEADOWS   SACRAMENTO   SACRAMENTO   ROLLING MEADOWS   SACRAMENTO   ROLLING MEADOWS   SACRAMENTO   MC LEAN   MC LEAN   SACRAMENTO   MC LEAN   SACRAMENTO   MC LEAN   SACRAMENTO   ALEXANDRIA   SHAUMBURG   SHAUMBURG   ROLLING MEADOWS   ROLLING MEADOWS   SACRAMENTO   ROLLING MEADOWS   SACRAMENTO   SACRAMENTO   ROLLING MEADOWS   SACRAMENTO   ROLLING MEADOWS   SACRAMENTO   MC LEAN   MC LEAN   SACRAMENTO   MC LEAN   SACRAMENTO   MC LEAN   SACRAMENTO   ALEXANDRIA   SHAUMBURG   SHAUMBURG   ROLLING MEADOWS   ROLLING MEADOWS   SACRAMENTO   ROLLING MEADOWS   SACRAMENTO   SACRAMENTO   ROLLING MEADOWS   SACRAMENTO   ROLLING MEADOWS   SACRAMENTO   MC LEAN   MC LEAN   SACRAMENTO   MC LEAN   SACRAMENTO   MC LEAN   SACRAMENTO   ALEXANDRIA   SHAUMBURG   SHAUMBURG   ROLLING MEADOWS   ROLLING MEADOWS   SACRAMENTO   ROLLING MEADOWS   SACRAMENTO   SACRAMENTO   ROLLING MEADOWS   SACRAMENTO   ROLLING MEADOWS   SACRAMENTO   MC LEAN   MC LEAN   SACRAMENTO   MC LEAN   SACRAMENTO   MC LEAN   SACRAMENTO   ALEXANDRIA   SHAUMBURG   SHAUMBURG   ROLLING MEADOWS   ROLLING MEADOWS   SACRAMENTO   ROLLING MEADOWS   SACRAMENTO   SACRAMENTO   ROLLING MEADOWS   SACRAMENTO   ROLLING MEADOWS   SACRAMENTO   MC LEAN   MC LEAN   SACRAMENTO   MC LEAN   SACRAMENTO   MC LEAN   SACRAMENTO   ALEXANDRIA   SHAUMBURG   SHAUMBURG   ROLLING MEADOWS   ROLLING MEADOWS   SACRAMENTO   ROLLING MEADOWS   SACRAMENTO   SACRAMENTO   ROLLING MEADOWS   SACRAMENTO   ROLLING MEADOWS   SACRAMENTO   MC LEAN   MC LEAN   SACRAMENTO   MC LEAN   SACRAMENTO   MC LEAN   SACRAMENTO   ALEXANDRIA   SHAUMBURG   SHAUMBURG   ROLLING MEADOWS   ROLLING MEADOWS   SACRAMENTO   ROLLING MEADOWS   SACRAMENTO   SACRAMENTO   ROLLING MEADOWS   SACRAMENTO   ROLLING MEADOWS   SACRAMENTO   MC LEAN   MC LEAN   SACRAMENTO   MC LEAN   SACRAMENTO   MC LEAN   SACRAMENTO   ALEXANDRIA   SHAUMBURG   SHAUMBURG   ROLLING MEADOWS   ROLLING MEADOWS   SACRAMENTO   ROLLING MEADOWS   SACRAMENTO   SACRAMENTO   ROLLING MEADOWS   SACRAMENTO   ROLLING MEADOWS   SACRAMENTO   MC LEAN   MC LEAN   SACRAMENTO   MC LEAN   SACRAMENTO   MC LEAN   SACRAMENTO
st   VA   IL   IL   IL   IL   CA   IL   CA   CA   IL   CA   IL   CA   VA   VA   CA   VA   CA   VA   CA   VA   IL   IL   IL   IL   CA   IL   CA   CA   IL   CA   IL   CA   VA   VA   CA   VA   CA   VA   CA   VA   IL   IL   IL   IL   CA   IL   CA   CA   IL   CA   IL   CA   VA   VA   CA   VA   CA   VA   CA   VA   IL   IL   IL   IL   CA   IL   CA   CA   IL   CA   IL   CA   VA   VA   CA   VA   CA   VA   CA   VA   IL   IL   IL   IL   CA   IL   CA   CA   IL   CA   IL   CA   VA   VA   CA   VA   CA   VA   CA   VA   IL   IL   IL   IL   CA   IL   CA   CA   IL   CA   IL   CA   VA   VA   CA   VA   CA   VA   CA   VA   IL   IL   IL   IL   CA   IL   CA   CA   IL   CA   IL   CA   VA   VA   CA   VA   CA   VA   CA   VA   IL   IL   IL   IL   CA   IL   CA   CA   IL   CA   IL   CA   VA   VA   CA   VA   CA   VA   CA   VA   IL   IL   IL   IL   CA   IL   CA   CA   IL   CA   IL   CA   VA   VA   CA   VA   CA   VA   CA   VA   IL   IL   IL   IL   CA   IL   CA   CA   IL   CA   IL   CA   VA   VA   CA   VA   CA   VA   CA   VA   IL   IL   IL   IL   CA   IL   CA   CA   IL   CA   IL   CA   VA   VA   CA   VA   CA   VA   CA   VA   IL   IL   IL   IL   CA   IL   CA   CA   IL   CA   IL   CA   VA   VA   CA   VA   CA   VA   CA
zip4   223143137   60173   60173   60008   60008   95814   60008   95814   95814   60008   95814   60008   95814   22102   22102   95814   22102   95814   22102   95814   223143137   60173   60173   60008   60008   95814   60008   95814   95814   60008   95814   60008   95814   22102   22102   95814   22102   95814   22102   95814   223143137   60173   60173   60008   60008   95814   60008   95814   95814   60008   95814   60008   95814   22102   22102   95814   22102   95814   22102   95814   223143137   60173   60173   60008   60008   95814   60008   95814   95814   60008   95814   60008   95814   22102   22102   95814   22102   95814   22102   95814   223143137   60173   60173   60008   60008   95814   60008   95814   95814   60008   95814   60008   95814   22102   22102   95814   22102   95814   22102   95814   223143137   60173   60173   60008   60008   95814   60008   95814   95814   60008   95814   60008   95814   22102   22102   95814   22102   95814   22102   95814   223143137   60173   60173   60008   60008   95814   60008   95814   95814   60008   95814   60008   95814   22102   22102   95814   22102   95814   22102   95814   223143137   60173   60173   60008   60008   95814   60008   95814   95814   60008   95814   60008   95814   22102   22102   95814   22102   95814   22102   95814   223143137   60173   60173   60008   60008   95814   60008   95814   95814   60008   95814   60008   95814   22102   22102   95814   22102   95814   22102   95814   223143137   60173   60173   60008   60008   95814   60008   95814   95814   60008   95814   60008   95814   22102   22102   95814   22102   95814   22102   95814   223143137   60173   60173   60008   60008   95814   60008   95814   95814   60008   95814   60008   95814   22102   22102   95814   22102   95814   22102   95814   223143137   60173   60173   60008   60008   95814   60008   95814   95814   60008   95814   60008   95814   22102   22102   95814   22102   95814   22102   95814
phon   7036841110   8478849764   8478849764   8474815500   8474815500      8474815500      9164414166   8474815500      8474815500      8474815500   8474815500      8474815500      8474815500      7036841110   8478849764   8478849764   8474815500   8474815500      8474815500      9164414166   8474815500      8474815500      8474815500   8474815500      8474815500      8474815500      7036841110   8478849764   8478849764   8474815500   8474815500      8474815500      9164414166   8474815500      8474815500      8474815500   8474815500      8474815500      8474815500      7036841110   8478849764   8478849764   8474815500   8474815500      8474815500      9164414166   8474815500      8474815500      8474815500   8474815500      8474815500      8474815500      7036841110   8478849764   8478849764   8474815500   8474815500      8474815500      9164414166   8474815500      8474815500      8474815500   8474815500      8474815500      8474815500      7036841110   8478849764   8478849764   8474815500   8474815500      8474815500      9164414166   8474815500      8474815500      8474815500   8474815500      8474815500      8474815500      7036841110   8478849764   8478849764   8474815500   8474815500      8474815500      9164414166   8474815500      8474815500      8474815500   8474815500      8474815500      8474815500      7036841110   8478849764   8478849764   8474815500   8474815500      8474815500      9164414166   8474815500      8474815500      8474815500   8474815500      8474815500      8474815500      7036841110   8478849764   8478849764   8474815500   8474815500      8474815500      9164414166   8474815500      8474815500      8474815500   8474815500      8474815500      8474815500      7036841110   8478849764   8478849764   8474815500   8474815500      8474815500      9164414166   8474815500      8474815500      8474815500   8474815500      8474815500      8474815500      7036841110   8478849764   8478849764   8474815500   8474815500      8474815500      9164414166   8474815500      8474815500      8474815500   8474815500      8474815500      8474815500      7036841110   8478849764   8478849764   8474815500   8474815500      8474815500      9164414166   8474815500      8474815500      8474815500   8474815500      8474815500      8474815500   
fax         8478849775   8474815501         8474815501      8474815501   8474815501      8474815501      8474815501                           8478849775   8474815501         8474815501      8474815501   8474815501      8474815501      8474815501                           8478849775   8474815501         8474815501      8474815501   8474815501      8474815501      8474815501                           8478849775   8474815501         8474815501      8474815501   8474815501      8474815501      8474815501                           8478849775   8474815501         8474815501      8474815501   8474815501      8474815501      8474815501                           8478849775   8474815501         8474815501      8474815501   8474815501      8474815501      8474815501                           8478849775   8474815501         8474815501      8474815501   8474815501      8474815501      8474815501                           8478849775   8474815501         8474815501      8474815501   8474815501      8474815501      8474815501                           8478849775   8474815501         8474815501      8474815501   8474815501      8474815501      8474815501                           8478849775   8474815501         8474815501      8474815501   8474815501      8474815501      8474815501                           8478849775   8474815501         8474815501      8474815501   8474815501      8474815501      8474815501                           8478849775   8474815501         8474815501      8474815501   8474815501      8474815501      8474815501                  
email   None   None   None   [email protected]   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   [email protected]   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   [email protected]   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   [email protected]   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   [email protected]   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   [email protected]   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   [email protected]   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   [email protected]   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   [email protected]   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   [email protected]   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   [email protected]   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   [email protected]   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
Table: filers
filer_id   1236649
Table: lobbying_chg_log
filer_id   1236649   1236649   1236649   1236649
change_no   0   6   7   8
session_id   2001   2001   2001   2005
log_dt   2001-07-27 00:00:00   2002-04-09 00:00:00   2002-04-09 00:00:00   2006-02-14 00:00:00
filer_type   1   2   2   1
correction_flg   Y   Y   Y   None
action   NEW   DELETED   TERMINATED   SET ACTIVE
attribute_changed   EMPLOYER   FIRM   EMPLOYER   
ethics_dt   None   None   None   None
interests   None   None   None   None
filer_full_name   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE   PLUMBING MANUFACTURERS INSTITUTE
filer_city   None   None   None   None
filer_st   None   None   None   None
filer_zip   None   None   None   None
filer_phone   None   None   None   None
entity_type   2   3   2   1
entity_name   LIVINGSTON & MATTESICH LAW CORPORATION   LIVINGSTON & MATTESICH LAW CORPORATION   PLUMBING MANUFACTURERS INSTITUTE   None
entity_city   None   None   None   None
entity_st   None   None   None   None
entity_zip   None   None   None   None
entity_phone   None   None   None   None
entity_id   1147252   1147252   0   0
responsible_officer   None   None   None   None
effect_dt   2001-06-09 00:00:00   2001-12-31 00:00:00   2001-12-31 00:00:00   2006-02-12 00:00:00
Table: received_filings
filer_id   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649   1236649
filing_file_name   789326_0.cal   811062_0.cal   1151997_0.cal   1167573_0.cal   1192136_0.cal   1330232_0.cal   1500082_0.cal   1396099_0.cal   1351915_0.cal   1485594_0.cal   1452364_0.cal   1216966_0.cal   1238554_0.cal   1224889_0.cal   1465342_0.cal   1297996_0.cal   1262809_0.cal   1420561_0.cal   1438678_0.cal   1285060_0.cal   1285060_1.cal   1312525_0.cal   1385853_0.cal   1374222_0.cal   1846248_0.cal   1740691_0.cal   1680607_0.cal   1783810_0.cal   1541162_0.cal   1385853_1.cal   1569611_0.cal   1818387_0.cal   1783810_1.cal   1598871_0.cal   1553699_1.cal   1609145_0.cal   1800520_0.cal   1766278_0.cal   1658259_0.cal   1621633_0.cal   1637519_0.cal   1721408_0.cal   1710349_0.cal   1871301_0.cal   1553699_0.cal   1966305_0.cal   2126267_0.cal   2038764_1.cal   1980449_1.cal   2010890_0.cal   1995925_0.cal   2102605_0.cal   1908310_0.cal   2110851_0.cal   1921225_0.cal   2064569_0.cal   2038764_0.cal   1980449_0.cal   1937484_0.cal   2156818_0.cal   2168795_0.cal   2241035_0.cal   2486729_0.cal   2349974_0.cal   2471399_0.cal   2314313_0.cal   2193849_0.cal   2393277_0.cal   163773.cal   2444147_0.cal   2211712_0.cal   2276712_0.cal   2415307_0.cal   2379110_0.cal   2328061_0.cal   2553857_0.cal   2580311_0.cal   2603692_0.cal   2676451_0.cal   2624364_0.cal   2541665_0.cal   2525587_0.cal   2702417_0.cal   2643269_0.cal   2740863_0.cal
received_date   2001-10-25 00:00:00   2002-01-28 00:00:00   2006-02-14 00:00:00   2006-05-01 00:00:00   2006-07-31 00:00:00   2008-04-30 00:00:00   2010-07-12 00:00:00   2009-01-30 00:00:00   2008-07-31 00:00:00   2010-04-30 00:00:00   2009-10-30 00:00:00   2006-10-31 00:00:00   2007-01-31 00:00:00   2006-12-27 00:00:00   2010-02-01 00:00:00   2007-10-31 00:00:00   2007-05-01 00:00:00   2009-04-29 00:00:00   2009-07-31 00:00:00   2007-07-31 00:00:00   2007-10-04 00:00:00   2008-01-31 00:00:00   2008-12-29 00:00:00   2008-10-28 00:00:00   2014-04-30 00:00:00   2013-01-31 00:00:00   2012-07-31 00:00:00   2013-07-31 00:00:00   2010-11-01 00:00:00   2011-07-07 00:00:00   2011-01-29 00:00:00   2014-01-31 00:00:00   2014-01-30 00:00:00   2011-07-06 00:00:00   2011-07-07 00:00:00   2011-08-01 00:00:00   2013-10-31 00:00:00   2013-04-30 00:00:00   2012-04-30 00:00:00   2011-10-30 00:00:00   2012-01-31 00:00:00   2012-12-28 00:00:00   2012-10-31 00:00:00   2014-07-31 00:00:00   2010-12-23 00:00:00   2015-04-30 00:00:00   2017-01-29 00:00:00   2016-07-28 00:00:00   2015-11-10 00:00:00   2016-01-29 00:00:00   2015-10-29 00:00:00   2016-10-31 00:00:00   2014-10-29 00:00:00   2016-12-13 00:00:00   2014-12-29 00:00:00   2016-08-01 00:00:00   2016-05-02 00:00:00   2015-07-30 00:00:00   2015-02-02 00:00:00   2017-04-30 00:00:00   2017-07-19 00:00:00   2018-04-30 00:00:00   2020-07-31 00:00:00   2019-01-31 00:00:00   2020-04-30 00:00:00   2018-10-26 00:00:00   2017-10-31 00:00:00   2019-07-25 00:00:00   2019-07-25 00:00:00   2020-01-31 00:00:00   2018-01-31 00:00:00   2018-07-31 00:00:00   2019-10-24 00:00:00   2019-04-29 00:00:00   2018-12-13 00:00:00   2021-02-01 00:00:00   2021-04-30 00:00:00   2021-08-02 00:00:00   2022-05-02 00:00:00   2021-11-01 00:00:00   2020-12-31 00:00:00   2020-10-28 00:00:00   2022-07-27 00:00:00   2022-01-31 00:00:00   2022-10-25 00:00:00
filing_directory   /usr/users/cafiler/disclose/ca99/cal   /usr/users/cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/temp   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal
filing_id   789326   811062   1151997   1167573   1192136   1330232   1500082   1396099   1351915   1485594   1452364   1216966   1238554   1224889   1465342   1297996   1262809   1420561   1438678   1285060   1285060   1312525   1385853   1374222   1846248   1740691   1680607   1783810   1541162   1385853   1569611   1818387   1783810   1598871   1553699   1609145   1800520   1766278   1658259   1621633   1637519   1721408   1710349   1871301   1553699   1966305   2126267   2038764   1980449   2010890   1995925   2102605   1908310   2110851   1921225   2064569   2038764   1980449   1937484   2156818   2168795   2241035   2486729   2349974   2471399   2314313   2193849   2393277   None   2444147   2211712   2276712   2415307   2379110   2328061   2553857   2580311   2603692   2676451   2624364   2541665   2525587   2702417   2643269   2740863
form_id   F635   F635   F602   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F602   F635   F635   F635   F635   F635   F635   F635   F635   F602   F635   F635   F635   F635   F635   F635   F602   F635   F635   F635   F635   F602   F635   F635   F635   F635   F635   F635   F602   F635   F635   F602   F635   F635   F635   F635   F635   F635   F635   F635   F602   F602   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   None   F635   F635   F635   F635   F635   F602   F635   F635   F635   F635   F635   F602   F635   F635   F635   F635
receive_comment   Filing accepted, but with warnings   Filing accepted, but with warnings   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing passed validation, but failed DB constraints   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted