Home

Filer ID: 1145260

Table: filer_address
filer_id   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260
adrid   1111238   2043722   2088598   2114150   2164798   2206938   2417499   2518891   2279125   2547290   2547291   2338860   2468156
effect_dt   1999-01-01 00:00:00   2003-01-01 00:00:00   2005-01-01 00:00:00   2007-01-01 00:00:00   2009-01-01 00:00:00   2011-01-01 00:00:00   2017-01-01 00:00:00   2021-01-01 00:00:00   2013-01-01 00:00:00   2023-01-01 00:00:00   2023-01-01 00:00:00   2015-01-01 00:00:00   2019-01-01 00:00:00
add_type   7051   7051   7051   7051   7051   7051   7051   7027   7051   7027   7051   7051   7051
session_id   1999   2003   2005   2007   2009   2011   2017   2021   2013   2023   2023   2015   2019
Table: filer_filings
filer_id   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260
filing_id   469160   480271   474688   472706   467332   498418   487449   494840   483824   487449   478292   491164   625698   616987   620314   642510   692943   712159   755895   740334   795629   768865   791794   778186   813648   678530   714310   745499   771596   819866   839265   842417   852944   854321   880727   891787   914406   901113   929106   908729   930654   947038   955407   989879   974400   968768   1012325   1010879   1025052   997362   1022582   1044290   1071051   1061883   1063931   1069199   1101730   1107859   1111744   1144174   1163980   1127578   1183894   1203868   1203868   1221619   1257047   1237105   1237666   1281158   1308016   1292649   1774465   1975505   1838100   1862837   1793078   1809403   1959582   1945366   1897993   1326317   1351143   1381731   1377782   1377782   1395426   1417295   1408344   1430706   1447850   1447850   1456967   1479344   1501193   1526911   1545259   1552636   1561171   1586575   1601591   1617050   1627929   1651786   1627929   1671627   1696803   1920244   1925325   1714488   1725251   1724085   1760879   2482659   2318242   2376909   2364387   2413672   2210133   2214584   2214588   2005984   1991458   2032416   2064576   2064576   2090336   2113144   2153175   2132770   2122837   2168027   2392103   2329816   2239027   2343012   2525293   2580070   2468125   2214596   2272944   2190696   2436752   2586518   2547671   2639413   2621273   2675967   2550116   2706181   2599053   2747479
period_id   157   159   158   150   149   156   153   155   152   153   151   154   161   160   158   162   163   None   165   164   None   165   167   None   168   163   164   165   166   None   169   None   170   None   171   None   None   None   173   172   None   174   None   176   None   175   None   177   None   None   178   179   None   180   None   180   181   None   182   184   185   183   186   187   187   188   189   None   188   190   192   191   214   222   217   218   215   216   221   None   219   193   194   196   195   195   196   197   None   198   199   199   200   201   202   203   204   None   204   205   206   207   208   209   208   210   211   220   220   212   None   212   213   242   235   237   None   239   232   None   None   224   223   225   226   226   227   228   229   None   228   230   238   236   233   236   243   245   241   233   234   231   240   None   244   248   247   249   244   250   246   251
form_id   F635   F635   F635   F635   F635   F635   F635   F635   F635   F690   F635   F635   F635   F635   F690   F635   F635   F602   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F602   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F602   F635   F635   F635   F602   F635   F635   F635   F635   F635   F635   F635   F602   F635   F602   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F635   F602   F635   F635   F635   F602   F635   F635   F635   F635   F602   F635   F635   F635   F635   F635   F635   F635   F602   F602   F635   F635   F635   F635   F635   F635   F635   F635   F635   F602   F635   F602   F602   F635   F635   F635   F635   F635   F602   F635   F635   F602   F605   F635   F635   F635   F635   F635   F635   F602   F635   F602   F635   F635   F635   F602   F635   F635   F635   F635   F635   F602   F635   F635   F635   F602   F602   F635   F635   F635   F635   F635   F635   F635
filing_sequence   0   0   0   0   0   0   0   0   0   1   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   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   1   0   0   0   0   0   0   1   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   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
filing_date   1999-04-19 00:00:00   1999-10-19 00:00:00   1999-07-26 00:00:00   1997-07-30 00:00:00   1997-04-30 00:00:00   1999-01-31 00:00:00   1998-04-23 00:00:00   1998-11-02 00:00:00   1998-01-29 00:00:00   1998-10-05 00:00:00   1997-11-06 00:00:00   1998-07-28 00:00:00   2000-04-28 00:00:00   2000-01-20 00:00:00   1999-10-29 00:00:00   2000-07-14 00:00:00   2000-10-31 00:00:00   2001-01-02 00:00:00   2001-04-25 00:00:00   2001-01-16 00:00:00   2001-10-29 00:00:00   2001-04-25 00:00:00   2001-10-31 00:00:00   2001-07-18 00:00:00   2002-01-31 00:00:00   2000-10-27 00:00:00   2001-01-25 00:00:00   2001-04-30 00:00:00   2001-07-30 00:00:00   2002-01-31 00:00:00   2002-04-30 00:00:00   2002-04-22 00:00:00   2002-07-29 00:00:00   2002-07-19 00:00:00   2002-10-27 00:00:00   2002-10-15 00:00:00   2003-01-31 00:00:00   2002-12-30 00:00:00   2003-04-26 00:00:00   2003-01-29 00:00:00   2003-04-15 00:00:00   2003-07-30 00:00:00   2003-07-30 00:00:00   2004-01-31 00:00:00   2003-10-17 00:00:00   2003-10-29 00:00:00   2004-04-27 00:00:00   2004-04-23 00:00:00   2004-07-19 00:00:00   2004-01-20 00:00:00   2004-07-13 00:00:00   2004-10-04 00:00:00   2005-01-06 00:00:00   2004-11-15 00:00:00   2004-10-07 00:00:00   2005-01-03 00:00:00   2005-04-21 00:00:00   2004-12-21 00:00:00   2005-07-13 00:00:00   2006-01-25 00:00:00   2006-04-24 00:00:00   2005-10-10 00:00:00   2006-07-13 00:00:00   2006-10-05 00:00:00   2006-10-04 00:00:00   2006-11-16 00:00:00   2007-04-17 00:00:00   2006-12-19 00:00:00   2007-01-31 00:00:00   2007-07-26 00:00:00   2008-01-29 00:00:00   2007-10-11 00:00:00   2013-07-10 00:00:00   2015-07-21 00:00:00   2014-04-14 00:00:00   2014-07-14 00:00:00   2013-10-08 00:00:00   2014-01-09 00:00:00   2015-04-20 00:00:00   2014-12-30 00:00:00   2014-10-14 00:00:00   2008-04-23 00:00:00   2008-07-31 00:00:00   2008-11-18 00:00:00   2008-11-19 00:00:00   2008-10-31 00:00:00   2009-01-30 00:00:00   2009-04-14 00:00:00   2008-12-18 00:00:00   2009-07-14 00:00:00   2009-10-15 00:00:00   2009-10-15 00:00:00   2010-01-07 00:00:00   2010-04-12 00:00:00   2010-07-18 00:00:00   2010-10-15 00:00:00   2010-11-17 00:00:00   2010-12-20 00:00:00   2011-01-18 00:00:00   2011-04-18 00:00:00   2011-07-20 00:00:00   2011-10-11 00:00:00   2012-01-11 00:00:00   2012-04-12 00:00:00   2012-03-13 00:00:00   2012-07-16 00:00:00   2012-10-10 00:00:00   2014-12-23 00:00:00   2015-01-14 00:00:00   2012-11-20 00:00:00   2012-12-17 00:00:00   2013-01-10 00:00:00   2013-04-23 00:00:00   2020-07-29 00:00:00   2018-10-31 00:00:00   2019-04-24 00:00:00   2018-12-28 00:00:00   2019-10-18 00:00:00   2018-01-31 00:00:00   2018-02-06 00:00:00   2018-02-06 00:00:00   2016-01-25 00:00:00   2015-10-12 00:00:00   2016-04-26 00:00:00   2016-08-05 00:00:00   2016-08-01 00:00:00   2016-10-17 00:00:00   2016-12-21 00:00:00   2017-04-25 00:00:00   2016-12-28 00:00:00   2017-01-24 00:00:00   2017-07-17 00:00:00   2019-07-23 00:00:00   2018-12-27 00:00:00   2018-04-27 00:00:00   2019-01-29 00:00:00   2020-10-28 00:00:00   2021-04-30 00:00:00   2020-04-28 00:00:00   2018-02-13 00:00:00   2018-07-30 00:00:00   2017-10-26 00:00:00   2020-01-28 00:00:00   2021-01-28 00:00:00   2021-01-26 00:00:00   2022-01-27 00:00:00   2021-10-28 00:00:00   2022-05-02 00:00:00   2021-01-29 00:00:00   2022-08-01 00:00:00   2021-07-29 00:00:00   2022-10-31 00:00:00
stmnt_type   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10005   10005   10005   10005   10005   10005   10005   10005   10005   10001   10001   10005   10001   10001   10001   10001   10001   10005   10001   10005   10001   10005   10001   10005   10005   10005   10001   10001   10005   10001   10005   10001   10005   10001   10005   10001   10005   10005   10001   10001   10005   10001   10005   10001   10001   10005   10001   10001   10001   10001   10001   10002   10001   10001   10001   10005   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10005   10001   10001   10001   10001   10002   10001   10001   10001   10005   10001   10001   10002   10001   10001   10001   10001   10001   10005   10001   10001   10001   10001   10001   10001   10002   10001   10001   10001   10001   10001   10005   10001   10001   10001   10001   10001   10005   10001   10001   10005   10006   10001   10001   10001   10002   10001   10001   10001   10001   10005   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10001   10005   10001   10001   10001   10001   10001   10001   10001   10001
stmnt_status   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11003   11003   11001   11003   11003   11003   11003   11003   11001   11003   11001   11003   11001   11003   11001   11001   11001   11003   11003   11001   11003   11001   11003   11001   11003   11001   11003   11001   11001   11003   11003   11001   11003   11001   11003   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   11001   11001   11001   11001   11001   11001   11001   11001   11003   11003   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   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   11003   11001   11003   11001   11003
session_id   1999   1999   1999   1997   1997   1997   1997   1997   1997   1997   1997   1997   1999   1999   1999   1999   1999   2001   2001   1999   2001   2001   2001   2001   2001   1999   1999   2001   2001   2001   2001   2001   2001   2001   2001   2001   2001   2003   2003   2001   2003   2003   2003   2003   2003   2003   2003   2003   2003   2003   2003   2003   2005   2005   2003   2003   2005   2005   2005   2005   2005   2005   2005   2005   2005   2007   2007   2007   2005   2007   2007   2007   2013   2015   2013   2013   2013   2013   2015   2015   2013   2007   2007   2009   2007   2007   2007   2009   2009   2009   2009   2009   2009   2009   2009   2009   2011   2011   2009   2011   2011   2011   2011   2011   2011   2011   2011   2015   2013   2013   2013   2011   2013   2019   2017   2019   2019   2019   2017   2017   2017   2015   2015   2015   2015   2015   2015   2017   2017   2017   2015   2017   2019   2019   2017   2017   2019   2021   2019   0   2017   2017   2019   2021   2021   2021   2021   2021   2019   2021   2021   2021
user_id   *   *   *   *   *   *   *   *   *   *   *   *   TTHAM   *   *   TTHAM   YBONILLA   NJACKSON   LTHIBAUL   GPEREZ   LTHIBAUL   MKIENG   *   LTHIBAUL   *   DMCCASTL   DMCCASTL   DMCCASTL   DMCCASTL   LTHIBAUL   *   LTHIBAUL   *   LTHIBAUL   *   LTHIBAUL   LTHIBAUL   GPEREZ   COMPLETED   COMPLETED   LTHIBAUL   COMPLETED   LTHIBAUL   COMPLETED   LTHIBAUL   COMPLETED   LTHIBAUL   COMPLETED   LTHIBAUL   LTHIBAUL   COMPLETED   COMPLETED   LTHIBAUL   COMPLETED   LTHIBAUL   COMPLETED   LTHIBAUL   SARRIAGA   LTHIBAUL   LTHIBAUL   LTHIBAUL   LTHIBAUL   LTHIBAUL   LTHIBAUL   LTHIBAUL   *   LTHIBAUL   CFLAGG   LTHIBAUL   YRODRIGU   LTHIBAUL   YRODRIGU   ASAETERN   AGLADNEY   ASAETERN   AGLADNEY   AGLADNEY   ASAETERN   AGLADNEY   YRODRIGU   AGLADNEY   LTHIBAUL   LTHIBAUL   *   JINGRAM   JINGRAM   JINGRAM   MGUERRA   PBANFORD   MGUERRA   MGUERRA   MGUERRA   JINGRAM   JINGRAM   ASAETERN   ASAETERN   *   PBANFORD   AGLADNEY   CFLAGG   AGLADNEY   ASAETERN   AGLADNEY   AGLADNEY   AGLADNEY   ASAETERN   AGLADNEY   YRODRIGU   AGLADNEY   SARRIAGA   SARRIAGA   AGLADNEY   ASAETERN   GTAYLOR   AGLADNEY   VUKSTINA   GPEREZ   VUKSTINA   AGLADNEY   YRODRIGU   YRODRIGU   AGLADNEY   AGLADNEY   AGLADNEY   AGLADNEY   AGLADNEY   AGLADNEY   YRODRIGU   AGLADNEY   YRODRIGU   AGLADNEY   AGLADNEY   VUKSTINA   GPEREZ   AGLADNEY   AGLADNEY   GTAYLOR   GTAYLOR   GTAYLOR   CAFILER   AGLADNEY   AGLADNEY   GTAYLOR   MMERCHANT   MMERCHANT   RATTIYEH   GTAYLOR   CAFILER   GTAYLOR   CAFILER   GTAYLOR   CAFILER
special_audit   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11003   11001   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11002   11003   11002   11003   11002   11003   11002   11002   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003
fine_audit   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11003   11001   11003   11003   11001   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11001   11001   11001   11001   11001   11001   11001   11001   11001   11003   11003   11003   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11003   11003   11001   11003   11001   11001   11001   11001   11001   11001   11001   11001   11001   11003   11003   11001   11001   11001   11001   11001   11003   11001   11001   11003   11003   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11003   11001   11001   11001   11001   11001   11003   11001   11001   11001   11003   11003   11001   11001   11003   11001   11003   11001   11003
rpt_start   1999-01-01 00:00:00   1999-07-01 00:00:00   1999-04-01 00:00:00   1997-04-01 00:00:00   1997-01-01 00:00:00   1998-10-01 00:00:00   1998-01-01 00:00:00   1998-07-01 00:00:00   1997-10-01 00:00:00   1998-01-01 00:00:00   1997-07-01 00:00:00   1998-04-01 00:00:00   2000-01-01 00:00:00   1999-10-01 00:00:00   1999-04-01 00:00:00   2000-04-01 00:00:00   2000-07-01 00:00:00   1900-01-01 00:00:00   2001-01-01 00:00:00   2000-10-01 00:00:00   2001-07-01 00:00:00   None   2001-07-01 00:00:00   2001-04-01 00:00:00   2001-10-01 00:00:00   2000-07-01 00:00:00   2000-10-01 00:00:00   2001-01-01 00:00:00   2001-04-01 00:00:00   2001-10-01 00:00:00   2002-01-01 00:00:00   2002-01-01 00:00:00   2002-04-01 00:00:00   2002-04-01 00:00:00   2002-07-01 00:00:00   2002-07-01 00:00:00   2002-10-01 00:00:00   1900-01-01 00:00:00   2003-01-01 00:00:00   2002-10-01 00:00:00   2003-01-01 00:00:00   2003-04-01 00:00:00   2003-04-01 00:00:00   2003-10-01 00:00:00   2003-07-01 00:00:00   2003-07-01 00:00:00   2004-01-01 00:00:00   2004-01-01 00:00:00   2004-04-01 00:00:00   2003-10-01 00:00:00   2004-04-01 00:00:00   2004-07-01 00:00:00   2004-10-01 00:00:00   2004-11-12 00:00:00   2004-07-01 00:00:00   2004-10-01 00:00:00   2005-01-01 00:00:00   1900-01-01 00:00:00   2005-04-01 00:00:00   2005-10-01 00:00:00   2006-01-01 00:00:00   2005-07-01 00:00:00   2006-04-01 00:00:00   2006-07-01 00:00:00   2006-07-01 00:00:00   2006-11-16 00:00:00   2007-01-01 00:00:00   1900-01-01 00:00:00   2006-10-01 00:00:00   2007-04-01 00:00:00   2007-10-01 00:00:00   2007-07-01 00:00:00   2013-04-01 00:00:00   2015-04-01 00:00:00   2014-01-01 00:00:00   2014-04-01 00:00:00   2013-07-01 00:00:00   2013-10-01 00:00:00   2015-01-01 00:00:00   1900-01-01 00:00:00   2014-07-01 00:00:00   2008-01-01 00:00:00   2008-04-01 00:00:00   2008-11-18 00:00:00   2008-07-01 00:00:00   2008-07-01 00:00:00   2008-10-01 00:00:00   2009-01-01 00:00:00   1900-01-01 00:00:00   2009-04-01 00:00:00   2009-07-01 00:00:00   2009-07-01 00:00:00   2009-10-01 00:00:00   2010-01-01 00:00:00   2010-04-01 00:00:00   2010-07-01 00:00:00   2010-11-17 00:00:00   1900-01-01 00:00:00   2010-10-01 00:00:00   2011-01-01 00:00:00   2011-04-01 00:00:00   2011-07-01 00:00:00   2011-10-01 00:00:00   2012-01-01 00:00:00   2011-10-01 00:00:00   2012-04-01 00:00:00   2012-07-01 00:00:00   2014-12-23 00:00:00   2014-10-01 00:00:00   2012-11-20 00:00:00   1900-01-01 00:00:00   2012-10-01 00:00:00   2013-01-01 00:00:00   2020-04-01 00:00:00   2018-07-01 00:00:00   2019-01-01 00:00:00   1900-01-01 00:00:00   2019-07-01 00:00:00   2017-10-01 00:00:00   1900-01-01 00:00:00   1900-01-01 00:00:00   2015-10-01 00:00:00   2015-07-01 00:00:00   2016-01-01 00:00:00   2016-04-01 00:00:00   2016-04-01 00:00:00   2016-07-01 00:00:00   2016-12-21 00:00:00   2017-01-01 00:00:00   1900-01-01 00:00:00   2016-10-01 00:00:00   2017-04-01 00:00:00   2019-04-01 00:00:00   2018-11-26 00:00:00   2018-01-01 00:00:00   2018-10-01 00:00:00   2020-07-01 00:00:00   2021-01-01 00:00:00   2020-01-01 00:00:00   2018-02-13 00:00:00   2018-04-01 00:00:00   2017-07-01 00:00:00   2019-10-01 00:00:00   1900-01-01 00:00:00   2020-12-01 00:00:00   2021-10-01 00:00:00   2021-07-01 00:00:00   2022-01-01 00:00:00   2020-10-01 00:00:00   2022-04-01 00:00:00   2021-04-01 00:00:00   2022-07-01 00:00:00
rpt_end   1999-03-31 00:00:00   1999-09-30 00:00:00   1999-06-30 00:00:00   1997-06-30 00:00:00   1997-03-31 00:00:00   1998-12-31 00:00:00   1998-03-31 00:00:00   1998-09-30 00:00:00   1997-12-31 00:00:00   1998-03-31 00:00:00   1997-09-30 00:00:00   1998-06-30 00:00:00   2000-03-31 00:00:00   1999-12-31 00:00:00   1999-06-30 00:00:00   2000-06-30 00:00:00   2000-09-30 00:00:00   1900-01-01 00:00:00   2001-03-31 00:00:00   2000-12-31 00:00:00   2001-09-30 00:00:00   None   2001-09-30 00:00:00   2001-06-30 00:00:00   2001-12-31 00:00:00   2000-09-30 00:00:00   2000-12-31 00:00:00   2001-03-31 00:00:00   2001-06-30 00:00:00   2001-12-31 00:00:00   2002-03-31 00:00:00   2002-03-31 00:00:00   2002-06-30 00:00:00   2002-06-30 00:00:00   2002-09-30 00:00:00   2002-09-30 00:00:00   2002-12-31 00:00:00   1900-01-01 00:00:00   2003-03-31 00:00:00   2002-12-31 00:00:00   2003-03-31 00:00:00   2003-06-30 00:00:00   2003-06-30 00:00:00   2003-12-31 00:00:00   2003-09-30 00:00:00   2003-09-30 00:00:00   2004-03-31 00:00:00   2004-03-31 00:00:00   2004-06-30 00:00:00   2003-12-31 00:00:00   2004-06-30 00:00:00   2004-09-30 00:00:00   2004-12-31 00:00:00   2004-11-12 00:00:00   2004-09-30 00:00:00   2004-12-31 00:00:00   2005-03-31 00:00:00   1900-01-01 00:00:00   2005-06-30 00:00:00   2005-12-31 00:00:00   2006-03-31 00:00:00   2005-09-30 00:00:00   2006-06-30 00:00:00   2006-09-30 00:00:00   2006-09-30 00:00:00   2006-11-16 00:00:00   2007-03-31 00:00:00   1900-01-01 00:00:00   2006-12-31 00:00:00   2007-06-30 00:00:00   2007-12-31 00:00:00   2007-09-30 00:00:00   2013-06-30 00:00:00   2015-06-30 00:00:00   2014-03-31 00:00:00   2014-06-30 00:00:00   2013-09-30 00:00:00   2013-12-31 00:00:00   2015-03-31 00:00:00   1900-01-01 00:00:00   2014-09-30 00:00:00   2008-03-31 00:00:00   2008-06-30 00:00:00   2008-11-18 00:00:00   2008-09-30 00:00:00   2008-09-30 00:00:00   2008-12-31 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-09-30 00:00:00   2009-12-31 00:00:00   2010-03-31 00:00:00   2010-06-30 00:00:00   2010-09-30 00:00:00   2010-11-17 00:00:00   1900-01-01 00:00:00   2010-12-31 00:00:00   2011-03-31 00:00:00   2011-06-30 00:00:00   2011-09-30 00:00:00   2011-12-31 00:00:00   2012-03-31 00:00:00   2011-12-31 00:00:00   2012-06-30 00:00:00   2012-09-30 00:00:00   2014-12-23 00:00:00   2014-12-31 00:00:00   2012-11-20 00:00:00   1900-01-01 00:00:00   2012-12-31 00:00:00   2013-03-31 00:00:00   2020-06-30 00:00:00   2018-09-30 00:00:00   2019-03-31 00:00:00   1900-01-01 00:00:00   2019-09-30 00:00:00   2017-12-31 00:00:00   1900-01-01 00:00:00   1900-01-01 00:00:00   2015-12-31 00:00:00   2015-09-30 00:00:00   2016-03-31 00:00:00   2016-06-30 00:00:00   2016-06-30 00:00:00   2016-09-30 00:00:00   2016-12-21 00:00:00   2017-03-31 00:00:00   1900-01-01 00:00:00   2016-12-31 00:00:00   2017-06-30 00:00:00   2019-06-30 00:00:00   2018-11-26 00:00:00   2018-03-31 00:00:00   2018-12-31 00:00:00   2020-09-30 00:00:00   2021-03-31 00:00:00   2020-03-31 00:00:00   2018-02-13 00:00:00   2018-06-30 00:00:00   2017-09-30 00:00:00   2019-12-31 00:00:00   1900-01-01 00:00:00   2020-12-01 00:00:00   2021-12-31 00:00:00   2021-09-30 00:00:00   2022-03-31 00:00:00   2020-12-31 00:00:00   2022-06-30 00:00:00   2021-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   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
filing_type   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   22001   22001   None   22001   None   22001   None   22001   None   22006   None   None   22006   22006   None   22001   None   22006   22006   None   22006   22006   22006   22006   22006   22006   22006   22006   22006   None   22006   22006   22006   22006   22006   22006   22006   22006   22006   22006   22006   None   22006   22006   22006   22006   22006   22006   22006   22006   None   22006   22006   22006   22006   22006   22006   22006   22006   None   22006   22006   22006   22006   22006   22006   22006   22006   22006   22006   22006   22006   None   22006   22006   22001   22001   22001   None   22001   22006   None   None   22006   22006   22006   22006   22006   22006   22006   22006   None   22006   22006   22001   22001   22001   22001   22001   22001   22001   22001   22001   22006   22001   None   22001   22001   22001   22001   22001   22001   22001   22001
Table: filer_interests
filer_id   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260
session_id   2001   1999   1997   2003   2009   2017   2011   2007   2013   2005   2019   2015   2023   2021
interest_cd   40319   40319   40319   40319   40319   40319   40319   40319   40319   40319   40319   40319   40312   40312
effect_date   2001-01-01 00:00:00   1999-01-01 00:00:00   1997-01-01 00:00:00   2003-01-01 00:00:00   2009-01-01 00:00:00   2017-01-01 00:00:00   2011-01-01 00:00:00   2007-01-01 00:00:00   2013-01-01 00:00:00   2005-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   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260
filer_type   1   1   1   1   1   1   1   1   1   1   1   1   1   1
active   Y   Y   Y   Y   Y   Y   Y   Y   Y   Y   Y   Y   Y   N
race   0   0   0   None   None   None   None   None   None   None   None   None   None   None
session_id   1997   1999   2001   2003   2005   2007   2013   2011   2009   2017   2019   2015   2021   2023
category   0   0   0   None   None   None   None   None   None   None   None   None   None   None
category_type   0   0   0   None   None   None   None   None   None   None   None   None   None   None
sub_category   0   0   0   None   None   None   None   None   None   None   None   None   None   None
effect_dt   1997-01-01 00:00:00   1999-01-01 00:00:00   2001-01-01 00:00:00   2003-01-01 00:00:00   2005-01-01 00:00:00   2007-01-01 00:00:00   2013-01-01 00:00:00   2011-01-01 00:00:00   2009-01-01 00:00:00   2017-01-01 00:00:00   2019-01-01 00:00:00   2015-01-01 00:00:00   2021-01-01 00:00:00   2023-01-01 00:00:00
sub_category_type   0   0   0   None   None   None   None   None   None   None   None   None   None   None
election_type   0   0   0   None   None   None   None   None   None   None   None   None   None   None
sub_category_a   None   None   None   None   None   None   None   None   None   None   None   None   None   None
nyq_dt   None   None   None   None   2000-07-01 00:00:00   2000-07-01 00:00:00   None   None   None   None   None   None   None   None
party_cd   None   None   None   None   None   None   None   None   None   None   None   None   None   None
county_cd   None   None   None   None   None   None   None   None   None   None   None   None   None   None
district_cd   None   None   None   None   None   None   None   None   None   None   None   None   None   None
Table: filer_xref
filer_id   1145260
xref_id   C26732
effect_dt   1999-12-08 00:00:00
migration_source   MASTER
Table: filername
xref_filer_id   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732   C26732
filer_id   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260
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
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
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
naml   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH BOARD OF WATER COMMISSIONERS   LONG BEACH BOARD OF WATER COMMISSIONERS   LONG BEACH BOARD OF WATER COMMISSIONERS   LONG BEACH BOARD OF WATER COMMISSIONERS   LONG BEACH BOARD OF WATER COMMISSIONERS   LONG BEACH BOARD OF WATER COMMISSIONERS   LONG BEACH BOARD OF WATER COMMISSIONERS   LONG BEACH BOARD OF WATER COMMISSIONERS   LONG BEACH BOARD OF WATER COMMISSIONERS   LONG BEACH BOARD OF WATER COMMISSIONERS   LONG BEACH BOARD OF WATER COMMISSIONERS   LONG BEACH BOARD OF WATER COMMISSIONERS   LONG BEACH BOARD OF WATER COMMISSIONERS   LONG BEACH BOARD OF WATER COMMISSIONERS   LONG BEACH BOARD OF WATER COMMISSIONERS   LONG BEACH BOARD OF WATER COMMISSIONERS   LONG BEACH BOARD OF WATER COMMISSIONERS   LONG BEACH BOARD OF WATER COMMISSIONERS   LONG BEACH BOARD OF WATER COMMISSIONERS   LONG BEACH BOARD OF WATER COMMISSIONERS   LONG BEACH BOARD OF WATER COMMISSIONERS   LONG BEACH BOARD OF WATER COMMISSIONERS   LONG BEACH BOARD OF WATER COMMISSIONERS   LONG BEACH BOARD OF WATER COMMISSIONERS   LONG BEACH BOARD OF WATER COMMISSIONERS   LONG BEACH BOARD OF WATER COMMISSIONERS   LONG BEACH BOARD OF WATER COMMISSIONERS   LONG BEACH BOARD OF WATER COMMISSIONERS   LONG BEACH BOARD OF WATER COMMISSIONERS   LONG BEACH BOARD OF WATER COMMISSIONERS   LONG BEACH BOARD OF WATER COMMISSIONERS   LONG BEACH BOARD OF WATER COMMISSIONERS   LONG BEACH BOARD OF WATER COMMISSIONERS   LONG BEACH BOARD OF WATER COMMISSIONERS   LONG BEACH BOARD OF WATER COMMISSIONERS   LONG BEACH BOARD OF WATER COMMISSIONERS   LONG BEACH BOARD OF WATER COMMISSIONERS   LONG BEACH BOARD OF WATER COMMISSIONERS   LONG BEACH BOARD OF WATER COMMISSIONERS   BOARD OF WATER COMMISSIONERS OF THE CITY OF LONG BEACH   BOARD OF WATER COMMISSIONERS OF THE CITY OF LONG BEACH   BOARD OF WATER COMMISSIONERS OF THE CITY OF LONG BEACH   BOARD OF WATER COMMISSIONERS OF THE CITY OF LONG BEACH   BOARD OF WATER COMMISSIONERS OF THE CITY OF LONG BEACH   BOARD OF WATER COMMISSIONERS OF THE CITY OF LONG BEACH   BOARD OF WATER COMMISSIONERS OF THE CITY OF LONG BEACH   BOARD OF WATER COMMISSIONERS OF THE CITY OF LONG BEACH   BOARD OF WATER COMMISSIONERS OF THE CITY OF LONG BEACH   BOARD OF WATER COMMISSIONERS OF THE CITY OF LONG BEACH   BOARD OF WATER COMMISSIONERS OF THE CITY OF LONG BEACH   BOARD OF WATER COMMISSIONERS OF THE CITY OF LONG BEACH   BOARD OF WATER COMMISSIONERS OF THE CITY OF LONG BEACH   LONG BEACH BOARD OF WATER COMMISSIONERS OF THE CITY OF   LONG BEACH BOARD OF WATER COMMISSIONERS OF THE CITY OF   LONG BEACH BOARD OF WATER COMMISSIONERS OF THE CITY OF   LONG BEACH BOARD OF WATER COMMISSIONERS OF THE CITY OF   LONG BEACH BOARD OF WATER COMMISSIONERS OF THE CITY OF   LONG BEACH BOARD OF WATER COMMISSIONERS OF THE CITY OF   LONG BEACH BOARD OF WATER COMMISSIONERS OF THE CITY OF   LONG BEACH BOARD OF WATER COMMISSIONERS OF THE CITY OF   LONG BEACH BOARD OF WATER COMMISSIONERS OF THE CITY OF   LONG BEACH BOARD OF WATER COMMISSIONERS OF THE CITY OF   LONG BEACH BOARD OF WATER COMMISSIONERS OF THE CITY OF   LONG BEACH BOARD OF WATER COMMISSIONERS OF THE CITY OF   LONG BEACH BOARD OF WATER COMMISSIONERS OF THE CITY OF
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
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
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
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
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
city   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH
st   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA
zip4   90807   90807   90807   90807   90807   90807   90807   90807   908074931   90807   90807   90807   90807   90807   90807   90807   90807   90807   90807   90807   90807   908074931   90807   90807   90807   90807   90807   90807   90807   90807   90807   90807   90807   90807   908074931   90807   90807   90807   90807   90807   90807   90807   90807   90807   90807   90807   90807   908074931   90807   90807   90807   90807   90807   90807   90807   90807   90807   90807   90807   90807   908074931   90807   90807   90807   90807   90807   90807   90807   90807   90807   90807   90807   90807   908074931   90807   90807   90807   90807   90807   90807   90807   90807   90807   90807   90807   90807   908074931   90807   90807   90807   90807   90807   90807   90807   90807   90807   90807   90807   90807   908074931   90807   90807   90807   90807   90807   90807   90807   90807   90807   90807   90807   90807   908074931   90807   90807   90807   90807   90807   90807   90807   90807   90807   90807   90807   90807   908074931   90807   90807   90807   90807   90807   90807   90807   90807   90807   90807   90807   90807   908074931   90807   90807   90807   90807   90807   90807   90807   90807   90807   90807   90807   90807   908074931   90807   90807   90807   90807   90807   90807   90807   90807   90807   90807   90807   90807   908074931   90807   90807   90807   90807   90807   90807   90807   90807   90807   90807   90807   90807   908074931   90807   90807   90807   90807   90807   90807   90807   90807   90807   90807   90807   90807   908074931   90807   90807   90807   90807
phon   5625702315   5625702315   5625702300   5625702300   5625702300   5625702300   5625702300   5625702300   5625702309   5625702309   5625702309   5625702309   5625702309   5625702315   5625702315   5625702300   5625702300   5625702300   5625702300   5625702300   5625702300   5625702309   5625702309   5625702309   5625702309   5625702309   5625702315   5625702315   5625702300   5625702300   5625702300   5625702300   5625702300   5625702300   5625702309   5625702309   5625702309   5625702309   5625702309   5625702315   5625702315   5625702300   5625702300   5625702300   5625702300   5625702300   5625702300   5625702309   5625702309   5625702309   5625702309   5625702309   5625702315   5625702315   5625702300   5625702300   5625702300   5625702300   5625702300   5625702300   5625702309   5625702309   5625702309   5625702309   5625702309   5625702315   5625702315   5625702300   5625702300   5625702300   5625702300   5625702300   5625702300   5625702309   5625702309   5625702309   5625702309   5625702309   5625702315   5625702315   5625702300   5625702300   5625702300   5625702300   5625702300   5625702300   5625702309   5625702309   5625702309   5625702309   5625702309   5625702315   5625702315   5625702300   5625702300   5625702300   5625702300   5625702300   5625702300   5625702309   5625702309   5625702309   5625702309   5625702309   5625702315   5625702315   5625702300   5625702300   5625702300   5625702300   5625702300   5625702300   5625702309   5625702309   5625702309   5625702309   5625702309   5625702315   5625702315   5625702300   5625702300   5625702300   5625702300   5625702300   5625702300   5625702309   5625702309   5625702309   5625702309   5625702309   5625702315   5625702315   5625702300   5625702300   5625702300   5625702300   5625702300   5625702300   5625702309   5625702309   5625702309   5625702309   5625702309   5625702315   5625702315   5625702300   5625702300   5625702300   5625702300   5625702300   5625702300   5625702309   5625702309   5625702309   5625702309   5625702309   5625702315   5625702315   5625702300   5625702300   5625702300   5625702300   5625702300   5625702300   5625702309   5625702309   5625702309   5625702309   5625702309   5625702315   5625702315   5625702300   5625702300   5625702300   5625702300   5625702300   5625702300   5625702309   5625702309   5625702309   5625702309   5625702309   5625702315   5625702315   5625702300   5625702300   5625702300   5625702300   5625702300   5625702300   5625702309   5625702309   5625702309   5625702309   5625702309
fax   None   None   5625702306   5625702306   5625702306   5625702306   5625702306                     None   None   5625702306   5625702306   5625702306   5625702306   5625702306                     None   None   5625702306   5625702306   5625702306   5625702306   5625702306                     None   None   5625702306   5625702306   5625702306   5625702306   5625702306                     None   None   5625702306   5625702306   5625702306   5625702306   5625702306                     None   None   5625702306   5625702306   5625702306   5625702306   5625702306                     None   None   5625702306   5625702306   5625702306   5625702306   5625702306                     None   None   5625702306   5625702306   5625702306   5625702306   5625702306                     None   None   5625702306   5625702306   5625702306   5625702306   5625702306                     None   None   5625702306   5625702306   5625702306   5625702306   5625702306                     None   None   5625702306   5625702306   5625702306   5625702306   5625702306                     None   None   5625702306   5625702306   5625702306   5625702306   5625702306                     None   None   5625702306   5625702306   5625702306   5625702306   5625702306                     None   None   5625702306   5625702306   5625702306   5625702306   5625702306                     None   None   5625702306   5625702306   5625702306   5625702306   5625702306                  
email   None   None   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   None   None   None   None   None   None   None   None   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   None   None   None   None   None   None   None   None   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   None   None   None   None   None   None   None   None   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   None   None   None   None   None   None   None   None   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   None   None   None   None   None   None   None   None   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   None   None   None   None   None   None   None   None   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   None   None   None   None   None   None   None   None   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   None   None   None   None   None   None   None   None   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   None   None   None   None   None   None   None   None   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   None   None   None   None   None   None   None   None   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   None   None   None   None   None   None   None   None   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   None   None   None   None   None   None   None   None   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   None   None   None   None   None   None   None   None   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   None   None   None   None   None   None   None   None   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   None   None   None   None   None   None
Table: filers
filer_id   1145260
Table: lobbying_chg_log
filer_id   1145260   1145260   1145260   1145260   1145260   1145260
change_no   1   2   3   0   4   5
session_id   2001   2005   2005   2005   2017   2021
log_dt   2001-05-01 00:00:00   2004-12-21 00:00:00   2004-12-21 00:00:00   2004-12-21 00:00:00   2017-12-19 00:00:00   2021-01-28 00:00:00
filer_type   1   1   1   1   2   1
correction_flg   None   None   None   None   Y   None
action   SET ACTIVE   CHANGED   SET ACTIVE   ADDED   DELETED   CHANGED
attribute_changed   CLIENT   NAME      FIRM   FIRM   RESPONSIBLE OFFICER
ethics_dt   None   None   None   None   None   None
interests   None   None   None   None   None   None
filer_full_name   LONG BEACH BOARD OF WATER COMMISSIONERS   LONG BEACH BOARD OF WATER COMMISSIONERS   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT   LONG BEACH WATER DEPARTMENT
filer_city   SAN DIEGO   None   None   None   None   None
filer_st   CA   None   None   None   None   None
filer_zip   92121   None   None   None   None   None
filer_phone   8584502887   None   None   None   None   None
entity_type   3   1   1   3   3   20
entity_name   ARNOLD & ASSOCIATES   LONG BEACH WATER DEPARTMENT,   None   ARNOLD & ASSOCIATES   ARNOLD & ASSOCIATES   GENERAL MANAGER CHRIS GARNER
entity_city   None   None   None   None   None   None
entity_st   None   None   None   None   None   None
entity_zip   None   None   None   None   None   None
entity_phone   None   None   None   None   None   None
entity_id   1147311   0   0   1147311   1147311   1394040
responsible_officer   None   None   None   None   None   None
effect_dt   None   2005-01-01 00:00:00   2005-01-01 00:00:00   2005-01-01 00:00:00   2017-12-31 00:00:00   2021-01-01 00:00:00
Table: received_filings
filer_id   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260   1145260
filing_file_name   791794_0.cal   813648_0.cal   839265_0.cal   852944_0.cal   880727_0.cal   908729_0.cal   929106_0.cal   947038_0.cal   968768_0.cal   1061883_0.cal   2318242_0.cal   2436752_0.cal   2468125_0.cal   2392103_0.cal   2376909_0.cal   2239027_0.cal   2329816_0.cal   2343012_0.cal   2413672_0.cal   2272944_0.cal   2482659_0.cal   2599053_0.cal   2580070_0.cal   2639413_0.cal   2621273_0.cal   2675967_0.cal   2547671_0.cal   2525293_0.cal   2550116_0.cal   2706181_0.cal   2747479_0.cal
received_date   2001-10-31 00:00:00   2002-01-31 00:00:00   2002-04-30 00:00:00   2002-07-29 00:00:00   2002-10-27 00:00:00   2003-01-29 00:00:00   2003-04-26 00:00:00   2003-07-30 00:00:00   2003-10-29 00:00:00   2004-11-15 00:00:00   2018-10-31 00:00:00   2020-01-28 00:00:00   2020-04-28 00:00:00   2019-07-23 00:00:00   2019-04-24 00:00:00   2018-04-27 00:00:00   2018-12-27 00:00:00   2019-01-29 00:00:00   2019-10-18 00:00:00   2018-07-30 00:00:00   2020-07-29 00:00:00   2021-07-29 00:00:00   2021-04-30 00:00:00   2022-01-27 00:00:00   2021-10-28 00:00:00   2022-05-02 00:00:00   2021-01-26 00:00:00   2020-10-28 00:00:00   2021-01-29 00:00:00   2022-08-01 00:00:00   2022-10-31 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
filing_id   791794   813648   839265   852944   880727   908729   929106   947038   968768   1061883   2318242   2436752   2468125   2392103   2376909   2239027   2329816   2343012   2413672   2272944   2482659   2599053   2580070   2639413   2621273   2675967   2547671   2525293   2550116   2706181   2747479
form_id   F635   F635   F635   F635   F635   F635   F635   F635   F635   F602   F635   F635   F635   F635   F635   F635   F602   F635   F635   F635   F635   F635   F635   F635   F635   F635   F602   F635   F635   F635   F635
receive_comment   Filing accepted, but with warnings   Filing accepted   Filing accepted   Filing accepted, but with warnings   Filing accepted, but with warnings   Filing accepted, but with warnings   Filing accepted, but with warnings   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