filer_id | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
adrid | 2041122 | 2079637 | 2117065 | 2159550 | 2204906 | 2412643 | 2269956 | 2339674 | ||||||||
effect_dt | 2003-01-01 00:00:00 | 2005-01-01 00:00:00 | 2007-01-01 00:00:00 | 2009-01-01 00:00:00 | 2011-01-01 00:00:00 | 2017-01-01 00:00:00 | 2013-03-29 00:00:00 | 2015-05-27 00:00:00 | ||||||||
add_type | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | ||||||||
session_id | 2003 | 2005 | 2007 | 2009 | 2011 | 2017 | 2013 | 2015 |
filer_id | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 896214 | 959147 | 986953 | 986983 | 1015456 | 1016616 | 1035216 | 1098565 | 1062964 | 1121931 | 1085913 | 1106913 | 1135600 | 1169003 | 1151719 | 1227265 | 1196119 | 1219599 | 1247136 | 1265184 | 1969626 | 1969628 | 1802693 | 1788521 | 1941483 | 1287496 | 1298383 | 1312795 | 1330851 | 1349167 | 1381016 | 1401077 | 1409307 | 1422581 | 1450812 | 1440266 | 1467300 | 1486456 | 1513348 | 1516334 | 1541893 | 1553148 | 1592215 | 1575297 | 1610921 | 1623714 | 1639212 | 1658848 | 1684801 | 1915024 | 1714390 | 1879460 | 1847843 | 1822760 | 1767250 | 1748422 | 1762554 | 1749928 | 1995569 | 2001167 | 2385957 | 2323775 | 2017917 | 2049759 | 2068153 | 2111465 | 2148132 | 2160667 | 2245852 | 2181106 | 2273805 | 2195212 | 2219839 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
period_id | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 221 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 237 | None | None | None | None | None | None | 229 | 233 | None | None | 231 | 232 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F601 | F625 | F625 | F625 | F625 | F625 | F625 | F601 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F601 | F625 | F625 | F625 | F625 | F601 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F601 | F625 | F625 | F625 | F625 | F625 | F625 | F690 | F625 | F601 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F690 | F601 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_sequence | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_date | 2002-11-13 00:00:00 | 2003-07-16 00:00:00 | 2003-09-05 00:00:00 | 2003-11-04 00:00:00 | 2004-04-30 00:00:00 | 2004-05-05 00:00:00 | 2004-08-02 00:00:00 | 2005-03-28 00:00:00 | 2004-10-29 00:00:00 | 2005-08-01 00:00:00 | 2005-01-31 00:00:00 | 2005-04-29 00:00:00 | 2005-10-31 00:00:00 | 2006-05-01 00:00:00 | 2006-02-08 00:00:00 | 2007-01-04 00:00:00 | 2006-07-31 00:00:00 | 2006-10-31 00:00:00 | 2007-01-29 00:00:00 | 2007-04-30 00:00:00 | 2015-05-27 00:00:00 | 2015-04-29 00:00:00 | 2013-10-31 00:00:00 | 2013-07-31 00:00:00 | 2015-01-30 00:00:00 | 2007-07-31 00:00:00 | 2007-10-30 00:00:00 | 2008-01-30 00:00:00 | 2008-04-29 00:00:00 | 2008-07-29 00:00:00 | 2008-10-30 00:00:00 | 2009-01-30 00:00:00 | 2008-11-24 00:00:00 | 2009-04-29 00:00:00 | 2009-10-27 00:00:00 | 2009-07-28 00:00:00 | 2010-02-01 00:00:00 | 2010-04-29 00:00:00 | 2010-07-29 00:00:00 | 2010-07-29 00:00:00 | 2010-11-01 00:00:00 | 2010-10-19 00:00:00 | 2011-04-28 00:00:00 | 2011-01-31 00:00:00 | 2011-07-31 00:00:00 | 2011-10-31 00:00:00 | 2012-01-31 00:00:00 | 2012-04-30 00:00:00 | 2012-07-31 00:00:00 | 2014-10-30 00:00:00 | 2012-10-31 00:00:00 | 2014-07-28 00:00:00 | 2014-04-30 00:00:00 | 2014-01-30 00:00:00 | 2013-04-30 00:00:00 | 2013-02-12 00:00:00 | 2013-03-29 00:00:00 | 2013-01-31 00:00:00 | 2015-09-12 00:00:00 | 2015-11-20 00:00:00 | 2019-01-31 00:00:00 | 2018-10-31 00:00:00 | 2016-02-01 00:00:00 | 2016-05-02 00:00:00 | 2016-07-31 00:00:00 | 2016-11-03 00:00:00 | 2017-01-31 00:00:00 | 2017-04-29 00:00:00 | 2018-04-27 00:00:00 | 2017-07-31 00:00:00 | 2018-07-30 00:00:00 | 2017-10-31 00:00:00 | 2018-01-31 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_type | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10001 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10001 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_status | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
session_id | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2005 | 2003 | 2005 | 2003 | 2005 | 2005 | 2005 | 2005 | 2007 | 2005 | 2005 | 2005 | 2007 | 2015 | 2015 | 2013 | 2013 | 2013 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2011 | 2011 | 2009 | 2011 | 2011 | 2011 | 2011 | 2011 | 2013 | 2011 | 2013 | 2013 | 2013 | 2013 | 1973 | 2013 | 2011 | 2015 | 2015 | 2019 | 2017 | 2015 | 2015 | 2015 | 2015 | 2015 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
user_id | SARRIAGA | YBONILLA | YBONILLA | DHORRELL | LTHIBAUL | LTHIBAUL | LTHIBAUL | GPEREZ | YRODRIGUEZ | YRODRIGU | YRODRIGU | YRODRIGU | YRODRIGU | YRODRIGU | YRODRIGU | PBANFORD | YRODRIGU | YRODRIGU | YRODRIGU | YRODRIGU | YRODRIGU | AGLADNEY | ASAETERN | ASAETERN | AGLADNEY | YRODRIGU | YRODRIGU | YRODRIGU | YRODRIGU | YRODRIGU | MGUERRA | MGUERRA | DMCCASTL | YRODRIGU | YRODRIGU | YRODRIGU | YRODRIGU | MGUERRA | ASAETERN | ASAETERN | ASAETERN | CPON | ASAETERN | ASAETERN | ASAETERN | ASAETERN | ASAETERN | ASAETERN | AGLADNEY | AGLADNEY | ASAETERN | ASAETERN | ASAETERN | ASAETERN | ASAETERN | ASAETERN | PBANFORD | ASAETERN | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
special_audit | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fine_audit | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_start | 1900-01-01 00:00:00 | 2003-01-01 00:00:00 | 2003-07-01 00:00:00 | 2003-04-01 00:00:00 | 2003-10-01 00:00:00 | 2004-01-01 00:00:00 | 2004-04-01 00:00:00 | 1900-01-01 00:00:00 | 2004-07-01 00:00:00 | 2005-04-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 | 2005-10-01 00:00:00 | 1900-01-01 00:00:00 | 2006-04-01 00:00:00 | 2006-07-01 00:00:00 | 2006-10-01 00:00:00 | 2007-01-01 00:00:00 | 1900-01-01 00:00:00 | 2015-01-01 00:00:00 | 2013-07-01 00:00:00 | 2013-04-01 00:00:00 | 2014-10-01 00:00:00 | 2007-04-01 00:00:00 | 2007-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 | 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-10-01 00:00:00 | 2010-01-01 00:00:00 | 2010-04-01 00:00:00 | 2010-01-01 00:00:00 | 2010-07-01 00:00:00 | 1900-01-01 00:00:00 | 2011-01-01 00:00:00 | 2010-10-01 00:00:00 | 2011-04-01 00:00:00 | 2011-07-01 00:00:00 | 2011-10-01 00:00:00 | 2012-01-01 00:00:00 | 2012-04-01 00:00:00 | 2014-07-01 00:00:00 | 2012-07-01 00:00:00 | 2014-04-01 00:00:00 | 2014-01-01 00:00:00 | 2013-10-01 00:00:00 | 2013-01-01 00:00:00 | 2012-04-01 00:00:00 | 1900-01-01 00:00:00 | 2012-10-01 00:00:00 | 2015-04-01 00:00:00 | 2015-07-01 00:00:00 | 2019-01-01 00:00:00 | 2018-07-01 00:00:00 | 2015-10-01 00:00:00 | 2016-01-01 00:00:00 | 2016-04-01 00:00:00 | 2016-07-01 00:00:00 | 2016-10-01 00:00:00 | 2017-01-01 00:00:00 | 2018-01-01 00:00:00 | 2017-04-01 00:00:00 | 2018-04-01 00:00:00 | 2017-07-01 00:00:00 | 2017-10-01 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_end | 1900-01-01 00:00:00 | 2003-03-31 00:00:00 | 2003-09-30 00:00:00 | 2003-06-30 00:00:00 | 2003-12-31 00:00:00 | 2004-03-31 00:00:00 | 2004-06-30 00:00:00 | 1900-01-01 00:00:00 | 2004-09-30 00:00:00 | 2005-06-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 | 2005-12-31 00:00:00 | 1900-01-01 00:00:00 | 2006-06-30 00:00:00 | 2006-09-30 00:00:00 | 2006-12-31 00:00:00 | 2007-03-31 00:00:00 | 1900-01-01 00:00:00 | 2015-03-31 00:00:00 | 2013-09-30 00:00:00 | 2013-06-30 00:00:00 | 2014-12-31 00:00:00 | 2007-06-30 00:00:00 | 2007-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 | 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-03-31 00:00:00 | 2010-09-30 00:00:00 | 1900-01-01 00:00:00 | 2011-03-31 00:00:00 | 2010-12-31 00:00:00 | 2011-06-30 00:00:00 | 2011-09-30 00:00:00 | 2011-12-31 00:00:00 | 2012-03-31 00:00:00 | 2012-06-30 00:00:00 | 2014-09-30 00:00:00 | 2012-09-30 00:00:00 | 2014-06-30 00:00:00 | 2014-03-31 00:00:00 | 2013-12-31 00:00:00 | 2013-03-31 00:00:00 | 2012-06-30 00:00:00 | 1900-01-01 00:00:00 | 2012-12-31 00:00:00 | 2015-06-30 00:00:00 | 2015-09-30 00:00:00 | 2019-03-31 00:00:00 | 2018-09-30 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-31 00:00:00 | 2017-03-31 00:00:00 | 2018-03-31 00:00:00 | 2017-06-30 00:00:00 | 2018-06-30 00:00:00 | 2017-09-30 00:00:00 | 2017-12-31 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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_type | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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_id | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_type | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | ||||||||
active | Y | Y | Y | Y | Y | Y | Y | N | ||||||||
race | 0 | 0 | 0 | None | None | None | None | None | ||||||||
session_id | 2003 | 2005 | 2007 | 2013 | 2011 | 2009 | 2015 | 2017 | ||||||||
category | 0 | 0 | 0 | None | None | None | None | None | ||||||||
category_type | 0 | 0 | 0 | None | None | None | None | None | ||||||||
sub_category | 0 | 0 | 0 | None | None | None | None | None | ||||||||
effect_dt | 2003-01-01 00:00:00 | 2005-01-01 00:00:00 | 2007-01-01 00:00:00 | 2013-03-29 00:00:00 | 2011-01-01 00:00:00 | 2009-01-01 00:00:00 | 2015-05-27 00:00:00 | 2017-01-01 00:00:00 | ||||||||
sub_category_type | 0 | 0 | 0 | None | None | None | None | None | ||||||||
election_type | 0 | 0 | 0 | None | None | None | None | None | ||||||||
sub_category_a | None | None | None | None | None | None | None | None | ||||||||
nyq_dt | None | None | None | None | None | None | None | None | ||||||||
party_cd | 0 | 0 | 0 | None | None | None | None | None | ||||||||
county_cd | 0 | 0 | 0 | None | None | None | None | None | ||||||||
district_cd | 0 | 0 | 0 | None | None | None | None | None |
filer_id | 1251137 | |
---|---|---|
xref_id | 1251137 | |
effect_dt | 2002-12-13 00:00:00 | |
migration_source | CLAIMS |
xref_filer_id | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_id | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | 1251137 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filer_type | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
effect_dt | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 2017-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017-01-01 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
naml | POWELL & ASSOCIATES, V. J. | POWELL & ASSOCIATES, V. J. | POWELL & ASSOCIATES, V. J. | POWELL & ASSOCIATES, V. J. | POWELL & ASSOCIATES, V. J. | POWELL & ASSOCIATES, V. J. | POWELL & ASSOCIATES, V. J. | POWELL & ASSOCIATES, V. J. | POWELL & ASSOCIATES, V.J. | POWELL & ASSOCIATES, V.J. | POWELL & ASSOCIATES, V.J. | POWELL & ASSOCIATES, V.J. | POWELL & ASSOCIATES, V.J. | POWELL & ASSOCIATES, V.J. | POWELL & ASSOCIATES, V.J. | POWELL & ASSOCIATES, V.J. | POWELL & ASSOCIATES; VJ | POWELL & ASSOCIATES; VJ | POWELL & ASSOCIATES; VJ | POWELL & ASSOCIATES; VJ | POWELL & ASSOCIATES; VJ | POWELL & ASSOCIATES; VJ | POWELL & ASSOCIATES; VJ | POWELL & ASSOCIATES; VJ | POWELL & ASSOCIATES; VJ | POWELL & ASSOCIATES; VJ | POWELL & ASSOCIATES; VJ | POWELL & ASSOCIATES; VJ | POWELL & ASSOCIATES; VJ | POWELL & ASSOCIATES; VJ | POWELL & ASSOCIATES; VJ | POWELL & ASSOCIATES; VJ | POWELL & ASSOCIATES; VJ | POWELL & ASSOCIATES; VJ | POWELL & ASSOCIATES; VJ | POWELL & ASSOCIATES; VJ | POWELL & ASSOCIATES; VJ | POWELL & ASSOCIATES; VJ | POWELL & ASSOCIATES; VJ | POWELL & ASSOCIATES; VJ | POWELL & ASSOCIATES; VJ | POWELL & ASSOCIATES; VJ | POWELL & ASSOCIATES; VJ | POWELL & ASSOCIATES; VJ | POWELL & ASSOCIATES; VJ | POWELL & ASSOCIATES; VJ | POWELL & ASSOCIATES; VJ | POWELL & ASSOCIATES; VJ | POWELL & ASSOCIATES; VJ | POWELL & ASSOCIATES; VJ | POWELL & ASSOCIATES; VJ | POWELL & ASSOCIATES; VJ | POWELL & ASSOCIATES; VJ | POWELL & ASSOCIATES; VJ | POWELL & ASSOCIATES; VJ | POWELL & ASSOCIATES; VJ | POWELL & ASSOCIATES; VJ | POWELL & ASSOCIATES; VJ | POWELL & ASSOCIATES; VJ | POWELL & ASSOCIATES; VJ | POWELL & ASSOCIATES; VJ | POWELL & ASSOCIATES; VJ | POWELL & ASSOCIATES; VJ | POWELL & ASSOCIATES; VJ | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
namf | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
namt | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
nams | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
adr1 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
adr2 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
city | VALLEJO | VALLEJO | VALLEJO | VALLEJO | VALLEJO | VALLEJO | VALLEJO | VALLEJO | VALLEJO | VALLEJO | VALLEJO | VALLEJO | VALLEJO | VALLEJO | VALLEJO | VALLEJO | VALLEJO | VALLEJO | VALLEJO | VALLEJO | VALLEJO | VALLEJO | VALLEJO | VALLEJO | VALLEJO | VALLEJO | VALLEJO | VALLEJO | VALLEJO | VALLEJO | VALLEJO | VALLEJO | VALLEJO | VALLEJO | VALLEJO | VALLEJO | VALLEJO | VALLEJO | VALLEJO | VALLEJO | VALLEJO | VALLEJO | VALLEJO | VALLEJO | VALLEJO | VALLEJO | VALLEJO | VALLEJO | VALLEJO | VALLEJO | VALLEJO | VALLEJO | VALLEJO | VALLEJO | VALLEJO | VALLEJO | VALLEJO | VALLEJO | VALLEJO | VALLEJO | VALLEJO | VALLEJO | VALLEJO | VALLEJO | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
st | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
zip4 | 94591 | 94591 | 94591 | 94591 | 94591 | 94591 | 94591 | 94591 | 94591 | 94591 | 94591 | 94591 | 94591 | 94591 | 94591 | 94591 | 94591 | 94591 | 94591 | 94591 | 94591 | 94591 | 94591 | 94591 | 94591 | 94591 | 94591 | 94591 | 94591 | 94591 | 94591 | 94591 | 94591 | 94591 | 94591 | 94591 | 94591 | 94591 | 94591 | 94591 | 94591 | 94591 | 94591 | 94591 | 94591 | 94591 | 94591 | 94591 | 94591 | 94591 | 94591 | 94591 | 94591 | 94591 | 94591 | 94591 | 94591 | 94591 | 94591 | 94591 | 94591 | 94591 | 94591 | 94591 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
phon | 7075527196 | 7075527196 | 7075527196 | 7075527196 | 7075527196 | 7075527196 | 7075527196 | 7075527196 | 7075527196 | 7075527196 | 7075527196 | 7075527196 | 7075527196 | 7075527196 | 7075527196 | 7075527196 | 7075527196 | 7075527196 | 7075527196 | 7075527196 | 7075527196 | 7075527196 | 7075527196 | 7075527196 | 7075527196 | 7075527196 | 7075527196 | 7075527196 | 7075527196 | 7075527196 | 7075527196 | 7075527196 | 7075527196 | 7075527196 | 7075527196 | 7075527196 | 7075527196 | 7075527196 | 7075527196 | 7075527196 | 7075527196 | 7075527196 | 7075527196 | 7075527196 | 7075527196 | 7075527196 | 7075527196 | 7075527196 | 7075527196 | 7075527196 | 7075527196 | 7075527196 | 7075527196 | 7075527196 | 7075527196 | 7075527196 | 7075527196 | 7075527196 | 7075527196 | 7075527196 | 7075527196 | 7075527196 | 7075527196 | 7075527196 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fax | 7075527338 | 7075527338 | 7075527338 | 7075527338 | 7075527338 | 7075527338 | 7075527338 | 7075527338 | 7075527338 | 7075527338 | 7075527338 | 7075527338 | 7075527338 | 7075527338 | 7075527338 | 7075527338 | 7075527338 | 7075527338 | 7075527338 | 7075527338 | 7075527338 | 7075527338 | 7075527338 | 7075527338 | 7075527338 | 7075527338 | 7075527338 | 7075527338 | 7075527338 | 7075527338 | 7075527338 | 7075527338 | 7075527338 | 7075527338 | 7075527338 | 7075527338 | 7075527338 | 7075527338 | 7075527338 | 7075527338 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
None | None | None | None | [email protected] | None | None | None | None | None | None | None | [email protected] | None | None | None | None | None | None | None | [email protected] | None | None | None | None | None | None | None | [email protected] | None | None | None | None | None | None | None | [email protected] | None | None | None | None | None | None | None | [email protected] | None | None | None | None | None | None | None | [email protected] | None | None | None | None | None | None | None | [email protected] | None | None | None |
filer_id | 1251137 |
---|
filer_id | 1251137 | 1251137 | ||
---|---|---|---|---|
change_no | 2 | 3 | ||
session_id | 2013 | 2015 | ||
log_dt | 2013-03-29 00:00:00 | 2015-05-27 00:00:00 | ||
filer_type | 3 | 3 | ||
correction_flg | Y | Y | ||
action | ADDED | ADDED | ||
attribute_changed | LOBBYIST | LOBBYIST | ||
ethics_dt | None | None | ||
interests | None | None | ||
filer_full_name | POWELL & ASSOCIATES; VJ | POWELL, VALERIE J. | ||
filer_city | None | VALLEJO | ||
filer_st | None | CA | ||
filer_zip | None | 94591 | ||
filer_phone | None | 7075527196 | ||
entity_type | 4 | 4 | ||
entity_name | POWELL, VALERIE J. | POWELL, VALERIE J. | ||
entity_city | None | None | ||
entity_st | None | None | ||
entity_zip | None | None | ||
entity_phone | None | None | ||
entity_id | 1245390 | None | ||
responsible_officer | None | None | ||
effect_dt | 2013-03-29 00:00:00 | 2015-05-27 00:00:00 |