filing_id | 768897 | 791837 | 793869 | 793931 | 808320 | 808320 | 836553 | 849503 | 874738 | 907107 | 1024500 | 1061297 | 1078843 | 1099568 | 1128716 | 1161814 | 1161814 | 1112205 | 1142544 | 1185668 | 1236201 | 1278128 | 1209477 | 1256316 | 1293483 | 1348206 | 1293483 | 1328227 | 1305061 | 1372364 | 1432082 | 1448946 | 1403928 | 1417888 | 1537184 | 1504313 | 1462585 | 1483372 | 1565841 | 1618563 | 1636442 | 1603051 | 1588108 | 1673967 | 1706355 | 1654561 | 1737658 | 1797787 | 1761779 | 1777975 | 1761779 | 1817404 | 1909245 | 1864497 | 1842744 | 1927201 | 1980268 | 1963528 | 1996463 | 2061327 | 2034021 | 2010471 | 2010471 | 2101887 | 2173387 | 2154864 | 2130510 | 2192721 | 2209125 | 2238225 | 2276663 | 2209125 | 2347498 | 2396094 | 2381142 | 2319171 | 2419044 | 2439695 | 2470330 | 2483270 | 2526403 | 2547540 | 2607160 | 2627099 | 2577809 | 2668828 | 2702728 | 2646740 | 2607160 | 2607160 | 2668828 | 2627099 | 2668828 | 2646740 | 2646740 | 2743866 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
amend_id | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 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 | 1 | 2 | 1 | 1 | 2 | 1 | 2 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rec_type | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_type | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
sender_id | None | F24744 | F24744 | F24744 | F24744 | F24744 | F24744 | F24744 | F24744 | F24744 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filer_id | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
entity_cd | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filer_naml | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filer_namf | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filer_namt | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filer_nams | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
report_num | None | 000 | 000 | 000 | 000 | 001 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 001 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 001 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 001 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 001 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 001 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 001 | 002 | 001 | 001 | 002 | 001 | 002 | 000 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_date | 2001-04-30 00:00:00 | 2001-10-31 00:00:00 | 2001-07-31 00:00:00 | 2001-04-30 00:00:00 | 2002-01-21 00:00:00 | 2002-01-21 00:00:00 | 2002-04-22 00:00:00 | 2002-07-13 00:00:00 | 2002-10-17 00:00:00 | 2003-01-27 00:00:00 | 2004-07-21 00:00:00 | 2004-10-22 00:00:00 | 2005-01-28 00:00:00 | 2005-04-07 00:00:00 | 2005-10-17 00:00:00 | 2006-04-11 00:00:00 | 2006-04-11 00:00:00 | 2005-07-15 00:00:00 | 2006-01-18 00:00:00 | 2006-07-19 00:00:00 | 2007-01-29 00:00:00 | 2007-07-18 00:00:00 | 2006-10-20 00:00:00 | 2007-04-11 00:00:00 | 2007-10-17 00:00:00 | 2008-07-28 00:00:00 | 2007-10-17 00:00:00 | 2008-04-24 00:00:00 | 2008-01-14 00:00:00 | 2008-10-22 00:00:00 | 2009-04-16 00:00:00 | 2009-10-21 00:00:00 | 2009-02-25 00:00:00 | 2009-04-16 00:00:00 | 2010-10-26 00:00:00 | 2010-04-27 00:00:00 | 2010-01-28 00:00:00 | 2010-04-27 00:00:00 | 2011-01-25 00:00:00 | 2011-10-20 00:00:00 | 2011-10-20 00:00:00 | 2011-04-19 00:00:00 | 2011-04-19 00:00:00 | 2012-07-23 00:00:00 | 2012-10-29 00:00:00 | 2012-04-19 00:00:00 | 2013-01-30 00:00:00 | 2013-10-23 00:00:00 | 2013-04-24 00:00:00 | 2013-07-22 00:00:00 | 2013-04-24 00:00:00 | 2014-01-31 00:00:00 | 2014-10-29 00:00:00 | 2014-07-17 00:00:00 | 2014-04-28 00:00:00 | 2015-01-20 00:00:00 | 2015-04-27 00:00:00 | 2015-04-27 00:00:00 | 2015-10-25 00:00:00 | 2016-07-26 00:00:00 | 2016-04-27 00:00:00 | 2016-01-26 00:00:00 | 2016-02-17 00:00:00 | 2016-10-28 00:00:00 | 2017-07-27 00:00:00 | 2017-04-26 00:00:00 | 2017-01-30 00:00:00 | 2017-07-27 00:00:00 | 2018-01-30 00:00:00 | 2018-04-25 00:00:00 | 2018-07-31 00:00:00 | 2018-01-30 00:00:00 | 2019-01-31 00:00:00 | 2019-07-29 00:00:00 | 2019-04-30 00:00:00 | 2018-10-31 00:00:00 | 2019-10-31 00:00:00 | 2020-01-29 00:00:00 | 2020-04-30 00:00:00 | 2020-07-29 00:00:00 | 2020-10-29 00:00:00 | 2021-01-25 00:00:00 | 2021-08-17 00:00:00 | 2021-11-05 00:00:00 | 2021-04-27 00:00:00 | 2022-04-21 00:00:00 | 2022-07-28 00:00:00 | 2022-02-02 00:00:00 | 2022-06-13 00:00:00 | 2022-06-14 00:00:00 | 2022-07-27 00:00:00 | 2022-07-27 00:00:00 | 2022-07-27 00:00:00 | 2022-07-27 00:00:00 | 2022-11-03 00:00:00 | 2022-10-27 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
from_date | 2001-01-01 00:00:00 | 2001-07-01 00:00:00 | 2001-04-01 00:00:00 | 2001-01-01 00:00:00 | 2001-10-01 00:00:00 | 2001-10-01 00:00:00 | 2002-01-01 00:00:00 | 2002-04-01 00:00:00 | 2002-07-01 00:00:00 | 2002-10-01 00:00:00 | 2004-04-01 00:00:00 | 2004-07-01 00:00:00 | 2004-10-01 00:00:00 | 2005-01-01 00:00:00 | 2005-07-01 00:00:00 | 2006-01-01 00:00:00 | 2006-01-01 00:00:00 | 2005-04-01 00:00:00 | 2005-10-01 00:00:00 | 2006-04-01 00:00:00 | 2006-10-01 00:00:00 | 2007-04-01 00:00:00 | 2006-07-01 00:00:00 | 2007-01-01 00:00:00 | 2007-07-01 00:00:00 | 2008-04-01 00:00:00 | 2007-07-01 00:00:00 | 2008-01-01 00:00:00 | 2007-10-01 00:00:00 | 2008-07-01 00:00:00 | 2009-04-01 00:00:00 | 2009-07-01 00:00:00 | 2008-10-01 00:00:00 | 2009-01-01 00:00:00 | 2010-07-01 00:00:00 | 2010-04-01 00:00:00 | 2009-09-01 00:00:00 | 2010-01-01 00:00:00 | 2010-10-01 00:00:00 | 2011-07-01 00:00:00 | 2011-10-01 00:00:00 | 2011-04-01 00:00:00 | 2011-01-01 00:00:00 | 2012-04-01 00:00:00 | 2012-07-01 00:00:00 | 2012-01-01 00:00:00 | 2012-10-01 00:00:00 | 2013-07-01 00:00:00 | 2013-01-01 00:00:00 | 2013-04-01 00:00:00 | 2013-01-01 00:00:00 | 2013-10-01 00:00:00 | 2014-07-01 00:00:00 | 2014-04-01 00:00:00 | 2014-01-01 00:00:00 | 2014-10-01 00:00:00 | 2015-04-01 00:00:00 | 2015-01-01 00:00:00 | 2015-07-01 00:00:00 | 2016-04-01 00:00:00 | 2016-01-01 00:00:00 | 2015-09-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 | 2017-10-01 00:00:00 | 2018-01-01 00:00:00 | 2018-04-01 00:00:00 | 2017-10-01 00:00:00 | 2018-10-01 00:00:00 | 2019-04-01 00:00:00 | 2019-01-01 00:00:00 | 2018-07-01 00:00:00 | 2019-07-01 00:00:00 | 2019-10-01 00:00:00 | 2020-01-01 00:00:00 | 2020-04-01 00:00:00 | 2020-07-01 00:00:00 | 2020-10-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-01-01 00:00:00 | 2022-01-01 00:00:00 | 2022-04-01 00:00:00 | 2021-10-01 00:00:00 | 2021-04-01 00:00:00 | 2021-04-01 00:00:00 | 2022-01-01 00:00:00 | 2021-07-01 00:00:00 | 2022-01-01 00:00:00 | 2021-10-01 00:00:00 | 2021-10-01 00:00:00 | 2022-07-01 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
thru_date | 2001-03-31 00:00:00 | 2001-09-30 00:00:00 | 2001-06-30 00:00:00 | 2001-03-31 00:00:00 | 2001-12-31 00:00:00 | 2001-12-31 00:00:00 | 2002-03-31 00:00:00 | 2002-06-30 00:00:00 | 2002-09-30 00:00:00 | 2002-12-31 00:00:00 | 2004-06-30 00:00:00 | 2004-09-30 00:00:00 | 2004-12-31 00:00:00 | 2005-03-31 00:00:00 | 2005-09-30 00:00:00 | 2006-03-31 00:00:00 | 2006-03-31 00:00:00 | 2005-06-30 00:00:00 | 2005-12-31 00:00:00 | 2006-06-30 00:00:00 | 2006-12-31 00:00:00 | 2007-06-30 00:00:00 | 2006-09-30 00:00:00 | 2007-03-31 00:00:00 | 2007-09-30 00:00:00 | 2008-06-30 00:00:00 | 2007-09-30 00:00:00 | 2008-03-31 00:00:00 | 2007-12-31 00:00:00 | 2008-09-30 00:00:00 | 2009-06-30 00:00:00 | 2009-09-30 00:00:00 | 2008-12-31 00:00:00 | 2009-03-31 00:00:00 | 2010-09-30 00:00:00 | 2010-06-30 00:00:00 | 2009-12-31 00:00:00 | 2010-03-31 00:00:00 | 2010-12-31 00:00:00 | 2011-09-30 00:00:00 | 2011-12-31 00:00:00 | 2011-06-30 00:00:00 | 2011-03-31 00:00:00 | 2012-06-30 00:00:00 | 2012-09-30 00:00:00 | 2012-03-31 00:00:00 | 2012-12-31 00:00:00 | 2013-09-30 00:00:00 | 2013-03-31 00:00:00 | 2013-06-30 00:00:00 | 2013-03-31 00:00:00 | 2013-12-31 00:00:00 | 2014-09-30 00:00:00 | 2014-06-30 00:00:00 | 2014-03-31 00:00:00 | 2014-12-31 00:00:00 | 2015-06-30 00:00:00 | 2015-03-31 00:00:00 | 2015-09-30 00:00:00 | 2016-06-30 00:00:00 | 2016-03-31 00:00:00 | 2015-12-31 00:00:00 | 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 | 2017-12-31 00:00:00 | 2018-03-31 00:00:00 | 2018-06-30 00:00:00 | 2017-12-31 00:00:00 | 2018-12-31 00:00:00 | 2019-06-30 00:00:00 | 2019-03-31 00:00:00 | 2018-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-12-31 00:00:00 | 2020-03-31 00:00:00 | 2020-06-30 00:00:00 | 2020-09-30 00:00:00 | 2020-12-31 00:00:00 | 2021-06-30 00:00:00 | 2021-08-01 00:00:00 | 2021-03-31 00:00:00 | 2022-03-31 00:00:00 | 2022-06-30 00:00:00 | 2021-12-31 00:00:00 | 2021-06-30 00:00:00 | 2021-06-30 00:00:00 | 2022-03-31 00:00:00 | 2021-09-30 00:00:00 | 2022-03-31 00:00:00 | 2021-12-31 00:00:00 | 2021-12-31 00:00:00 | 2022-09-30 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
cum_beg_dt | 2001-01-01 00:00:00 | 2001-01-01 00:00:00 | 2001-01-01 00:00:00 | 2001-01-01 00:00:00 | 2001-01-01 00:00:00 | 2001-01-01 00:00:00 | 2001-01-01 00:00:00 | 2001-01-01 00:00:00 | 2001-01-01 00:00:00 | 2001-01-01 00:00:00 | 2004-01-01 00:00:00 | 2004-01-01 00:00:00 | 2004-01-01 00:00:00 | 2005-01-01 00:00:00 | 2005-01-01 00:00:00 | 2006-01-01 00:00:00 | 2006-01-01 00:00:00 | 2005-01-01 00:00:00 | 2005-01-01 00:00:00 | 2006-01-01 00:00:00 | 2006-01-01 00:00:00 | 2007-01-01 00:00:00 | 2006-01-01 00:00:00 | 2007-01-01 00:00:00 | 2007-01-01 00:00:00 | 2008-01-01 00:00:00 | 2007-01-01 00:00:00 | 2008-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 | 2007-01-01 00:00:00 | 2009-01-01 00:00:00 | 2009-01-01 00:00:00 | 2009-01-01 00:00:00 | 2009-01-01 00:00:00 | 2009-01-01 00:00:00 | 2009-01-01 00:00:00 | 2011-01-01 00:00:00 | 2011-01-01 00:00:00 | 2011-01-01 00:00:00 | 2011-01-01 00:00:00 | 2011-01-01 00:00:00 | 2011-01-01 00:00:00 | 2011-01-01 00:00:00 | 2011-01-01 00:00:00 | 2013-01-01 00:00:00 | 2013-01-01 00:00:00 | 2013-01-01 00:00:00 | 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 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017-01-01 00:00:00 | 2015-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2017-01-01 00:00:00 | 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-04-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2022-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
firm_id | None | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | None | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
firm_name | None | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | None | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
firm_city | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
firm_st | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
firm_zip4 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
firm_phon | 6196702222 | 619.670.2222 | 619.670.2222 | 619.670.2222 | 619-670-2222 | 619-670-2222 | 619-670-2222 | 619-670-2222 | 619-670-2222 | 619-670-2222 | 6196702210 | 619-670-2280 | 619-670-2280 | 619-670-2280 | 619-670-2280 | 619-670-2280 | 619-670-2280 | 619-670-2280 | 619-670-2280 | 619-670-2280 | 619-670-2280 | 619-670-2280 | 619-670-2280 | 619-670-2280 | 619-670-2280 | 619-670-2280 | 619-670-2280 | 619-670-2280 | 619-670-2280 | 619-670-2280 | 619-670-2280 | 619-670-2280 | 619-670-2280 | 619-670-2280 | 619-670-2280 | 619-670-2280 | 619-670-2280 | 619-670-2280 | 619-670-2280 | 619-670-2280 | 619-670-2280 | 619-670-2280 | 619-670-2280 | 619-670-2280 | 619-670-2280 | 619-670-2280 | 619-670-2280 | 619-670-2280 | 619-670-2280 | 619-670-2280 | 619-670-2280 | 619-670-2280 | 619-670-2280 | 619-670-2280 | 619-670-2280 | 619-670-2280 | 619-670-2280 | 619-670-2280 | 619-670-2280 | 619-670-2280 | 619-670-2280 | 619-670-2280 | 619-670-2280 | 619-670-2280 | 619-670-2280 | 619-670-2280 | 619-670-2280 | 619-670-2280 | 619-670-2280 | 619-670-2280 | 619-670-2280 | 619-670-2280 | 619-670-2280 | 619-670-2280 | 619-670-2280 | 619-670-2280 | 619-670-2280 | 619-670-2280 | 619-670-2280 | 619-670-2280 | 619-670-2280 | 619-670-2280 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
mail_city | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
mail_st | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
mail_zip4 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
mail_phon | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
sig_date | None | 2001-10-31 00:00:00 | 2001-07-31 00:00:00 | 2001-04-30 00:00:00 | 2002-01-22 00:00:00 | 2002-01-21 00:00:00 | 2002-04-22 00:00:00 | 2002-07-13 00:00:00 | 2002-10-17 00:00:00 | 2003-01-27 00:00:00 | 2004-07-21 00:00:00 | 2004-11-08 00:00:00 | 2005-01-28 00:00:00 | 2005-04-08 00:00:00 | 2005-10-18 00:00:00 | 2006-05-17 00:00:00 | 2006-04-11 00:00:00 | 2005-07-15 00:00:00 | 2006-01-19 00:00:00 | 2006-07-17 00:00:00 | 2007-01-30 00:00:00 | 2007-07-18 00:00:00 | 2006-10-20 00:00:00 | 2007-04-11 00:00:00 | 2007-10-18 00:00:00 | 2008-07-29 00:00:00 | 2008-01-07 00:00:00 | 2008-04-29 00:00:00 | 2008-01-22 00:00:00 | 2008-10-27 00:00:00 | 2009-07-21 00:00:00 | 2009-10-21 00:00:00 | 2009-02-25 00:00:00 | 2009-04-20 00:00:00 | 2010-10-27 00:00:00 | 2010-07-28 00:00:00 | 2010-01-28 00:00:00 | 2010-04-28 00:00:00 | 2011-01-25 00:00:00 | 2020-10-20 00:00:00 | 2012-01-31 00:00:00 | 2011-07-25 00:00:00 | 2011-04-25 00:00:00 | 2012-07-24 00:00:00 | 2012-10-29 00:00:00 | 2012-04-25 00:00:00 | 2013-01-30 00:00:00 | 2013-10-28 00:00:00 | 2013-07-22 00:00:00 | 2013-07-24 00:00:00 | 2013-04-25 00:00:00 | 2014-01-31 00:00:00 | 2014-10-30 00:00:00 | 2014-07-21 00:00:00 | 2014-04-28 00:00:00 | 2015-01-20 00:00:00 | 2015-07-30 00:00:00 | 2015-04-28 00:00:00 | 2015-10-29 00:00:00 | 2016-07-29 00:00:00 | 2016-04-28 00:00:00 | 2016-01-29 00:00:00 | 2016-02-17 00:00:00 | 2016-10-31 00:00:00 | 2017-07-28 00:00:00 | 2017-04-27 00:00:00 | 2017-01-31 00:00:00 | 2017-10-30 00:00:00 | 2018-01-30 00:00:00 | 2018-04-26 00:00:00 | 2018-07-31 00:00:00 | 2018-04-25 00:00:00 | 2019-01-31 00:00:00 | 2019-07-30 00:00:00 | 2019-04-30 00:00:00 | 2018-10-31 00:00:00 | 2019-10-31 00:00:00 | 2020-01-30 00:00:00 | 2020-04-30 00:00:00 | 2020-07-29 00:00:00 | 2020-10-29 00:00:00 | 2021-01-26 00:00:00 | 2021-08-17 00:00:00 | 2021-11-01 00:00:00 | 2021-04-27 00:00:00 | 2022-04-21 00:00:00 | 2022-07-28 00:00:00 | 2022-02-02 00:00:00 | 2022-04-21 00:00:00 | 2022-06-14 00:00:00 | 2022-04-21 00:00:00 | 2021-11-01 00:00:00 | 2022-04-21 00:00:00 | 2022-02-02 00:00:00 | 2022-11-01 00:00:00 | 2022-10-27 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
sig_loc | None | SPRING VALLEY CALIFORNIA | SPRINGS VALLEY CALIFORNIA | SPRINGS VALLEY CALIFORNIA | Spring Valley California | Spring Valley California | Spring Valley California | Spring Valley California | Spring Valley CA | Spring Valley California | Spring Valley, CA | Spring Valley CA | Spring Valley CA | Spring Valley CA | Spring Valley CA | Spring Valley CA | Spring Valley CA | Spring Valley CA | Spring Valley CA | Spring Valley CA | Spring Valley CA | Spring Valley CA | Spring Valley CA | Spring Valley CA | Spring Valley CA | Spring Valley CA | Spring Valley CA | Spring Valley CA | Spring Valley CA | Spring Valley CA | Spring Valley CA | Spring Valley CA | Spring Valley CA | Spring Valley CA | Spring Valley CA | Spring Valley CA | Spring Valley CA | Spring Valley CA | Spring Valley CA | Spring Valley CA | Spring Valley CA | Spring Valley CA | Spring Valley CA | Spring Valley CA | Spring Valley CA | Spring Valley CA | Spring Valley CA | Spring Valley | Spring Valley CA | Spring Valley CQ | Spring Valley | Spring Valley CA | Spring Valley CA | Spring Valley CA | Spring Valley CA | Spring Valley CA | Spring Valley | Spring Valley CA | Spring Valley CA | Spring Valley CA | Spring Valley CA | Spring Valley CA | Spring Valley CA | Spring Valley | Spring Valley CA | Spring Valley | Spring Valley | Spring Valley CA | Spring Valley | Spring Valley CA | Spring Valley | Spring Valley CA | Spring Valley CA | Spring Valley CA | Spring Valley CA | Spring Valley | Spring Valley CA | Spring Valley | Spring Valley | Spring Valley | Spring Valley CA | Spring Valley CA | Spring Valley | Spring Valley | Spring Valley, CA | Spring Valley | Spring Valley, California | Spring Valley | Spring Valley, California | Spring Valley, California | Spring Valley | Spring Valley, CA | Spring Valley | Spring Valley, CA | Spring Valley | Spring Valley, CA | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
sig_naml | None | GRIEGO | GRIEGO | GUNSTINSON | Griego | Griego | Griego | Griego | Griego | Griego | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Mark | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Martinez | Martinez | Martinez | Martinez | Martinez | Martinez | Martinez | Martinez | Martinez | Martinez | Martinez | Martinez | Martinez | Martinez | Martinez | Martinez | Martinez | Martinez | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
sig_namf | None | ROBERT | ROBERT | JAMES | Robert | Robert | Robert | Robert | Robert | Robert | Mark | Mar | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Watton | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Jose | Jose | Jose | Jose | Jose | Jose | Jose | Jose | Jose | Jose | Jose | Jose | Jose | Jose | Jose | Jose | Jose | Jose | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
sig_namt | None | None | None | None | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | None | None | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | None | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | None | Mr. | None | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | None | Mr. | Mr. | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
sig_nams | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
prn_naml | None | GRIEGO | GRIEGO | GUNSTINSON | Griego | Griego | Griego | Griego | Griego | Griego | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Mark | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Watton | Martinez | Martinez | Martinez | Martinez | Martinez | Martinez | Martinez | Martinez | Martinez | Martinez | Martinez | Martinez | Martinez | Martinez | Martinez | Martinez | Martinez | Martinez | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
prn_namf | None | ROBERT | ROBERT | JAMES | Robert | Robert | Robert | Robert | Robert | Robert | Mark | Mar | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Watton | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Mark | Jose | Jose | Jose | Jose | Jose | Jose | Jose | Jose | Jose | Jose | Jose | Jose | Jose | Jose | Jose | Jose | Jose | Jose | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
prn_namt | None | None | None | None | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | None | None | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | None | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | None | Mr. | None | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | None | Mr. | Mr. | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
prn_nams | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
sig_title | None | GENERAL MANAGER | GENERAL MANAGER | GENERAL MANAGER | General Manager | General Manager | General Manager | General Manager | General Manager | General Manager | Interim General Manager | Interim General Manager | General Manager | General Manager | General Manager | General Manager | General Manager | General Manager | General Manager | General Manager | General Manager | General Manager | General Manager | General Manager | General Manager | General Manager | General Manager | General Manager | General Manager | General Manager | General Manager | General Manager | General Manager | General Manager | General Manager | General Manager | General Manager | General Manager | General Manager | General Manager | General Manager | General Manager | General Manager | General Manager | General Manager | General Manager | General Manager | General Manager | General Manager | General Manager | General Manager | General Manager | General Manager | General Manager | General Manager | General Manager | General Manager | General Manager | General Manager | General Manager | General Manager | General Manager | General Manager | General Manager | General Manager | General Manager | General Manager | General Manager | General Manager | General Manager | General Manager | General Manager | General Manager | General Manager | General Manager | General Manager | General Manager | General Manager | General Manager | General Manager | General Manager | General Manager | General Manager | General Manager | General Manager | General Manager | General Manager | General Manager | General Manager | General Manager | General Manager | General Manager | General Manager | General Manager | General Manager | General 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
nopart2_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
part1_1_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
part1_2_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
ctrib_n_cb | None | X | X | X | X | X | X | X | X | X | X | X | None | X | X | None | None | X | X | None | X | X | None | X | None | None | X | None | X | None | None | None | X | None | None | None | None | None | None | None | X | None | None | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
ctrib_y_cb | None | None | None | None | None | None | None | None | None | X | None | None | X | X | None | None | X | None | None | X | None | X | X | None | X | None | X | X | X | None | X | X | X | X | X | X | X | None | 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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
lby_actvty | None | The California State Legislature | Lobbied the California State Legislature on a number of water related issues. Sponsored and lobbied AB 958 (Chavez). | Lobby the California State Legislature on issues of importance to the Water District. | California State Assembly and California State Senate regarding AB 958. | California State Assembly and California State Senate regarding AB 958 and other water-related legislation. | The California State Legislature regarding AB 958. | We no longer have a lobbyist. As such we have no activity to report. | We no longer have a contract with Legislative Advocacy Group Inc. As a result they do not do any work for us this quarter. | None. No longer our client. | Water related legislation: SB 1272 and ERAF as related to the State Budget. | Water related legislation: SB 1272 and ERAF as related to the State Budget. | Water related legislation: Prop 50 Funding | Assemblymember Saldana's staff; Katherine Mrowka; SWRCB | Bill Numbers: General contact on pending water issues. Other Actions & Officials Lobbied: DWR Director Snow | Bill Numbers: Desalination Plan; Other Actions & Officials Lobbied: Senator Ducheny; IRWMP; Water Bonds; and Infrastructure Bonds. | Bill Numbers: Desalination Plan; Other Actions & Officials Lobbied: Senator Ducheny | Bill Numbers: Prop 50; status of Cal Fed; and other issues. -- Other Actions & Officials Lobbied: Senator Machado; Peter Silva (SWRCB) Assemblymember Saldana; Mr. Brandt Assembly Water Parks & Wildlife Committee | Bill Numbers: Funding for Otay Recycling Projects SB1024. Other Actions & Officials Lobbied: SWRCB Members Katz and Secundy; Senator Machado. | Bill Numbers: Desalination Plan Prop 84 Water Bond Issues and SB 1242. Other Actions & Officials Lobbied: Carpenters Union Laborers Union Operating Engineers Senators Hollingsworth Machado Denham Kehoe & Ducheney. Assembly Members Horton Saldana and Plescia. | Bill Numbers: SB1640 Prop 84 AB2951 and Water Bond Issues; Other Actions & Officials Lobbied: Assembly Member Goldberg and Senator Kuehl | Bill Numbers: SB59 AB1435 AB1420 and AB885; Senate Members: Senator Christine Kehoe; Other Actions & Officials Lobbied: Water Bond Issues | Bill Numbers: Desalination Plan; Water Bond Issues: Prop 84 AB2951 AB966; Other Actions & Officials Lobbied: Assembly Members Saldana and Goldberg; Senator Machado; and Governor Schwarzenegger | Bill Numbers: Proposition 84 50 1E SB59 and AB141. Other Actions & Officials Lobbied: Senators Cogdill Perata Peace Steinberg Ducheny Machado; Assembly Member Horton; DWR Director Lester Snow; and Senate Water Consultant Dennis O'Connor; regarding Water Bond Issues. | Issues Lobbied: AB554 AB885 AB1420 AB1435 AB1489 SB1002 and the Legislature regarding water bond issues. Legislative Offices Lobbied: Assembly - Sala and Huffman. | Legislature regarding water bonds and water supply issues AB 885 AB 2046 AB 2153 AB 2175. | Issues Lobbied: AB554 AB885 AB1420 AB1435 AB1489 SB1002 and the Legislature regarding water bond issues. Legislative Offices Lobbied: Assembly - Sala and Huffman. | Legislature regarding water bonds SB 1XX and AB 1654. | Issues lobbied: SB2x-1 SB2x-2 SB2x-3 and SB2x-4 and the Legislature regarding water bonds. | Assemblymember Anderson Senator Machado AB 2175-Laird AB 8xx-Huffman AB 9xx-Plescia SB 1xx - Perata SB 6x Assembly Water Committee Consultant Alf Brandt AB 7xx-Wolk SB 1391-Padilla AB 885-Calderon and the Legislature regarding water bonds and water supply issues. | General Water Bonds AB 687 SB 12 and SB 555. | General Water Bonds AB 687 SB 12 and SB 555. | Lobbied California State Legislature regarding water bond issues and 20X2020. | California State Legislature regarding SB 42 and water bond issues. | State Legislature Regarding: AB 153; General Water Bonds. | General Water Bills. | General Water Bonds SB X 7-2. | General Water Bonds SBX7 2. | None this quarter. | None this quarter. | None this quarter. | None this quarter. | None this quarter. | None this quarter. | None this quarter. | None this quarter. | None this quarter. | None this quarter. | None this quarter. | None this quarter. | None this quarter. | None this quarter. | California State Legislature regarding AB 2417 AB 1471 SB 866 and SB 848. | California State Legislature regarding AB 2417. | State legislature regarding SB42 SB594 SB848 and water bond issues. | None. | Governor's office regarding drought regulations. | None. | None. | California State Legislature Regarding AB 2470. | None. | None. | None. | None. | None. | None. | None. | California State Legislature regarding SB 623 and AB 1000. | None. | California State Legislature Regarding: Safe and Affordable Drinking Water Budget Proposal | California State Legislature Regarding SB 831 998 and Safe and Affordable Drinking Water Fund. | None. | None. | California State Legislature Regarding: AB 217 533 1588 SB 200 307 669 Safe and Affordable Drinking Water Proposals. | California State Legislature AB 1588 SB 669 safe and affordable drinking water budget proposal. | California State Legislature Regarding SB 120 998 and Administration Regarding SB 998. | California State Legislature Regarding: AB 1588 SB 307. Governor's Office Regarding: AB 1588 SB 307. State Water Resources Control Board Regarding : AB 1588. | None. | California State Legislature regarding Water/Wastewater Advisory Committee Application. | None. | None. | None. | CALIFORNIA STATE LEGISLATURE REGARDING AB 927, AB1434, SB 323, WATER BILL ARREARAGE FUNDING. | California State Legislature regarding SB 323; California Air Resources Board Regarding Advanced Clean Fleets Proposed Rule | CALIFORNIA STATE LEGISLATURE AND GOVERNORS OFFICE REGARDING UTILITY AND WATER DEBT BUDGET REQUEST | California State Legislature Regarding ASB 1157 | ACWA, Office of the Governor, California State Legislature, California State Water Resources Control Board, California Department of Community Services & Development Regarding SB 1157, SB 222 and State Budget Related to Water Arrearages. | California Air Resources Board Regarding Advanced Clean Fleets Rulemaking. | CALIFORNIA STATE LEGISLATURE REGARDING AB 927, AB1434, SB 323, WATER BILL ARREARAGE FUNDING. | CALIFORNIA STATE LEGISLATURE REGARDING AB 927, AB1434, SB 323, WATER BILL ARREARAGE FUNDING. | California State Legislature Regarding ASB 1157 | California State Legislature regarding SB 323; California Air Resources Board Regarding Advanced Clean Fleets Proposed Rule | California State Legislature Regarding ASB 1157 | California Air Resources Board Regarding Advanced Clean Fleets Rulemaking. | California Air Resources Board Regarding Advanced Clean Fleets Rulemaking. | OFFICE OF THE GOVERNOR, CALIFORNIA STATE LESISLATURE, CALIFORNIA STATE WATER RESOURCES CONTROL BOARD, CALIFORNIA DEPARTMENT OF COMMUNITY SERVICES AND DEVELOPMENT REGARDING SB 1157, SB 222 AND STATE BUDGET RELATED TO WATER ARREARAGES. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
lobby_n_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
lobby_y_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
major_naml | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
major_namf | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
major_namt | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
major_nams | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rcpcmte_nm | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rcpcmte_id | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None |
filing_id | 1068981 | 1256256 | 1387854 | 1553885 | 1722130 | 1922234 | 2116058 | 2331066 | 2538184 | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
amend_id | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||
rec_type | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | |||||||||
form_type | F602 | F602 | F602 | F602 | F602 | F602 | F602 | F602 | F602 | |||||||||
sender_id | F24890 | F24890 | F24890 | F24890 | F24890 | F24890 | F24890 | F24890 | F24890 | |||||||||
filer_id | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | |||||||||
entity_cd | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | |||||||||
filer_naml | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | |||||||||
filer_namf | None | None | None | None | None | None | None | None | None | |||||||||
filer_namt | None | None | None | None | None | None | None | None | None | |||||||||
filer_nams | None | None | None | None | None | None | None | None | None | |||||||||
report_num | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | |||||||||
rpt_date | 2004-12-30 00:00:00 | 2006-12-31 00:00:00 | 2009-01-08 00:00:00 | 2010-12-23 00:00:00 | 2013-01-01 00:00:00 | 2014-12-31 00:00:00 | 2016-12-30 00:00:00 | 2018-12-31 00:00:00 | 2020-12-23 00:00:00 | |||||||||
ls_beg_yr | 2005 | 2007 | 2009 | 2011 | 2013 | 2015 | 2017 | 2019 | 2021 | |||||||||
ls_end_yr | 2006 | 2008 | 2010 | 2012 | 2014 | 2016 | 2018 | 2020 | 2022 | |||||||||
qual_date | None | None | None | None | None | None | None | None | None | |||||||||
eff_date | 2005-01-01 00:00:00 | 2007-01-01 00:00:00 | 2009-01-01 00:00:00 | 2011-01-01 00:00:00 | 2013-01-01 00:00:00 | 2015-01-01 00:00:00 | 2017-01-01 00:00:00 | 2019-01-01 00:00:00 | 2021-01-01 00:00:00 | |||||||||
bus_city | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | |||||||||
bus_st | CA | CA | CA | CA | CA | CA | CA | CA | CA | |||||||||
bus_zip4 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | |||||||||
bus_phon | (619) 670-2280 | (619) 670-2280 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | |||||||||
bus_fax | (619) 660-0829 | (619) 660-0829 | 6196600829 | 6196600829 | None | None | None | None | None | |||||||||
bus_email | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | |||||||||
mail_city | None | None | None | None | None | None | None | None | None | |||||||||
mail_st | None | None | None | None | None | None | None | None | None | |||||||||
mail_zip4 | None | None | None | None | None | None | None | None | None | |||||||||
mail_phon | None | None | None | None | None | None | None | None | None | |||||||||
sig_date | 2004-12-06 00:00:00 | 2006-12-20 00:00:00 | 2008-12-23 00:00:00 | 2010-12-23 00:00:00 | 2012-12-17 00:00:00 | 2014-12-09 00:00:00 | 2016-11-28 00:00:00 | 2018-12-04 00:00:00 | 2020-11-18 00:00:00 | |||||||||
sig_loc | SPRING VALLEY, CA | SPRING VALLEY, CA | None | None | None | None | None | None | None | |||||||||
sig_naml | WATTON | WATTON | WATTON | Watton | WATTON | WATTON | WATTON | WATTON | MARTINEZ | |||||||||
sig_namf | MARK | MARK | MARK | Mark | MARK | MARK | MARK | MARK | JOSE | |||||||||
sig_namt | None | None | None | None | None | None | None | None | None | |||||||||
sig_nams | None | None | None | None | None | None | None | None | None | |||||||||
prn_naml | WATTON | WATTON | WATTON | Watton | WATTON | WATTON | WATTON | WATTON | MARTINEZ | |||||||||
prn_namf | MARK | MARK | MARK | Mark | MARK | MARK | MARK | MARK | JOSE | |||||||||
prn_namt | None | None | None | None | None | None | None | None | None | |||||||||
prn_nams | None | None | None | None | None | None | None | None | None | |||||||||
sig_title | GENERAL MANAGER | GENERAL MANAGER | GENERAL MANAGER | General Manager | GENERAL MANAGER | GENERAL MANAGER | GENERAL MANAGER | GENERAL MANAGER | GENERAL MANAGER | |||||||||
stmt_firm | None | None | None | None | None | None | None | None | None | |||||||||
ind_cb | None | None | None | None | None | None | None | None | None | |||||||||
bus_cb | None | None | None | None | None | None | None | None | None | |||||||||
trade_cb | None | None | None | None | None | None | None | None | None | |||||||||
oth_cb | X | X | X | X | X | X | X | X | X | |||||||||
a_b_name | None | None | None | None | None | None | None | None | None | |||||||||
a_b_city | None | None | None | None | None | None | None | None | None | |||||||||
a_b_st | None | None | None | None | None | None | None | None | None | |||||||||
a_b_zip4 | None | None | None | None | None | None | None | None | None | |||||||||
descrip_1 | WATER & SEWER SERVICE AGENCY | WATER & SEWER SERVICE AGENCY | WATER & SEWER SERVICE AGENCY | Water and Sewer Services Agency | WATER AND SEWER SERVICE AGENCY | WATER AND SEWER SERVICE AGENCY | WATER AND SEWER SERVICE AGENCY | GOVERNMENT, WATER DISTRICT | GOVERNMENT, WATER DISTRICT | |||||||||
descrip_2 | GOVERNMENT & WATER ENTITIES | GOVERNMENT & WATER ENTITIES | GOVERNMENT & WATER ENTITIES | Government and Water entities | GOVERNMENT AND WATER ENTITIES | GOVERNMENT AND WATER ENTITIES | GOVERNMENT AND WATER ENTITIES | WATER DISTRICT | WATER DISTRICT | |||||||||
c_less50 | None | None | None | None | None | None | None | None | None | |||||||||
c_more50 | None | None | None | None | None | None | None | None | None | |||||||||
ind_class | GOV | GOV | GOV | GOV | GOV | GOV | GOV | GOV | GOV | |||||||||
ind_descr | None | None | None | None | None | None | None | None | None | |||||||||
bus_class | None | None | None | None | None | None | None | None | None | |||||||||
bus_descr | None | None | None | None | None | None | None | None | None | |||||||||
auth_name | HATCH & PARENT, A LAW CORPORATION | HATCH & PARENT, A LAW CORPORATION | BROWNSTEIN HYATT FARBER & SCHRECK | Brownstein Hyatt Farber Schreck, LLP | BROWNSTEIN HYATT FARBER SCHRECK, LLP | BROWNSTEIN HYATT FARBER SHRECHK, LLP | BROWNSTEIN HYATT FARBER SCHRECK, LLP | BROWNSTEIN HYATT FARBER SCHRECK, LLP | BROWNSTEIN HYATT FARBER SCHRECK, LLP | |||||||||
auth_city | SANTA BARBARA | SACRAMENTO | SANTA BARBARA | Sacramento | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | |||||||||
auth_st | CA | CA | CA | CA | CA | CA | CA | CA | CA | |||||||||
auth_zip4 | 93101 | 95814 | 93102 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | |||||||||
lobby_int | None | None | None | None | None | None | None | None | None | |||||||||
influen_yn | None | None | None | None | None | None | None | None | None | |||||||||
firm_name | None | None | None | None | None | None | None | None | None | |||||||||
newcert_cb | None | None | None | None | None | None | None | None | None | |||||||||
rencert_cb | None | None | None | None | None | None | None | None | None | |||||||||
complet_dt | None | None | None | None | None | None | None | None | None | |||||||||
lby_reg_cb | None | None | None | None | None | None | None | None | None | |||||||||
lby_604_cb | None | None | None | None | None | None | None | None | None | |||||||||
st_leg_yn | None | None | None | None | None | None | None | None | None | |||||||||
st_agency | None | None | None | None | None | None | None | None | None | |||||||||
lobby_cb | None | None | None | None | None | None | None | None | None | |||||||||
l_firm_cb | None | None | None | None | None | None | None | None | None |
filing_date | 2001-11-05 00:00:00 | |
---|---|---|
filingstatus | 2 | |
vendor | vendor | |
filer_id | 1234236 | |
form_type | form | |
error_no | BADFORMAT 254 |
filer_id | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
adrid | 2014510 | 2065238 | 2080635 | 2122733 | 2165151 | 2206318 | 2417311 | 2549287 | 2279513 | 2339618 | 2507051 | 2468603 | ||||||||||||
effect_dt | 2001-03-01 00:00:00 | 2004-03-09 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 | 2023-01-01 00:00:00 | 2013-01-01 00:00:00 | 2015-01-01 00:00:00 | 2021-01-01 00:00:00 | 2019-01-01 00:00:00 | ||||||||||||
add_type | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | ||||||||||||
session_id | 2001 | 2003 | 2005 | 2007 | 2009 | 2011 | 2017 | 2023 | 2013 | 2015 | 2021 | 2019 |
filer_id | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 741309 | 754265 | 741306 | 753384 | 768897 | 793869 | 793931 | 791837 | 777583 | 794837 | 808320 | 808320 | 836553 | 822110 | 849503 | 862979 | 844137 | 893328 | 874738 | 920458 | 907107 | 1007790 | 1007788 | 1028536 | 1024500 | 1021939 | 1064833 | 1076855 | 1068981 | 1099568 | 1078843 | 1093746 | 1061297 | 1112205 | 1128716 | 1142544 | 1161814 | 1185668 | 1161814 | 1209477 | 1256256 | 1260397 | 1236201 | 1256316 | 1278128 | 1293483 | 1293483 | 1777975 | 1980268 | 1963528 | 1864497 | 1797787 | 1761779 | 1922234 | 1946601 | 1909245 | 1305061 | 1328227 | 1348206 | 1372364 | 1387854 | 1403928 | 1409549 | 1417888 | 1448946 | 1432082 | 1462585 | 1483372 | 1504313 | 1537184 | 1554381 | 1565841 | 1553885 | 1603051 | 1588108 | 1618563 | 1636442 | 1654561 | 1673967 | 1927201 | 1706355 | 1722130 | 1737658 | 1842744 | 1817404 | 1750296 | 1761779 | 1996463 | 2331066 | 2470330 | 2396094 | 2526403 | 2209125 | 2010471 | 2010471 | 2034021 | 2061327 | 2101887 | 2116058 | 2154864 | 2134561 | 2130510 | 2173387 | 2276663 | 2439695 | 2192721 | 2347498 | 2483270 | 2319171 | 2209125 | 2419044 | 2538184 | 2339313 | 2238225 | 2381142 | 2668828 | 2607160 | 2557001 | 2627099 | 2668828 | 2668828 | 2702728 | 2607160 | 2627099 | 2646740 | 2607160 | 2577809 | 2547540 | 2646740 | 2646740 | 2743866 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
period_id | None | 165 | None | 165 | 165 | 166 | 165 | 167 | None | None | 168 | 168 | 169 | None | 170 | None | None | None | 171 | None | 172 | None | None | None | 178 | None | None | None | 180 | 181 | 180 | None | 179 | 182 | 183 | 184 | 185 | 186 | 185 | 187 | 188 | None | 188 | 189 | 190 | 191 | 191 | 214 | 222 | 221 | 218 | 215 | 213 | 220 | None | 219 | 192 | 193 | 194 | 195 | 197 | 196 | None | 197 | 199 | 198 | 199 | 201 | 202 | 203 | None | 204 | 204 | 206 | 205 | 207 | 208 | 209 | 210 | 220 | 211 | 213 | 212 | 217 | 216 | None | 213 | 223 | 236 | 241 | 238 | 243 | 232 | 224 | 223 | 225 | 226 | 227 | 228 | 229 | None | 228 | 230 | 234 | 240 | 231 | 236 | 242 | 235 | 232 | 239 | 244 | None | 233 | 237 | 249 | 246 | None | 247 | 249 | 249 | 250 | 246 | 246 | 248 | 246 | 245 | 244 | 248 | 248 | 251 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F602 | F635 | F999 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F999 | F602 | F635 | F635 | F635 | F635 | F602 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F602 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F602 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F602 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_sequence | 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 | 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 | 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 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 2 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 1 | 2 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_date | 2001-03-12 00:00:00 | 2001-04-30 00:00:00 | 2001-03-12 00:00:00 | 2001-05-01 00:00:00 | 2001-04-30 00:00:00 | 2001-11-05 00:00:00 | 2001-11-05 00:00:00 | 2001-10-31 00:00:00 | 2001-07-31 00:00:00 | 2001-10-30 00:00:00 | 2002-01-21 00:00:00 | 2002-01-21 00:00:00 | 2002-04-22 00:00:00 | 2002-01-31 00:00:00 | 2002-07-13 00:00:00 | 2002-07-25 00:00:00 | 2002-04-30 00:00:00 | 2002-10-30 00:00:00 | 2002-10-17 00:00:00 | 2003-01-29 00:00:00 | 2003-01-27 00:00:00 | 2004-03-24 00:00:00 | 2004-03-23 00:00:00 | 2004-07-26 00:00:00 | 2004-07-21 00:00:00 | 2004-07-06 00:00:00 | 2004-10-29 00:00:00 | 2005-01-03 00:00:00 | 2004-12-30 00:00:00 | 2005-04-08 00:00:00 | 2005-01-28 00:00:00 | 2005-01-31 00:00:00 | 2004-11-08 00:00:00 | 2005-07-15 00:00:00 | 2005-10-18 00:00:00 | 2006-01-19 00:00:00 | 2006-04-11 00:00:00 | 2006-07-20 00:00:00 | 2006-05-17 00:00:00 | 2006-10-20 00:00:00 | 2007-04-11 00:00:00 | 2007-04-11 00:00:00 | 2007-01-30 00:00:00 | 2007-04-11 00:00:00 | 2007-07-18 00:00:00 | 2008-01-07 00:00:00 | 2007-10-18 00:00:00 | 2013-07-24 00:00:00 | 2015-07-30 00:00:00 | 2015-04-28 00:00:00 | 2014-07-21 00:00:00 | 2013-10-28 00:00:00 | 2013-07-22 00:00:00 | 2014-12-31 00:00:00 | 2014-12-31 00:00:00 | 2014-10-30 00:00:00 | 2008-01-22 00:00:00 | 2008-04-29 00:00:00 | 2008-07-29 00:00:00 | 2008-10-27 00:00:00 | 2009-01-08 00:00:00 | 2009-02-25 00:00:00 | 2009-01-05 00:00:00 | 2009-04-20 00:00:00 | 2009-10-21 00:00:00 | 2009-07-21 00:00:00 | 2010-01-28 00:00:00 | 2010-04-28 00:00:00 | 2010-07-28 00:00:00 | 2010-10-27 00:00:00 | 2010-12-23 00:00:00 | 2011-01-25 00:00:00 | 2010-12-23 00:00:00 | 2011-07-25 00:00:00 | 2011-04-25 00:00:00 | 2011-10-20 00:00:00 | 2012-01-31 00:00:00 | 2012-04-25 00:00:00 | 2012-07-24 00:00:00 | 2015-01-20 00:00:00 | 2012-10-29 00:00:00 | 2013-01-01 00:00:00 | 2013-01-30 00:00:00 | 2014-04-28 00:00:00 | 2014-01-31 00:00:00 | 2012-12-31 00:00:00 | 2013-04-25 00:00:00 | 2015-10-29 00:00:00 | 2018-12-31 00:00:00 | 2020-04-30 00:00:00 | 2019-07-30 00:00:00 | 2020-10-29 00:00:00 | 2018-01-30 00:00:00 | 2016-02-17 00:00:00 | 2016-01-29 00:00:00 | 2016-04-28 00:00:00 | 2016-07-29 00:00:00 | 2016-10-31 00:00:00 | 2016-12-30 00:00:00 | 2017-04-27 00:00:00 | 2016-12-30 00:00:00 | 2017-01-31 00:00:00 | 2017-07-28 00:00:00 | 2018-07-31 00:00:00 | 2020-01-30 00:00:00 | 2017-10-30 00:00:00 | 2019-01-31 00:00:00 | 2020-07-29 00:00:00 | 2018-10-31 00:00:00 | 2018-04-25 00:00:00 | 2019-10-31 00:00:00 | 2020-12-23 00:00:00 | 2018-12-28 00:00:00 | 2018-04-26 00:00:00 | 2019-04-30 00:00:00 | 2022-04-21 00:00:00 | 2022-06-13 00:00:00 | 2020-12-23 00:00:00 | 2022-07-27 00:00:00 | 2022-07-27 00:00:00 | 2022-07-27 00:00:00 | 2022-07-28 00:00:00 | 2021-08-17 00:00:00 | 2021-11-05 00:00:00 | 2022-02-02 00:00:00 | 2022-06-14 00:00:00 | 2021-04-27 00:00:00 | 2021-01-26 00:00:00 | 2022-07-27 00:00:00 | 2022-11-03 00:00:00 | 2022-10-27 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_type | 10005 | 10005 | 10005 | 10005 | 10001 | 10001 | 10001 | 10001 | 10005 | 10005 | 10001 | 10002 | 10001 | 10005 | 10001 | 10005 | 10005 | 10005 | 10001 | 10005 | 10001 | 10005 | 10005 | 10005 | 10001 | 10005 | 10005 | 10005 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10005 | 10002 | 10002 | 10002 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | 10001 | 10002 | 10002 | 10001 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_status | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 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 | 11003 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
session_id | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2005 | 2005 | 2005 | 2003 | 2003 | 2003 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2007 | 2007 | 2005 | 2007 | 2007 | 2007 | 2007 | 2013 | 2015 | 2015 | 2013 | 2013 | 2013 | 2015 | 2015 | 2013 | 2007 | 2007 | 2007 | 2007 | 2009 | 2007 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2011 | 2009 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2013 | 2011 | 2013 | 2011 | 2013 | 2013 | 2013 | 2013 | 2015 | 2019 | 2019 | 2019 | 2019 | 2017 | 2015 | 2015 | 2015 | 2015 | 2015 | 2017 | 2017 | 2017 | 2015 | 2017 | 2017 | 2019 | 2017 | 2017 | 2019 | 2017 | 2017 | 2019 | 2021 | 2019 | 2017 | 2019 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2019 | 2021 | 2021 | 2021 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
user_id | GPEREZ | LTHIBAUL | GPEREZ | JBRANNAN | MHOANG | DHORRELL | * | * | LTHIBAUL | LTHIBAUL | * | * | * | LTHIBAUL | * | LTHIBAUL | LTHIBAUL | LTHIBAUL | * | LTHIBAUL | COMPLETED | SARRIAGA | SARRIAGA | LTHIBAUL | COMPLETED | LTHIBAUL | LTHIBAUL | SARRIAGA | COMPLETED | LTHIBAUL | COMPLETED | LTHIBAUL | DHORRELL | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | * | SARRIAGA | LTHIBAUL | LTHIBAUL | YRODRIGU | LTHIBAUL | YRODRIGU | AGLADNEY | AGLADNEY | AGLADNEY | ASAETERN | AGLADNEY | AGLADNEY | CAFILER | GPEREZ | AGLADNEY | LTHIBAUL | LTHIBAUL | LTHIBAUL | JINGRAM | * | JINGRAM | PBANFORD | MGUERRA | MGUERRA | MGUERRA | JINGRAM | ASAETERN | ASAETERN | ASAETERN | YRODRIGU | AGLADNEY | YRODRIGU | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | ASAETERN | AGLADNEY | AGLADNEY | YRODRIGU | AGLADNEY | ASAETERN | ASAETERN | YRODRIGU | AGLADNEY | JINGRAM | CAFILER | GTAYLOR | SUSHAKOV | GTAYLOR | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | YRODRIGU | MPACHECO | YRODRIGU | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | GTAYLOR | AGLADNEY | AGLADNEY | SUSHAKOV | MMERCHANT | DMCCASTL | AGLADNEY | GTAYLOR | CAFILER | CHATRIDGE | MMERCHANT | LPHEAV | CAFILER | CAFILER | CAFILER | AROJAS | LPHEAV | CHATRIDGE | CHATRIDGE | CHATRIDGE | JMAVES | CHATRIDGE | CAFILER | CAFILER | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
special_audit | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11002 | 11003 | 11002 | 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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fine_audit | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 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 | 11003 | 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 | 11003 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_start | 1900-01-01 00:00:00 | 2001-01-01 00:00:00 | 1900-01-01 00:00:00 | 2001-01-01 00:00:00 | None | 2001-04-01 00:00:00 | 2001-01-01 00:00:00 | 2001-07-01 00:00:00 | 2001-04-01 00:00:00 | 2001-07-01 00:00:00 | 2001-10-01 00:00:00 | 2001-10-01 00:00:00 | 2002-01-01 00:00:00 | 2001-10-01 00:00:00 | 2002-04-01 00:00:00 | 2002-04-01 00:00:00 | 2002-01-01 00:00:00 | 2002-07-01 00:00:00 | 2002-07-01 00:00:00 | 2002-10-01 00:00:00 | 2002-10-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2004-04-01 00:00:00 | 2004-04-01 00:00:00 | 2004-03-01 00:00:00 | 2004-07-01 00:00:00 | 1900-01-01 00:00:00 | 2004-12-30 00:00:00 | 2005-01-01 00:00:00 | 2004-10-01 00:00:00 | 2004-10-01 00:00:00 | 2004-07-01 00:00:00 | 2005-04-01 00:00:00 | 2005-07-01 00:00:00 | 2005-10-01 00:00:00 | 2006-01-01 00:00:00 | 2006-04-01 00:00:00 | 2006-01-01 00:00:00 | 2006-07-01 00:00:00 | 2006-12-31 00:00:00 | 1900-01-01 00:00:00 | 2006-10-01 00:00:00 | 2007-01-01 00:00:00 | 2007-04-01 00:00:00 | 2007-07-01 00:00:00 | 2007-07-01 00:00:00 | 2013-04-01 00:00:00 | 2015-04-01 00:00:00 | 2015-01-01 00:00:00 | 2014-04-01 00:00:00 | 2013-07-01 00:00:00 | 2013-01-01 00:00:00 | 2014-12-31 00:00:00 | 1900-01-01 00:00:00 | 2014-07-01 00:00:00 | 2007-10-01 00:00:00 | 2008-01-01 00:00:00 | 2008-04-01 00:00:00 | 2008-07-01 00:00:00 | 2009-01-08 00:00:00 | 2008-10-01 00:00:00 | 1900-01-01 00:00:00 | 2009-01-01 00:00:00 | 2009-07-01 00:00:00 | 2009-04-01 00:00:00 | 2009-09-01 00:00:00 | 2010-01-01 00:00:00 | 2010-04-01 00:00:00 | 2010-07-01 00:00:00 | 1900-01-01 00:00:00 | 2010-10-01 00:00:00 | 2010-12-23 00:00:00 | 2011-04-01 00:00:00 | 2011-01-01 00:00:00 | 2011-07-01 00:00:00 | 2011-10-01 00:00:00 | 2012-01-01 00:00:00 | 2012-04-01 00:00:00 | 2014-10-01 00:00:00 | 2012-07-01 00:00:00 | 2013-01-01 00:00:00 | 2012-10-01 00:00:00 | 2014-01-01 00:00:00 | 2013-10-01 00:00:00 | 1900-01-01 00:00:00 | 2013-01-01 00:00:00 | 2015-07-01 00:00:00 | 2018-12-31 00:00:00 | 2020-01-01 00:00:00 | 2019-04-01 00:00:00 | 2020-07-01 00:00:00 | 2017-10-01 00:00:00 | 2015-10-01 00:00:00 | 2015-09-01 00:00:00 | 2016-01-01 00:00:00 | 2016-04-01 00:00:00 | 2016-07-01 00:00:00 | 2016-12-30 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 | 2018-04-01 00:00:00 | 2019-10-01 00:00:00 | 2017-07-01 00:00:00 | 2018-10-01 00:00:00 | 2020-04-01 00:00:00 | 2018-07-01 00:00:00 | 2017-10-01 00:00:00 | 2019-07-01 00:00:00 | 2020-12-23 00:00:00 | 1900-01-01 00:00:00 | 2018-01-01 00:00:00 | 2019-01-01 00:00:00 | 2022-01-01 00:00:00 | 2021-04-01 00:00:00 | 1900-01-01 00:00:00 | 2021-07-01 00:00:00 | 2022-01-01 00:00:00 | 2022-01-01 00:00:00 | 2022-04-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-10-01 00:00:00 | 2021-04-01 00:00:00 | 2021-01-01 00:00:00 | 2020-10-01 00:00:00 | 2021-10-01 00:00:00 | 2021-10-01 00:00:00 | 2022-07-01 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_end | 1900-01-01 00:00:00 | 2001-03-31 00:00:00 | 1900-01-01 00:00:00 | 2001-03-31 00:00:00 | None | 2001-06-30 00:00:00 | 2001-03-31 00:00:00 | 2001-09-30 00:00:00 | 2001-06-30 00:00:00 | 2001-09-30 00:00:00 | 2001-12-31 00:00:00 | 2001-12-31 00:00:00 | 2002-03-31 00:00:00 | 2001-12-31 00:00:00 | 2002-06-30 00:00:00 | 2002-06-30 00:00:00 | 2002-03-31 00:00:00 | 2002-09-30 00:00:00 | 2002-09-30 00:00:00 | 2002-12-31 00:00:00 | 2002-12-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2004-06-30 00:00:00 | 2004-06-30 00:00:00 | 2004-03-31 00:00:00 | 2004-09-30 00:00:00 | 1900-01-01 00:00:00 | 2004-12-30 00:00:00 | 2005-03-31 00:00:00 | 2004-12-31 00:00:00 | 2004-12-31 00:00:00 | 2004-09-30 00:00:00 | 2005-06-30 00:00:00 | 2005-09-30 00:00:00 | 2005-12-31 00:00:00 | 2006-03-31 00:00:00 | 2006-06-30 00:00:00 | 2006-03-31 00:00:00 | 2006-09-30 00:00:00 | 2006-12-31 00:00:00 | 1900-01-01 00:00:00 | 2006-12-31 00:00:00 | 2007-03-31 00:00:00 | 2007-06-30 00:00:00 | 2007-09-30 00:00:00 | 2007-09-30 00:00:00 | 2013-06-30 00:00:00 | 2015-06-30 00:00:00 | 2015-03-31 00:00:00 | 2014-06-30 00:00:00 | 2013-09-30 00:00:00 | 2013-03-31 00:00:00 | 2014-12-31 00:00:00 | 1900-01-01 00:00:00 | 2014-09-30 00:00:00 | 2007-12-31 00:00:00 | 2008-03-31 00:00:00 | 2008-06-30 00:00:00 | 2008-09-30 00:00:00 | 2009-01-08 00:00:00 | 2008-12-31 00:00:00 | 1900-01-01 00:00:00 | 2009-03-31 00:00:00 | 2009-09-30 00:00:00 | 2009-06-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 | 1900-01-01 00:00:00 | 2010-12-31 00:00:00 | 2010-12-23 00:00:00 | 2011-06-30 00:00:00 | 2011-03-31 00:00:00 | 2011-09-30 00:00:00 | 2011-12-31 00:00:00 | 2012-03-31 00:00:00 | 2012-06-30 00:00:00 | 2014-12-31 00:00:00 | 2012-09-30 00:00:00 | 2013-01-01 00:00:00 | 2012-12-31 00:00:00 | 2014-03-31 00:00:00 | 2013-12-31 00:00:00 | 1900-01-01 00:00:00 | 2013-03-31 00:00:00 | 2015-09-30 00:00:00 | 2018-12-31 00:00:00 | 2020-03-31 00:00:00 | 2019-06-30 00:00:00 | 2020-09-30 00:00:00 | 2017-12-31 00:00:00 | 2015-12-31 00:00:00 | 2015-12-31 00:00:00 | 2016-03-31 00:00:00 | 2016-06-30 00:00:00 | 2016-09-30 00:00:00 | 2016-12-30 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 | 2018-06-30 00:00:00 | 2019-12-31 00:00:00 | 2017-09-30 00:00:00 | 2018-12-31 00:00:00 | 2020-06-30 00:00:00 | 2018-09-30 00:00:00 | 2017-12-31 00:00:00 | 2019-09-30 00:00:00 | 2020-12-23 00:00:00 | 1900-01-01 00:00:00 | 2018-03-31 00:00:00 | 2019-03-31 00:00:00 | 2022-03-31 00:00:00 | 2021-06-30 00:00:00 | 1900-01-01 00:00:00 | 2021-09-30 00:00:00 | 2022-03-31 00:00:00 | 2022-03-31 00:00:00 | 2022-06-30 00:00:00 | 2021-06-30 00:00:00 | 2021-08-01 00:00:00 | 2021-12-31 00:00:00 | 2021-06-30 00:00:00 | 2021-03-31 00:00:00 | 2020-12-31 00:00:00 | 2021-12-31 00:00:00 | 2021-12-31 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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_type | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 22001 | None | None | None | 22006 | None | None | None | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22006 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22006 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22006 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22006 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22006 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22006 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22006 | None | 22001 | 22001 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22001 | 22006 | 22006 | 22006 |
filer_id | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
session_id | 2003 | 2001 | 2013 | 2005 | 2017 | 2009 | 2007 | 2011 | 2019 | 2015 | 2021 | 2023 | ||||||||||||
interest_cd | 40319 | 40305 | 40305 | 40305 | 40305 | 40305 | 40305 | 40305 | 40305 | 40305 | 40305 | 40305 | ||||||||||||
effect_date | 2004-03-09 00:00:00 | 2001-03-01 00:00:00 | 2013-01-01 00:00:00 | 2005-01-01 00:00:00 | 2017-01-01 00:00:00 | 2009-01-01 00:00:00 | 2007-01-01 00:00:00 | 2011-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 |
filer_id | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_type | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | |||||||||||||
active | T | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | N | |||||||||||||
race | 0 | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | |||||||||||||
session_id | 2001 | 2001 | 2003 | 2005 | 2007 | 2013 | 2011 | 2009 | 2017 | 2019 | 2015 | 2021 | 2023 | |||||||||||||
category | 0 | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | |||||||||||||
category_type | 0 | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | |||||||||||||
sub_category | 0 | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | |||||||||||||
effect_dt | 2002-03-01 00:00:00 | 2001-03-01 00:00:00 | 2004-03-09 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 | 0 | 0 | None | None | None | None | None | None | None | None | |||||||||||||
election_type | 0 | 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 | None | |||||||||||||
nyq_dt | None | 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 | 0 | None | None | None | None | None | None | None | None | |||||||||||||
county_cd | 0 | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | |||||||||||||
district_cd | 0 | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None |
filer_id | 1234236 | |
---|---|---|
xref_id | 1234236 | |
effect_dt | 2001-04-09 00:00:00 | |
migration_source | CLAIMS |
xref_filer_id | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_id | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
naml | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
city | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | SPRING VALLEY | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
zip4 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | 91978 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
phon | 6196702222 | 6196702210 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702222 | 6196702210 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702222 | 6196702210 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702222 | 6196702210 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702222 | 6196702210 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702222 | 6196702210 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702222 | 6196702210 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702222 | 6196702210 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702222 | 6196702210 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702222 | 6196702210 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702222 | 6196702210 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702222 | 6196702210 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | 6196702280 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fax | 6194094184 | 6196600829 | 6196600829 | 6196600829 | 6196600829 | 6194094184 | 6196600829 | 6196600829 | 6196600829 | 6196600829 | 6194094184 | 6196600829 | 6196600829 | 6196600829 | 6196600829 | 6194094184 | 6196600829 | 6196600829 | 6196600829 | 6196600829 | 6194094184 | 6196600829 | 6196600829 | 6196600829 | 6196600829 | 6194094184 | 6196600829 | 6196600829 | 6196600829 | 6196600829 | 6194094184 | 6196600829 | 6196600829 | 6196600829 | 6196600829 | 6194094184 | 6196600829 | 6196600829 | 6196600829 | 6196600829 | 6194094184 | 6196600829 | 6196600829 | 6196600829 | 6196600829 | 6194094184 | 6196600829 | 6196600829 | 6196600829 | 6196600829 | 6194094184 | 6196600829 | 6196600829 | 6196600829 | 6196600829 | 6194094184 | 6196600829 | 6196600829 | 6196600829 | 6196600829 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
None | None | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] |
filer_id | 1234236 |
---|
filer_id | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | ||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
change_no | 1 | 4 | 2 | 0 | 5 | 6 | ||||||
session_id | 2001 | 2001 | 2001 | 2003 | 2007 | 2021 | ||||||
log_dt | 2001-03-12 00:00:00 | 2002-03-18 00:00:00 | 2002-03-18 00:00:00 | 2004-03-23 00:00:00 | 2007-04-11 00:00:00 | 2020-12-23 00:00:00 | ||||||
filer_type | 1 | 2 | 2 | 1 | 1 | 1 | ||||||
correction_flg | Y | Y | Y | None | Y | None | ||||||
action | NEW | TERMINATED | DELETED | ADDED | ADDED | CHANGED | ||||||
attribute_changed | EMPLOYER | None | FIRM | FIRM | FIRM | RESPONSIBLE OFFICER | ||||||
ethics_dt | None | None | None | None | None | None | ||||||
interests | None | None | None | None | None | None | ||||||
filer_full_name | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | OTAY WATER DISTRICT | ||||||
filer_city | None | SPRING VALLEY | None | None | None | None | ||||||
filer_st | None | CA | None | None | None | None | ||||||
filer_zip | None | 91978 | None | None | None | None | ||||||
filer_phone | None | 6196702222 | None | None | None | None | ||||||
entity_type | 2 | 2 | 3 | 3 | 3 | 20 | ||||||
entity_name | LEGISLATIVE ADVOCACY GROUP, INC. | OTAY WATER DISTRICT | LEGISLATIVE ADVOCACY GROUP, INC. | MARSTON & MARSTON, INC. | HATCH & PARENT, A LAW CORPORATION | GENERAL MANAGER JOSE MARTINEZ | ||||||
entity_city | LOS ANGELES | None | None | None | None | None | ||||||
entity_st | CA | None | None | None | None | None | ||||||
entity_zip | 90012 | None | None | None | None | None | ||||||
entity_phone | 2135807900 | None | None | None | None | None | ||||||
entity_id | 1147624 | None | 1147624 | 1147715 | 0 | 1436091 | ||||||
responsible_officer | None | None | None | None | None | None | ||||||
effect_dt | 2001-03-01 00:00:00 | 2002-03-01 00:00:00 | 2002-03-01 00:00:00 | 2004-03-09 00:00:00 | 2007-01-01 00:00:00 | 2021-01-01 00:00:00 |
filer_id | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | 1234236 | |||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_file_name | 793869_0.cal | 793931_0.cal | 791837_0.cal | 808320_0.cal | 72520.cal | 72001.cal | 808320_1.cal | 836553_0.cal | 849503_0.cal | 874738_0.cal | 907107_0.cal | 85930.cal | 85991.cal | 159853.cal | 159913.cal | 159947.cal | 189936.cal | 190714.cal | 190086.cal | 191102.cal | 193155.cal | |||||||||||||||||||||
received_date | 2001-11-05 00:00:00 | 2001-11-05 00:00:00 | 2001-10-31 00:00:00 | 2002-01-21 00:00:00 | 2002-01-21 00:00:00 | 2002-01-21 00:00:00 | 2002-01-21 00:00:00 | 2002-04-22 00:00:00 | 2002-07-13 00:00:00 | 2002-10-17 00:00:00 | 2003-01-27 00:00:00 | 2009-02-25 00:00:00 | 2009-02-25 00:00:00 | 2008-12-23 00:00:00 | 2008-12-23 00:00:00 | 2008-12-23 00:00:00 | 2019-01-31 00:00:00 | 2019-01-31 00:00:00 | 2019-01-31 00:00:00 | 2019-01-31 00:00:00 | 2019-01-31 00:00:00 | |||||||||||||||||||||
filing_directory | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/temp | /usr/users/cafiler/disclose/ca99/temp | /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/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | |||||||||||||||||||||
filing_id | 793869 | 793931 | 791837 | 808320 | None | None | 808320 | 836553 | 849503 | 874738 | 907107 | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||
form_id | F635 | F635 | F635 | F635 | None | None | F635 | F635 | F635 | F635 | F635 | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||
receive_comment | Filing accepted, but with warnings | Filing accepted, but with warnings | Filing accepted, but with warnings | Filing accepted | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints |