filer_id | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
adrid | 1113204 | 1111307 | 2041958 | 2078833 | 2115056 | 2164683 | 2206789 | 2417107 | 2549103 | 2278755 | 2338140 | 2506888 | 2467971 | |||||||||||||
effect_dt | 1997-01-01 00:00:00 | 1999-01-01 00:00:00 | 2003-01-01 00:00:00 | 2005-01-01 00:00:00 | 2007-01-01 00:00:00 | 2009-01-01 00:00:00 | 2011-02-03 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 | 7050 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | |||||||||||||
session_id | 1997 | 1999 | 2003 | 2005 | 2007 | 2009 | 2011 | 2017 | 2023 | 2013 | 2015 | 2021 | 2019 |
filer_id | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 482400 | 480283 | 474700 | 471288 | 489676 | 485988 | 497002 | 541372 | 466036 | 476844 | 489676 | 482400 | 540389 | 631618 | 614326 | 652358 | 695807 | 704559 | 708410 | 753038 | 736503 | 779411 | 770392 | 780245 | 790216 | 796539 | 812896 | 838382 | 818727 | 861470 | 842578 | 852194 | 891808 | 906665 | 897526 | 906993 | 883169 | 898608 | 931048 | 942872 | 942872 | 944428 | 931048 | 949113 | 935228 | 989236 | 968911 | 974938 | 1013313 | 1002664 | 1025039 | 1022828 | 1019915 | 1068395 | 1056191 | 1064114 | 1081107 | 1090945 | 1092623 | 1145310 | 1115106 | 1103635 | 1131323 | 1166114 | 1187821 | 1231937 | 1213373 | 1223399 | 1259556 | 1232547 | 1282782 | 1777734 | 1867876 | 1839841 | 1810663 | 1795374 | 1960167 | 1944241 | 1910021 | 1311279 | 1329231 | 1347843 | 1378276 | 1383864 | 1392795 | 1419293 | 1411915 | 1406663 | 1429923 | 1449121 | 1460495 | 1431599 | 1482319 | 1504517 | 1537572 | 1569011 | 1575865 | 1580026 | 1596501 | 1603478 | 1603478 | 1586868 | 1603478 | 1633230 | 1653264 | 1620542 | 1674947 | 1924477 | 1926335 | 1705412 | 1743352 | 1735096 | 1763244 | 1296436 | 1977694 | 1995366 | 2339060 | 2377913 | 2333947 | 2483646 | 2433313 | 2316932 | 2005535 | 2031357 | 2056201 | 2084358 | 2084300 | 2083943 | 2096383 | 2116814 | 2120575 | 2096383 | 2152294 | 2134214 | 2166213 | 2235005 | 2524845 | 2483646 | 2467870 | 2576816 | 2191911 | 2545783 | 2467870 | 2337049 | 2416946 | 2391848 | 2268286 | 2203834 | 2577785 | 2576767 | 2595706 | 2617303 | 2698871 | 2637270 | 2667917 | 2739672 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
period_id | 152 | 159 | 158 | 150 | 154 | 153 | 156 | 155 | 149 | 151 | 154 | 152 | 157 | None | 160 | 162 | 163 | 165 | None | 165 | 164 | None | 165 | None | 167 | None | 168 | 169 | None | None | None | 170 | None | None | None | 172 | 171 | 172 | 173 | 174 | 174 | 174 | 173 | None | None | 176 | 175 | None | 177 | None | None | 178 | None | 180 | 179 | None | 180 | None | None | 184 | 182 | 181 | 183 | 185 | 186 | 188 | 187 | 188 | 189 | None | 190 | 214 | 218 | 217 | 216 | 215 | 221 | None | 219 | 192 | 193 | 194 | 195 | 196 | 196 | 197 | None | 197 | None | 199 | 200 | 198 | 201 | 202 | 203 | 204 | None | 205 | None | 206 | 206 | 205 | 206 | 208 | 209 | 207 | 210 | 221 | 220 | 211 | None | 212 | 213 | 191 | 222 | 223 | None | 237 | 237 | 242 | 240 | 235 | 224 | 225 | 226 | None | None | 227 | 227 | 229 | 228 | 227 | 229 | None | 230 | 233 | 243 | 242 | 241 | 246 | 231 | 244 | 241 | 236 | 239 | 238 | 234 | 232 | 245 | None | 246 | 247 | 250 | 248 | 249 | 251 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F690 | F690 | F635 | F635 | F635 | F635 | F635 | F602 | F602 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F602 | F602 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F602 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F605 | F602 | F635 | F602 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_sequence | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 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 | 2 | 1 | 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 | 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_date | 1998-01-30 00:00:00 | 1999-10-29 00:00:00 | 1999-07-28 00:00:00 | 1997-07-31 00:00:00 | 1998-07-30 00:00:00 | 1998-04-30 00:00:00 | 1999-02-01 00:00:00 | 1998-11-02 00:00:00 | 1997-04-29 00:00:00 | 1997-10-31 00:00:00 | 1998-10-19 00:00:00 | 1998-02-02 00:00:00 | 1999-04-30 00:00:00 | 2000-05-01 00:00:00 | 2000-01-28 00:00:00 | 2000-07-25 00:00:00 | 2000-10-30 00:00:00 | 2001-01-02 00:00:00 | 2001-01-02 00:00:00 | 2001-04-27 00:00:00 | 2001-01-30 00:00:00 | 2001-07-31 00:00:00 | 2001-04-27 00:00:00 | 2001-09-06 00:00:00 | 2001-10-29 00:00:00 | 2001-10-24 00:00:00 | 2002-01-30 00:00:00 | 2002-04-29 00:00:00 | 2002-01-28 00:00:00 | 2002-07-22 00:00:00 | 2002-04-29 00:00:00 | 2002-07-26 00:00:00 | 2002-10-28 00:00:00 | 2003-01-27 00:00:00 | 2002-12-19 00:00:00 | 2003-01-27 00:00:00 | 2002-10-30 00:00:00 | 2002-12-30 00:00:00 | 2003-04-30 00:00:00 | 2003-07-29 00:00:00 | 2003-07-18 00:00:00 | 2003-07-18 00:00:00 | 2003-04-30 00:00:00 | 2003-01-27 00:00:00 | 2003-04-30 00:00:00 | 2004-01-30 00:00:00 | 2003-10-30 00:00:00 | 2003-10-31 00:00:00 | 2004-04-29 00:00:00 | 2004-01-30 00:00:00 | 2004-07-16 00:00:00 | 2004-07-14 00:00:00 | 2004-04-29 00:00:00 | 2004-12-29 00:00:00 | 2004-10-28 00:00:00 | 2004-10-28 00:00:00 | 2005-01-31 00:00:00 | 2004-12-27 00:00:00 | 2005-01-31 00:00:00 | 2006-01-27 00:00:00 | 2005-07-27 00:00:00 | 2005-04-28 00:00:00 | 2005-10-27 00:00:00 | 2006-04-28 00:00:00 | 2006-07-26 00:00:00 | 2007-01-26 00:00:00 | 2006-10-27 00:00:00 | 2006-12-13 00:00:00 | 2007-04-25 00:00:00 | 2007-01-02 00:00:00 | 2007-07-30 00:00:00 | 2013-07-24 00:00:00 | 2014-07-28 00:00:00 | 2014-04-21 00:00:00 | 2014-01-17 00:00:00 | 2013-10-17 00:00:00 | 2015-04-21 00:00:00 | 2015-01-09 00:00:00 | 2014-10-30 00:00:00 | 2008-01-31 00:00:00 | 2008-04-30 00:00:00 | 2008-07-29 00:00:00 | 2008-10-31 00:00:00 | 2008-12-16 00:00:00 | 2009-01-27 00:00:00 | 2009-04-28 00:00:00 | 2008-12-19 00:00:00 | 2009-03-11 00:00:00 | 2009-03-09 00:00:00 | 2009-10-22 00:00:00 | 2010-01-26 00:00:00 | 2009-07-17 00:00:00 | 2010-04-26 00:00:00 | 2010-07-28 00:00:00 | 2010-10-28 00:00:00 | 2011-01-28 00:00:00 | 2011-02-03 00:00:00 | 2011-03-01 00:00:00 | 2011-05-16 00:00:00 | 2011-09-28 00:00:00 | 2011-09-28 00:00:00 | 2011-04-19 00:00:00 | 2011-07-26 00:00:00 | 2012-01-27 00:00:00 | 2012-04-20 00:00:00 | 2011-10-27 00:00:00 | 2012-07-26 00:00:00 | 2015-01-09 00:00:00 | 2015-01-16 00:00:00 | 2012-10-26 00:00:00 | 2013-01-15 00:00:00 | 2013-01-29 00:00:00 | 2013-04-29 00:00:00 | 2007-10-30 00:00:00 | 2015-07-27 00:00:00 | 2015-10-28 00:00:00 | 2018-12-19 00:00:00 | 2019-04-26 00:00:00 | 2019-01-11 00:00:00 | 2020-09-21 00:00:00 | 2020-01-22 00:00:00 | 2018-10-30 00:00:00 | 2016-01-22 00:00:00 | 2016-04-22 00:00:00 | 2016-07-19 00:00:00 | 2016-09-30 00:00:00 | 2016-09-30 00:00:00 | 2016-09-30 00:00:00 | 2016-10-26 00:00:00 | 2017-01-03 00:00:00 | 2017-01-18 00:00:00 | 2016-12-13 00:00:00 | 2017-04-21 00:00:00 | 2017-01-09 00:00:00 | 2017-07-10 00:00:00 | 2018-04-24 00:00:00 | 2020-10-28 00:00:00 | 2020-07-30 00:00:00 | 2020-04-27 00:00:00 | 2021-04-26 00:00:00 | 2017-10-30 00:00:00 | 2021-01-22 00:00:00 | 2020-09-21 00:00:00 | 2019-01-22 00:00:00 | 2019-10-29 00:00:00 | 2019-07-22 00:00:00 | 2018-07-24 00:00:00 | 2018-01-22 00:00:00 | 2021-04-27 00:00:00 | 2021-01-04 00:00:00 | 2021-07-22 00:00:00 | 2021-10-20 00:00:00 | 2022-07-18 00:00:00 | 2022-01-25 00:00:00 | 2022-04-20 00:00:00 | 2022-10-24 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_type | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10005 | 10005 | 10005 | 10001 | 10005 | 10005 | 10005 | 10005 | 10001 | 10005 | 10001 | 10005 | 10001 | 10001 | 10005 | 10005 | 10005 | 10001 | 10005 | 10005 | 10005 | 10001 | 10001 | 10001 | 10002 | 10002 | 10001 | 10005 | 10001 | 10005 | 10005 | 10001 | 10001 | 10005 | 10001 | 10005 | 10005 | 10001 | 10005 | 10001 | 10001 | 10005 | 10001 | 10005 | 10005 | 10001 | 10001 | 10001 | 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 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10005 | 10002 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10005 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_status | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11001 | 11003 | 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 | 11003 | 11001 | 11001 | 11001 | 11003 | 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 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
session_id | 1997 | 1999 | 1999 | 1997 | 1997 | 1997 | 1997 | 1997 | 1997 | 1997 | 1997 | 1997 | 1999 | 1999 | 1999 | 1999 | 1999 | 2001 | 2001 | 2001 | 1999 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2003 | 2001 | 2001 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2001 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2005 | 2003 | 2003 | 2003 | 2005 | 2003 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2007 | 2007 | 2007 | 2007 | 2013 | 2013 | 2013 | 2013 | 2013 | 2015 | 2015 | 2013 | 2007 | 2007 | 2007 | 2007 | 2009 | 2007 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2015 | 2013 | 2011 | 2013 | 2011 | 2013 | 2007 | 2015 | 2015 | 2019 | 2019 | 2019 | 2019 | 2019 | 2017 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2017 | 2015 | 2015 | 2017 | 2017 | 2017 | 2017 | 2019 | 2019 | 2019 | 2021 | 2017 | 2019 | 2019 | 2017 | 2019 | 2019 | 2017 | 2017 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
user_id | * | * | * | * | * | * | * | * | * | * | * | * | * | GGILMORE | * | YBONILLA | YBONILLA | * | YBONILLA | GGILMORE | YBONILLA | LTHIBAUL | MKIENG | GPEREZ | * | LTHIBAUL | * | * | LTHIBAUL | LTHIBAUL | LTHIBAUL | * | LTHIBAUL | MHOANG | SARRIAGA | COMPLETED | * | COMPLETED | COMPLETED | COMPLETED | COMPLETED | LTHIBAUL | COMPLETED | LTHIBAUL | LTHIBAUL | COMPLETED | COMPLETED | LTHIBAUL | COMPLETED | LTHIBAUL | LTHIBAUL | COMPLETED | LTHIBAUL | COMPLETED | COMPLETED | LTHIBAUL | COMPLETED | SARRIAGA | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | * | LTHIBAUL | GPEREZ | YRODRIGU | ASAETERN | AGLADNEY | ASAETERN | ASAETERN | AGLADNEY | AGLADNEY | YRODRIGU | ASAETERN | LTHIBAUL | RGEREMIA | LTHIBAUL | MGUERRA | * | MGUERRA | MGUERRA | DMCCASTL | * | YRODRIGU | MGUERRA | MGUERRA | MGUERRA | ASAETERN | ASAETERN | ASAETERN | AGLADNEY | SARRIAGA | YRODRIGU | ASAETERN | ASAETERN | ASAETERN | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | YRODRIGU | ASAETERN | AGLADNEY | GKURIMOT | AGLADNEY | ASAETERN | YRODRIGU | AGLADNEY | JINGRAM | DMCCASTL | SUSHAKOV | CAFILER | GTAYLOR | GTAYLOR | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | GPEREZ | GPEREZ | CAFILER | AGLADNEY | YRODRIGU | AGLADNEY | AGLADNEY | AGLADNEY | YRODRIGU | AGLADNEY | AGLADNEY | GTAYLOR | MKIRKHAM | VUKSTINA | CAFILER | AGLADNEY | GTAYLOR | GTAYLOR | AGLADNEY | VUKSTINA | SUSHAKOV | AGLADNEY | AGLADNEY | CHATRIDGE | MKIRKHAM | GTAYLOR | GTAYLOR | CAFILER | CHATRIDGE | CAFILER | CAFILER | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
special_audit | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11002 | 11002 | 11002 | 11003 | 11002 | 11002 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fine_audit | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 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 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_start | 1997-10-01 00:00:00 | 1999-07-01 00:00:00 | 1999-04-01 00:00:00 | 1997-04-01 00:00:00 | 1998-04-01 00:00:00 | 1998-01-01 00:00:00 | 1998-10-01 00:00:00 | 1998-07-01 00:00:00 | 1997-01-01 00:00:00 | 1997-07-01 00:00:00 | 1998-04-01 00:00:00 | 1997-10-01 00:00:00 | 1999-01-01 00:00:00 | 2000-01-01 00:00:00 | 1999-10-01 00:00:00 | 2000-04-01 00:00:00 | 2000-07-01 00:00:00 | 2001-01-02 00:00:00 | 1900-01-01 00:00:00 | 2001-01-01 00:00:00 | 2000-10-01 00:00:00 | 2001-04-01 00:00:00 | None | 1900-01-01 00:00:00 | 2001-07-01 00:00:00 | 2001-07-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-01-01 00:00:00 | 2002-04-01 00:00:00 | 2002-07-01 00:00:00 | 2002-10-01 00:00:00 | 1900-01-01 00:00:00 | 2002-10-01 00:00:00 | 2002-07-01 00:00:00 | 2002-12-30 00:00:00 | 2003-01-01 00:00:00 | 2003-04-01 00:00:00 | 2003-04-01 00:00:00 | 2003-04-01 00:00:00 | 2003-01-01 00:00:00 | 2002-10-01 00:00:00 | 2003-01-01 00:00:00 | 2003-10-01 00:00:00 | 2003-07-01 00:00:00 | 2003-07-01 00:00:00 | 2004-01-01 00:00:00 | 2003-10-01 00:00:00 | 2004-04-01 00:00:00 | 2004-04-01 00:00:00 | 2004-01-01 00:00:00 | 2004-12-29 00:00:00 | 2004-07-01 00:00:00 | 2004-07-01 00:00:00 | 2004-10-01 00:00:00 | 1900-01-01 00:00:00 | 2004-10-01 00:00:00 | 2005-10-01 00:00:00 | 2005-04-01 00:00:00 | 2005-01-01 00:00:00 | 2005-07-01 00:00:00 | 2006-01-01 00:00:00 | 2006-04-01 00:00:00 | 2006-10-01 00:00:00 | 2006-07-01 00:00:00 | 2006-12-13 00:00:00 | 2007-01-01 00:00:00 | 1900-01-01 00:00:00 | 2007-04-01 00:00:00 | 2013-04-01 00:00:00 | 2014-04-01 00:00:00 | 2014-01-01 00:00:00 | 2013-10-01 00:00:00 | 2013-07-01 00:00:00 | 2015-01-01 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 | 2008-12-16 00:00:00 | 2008-10-01 00:00:00 | 2009-01-01 00:00:00 | 1900-01-01 00:00:00 | 2009-03-11 00:00:00 | 1900-01-01 00:00:00 | 2009-07-01 00:00:00 | 2009-10-01 00:00:00 | 2009-04-01 00:00:00 | 2010-01-01 00:00:00 | 2010-04-01 00:00:00 | 2010-07-01 00:00:00 | 2010-10-01 00:00:00 | 1900-01-01 00:00:00 | 2011-03-01 00:00:00 | 1900-01-01 00:00:00 | 2011-04-01 00:00:00 | 2011-04-01 00:00:00 | 2011-01-01 00:00:00 | 2011-04-01 00:00:00 | 2011-10-01 00:00:00 | 2012-01-01 00:00:00 | 2011-07-01 00:00:00 | 2012-04-01 00:00:00 | 2015-01-09 00:00:00 | 2014-10-01 00:00:00 | 2012-07-01 00:00:00 | 1900-01-01 00:00:00 | 2012-10-01 00:00:00 | 2013-01-01 00:00:00 | 2007-07-01 00:00:00 | 2015-04-01 00:00:00 | 2015-07-01 00:00:00 | 1900-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-11 00:00:00 | 2020-04-01 00:00:00 | 2019-10-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 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2016-09-30 00:00:00 | 2016-07-01 00:00:00 | 2017-01-03 00:00:00 | 2016-10-01 00:00:00 | 2016-07-01 00:00:00 | 2017-01-01 00:00:00 | 1900-01-01 00:00:00 | 2017-04-01 00:00:00 | 2018-01-01 00:00:00 | 2020-07-01 00:00:00 | 2020-04-01 00:00:00 | 2020-01-01 00:00:00 | 2021-04-26 00:00:00 | 2017-07-01 00:00:00 | 2020-10-01 00:00:00 | 2020-01-01 00:00:00 | 2018-10-01 00:00:00 | 2019-07-01 00:00:00 | 2019-04-01 00:00:00 | 2018-04-01 00:00:00 | 2017-10-01 00:00:00 | 2021-01-01 00:00:00 | 1900-01-01 00:00:00 | 2021-04-01 00:00:00 | 2021-07-01 00:00:00 | 2022-04-01 00:00:00 | 2021-10-01 00:00:00 | 2022-01-01 00:00:00 | 2022-07-01 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_end | 1997-12-31 00:00:00 | 1999-09-30 00:00:00 | 1999-06-30 00:00:00 | 1997-06-30 00:00:00 | 1998-06-30 00:00:00 | 1998-03-31 00:00:00 | 1998-12-31 00:00:00 | 1998-09-30 00:00:00 | 1997-03-31 00:00:00 | 1997-09-30 00:00:00 | 1998-06-30 00:00:00 | 1997-12-31 00:00:00 | 1999-03-31 00:00:00 | 2000-03-31 00:00:00 | 1999-12-31 00:00:00 | 2000-06-30 00:00:00 | 2000-09-30 00:00:00 | 2001-01-02 00:00:00 | 1900-01-01 00:00:00 | 2001-03-31 00:00:00 | 2000-12-31 00:00:00 | 2001-06-30 00:00:00 | None | 1900-01-01 00:00:00 | 2001-09-30 00:00:00 | 2001-09-30 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-03-31 00:00:00 | 2002-06-30 00:00:00 | 2002-09-30 00:00:00 | 2001-01-01 00:00:00 | 1900-01-01 00:00:00 | 2002-12-31 00:00:00 | 2002-09-30 00:00:00 | 2002-12-30 00:00:00 | 2003-03-31 00:00:00 | 2003-06-30 00:00:00 | 2003-06-30 00:00:00 | 2003-06-30 00:00:00 | 2003-03-31 00:00:00 | 2002-12-31 00:00:00 | 2003-03-31 00:00:00 | 2003-12-31 00:00:00 | 2003-09-30 00:00:00 | 2003-09-30 00:00:00 | 2004-03-31 00:00:00 | 2003-12-31 00:00:00 | 2004-06-30 00:00:00 | 2004-06-30 00:00:00 | 2004-01-31 00:00:00 | 2004-12-29 00:00:00 | 2004-09-30 00:00:00 | 2004-09-30 00:00:00 | 2004-12-31 00:00:00 | 1900-01-01 00:00:00 | 2004-12-31 00:00:00 | 2005-12-31 00:00:00 | 2005-06-30 00:00:00 | 2005-03-31 00:00:00 | 2005-09-30 00:00:00 | 2006-03-31 00:00:00 | 2006-06-30 00:00:00 | 2006-12-31 00:00:00 | 2006-09-30 00:00:00 | 2006-12-13 00:00:00 | 2007-03-31 00:00:00 | 1900-01-01 00:00:00 | 2007-06-30 00:00:00 | 2013-06-30 00:00:00 | 2014-06-30 00:00:00 | 2014-03-31 00:00:00 | 2013-12-31 00:00:00 | 2013-09-30 00:00:00 | 2015-03-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 | 2008-12-16 00:00:00 | 2008-12-31 00:00:00 | 2009-03-31 00:00:00 | 1900-01-01 00:00:00 | 2009-03-11 00:00:00 | 1900-01-01 00:00:00 | 2009-09-30 00:00:00 | 2009-12-31 00:00:00 | 2009-06-30 00:00:00 | 2010-03-31 00:00:00 | 2010-06-30 00:00:00 | 2010-09-30 00:00:00 | 2010-12-31 00:00:00 | 1900-01-01 00:00:00 | 2011-03-01 00:00:00 | 1900-01-01 00:00:00 | 2011-06-30 00:00:00 | 2011-06-30 00:00:00 | 2011-03-31 00:00:00 | 2011-06-30 00:00:00 | 2011-12-31 00:00:00 | 2012-03-31 00:00:00 | 2011-09-30 00:00:00 | 2012-06-30 00:00:00 | 2015-01-09 00:00:00 | 2014-12-31 00:00:00 | 2012-09-30 00:00:00 | 1900-01-01 00:00:00 | 2012-12-31 00:00:00 | 2013-03-31 00:00:00 | 2007-09-30 00:00:00 | 2015-06-30 00:00:00 | 2015-09-30 00:00:00 | 1900-01-01 00:00:00 | 2019-03-31 00:00:00 | 2019-01-11 00:00:00 | 2020-06-30 00:00:00 | 2019-12-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 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2016-09-30 00:00:00 | 2016-09-30 00:00:00 | 2017-01-03 00:00:00 | 2016-12-31 00:00:00 | 2016-09-30 00:00:00 | 2017-03-31 00:00:00 | 1900-01-01 00:00:00 | 2017-06-30 00:00:00 | 2018-03-31 00:00:00 | 2020-09-30 00:00:00 | 2020-06-30 00:00:00 | 2020-03-31 00:00:00 | 2021-04-26 00:00:00 | 2017-09-30 00:00:00 | 2020-12-31 00:00:00 | 2020-03-31 00:00:00 | 2018-12-31 00:00:00 | 2019-09-30 00:00:00 | 2019-06-30 00:00:00 | 2018-06-30 00:00:00 | 2017-12-31 00:00:00 | 2021-03-31 00:00:00 | 1900-01-01 00:00:00 | 2021-06-30 00:00:00 | 2021-09-30 00:00:00 | 2022-06-30 00:00:00 | 2021-12-31 00:00:00 | 2022-03-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 | None | 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 | 22001 | None | None | 22006 | 22006 | 22006 | None | 22006 | None | None | 22006 | 22006 | None | 22006 | None | None | 22006 | None | 22001 | 22006 | None | 22006 | None | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22001 | None | 22001 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22001 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 |
filer_id | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
session_id | 1999 | 1997 | 2001 | 2003 | 2017 | 2011 | 2005 | 2013 | 2009 | 2007 | 2019 | 2015 | 2015 | 2023 | 2021 | |||||||||||||||
interest_cd | 40304 | 40304 | 40304 | 40304 | 40304 | 40304 | 40304 | 40304 | 40304 | 40304 | 40304 | 40315 | 40304 | 40315 | 40315 | |||||||||||||||
effect_date | 1999-01-01 00:00:00 | 1997-01-01 00:00:00 | 2001-01-01 00:00:00 | 2003-01-01 00:00:00 | 2017-01-01 00:00:00 | 2011-02-03 00:00:00 | 2005-01-01 00:00:00 | 2013-01-01 00:00:00 | 2009-01-01 00:00:00 | 2007-01-01 00:00:00 | 2019-01-01 00:00:00 | 2015-01-01 00:00:00 | 2016-10-01 00:00:00 | 2023-01-01 00:00:00 | 2021-01-01 00:00:00 |
filer_id | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_type | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | ||||||||||||||||
active | Y | Y | Y | Y | Y | Y | Y | T | Y | Y | Y | Y | Y | Y | Y | N | ||||||||||||||||
race | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||
session_id | 1997 | 1999 | 2001 | 2003 | 2005 | 2013 | 2007 | 2009 | 2009 | 2011 | 2009 | 2017 | 2019 | 2015 | 2021 | 2023 | ||||||||||||||||
category | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||
category_type | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||
sub_category | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||
effect_dt | 1997-01-01 00:00:00 | 1999-01-01 00:00:00 | 2001-01-01 00:00:00 | 2003-01-01 00:00:00 | 2005-01-01 00:00:00 | 2013-01-01 00:00:00 | 2007-01-01 00:00:00 | 2009-03-06 00:00:00 | 2009-01-01 00:00:00 | 2011-02-03 00:00:00 | 2009-03-09 00:00:00 | 2017-01-01 00:00:00 | 2019-01-01 00:00:00 | 2015-01-01 00:00:00 | 2021-01-01 00:00:00 | 2023-01-01 00:00:00 | ||||||||||||||||
sub_category_type | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||
election_type | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||
sub_category_a | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||
nyq_dt | None | None | None | None | 2001-01-02 00:00:00 | None | 2001-01-02 00:00:00 | None | None | None | None | None | None | None | None | None | ||||||||||||||||
party_cd | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||
county_cd | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||
district_cd | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None |
filer_id | 1145653 | |
---|---|---|
xref_id | C27164 | |
effect_dt | 1999-12-08 00:00:00 | |
migration_source | MASTER |
xref_filer_id | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | C27164 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_id | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filer_type | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
status | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
effect_dt | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
naml | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
namf | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
namt | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
nams | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
adr1 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
adr2 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
city | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
st | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
zip4 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | 20005 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
phon | 2023265800 | 2023265800 | 2023265800 | 2123265800 | 2123265800 | 2023265825 | 2023265825 | 2023265825 | 2023265825 | 2023265825 | 2023265825 | 2023265825 | 2023265825 | 2023265800 | 2023265800 | 2023265800 | 2123265800 | 2123265800 | 2023265825 | 2023265825 | 2023265825 | 2023265825 | 2023265825 | 2023265825 | 2023265825 | 2023265825 | 2023265800 | 2023265800 | 2023265800 | 2123265800 | 2123265800 | 2023265825 | 2023265825 | 2023265825 | 2023265825 | 2023265825 | 2023265825 | 2023265825 | 2023265825 | 2023265800 | 2023265800 | 2023265800 | 2123265800 | 2123265800 | 2023265825 | 2023265825 | 2023265825 | 2023265825 | 2023265825 | 2023265825 | 2023265825 | 2023265825 | 2023265800 | 2023265800 | 2023265800 | 2123265800 | 2123265800 | 2023265825 | 2023265825 | 2023265825 | 2023265825 | 2023265825 | 2023265825 | 2023265825 | 2023265825 | 2023265800 | 2023265800 | 2023265800 | 2123265800 | 2123265800 | 2023265825 | 2023265825 | 2023265825 | 2023265825 | 2023265825 | 2023265825 | 2023265825 | 2023265825 | 2023265800 | 2023265800 | 2023265800 | 2123265800 | 2123265800 | 2023265825 | 2023265825 | 2023265825 | 2023265825 | 2023265825 | 2023265825 | 2023265825 | 2023265825 | 2023265800 | 2023265800 | 2023265800 | 2123265800 | 2123265800 | 2023265825 | 2023265825 | 2023265825 | 2023265825 | 2023265825 | 2023265825 | 2023265825 | 2023265825 | 2023265800 | 2023265800 | 2023265800 | 2123265800 | 2123265800 | 2023265825 | 2023265825 | 2023265825 | 2023265825 | 2023265825 | 2023265825 | 2023265825 | 2023265825 | 2023265800 | 2023265800 | 2023265800 | 2123265800 | 2123265800 | 2023265825 | 2023265825 | 2023265825 | 2023265825 | 2023265825 | 2023265825 | 2023265825 | 2023265825 | 2023265800 | 2023265800 | 2023265800 | 2123265800 | 2123265800 | 2023265825 | 2023265825 | 2023265825 | 2023265825 | 2023265825 | 2023265825 | 2023265825 | 2023265825 | 2023265800 | 2023265800 | 2023265800 | 2123265800 | 2123265800 | 2023265825 | 2023265825 | 2023265825 | 2023265825 | 2023265825 | 2023265825 | 2023265825 | 2023265825 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fax | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | 1145653 |
---|
filer_id | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | |||||
---|---|---|---|---|---|---|---|---|---|---|
change_no | 0 | 2 | 1 | 3 | 4 | |||||
session_id | 2001 | 2009 | 2009 | 2011 | 2015 | |||||
log_dt | 2001-09-06 00:00:00 | 2009-03-09 00:00:00 | 2009-03-17 00:00:00 | 2012-01-03 00:00:00 | 2016-09-30 00:00:00 | |||||
filer_type | 1 | 1 | 1 | 1 | 1 | |||||
correction_flg | Y | Y | Y | Y | None | |||||
action | ADDED | ADDED | DELETED | DELETED | DELETED | |||||
attribute_changed | EMPLOYER | FIRM | FIRM | FIRM | FIRM | |||||
ethics_dt | None | None | None | None | None | |||||
interests | None | None | None | None | None | |||||
filer_full_name | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | INVESTMENT COMPANY INSTITUTE | |||||
filer_city | None | WASHINGTON | None | None | None | |||||
filer_st | None | DC | None | None | None | |||||
filer_zip | None | 20005 | None | None | None | |||||
filer_phone | None | 2023265800 | None | None | None | |||||
entity_type | 2 | 3 | 3 | 3 | 3 | |||||
entity_name | ALBERS & COMPANY | ADVOATION, INC. | ORRICK, HERRINGTON & SUTCLIFFE, LLP | COHN & BARR | ADVOCATION STRATEGIES, INC. | |||||
entity_city | None | None | None | None | None | |||||
entity_st | None | None | None | None | None | |||||
entity_zip | None | None | None | None | None | |||||
entity_phone | None | None | None | None | None | |||||
entity_id | 1147761 | None | 1147260 | 1339144 | 1355325 | |||||
responsible_officer | None | None | None | None | None | |||||
effect_dt | 2001-09-05 00:00:00 | 2009-03-09 00:00:00 | 2009-03-06 00:00:00 | 2011-12-30 00:00:00 | 2016-09-30 00:00:00 |
filer_id | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | 1145653 | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_file_name | 704559_0.cal | 42594.cal | 42653.cal | 790216_0.cal | 812896_0.cal | 838382_0.cal | 852194_0.cal | 883169_0.cal | 898608_0.cal | 906993_0.cal | 931048_1.cal | 942872_0.cal | 931048_0.cal | 942872_1.cal | 968911_0.cal | 1068395_0.cal | 1406663_0.cal | 1419293_0.cal | ||||||||||||||||||
received_date | 2001-01-02 00:00:00 | 2001-10-29 00:00:00 | 2001-10-29 00:00:00 | 2001-10-29 00:00:00 | 2002-01-30 00:00:00 | 2002-04-29 00:00:00 | 2002-07-26 00:00:00 | 2002-10-30 00:00:00 | 2002-12-30 00:00:00 | 2003-01-27 00:00:00 | 2003-04-30 00:00:00 | 2003-07-18 00:00:00 | 2003-04-30 00:00:00 | 2003-07-29 00:00:00 | 2003-10-30 00:00:00 | 2004-12-29 00:00:00 | 2009-03-11 00:00:00 | 2009-04-28 00:00:00 | ||||||||||||||||||
filing_directory | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/temp | /usr/users/cafiler/disclose/ca99/temp | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | ||||||||||||||||||
filing_id | 704559 | None | None | 790216 | 812896 | 838382 | 852194 | 883169 | 898608 | 906993 | 931048 | 942872 | 931048 | 942872 | 968911 | 1068395 | 1406663 | 1419293 | ||||||||||||||||||
form_id | F602 | None | None | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F602 | F635 | ||||||||||||||||||
receive_comment | Filing accepted | Filing did not pass validation | Filing did not pass validation | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted, but with warnings | Filing accepted | Filing accepted, but with warnings | Filing accepted, but with warnings | Filing accepted, but with warnings | Filing accepted, but with warnings | Filing accepted, but with warnings | Filing accepted | Filing accepted | Filing accepted |