filer_id | 1335818 | 1335818 | 1335818 | 1335818 | ||||
---|---|---|---|---|---|---|---|---|
adrid | 2210736 | 2413578 | 2264176 | 2337454 | ||||
effect_dt | 2011-01-01 00:00:00 | 2017-01-27 00:00:00 | 2013-01-01 00:00:00 | 2015-01-01 00:00:00 | ||||
add_type | 7051 | 7051 | 7051 | 7051 | ||||
session_id | 2011 | 2017 | 2013 | 2015 |
filer_id | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 1788490 | 1789554 | 1772323 | 1963875 | 1941459 | 1792357 | 1801966 | 1797615 | 1792272 | 1795477 | 1958974 | 1567274 | 1584246 | 1596297 | 1597732 | 1576412 | 1597695 | 1615285 | 1611722 | 1592334 | 1623664 | 1626255 | 1627746 | 1626265 | 1644707 | 1644710 | 1649415 | 1639174 | 1610062 | 1659079 | 1831278 | 1684856 | 1923921 | 1913345 | 1713365 | 1716406 | 1716230 | 1875551 | 1875410 | 1724443 | 1846548 | 1821488 | 1767037 | 1766753 | 1749875 | 1995240 | 1999769 | 1996408 | 2000707 | 1984078 | 1984075 | 1984690 | 1984073 | 2183791 | 2013885 | 2017566 | 2001408 | 2001410 | 2030240 | 2034794 | 2066271 | 2047380 | 2052305 | 2052307 | 2052019 | 2046958 | 2068249 | 2099293 | 2093339 | 2106315 | 2106151 | 2148416 | 2151056 | 2151058 | 2142493 | 2137557 | 2137618 | 2176752 | 2160278 | 2158994 | 2166314 | 2166326 | 2166329 | 2166331 | 2166333 | 2166336 | 2166338 | 2166340 | 2180665 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
period_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 | 230 | 229 | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F635 | F605 | F606 | F635 | F635 | F666 | F635 | F605 | F635 | F605 | F605 | F603 | F605 | F605 | F605 | F605 | F605 | F605 | F605 | F635 | F635 | F605 | F605 | F605 | F690 | F690 | F605 | F635 | F635 | F635 | F605 | F635 | F603 | F635 | F635 | F605 | F690 | F635 | F690 | F603 | F635 | F635 | F635 | F605 | F635 | F690 | F690 | F635 | F666 | F605 | F605 | F635 | F605 | F666 | F690 | F635 | F605 | F888 | F605 | F605 | F635 | F635 | F605 | F888 | F888 | F605 | F605 | F605 | F605 | F605 | F635 | F605 | F605 | F888 | F635 | F603 | F605 | F635 | F635 | F605 | F605 | F888 | F605 | F605 | F605 | F605 | F605 | F605 | F606 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_date | 2013-07-31 00:00:00 | 2013-08-15 00:00:00 | 2013-04-30 00:00:00 | 2015-04-24 00:00:00 | 2015-01-29 00:00:00 | 2013-09-30 00:00:00 | 2013-10-31 00:00:00 | 2013-10-21 00:00:00 | 2013-09-24 00:00:00 | 2013-10-17 00:00:00 | 2015-04-14 00:00:00 | 2011-01-24 00:00:00 | 2011-03-01 00:00:00 | 2011-05-24 00:00:00 | 2011-06-13 00:00:00 | 2011-02-04 00:00:00 | 2011-06-03 00:00:00 | 2011-08-26 00:00:00 | 2011-07-21 00:00:00 | 2011-05-02 00:00:00 | 2011-10-31 00:00:00 | 2011-11-03 00:00:00 | 2011-12-20 00:00:00 | 2011-11-21 00:00:00 | 2012-03-12 00:00:00 | 2012-03-12 00:00:00 | 2012-02-09 00:00:00 | 2012-01-31 00:00:00 | 2011-08-01 00:00:00 | 2012-04-30 00:00:00 | 2014-03-20 00:00:00 | 2012-07-30 00:00:00 | 2014-12-23 00:00:00 | 2014-10-27 00:00:00 | 2012-10-25 00:00:00 | 2012-12-03 00:00:00 | 2012-12-03 00:00:00 | 2014-07-31 00:00:00 | 2014-08-05 00:00:00 | 2012-12-31 00:00:00 | 2014-04-29 00:00:00 | 2014-01-31 00:00:00 | 2013-04-30 00:00:00 | 2013-03-07 00:00:00 | 2013-01-31 00:00:00 | 2015-10-02 00:00:00 | 2015-11-02 00:00:00 | 2015-10-22 00:00:00 | 2015-12-01 00:00:00 | 2015-07-29 00:00:00 | 2015-07-29 00:00:00 | 2015-07-29 00:00:00 | 2015-07-29 00:00:00 | 2017-07-31 00:00:00 | 2016-01-26 00:00:00 | 2016-01-28 00:00:00 | 2015-11-12 00:00:00 | 2015-11-12 00:00:00 | 2016-04-13 00:00:00 | 2016-04-26 00:00:00 | 2016-07-27 00:00:00 | 2016-04-27 00:00:00 | 2016-06-20 00:00:00 | 2016-06-20 00:00:00 | 2016-06-17 00:00:00 | 2016-04-27 00:00:00 | 2016-07-27 00:00:00 | 2016-10-20 00:00:00 | 2016-10-20 00:00:00 | 2016-11-04 00:00:00 | 2016-10-20 00:00:00 | 2017-03-15 00:00:00 | 2017-03-20 00:00:00 | 2017-03-20 00:00:00 | 2017-01-26 00:00:00 | 2017-01-27 00:00:00 | 2017-01-26 00:00:00 | 2017-07-26 00:00:00 | 2017-04-28 00:00:00 | 2017-04-28 00:00:00 | 2017-06-29 00:00:00 | 2017-06-29 00:00:00 | 2017-07-06 00:00:00 | 2017-07-06 00:00:00 | 2017-07-06 00:00:00 | 2017-07-06 00:00:00 | 2017-07-06 00:00:00 | 2017-07-06 00:00:00 | 2017-07-26 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_type | 10005 | 10006 | 10005 | 10005 | 10005 | 10005 | 10005 | 10006 | 10006 | 10006 | 10006 | 10005 | 10006 | 10006 | 10005 | 10006 | 10005 | 10006 | 10006 | 10005 | 10005 | 10006 | 10005 | 10006 | 10005 | 10005 | 10006 | 10005 | 10005 | 10005 | 10006 | 10005 | 10005 | 10005 | 10005 | 10006 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10006 | 10006 | 10005 | 10005 | 10006 | 10006 | 10005 | 10006 | 10005 | 10006 | 10005 | 10006 | 10005 | 10006 | 10006 | 10005 | 10005 | 10006 | 10005 | 10005 | 10006 | 10006 | 10006 | 10006 | 10006 | 10005 | 10005 | 10006 | 10005 | 10005 | 10005 | 10006 | 10005 | 10005 | 10005 | 10006 | 10005 | 10006 | 10006 | 10006 | 10006 | 10006 | 10006 | 10003 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_status | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 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 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
session_id | 2013 | 2013 | 2013 | 2015 | 2013 | 2011 | 2013 | 2013 | 2013 | 2013 | 2015 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2013 | 2011 | 2015 | 2013 | 2011 | 2011 | 2011 | 2013 | 2013 | 2013 | 2013 | 2013 | 2013 | 2013 | 2011 | 2015 | 2015 | 2015 | 2013 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2017 | 2017 | 2017 | 2015 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
user_id | ASAETERN | YRODRIGU | GPEREZ | AGLADNEY | AGLADNEY | NLANDERS | AGLADNEY | YRODRIGU | ASAETERN | YRODRIGU | YRODRIGU | CFLAGG | ASAETERN | ASAETERN | GPEREZ | YRODRIGU | GPEREZ | YRODRIGU | YRODRIGU | ASAETERN | AGLADNEY | YRODRIGU | SARRIAGA | GPEREZ | ASAETERN | ASAETERN | YRODRIGU | ASAETERN | AGLADNEY | AGLADNEY | PBANFORD | AGLADNEY | GPEREZ | AGLADNEY | AGLADNEY | SMCCONNAN | ASAETERN | ASAETERN | ASAETERN | GKURIMOT | AGLADNEY | ASAETERN | AGLADNEY | SARRIAGA | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | SBROWN | YRODRIGU | YRODRIGU | MPACHECO | YRODRIGU | SBROWN | AGLADNEY | AGLADNEY | YRODRIGU | YRODRIGU | YRODRIGU | YRODRIGU | AGLADNEY | AGLADNEY | YRODRIGU | YRODRIGU | YRODRIGU | YRODRIGU | YRODRIGU | YRODRIGU | YRODRIGU | YRODRIGU | AGLADNEY | GPEREZ | YRODRIGU | YRODRIGU | AGLADNEY | DMCCASTL | GPEREZ | RSAGARIO | AGLADNEY | GPEREZ | YRODRIGU | YRODRIGU | YRODRIGU | YRODRIGU | YRODRIGU | YRODRIGU | YRODRIGU | YRODRIGU | YRODRIGU | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
special_audit | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fine_audit | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_start | 2013-04-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2015-01-01 00:00:00 | 2014-10-01 00:00:00 | 2011-01-01 00:00:00 | 2013-07-01 00:00:00 | 1900-01-01 00:00:00 | 2013-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2011-01-01 00:00:00 | 2011-07-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2011-10-01 00:00:00 | 2011-07-01 00:00:00 | 1900-01-01 00:00:00 | 2011-10-01 00:00:00 | 2011-04-01 00:00:00 | 2012-01-01 00:00:00 | 1900-01-01 00:00:00 | 2012-04-01 00:00:00 | 1900-01-01 00:00:00 | 2014-07-01 00:00:00 | 2012-07-01 00:00:00 | 1900-01-01 00:00:00 | 2012-04-01 00:00:00 | 2014-04-01 00:00:00 | 2014-01-01 00:00:00 | 1900-01-01 00:00:00 | 2014-01-01 00:00:00 | 2013-10-01 00:00:00 | 2013-01-01 00:00:00 | 1900-01-01 00:00:00 | 2012-10-01 00:00:00 | 2015-01-01 00:00:00 | 2015-04-01 00:00:00 | 2015-07-01 00:00:00 | 2013-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2015-04-01 00:00:00 | 1900-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-07-01 00:00:00 | 2015-10-01 00:00:00 | 1900-01-01 00:00:00 | None | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2016-04-01 00:00:00 | 2016-01-01 00:00:00 | 1900-01-01 00:00:00 | None | None | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2016-07-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | None | 2016-10-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2017-03-01 00:00:00 | 2017-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | None | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_end | 2013-06-30 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2015-03-31 00:00:00 | 2014-12-31 00:00:00 | 2012-12-31 00:00:00 | 2013-09-30 00:00:00 | 1900-01-01 00:00:00 | 2013-03-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2011-03-31 00:00:00 | 2011-09-30 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2011-12-31 00:00:00 | 2011-09-30 00:00:00 | 1900-01-01 00:00:00 | 2011-12-31 00:00:00 | 2011-06-30 00:00:00 | 2012-03-31 00:00:00 | 1900-01-01 00:00:00 | 2012-06-30 00:00:00 | 1900-01-01 00:00:00 | 2014-09-30 00:00:00 | 2012-09-30 00:00:00 | 1900-01-01 00:00:00 | 2012-06-30 00:00:00 | 2014-06-30 00:00:00 | 2014-03-31 00:00:00 | 1900-01-01 00:00:00 | 2014-03-31 00:00:00 | 2013-12-31 00:00:00 | 2013-03-31 00:00:00 | 1900-01-01 00:00:00 | 2012-12-31 00:00:00 | 2015-03-31 00:00:00 | 2015-06-30 00:00:00 | 2015-09-30 00:00:00 | 2014-12-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2015-06-30 00:00:00 | 1900-01-01 00:00:00 | 2016-12-31 00:00:00 | 2015-09-30 00:00:00 | 2015-12-31 00:00:00 | 1900-01-01 00:00:00 | None | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2016-06-30 00:00:00 | 2016-03-31 00:00:00 | 1900-01-01 00:00:00 | None | None | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2016-09-30 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | None | 2016-12-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2017-06-30 00:00:00 | 2017-03-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | None | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None |
filer_id | 1335818 | 1335818 | 1335818 | 1335818 | ||||
---|---|---|---|---|---|---|---|---|
session_id | 2011 | 2013 | 2017 | 2015 | ||||
interest_cd | 40312 | 40312 | 40304 | 40312 | ||||
effect_date | 2011-01-01 00:00:00 | 2013-01-01 00:00:00 | 2017-01-27 00:00:00 | 2015-01-01 00:00:00 |
filer_id | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | |||||
---|---|---|---|---|---|---|---|---|---|---|
filer_type | 2 | 2 | 2 | 2 | 2 | |||||
active | Y | Y | T | Y | Y | |||||
race | None | 0 | None | None | None | |||||
session_id | 2013 | 2011 | 2017 | 2015 | 2017 | |||||
category | None | 0 | None | None | None | |||||
category_type | None | 0 | None | None | None | |||||
sub_category | None | 0 | None | None | None | |||||
effect_dt | 2013-01-01 00:00:00 | 2011-01-01 00:00:00 | 2017-06-30 00:00:00 | 2015-01-01 00:00:00 | 2017-01-27 00:00:00 | |||||
sub_category_type | None | 0 | None | None | None | |||||
election_type | None | 0 | None | None | None | |||||
sub_category_a | None | None | None | None | None | |||||
nyq_dt | None | None | None | None | None | |||||
party_cd | None | 0 | None | None | None | |||||
county_cd | None | 0 | None | None | None | |||||
district_cd | None | 0 | None | None | None |
filer_id | 1335818 | |
---|---|---|
xref_id | 1335818 | |
effect_dt | 2011-01-27 00:00:00 | |
migration_source | CLAIMS |
xref_filer_id | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_id | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | ||||||||||||||||
filer_type | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | ||||||||||||||||
status | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | ||||||||||||||||
effect_dt | 2017-06-30 00:00:00 | 2017-06-30 00:00:00 | 2017-06-30 00:00:00 | 2017-06-30 00:00:00 | 2017-06-30 00:00:00 | 2017-06-30 00:00:00 | 2017-06-30 00:00:00 | 2017-06-30 00:00:00 | 2017-06-30 00:00:00 | 2017-06-30 00:00:00 | 2017-06-30 00:00:00 | 2017-06-30 00:00:00 | 2017-06-30 00:00:00 | 2017-06-30 00:00:00 | 2017-06-30 00:00:00 | 2017-06-30 00:00:00 | ||||||||||||||||
naml | NUVEEN INVESTMENTS HOLDINGS, INC. | NUVEEN INVESTMENTS HOLDINGS, INC. | NUVEEN INVESTMENTS HOLDINGS, INC. | NUVEEN INVESTMENTS HOLDINGS, INC. | NUVEEN INVESTMENTS HOLDINGS, INC. | NUVEEN INVESTMENTS HOLDINGS, INC. | NUVEEN INVESTMENTS HOLDINGS, INC. | NUVEEN INVESTMENTS HOLDINGS, INC. | NUVEEN INVESTMENTS HOLDINGS, INC. | NUVEEN INVESTMENTS HOLDINGS, INC. | NUVEEN INVESTMENTS HOLDINGS, INC. | NUVEEN INVESTMENTS HOLDINGS, INC. | NUVEEN INVESTMENTS HOLDINGS, INC. | NUVEEN INVESTMENTS HOLDINGS, INC. | NUVEEN INVESTMENTS HOLDINGS, INC. | NUVEEN INVESTMENTS HOLDINGS, INC. | ||||||||||||||||
namf | 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 | ||||||||||||||||
nams | 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 | ||||||||||||||||
adr2 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||
city | CHICAGO | CHICAGO | CHICAGO | CHICAGO | CHICAGO | CHICAGO | CHICAGO | CHICAGO | CHICAGO | CHICAGO | CHICAGO | CHICAGO | CHICAGO | CHICAGO | CHICAGO | CHICAGO | ||||||||||||||||
st | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | ||||||||||||||||
zip4 | 60606 | 60606 | 60606 | 60606 | 60606 | 60606 | 60606 | 60606 | 60606 | 60606 | 60606 | 60606 | 60606 | 60606 | 60606 | 60606 | ||||||||||||||||
phon | 3129177868 | 3129178385 | 3129178385 | 3129178385 | 3129177868 | 3129178385 | 3129178385 | 3129178385 | 3129177868 | 3129178385 | 3129178385 | 3129178385 | 3129177868 | 3129178385 | 3129178385 | 3129178385 | ||||||||||||||||
fax | 3129176912 | 3129176912 | 3129176912 | 3129176912 | 3129176912 | 3129176912 | 3129176912 | 3129176912 | 3129176912 | 3129176912 | 3129176912 | 3129176912 | 3129176912 | 3129176912 | 3129176912 | 3129176912 | ||||||||||||||||
None | None | [email protected] | None | None | None | [email protected] | None | None | None | [email protected] | None | None | None | [email protected] | None |
filer_id | 1335818 |
---|
filer_id | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | 1335818 | ||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
change_no | 2 | 3 | 4 | 5 | 1 | 6 | 7 | 8 | 0 | 10 | 11 | 15 | 9 | 13 | 14 | 12 | 18 | 16 | 17 | 20 | 19 | 21 | 25 | 22 | 23 | 24 | 33 | 34 | 36 | 37 | 29 | 30 | 31 | 27 | 26 | 28 | 32 | 35 | ||||||||||||||||||||||||||||||||||||||
session_id | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2013 | 2011 | 2011 | 2013 | 2013 | 2013 | 2015 | 2015 | 2015 | 2015 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | ||||||||||||||||||||||||||||||||||||||
log_dt | 2011-05-24 00:00:00 | 2011-05-24 00:00:00 | 2011-06-03 00:00:00 | 2011-06-03 00:00:00 | 2011-02-04 00:00:00 | 2011-06-13 00:00:00 | 2011-08-26 00:00:00 | 2011-08-26 00:00:00 | 2011-03-01 00:00:00 | 2011-11-21 00:00:00 | 2011-11-21 00:00:00 | 2012-02-09 00:00:00 | 2011-11-03 00:00:00 | 2011-12-20 00:00:00 | 2011-12-20 00:00:00 | 2011-07-21 00:00:00 | 2013-03-07 00:00:00 | 2012-12-03 00:00:00 | 2012-12-03 00:00:00 | 2014-03-20 00:00:00 | 2013-08-15 00:00:00 | 2013-08-15 00:00:00 | 2015-04-14 00:00:00 | 2015-07-29 00:00:00 | 2015-07-29 00:00:00 | 2015-07-29 00:00:00 | 2017-07-06 00:00:00 | 2017-07-06 00:00:00 | 2017-07-06 00:00:00 | 2017-07-06 00:00:00 | 2017-01-27 00:00:00 | 2017-06-29 00:00:00 | 2017-07-06 00:00:00 | 2017-04-28 00:00:00 | 2017-03-15 00:00:00 | 2017-03-20 00:00:00 | 2017-07-06 00:00:00 | 2017-07-06 00:00:00 | ||||||||||||||||||||||||||||||||||||||
filer_type | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | ||||||||||||||||||||||||||||||||||||||
correction_flg | None | None | Y | Y | None | None | Y | Y | None | Y | Y | Y | None | Y | Y | Y | Y | None | None | Y | None | Y | Y | Y | Y | Y | Y | Y | Y | None | None | Y | Y | Y | Y | Y | Y | Y | ||||||||||||||||||||||||||||||||||||||
action | DELETED | DELETED | ADDED | ADDED | SET ACTIVE | IN SUSPENSE | TERMINATED | TERMINATED | ADDED | TERMINATED | TERMINATED | DELETED | DELETED | TERMINATED | TERMINATED | ADDED | TERMINATED | DELETED | DELETED | TERMINATED | SET ACTIVE | ADDED | ADDED | TERMINATED | TERMINATED | TERMINATED | DELETED | DELETED | DELETED | DELETED | IN SUSPENSE | TERMINATED | DELETED | TERMINATED | DELETED | TERMINATED | DELETED | DELETED | ||||||||||||||||||||||||||||||||||||||
attribute_changed | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | ||||||||||||||||||||||||||||||||||||||
ethics_dt | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||
interests | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||
filer_full_name | NUVEEN INVESTMENTS HOLDINGS, INC. | NUVEEN INVESTMENTS HOLDINGS, INC. | NUVEEN INVESTMENTS HOLDINGS, INC. | NUVEEN INVESTMENTS HOLDINGS, INC. | NUVEEN INVESTMENTS HOLDINGS, INC. | NUVEEN INVESTMENTS HOLDINGS, INC. | NUVEEN INVESTMENTS HOLDINGS, INC. | NUVEEN INVESTMENTS HOLDINGS, INC. | NUVEEN INVESTMENTS HOLDINGS, INC. | NUVEEN INVESTMENTS HOLDINGS, INC. | NUVEEN INVESTMENTS HOLDINGS, INC. | NUVEEN INVESTMENTS HOLDINGS, INC. | NUVEEN INVESTMENTS HOLDINGS, INC. | NUVEEN INVESTMENTS HOLDINGS, INC. | NUVEEN INVESTMENTS HOLDINGS, INC. | NUVEEN INVESTMENTS HOLDINGS, INC. | NUVEEN INVESTMENTS HOLDINGS, INC. | NUVEEN INVESTMENTS HOLDINGS, INC. | NUVEEN INVESTMENTS HOLDINGS, INC. | NUVEEN INVESTMENTS HOLDINGS, INC. | NUVEEN INVESTMENTS HOLDINGS, INC. | NUVEEN INVESTMENTS HOLDINGS, INC. | NUVEEN INVESTMENTS HOLDINGS, INC. | NUVEEN INVESTMENTS HOLDINGS, INC. | NUVEEN INVESTMENTS HOLDINGS, INC. | NUVEEN INVESTMENTS HOLDINGS, INC. | NUVEEN INVESTMENTS HOLDINGS, INC. | NUVEEN INVESTMENTS HOLDINGS, INC. | NUVEEN INVESTMENTS HOLDINGS, INC. | NUVEEN INVESTMENTS HOLDINGS, INC. | NUVEEN INVESTMENTS HOLDINGS, INC. | NUVEEN INVESTMENTS HOLDINGS, INC. | NUVEEN INVESTMENTS HOLDINGS, INC. | NUVEEN INVESTMENTS HOLDINGS, INC. | NUVEEN INVESTMENTS HOLDINGS, INC. | NUVEEN INVESTMENTS HOLDINGS, INC. | NUVEEN INVESTMENTS HOLDINGS, INC. | NUVEEN INVESTMENTS HOLDINGS, INC. | ||||||||||||||||||||||||||||||||||||||
filer_city | None | None | None | None | None | None | None | None | None | None | None | None | None | CHICAGO | CHICAGO | CHICAGO | None | None | None | None | None | CHICAGO | CHICAGO | None | None | None | CHICAGO | CHICAGO | CHICAGO | CHICAGO | None | None | None | None | None | CHICAGO | CHICAGO | CHICAGO | ||||||||||||||||||||||||||||||||||||||
filer_st | None | None | None | None | None | None | None | None | None | None | None | None | None | IL | IL | IL | None | None | None | None | None | IL | IL | None | None | None | IL | IL | IL | IL | None | None | None | None | None | IL | IL | IL | ||||||||||||||||||||||||||||||||||||||
filer_zip | None | None | None | None | None | None | None | None | None | None | None | None | None | 60606 | 60606 | 60606 | None | None | None | None | None | 60606 | 60606 | None | None | None | 60606 | 60606 | 60606 | 60606 | None | None | None | None | None | 60606 | 60606 | 60606 | ||||||||||||||||||||||||||||||||||||||
filer_phone | None | None | None | None | None | None | None | None | None | None | None | None | None | 3129177868 | 3129177868 | 3129177868 | None | None | None | None | None | 3129178385 | 3129178385 | None | None | None | 3129178385 | 3129178385 | 3129178385 | 3129178385 | None | None | None | None | None | 3129178385 | 3129178385 | 3129178385 | ||||||||||||||||||||||||||||||||||||||
entity_type | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | ||||||||||||||||||||||||||||||||||||||
entity_name | WILLIAM F. GILMAN | DAVID M. RENEKER | STANLEY, SCOTT ALAN | ROE, MELISSA BRITTON | DAVID M. RENEKER | LYNNE M. HARRINGTON | BARREN, CHRISTINA R. | SORAPARU, ROBERT S. | GEORGE D. BERRIDGE | POSEY, MARY A. | SIMMONS, JOHN C. | PEDERSEN, LEAH | JASON D. CULVER | BARLUP, SARAH | WEBB, GEORGE | KING, CHERYL | SUFI, RANJIT | ANTHONY MAYORKAS | ERIN J. KENNEDY | DRAPER, SCOTT | SCOTT STANLEY | HARRISON, CHRISTOPHER | LAZARUS, BENJAMIN S. | DOROFF, CLINT | HARRINGTON, LYNNE | STANLEY, SCOTT | SPRINGER, JEFFREY | SHERIDAN, EDWARD | ANDERSON, MEGAN | MC KILLIN, ANGELA | GRUHL, LINDSAY | LEWIS, SARAH | POPKIN, ANNE | ANATHAN, ELIZABETH | FRIEDRICH, MARK | HARRISON, CHRISTOPHER | MC KILLIN, ANGELA | GRUHL, LINDSAY | ||||||||||||||||||||||||||||||||||||||
entity_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 | ||||||||||||||||||||||||||||||||||||||
entity_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 | ||||||||||||||||||||||||||||||||||||||
entity_zip | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||
entity_phone | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||
entity_id | 1335826 | 1336501 | 1338711 | 1338710 | 1336501 | 1339472 | 1335821 | 1335843 | 1337577 | 1335840 | 1335842 | 1335838 | 1335822 | None | None | None | 1335844 | 1339097 | 1335829 | 1335825 | 1338711 | None | None | 1339471 | 1339472 | 1338711 | None | None | None | None | 1335827 | 1335831 | 1335839 | 1385349 | 1394257 | None | None | None | ||||||||||||||||||||||||||||||||||||||
responsible_officer | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||
effect_dt | 2011-05-02 00:00:00 | 2011-05-02 00:00:00 | 2011-04-07 00:00:00 | 2011-04-08 00:00:00 | 2011-01-20 00:00:00 | 2011-06-06 00:00:00 | 2011-08-10 00:00:00 | 2011-08-10 00:00:00 | 2011-02-25 00:00:00 | 2011-11-11 00:00:00 | 2011-11-11 00:00:00 | 2012-01-24 00:00:00 | 2011-10-01 00:00:00 | 2011-12-08 00:00:00 | 2011-12-02 00:00:00 | 2011-07-20 00:00:00 | 2013-02-28 00:00:00 | 2012-10-30 00:00:00 | 2012-08-31 00:00:00 | 2014-03-14 00:00:00 | 2013-01-01 00:00:00 | 2013-04-01 00:00:00 | 2015-03-30 00:00:00 | 2015-06-30 00:00:00 | 2015-06-30 00:00:00 | 2015-06-30 00:00:00 | 2017-06-30 00:00:00 | 2017-06-30 00:00:00 | 2017-06-30 00:00:00 | 2017-06-30 00:00:00 | 2017-07-01 00:00:00 | 2017-06-16 00:00:00 | 2017-06-30 00:00:00 | 2017-04-24 00:00:00 | 2017-03-14 00:00:00 | 2017-03-10 00:00:00 | 2017-06-30 00:00:00 | 2017-06-30 00:00:00 |