filer_id | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
adrid | 1110180 | 1110744 | 2164870 | 2137134 | 2207034 | 2417574 | 2508602 | 2276211 | 2547375 | 2339716 | 2468243 | |||||||||||
effect_dt | 1999-01-01 00:00:00 | 1997-04-01 00:00:00 | 2009-01-01 00:00:00 | 2008-03-16 00:00:00 | 2011-01-01 00:00:00 | 2017-03-01 00:00:00 | 2021-01-01 00:00:00 | 2013-01-01 00:00:00 | 2023-01-01 00:00:00 | 2015-01-01 00:00:00 | 2019-01-01 00:00:00 | |||||||||||
add_type | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | |||||||||||
session_id | 1999 | 1997 | 2009 | 2007 | 2011 | 2017 | 2021 | 2013 | 2023 | 2015 | 2019 |
filer_id | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 471082 | 476629 | 480059 | 496803 | 489473 | 489473 | 485786 | 468932 | 482188 | 489473 | 540602 | 493188 | 616219 | 1765321 | 1782550 | 1965470 | 1976413 | 1866850 | 1800710 | 1782550 | 1938731 | 1936040 | 1908275 | 1321831 | 1329056 | 1342628 | 1326649 | 1326652 | 1342628 | 1365669 | 1381658 | 1381658 | 1381658 | 1390247 | 1418461 | 1381658 | 1412803 | 1418461 | 1381658 | 1456761 | 1458442 | 1449758 | 1434181 | 1482674 | 1501293 | 1543471 | 1532332 | 1567530 | 1558165 | 1607553 | 1588142 | 1636061 | 1621563 | 1657725 | 1677913 | 1816600 | 1921107 | 1709265 | 1677913 | 1737330 | 1716612 | 1840216 | 1815872 | 1820318 | 1840216 | 1752556 | 2341529 | 2193319 | 2399676 | 2554596 | 2377547 | 2241183 | 1996114 | 2005737 | 2036055 | 2062465 | 2100229 | 2150595 | 2125297 | 2147531 | 2175461 | 2157976 | 2318510 | 2333789 | 2471579 | 2419109 | 2349070 | 2207426 | 2487742 | 2541547 | 2274762 | 2444229 | 2601826 | 2579792 | 2531907 | 2675908 | 2531907 | 2471579 | 2444229 | 2569552 | 2554596 | 2708075 | 2419109 | 2399676 | 2631458 | 2487742 | 2644332 | 2738556 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
period_id | 150 | 151 | 159 | 156 | 154 | 154 | 153 | 157 | 152 | 154 | 158 | 155 | 160 | 213 | 214 | 221 | 222 | 218 | 215 | 214 | None | 220 | 219 | 193 | 193 | 194 | None | None | 194 | 195 | 196 | 196 | 196 | 196 | 197 | 196 | None | 197 | 196 | None | 200 | 199 | 198 | 201 | 202 | 204 | 203 | 204 | None | 206 | 205 | 208 | 207 | 209 | 210 | 216 | 220 | 211 | 210 | 212 | 212 | 217 | None | 217 | 217 | None | None | 231 | 238 | 244 | 237 | 233 | 223 | 224 | 225 | 226 | 227 | None | 228 | 229 | 230 | 229 | 235 | 244 | 241 | 239 | 236 | 232 | 242 | 252 | 234 | 240 | 246 | 245 | 243 | 249 | 243 | 241 | 240 | None | 244 | 250 | 239 | 238 | 247 | 242 | 248 | 251 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F635 | F635 | F635 | F635 | F690 | F690 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F602 | F635 | F635 | F602 | F999 | F635 | F635 | F602 | F602 | F602 | F635 | F635 | F602 | F602 | F635 | F602 | F605 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F602 | F635 | F602 | F602 | F635 | F602 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | 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 | F635 | F635 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_sequence | 0 | 0 | 0 | 0 | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 2 | 0 | 1 | 3 | 0 | 0 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 1 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_date | 1997-07-31 00:00:00 | 1997-10-31 00:00:00 | 1999-11-01 00:00:00 | 1999-02-01 00:00:00 | 1998-10-30 00:00:00 | 1998-10-30 00:00:00 | 1998-04-30 00:00:00 | 1999-04-30 00:00:00 | 1998-02-02 00:00:00 | 1998-07-31 00:00:00 | 1999-08-02 00:00:00 | 1998-11-02 00:00:00 | 2000-01-31 00:00:00 | 2013-04-30 00:00:00 | 2013-07-31 00:00:00 | 2015-04-30 00:00:00 | 2015-07-23 00:00:00 | 2014-07-25 00:00:00 | 2013-10-31 00:00:00 | 2013-09-12 00:00:00 | 2014-12-29 00:00:00 | 2015-02-02 00:00:00 | 2014-10-29 00:00:00 | 2008-03-27 00:00:00 | 2008-04-30 00:00:00 | 2008-07-22 00:00:00 | 2008-04-16 00:00:00 | 2008-04-24 00:00:00 | 2008-07-10 00:00:00 | 2008-10-13 00:00:00 | 2008-11-17 00:00:00 | 2008-11-17 00:00:00 | 2008-11-17 00:00:00 | 2009-01-20 00:00:00 | 2009-04-24 00:00:00 | 2008-11-17 00:00:00 | 2008-12-23 00:00:00 | 2009-04-23 00:00:00 | 2009-12-21 00:00:00 | 2010-01-05 00:00:00 | 2010-01-19 00:00:00 | 2009-10-26 00:00:00 | 2009-07-28 00:00:00 | 2010-04-27 00:00:00 | 2010-07-19 00:00:00 | 2010-11-08 00:00:00 | 2010-10-22 00:00:00 | 2011-01-27 00:00:00 | 2010-12-29 00:00:00 | 2011-07-31 00:00:00 | 2011-04-25 00:00:00 | 2012-01-31 00:00:00 | 2011-10-29 00:00:00 | 2012-04-30 00:00:00 | 2012-07-30 00:00:00 | 2014-01-30 00:00:00 | 2014-12-29 00:00:00 | 2012-10-31 00:00:00 | 2012-10-31 00:00:00 | 2013-01-30 00:00:00 | 2012-12-09 00:00:00 | 2014-05-08 00:00:00 | 2014-01-17 00:00:00 | 2014-02-05 00:00:00 | 2014-04-22 00:00:00 | 2013-01-10 00:00:00 | 2019-01-11 00:00:00 | 2017-10-31 00:00:00 | 2019-07-31 00:00:00 | 2021-02-01 00:00:00 | 2019-04-25 00:00:00 | 2018-04-30 00:00:00 | 2015-10-29 00:00:00 | 2016-01-22 00:00:00 | 2016-04-29 00:00:00 | 2016-07-29 00:00:00 | 2016-10-29 00:00:00 | 2017-03-21 00:00:00 | 2017-01-27 00:00:00 | 2017-03-21 00:00:00 | 2017-07-31 00:00:00 | 2017-05-01 00:00:00 | 2018-10-31 00:00:00 | 2019-01-10 00:00:00 | 2020-04-30 00:00:00 | 2019-10-31 00:00:00 | 2019-01-31 00:00:00 | 2018-01-29 00:00:00 | 2020-07-31 00:00:00 | 2020-12-31 00:00:00 | 2018-07-31 00:00:00 | 2020-01-31 00:00:00 | 2021-07-31 00:00:00 | 2021-04-29 00:00:00 | 2020-11-02 00:00:00 | 2022-05-01 00:00:00 | 2021-12-20 00:00:00 | 2021-12-20 00:00:00 | 2021-12-20 00:00:00 | 2020-12-31 00:00:00 | 2021-10-31 00:00:00 | 2022-08-01 00:00:00 | 2021-12-20 00:00:00 | 2021-12-20 00:00:00 | 2021-12-20 00:00:00 | 2021-10-18 00:00:00 | 2022-01-31 00:00:00 | 2022-10-21 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_type | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10005 | 10001 | 10001 | 10001 | 10001 | 10002 | 10005 | 10005 | 10001 | 10001 | 10001 | 10002 | 10002 | 10001 | 10002 | 10002 | 10005 | 10001 | 10002 | 10006 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | 10001 | 10002 | 10005 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10002 | 10002 | 10005 | 10002 | 10001 | 10002 | 10002 | 10001 | 10002 | 10001 | 10001 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_status | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 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 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11001 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
session_id | 1997 | 1997 | 1999 | 1997 | 1997 | 1997 | 1997 | 1999 | 1997 | 1997 | 1999 | 1997 | 1999 | 2013 | 2013 | 2015 | 2015 | 2013 | 2013 | 2013 | 2015 | 2013 | 2013 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2009 | 2009 | 2009 | 2007 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2011 | 2009 | 2009 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2013 | 2015 | 2011 | 2011 | 2011 | 2013 | 2013 | 2013 | 2013 | 2013 | 2013 | 2019 | 2017 | 2019 | 2019 | 2019 | 2017 | 2015 | 2015 | 2015 | 2015 | 2015 | 2017 | 2015 | 2017 | 2017 | 2017 | 2017 | 2019 | 2019 | 2019 | 2017 | 2017 | 2019 | 2021 | 2017 | 2019 | 2021 | 2021 | 2019 | 2021 | 2019 | 2019 | 2019 | 2021 | 2019 | 2021 | 2019 | 2019 | 2021 | 2019 | 2021 | 2021 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
user_id | * | * | * | * | * | * | * | * | * | * | * | * | CFLAGG | AGLADNEY | ASAETERN | AGLADNEY | AGLADNEY | ASAETERN | ASAETERN | ASAETERN | GPEREZ | AGLADNEY | AGLADNEY | YRODRIGU | LTHIBAUL | LTHIBAUL | YRODRIGU | YRODRIGU | LTHIBAUL | JINGRAM | * | * | * | JINGRAM | MGUERRA | * | PBANFORD | MGUERRA | * | YRODRIGU | JINGRAM | MGUERRA | MGUERRA | ASAETERN | ASAETERN | YRODRIGU | ASAETERN | AGLADNEY | SARRIAGA | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | ASAETERN | ASAETERN | CAFILER | ASAETERN | AGLADNEY | ASAETERN | YRODRIGU | ASAETERN | YRODRIGU | YRODRIGU | ASAETERN | YRODRIGU | PBANFORD | AGLADNEY | VUKSTINA | CREYNOLDS2 | VUKSTINA | AGLADNEY | JINGRAM | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | GPEREZ | AGLADNEY | GPEREZ | AGLADNEY | AGLADNEY | AGLADNEY | PBANFORD | VUKSTINA | VUKSTINA | AGLADNEY | AGLADNEY | MKIRKHAM | SARRIAGA | AGLADNEY | VUKSTINA | MKIRKHAM | GTAYLOR | MKIRKHAM | CAFILER | CAFILER | CAFILER | CAFILER | SARRIAGA | CAFILER | CAFILER | CAFILER | CAFILER | AROJAS | CAFILER | RATTIYEH | CAFILER | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
special_audit | 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 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fine_audit | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11001 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_start | 1997-04-01 00:00:00 | 1997-07-01 00:00:00 | 1999-07-01 00:00:00 | 1998-10-01 00:00:00 | 1998-04-01 00:00:00 | 1998-04-01 00:00:00 | 1998-01-01 00:00:00 | 1999-01-01 00:00:00 | 1997-10-01 00:00:00 | 1998-04-01 00:00:00 | 1999-04-01 00:00:00 | 1998-07-01 00:00:00 | 1999-10-01 00:00:00 | 2013-01-01 00:00:00 | 2013-04-01 00:00:00 | 2015-01-01 00:00:00 | 2015-04-01 00:00:00 | 2014-04-01 00:00:00 | 2013-07-01 00:00:00 | 2013-04-01 00:00:00 | 1900-01-01 00:00:00 | 2014-10-01 00:00:00 | 2014-07-01 00:00:00 | 2008-03-27 00:00:00 | 2008-01-01 00:00:00 | 2008-04-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2008-04-01 00:00:00 | 2008-07-01 00:00:00 | 2008-11-17 00:00:00 | 2008-11-17 00:00:00 | 2008-11-17 00:00:00 | 2008-10-01 00:00:00 | 2009-01-01 00:00:00 | 2008-11-17 00:00:00 | 1900-01-01 00:00:00 | 2009-01-01 00:00:00 | 2008-11-17 00:00:00 | 1900-01-01 00:00:00 | 2009-10-01 00:00:00 | 2009-07-01 00:00:00 | 2009-04-01 00:00:00 | 2010-01-01 00:00:00 | 2010-04-01 00:00:00 | 2010-11-08 00:00:00 | 2010-07-01 00:00:00 | 2010-10-01 00:00:00 | 1900-01-01 00:00:00 | 2011-04-01 00:00:00 | 2011-01-01 00:00:00 | 2011-10-01 00:00:00 | 2011-07-01 00:00:00 | 2012-01-01 00:00:00 | 2012-04-01 00:00:00 | 2013-10-01 00:00:00 | 2014-12-29 00:00:00 | 2012-07-01 00:00:00 | 2012-04-01 00:00:00 | 2012-10-01 00:00:00 | 2012-12-09 00:00:00 | 2014-01-01 00:00:00 | 1900-01-01 00:00:00 | 2014-02-05 00:00:00 | 2014-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2017-07-01 00:00:00 | 2019-04-01 00:00:00 | 2020-10-01 00:00:00 | 2019-01-01 00:00:00 | 2018-01-01 00:00:00 | 2015-07-01 00:00:00 | 2015-10-01 00:00:00 | 2016-01-01 00:00:00 | 2016-04-01 00:00:00 | 2016-07-01 00:00:00 | 1900-01-01 00:00:00 | 2016-10-01 00:00:00 | 2017-03-17 00:00:00 | 2017-04-01 00:00:00 | 2017-01-01 00:00:00 | 2018-07-01 00:00:00 | 2020-12-31 00:00:00 | 2020-01-01 00:00:00 | 2019-07-01 00:00:00 | 2018-10-01 00:00:00 | 2017-10-01 00:00:00 | 2020-04-01 00:00:00 | 2022-12-31 00:00:00 | 2018-04-01 00:00:00 | 2019-10-01 00:00:00 | 2021-04-01 00:00:00 | 2021-01-01 00:00:00 | 2020-07-01 00:00:00 | 2022-01-01 00:00:00 | 2020-07-01 00:00:00 | 2020-01-01 00:00:00 | 2019-10-01 00:00:00 | 1900-01-01 00:00:00 | 2020-10-01 00:00:00 | 2022-04-01 00:00:00 | 2019-07-01 00:00:00 | 2019-04-01 00:00:00 | 2021-07-01 00:00:00 | 2020-04-01 00:00:00 | 2021-10-01 00:00:00 | 2022-07-01 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_end | 1997-06-30 00:00:00 | 1997-09-30 00:00:00 | 1999-09-30 00:00:00 | 1998-12-31 00:00:00 | 1998-06-30 00:00:00 | 1998-06-30 00:00:00 | 1998-03-31 00:00:00 | 1999-03-31 00:00:00 | 1997-12-31 00:00:00 | 1998-06-30 00:00:00 | 1999-06-30 00:00:00 | 1998-09-30 00:00:00 | 1999-12-31 00:00:00 | 2013-03-31 00:00:00 | 2013-06-30 00:00:00 | 2015-03-31 00:00:00 | 2015-06-30 00:00:00 | 2014-06-30 00:00:00 | 2013-09-30 00:00:00 | 2013-06-30 00:00:00 | 1900-01-01 00:00:00 | 2014-12-31 00:00:00 | 2014-09-30 00:00:00 | 2008-03-27 00:00:00 | 2008-03-31 00:00:00 | 2008-06-30 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2008-06-30 00:00:00 | 2008-09-30 00:00:00 | 2008-11-17 00:00:00 | 2008-11-17 00:00:00 | 2008-11-17 00:00:00 | 2008-12-31 00:00:00 | 2009-03-31 00:00:00 | 2008-11-17 00:00:00 | 1900-01-01 00:00:00 | 2009-03-31 00:00:00 | 2008-11-17 00:00:00 | 1900-01-01 00:00:00 | 2009-12-31 00:00:00 | 2009-09-30 00:00:00 | 2009-06-30 00:00:00 | 2010-03-31 00:00:00 | 2010-06-30 00:00:00 | 2010-11-08 00:00:00 | 2010-09-30 00:00:00 | 2010-12-31 00:00:00 | 1900-01-01 00:00:00 | 2011-06-30 00:00:00 | 2011-03-31 00:00:00 | 2011-12-31 00:00:00 | 2011-09-30 00:00:00 | 2012-03-31 00:00:00 | 2012-06-30 00:00:00 | 2013-12-31 00:00:00 | 2014-12-29 00:00:00 | 2012-09-30 00:00:00 | 2012-06-30 00:00:00 | 2012-12-31 00:00:00 | 2012-12-09 00:00:00 | 2014-03-31 00:00:00 | 1900-01-01 00:00:00 | 2014-02-05 00:00:00 | 2014-03-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2017-09-30 00:00:00 | 2019-06-30 00:00:00 | 2020-12-31 00:00:00 | 2019-03-31 00:00:00 | 2018-03-31 00:00:00 | 2015-09-30 00:00:00 | 2015-12-31 00:00:00 | 2016-03-31 00:00:00 | 2016-06-30 00:00:00 | 2016-09-30 00:00:00 | 1900-01-01 00:00:00 | 2016-12-31 00:00:00 | 2017-03-17 00:00:00 | 2017-06-30 00:00:00 | 2017-03-31 00:00:00 | 2018-09-30 00:00:00 | 2020-12-31 00:00:00 | 2020-03-31 00:00:00 | 2019-09-30 00:00:00 | 2018-12-31 00:00:00 | 2017-12-31 00:00:00 | 2020-06-30 00:00:00 | 2022-12-31 00:00:00 | 2018-06-30 00:00:00 | 2019-12-31 00:00:00 | 2021-06-30 00:00:00 | 2021-03-31 00:00:00 | 2020-09-30 00:00:00 | 2022-03-31 00:00:00 | 2020-09-30 00:00:00 | 2020-03-31 00:00:00 | 2019-12-31 00:00:00 | 1900-01-01 00:00:00 | 2020-12-31 00:00:00 | 2022-06-30 00:00:00 | 2019-09-30 00:00:00 | 2019-06-30 00:00:00 | 2021-09-30 00:00:00 | 2020-06-30 00:00:00 | 2021-12-31 00:00:00 | 2022-09-30 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_date | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_type | None | None | None | None | None | None | None | None | None | None | None | None | None | 22006 | 22006 | 22001 | 22001 | 22001 | 22006 | 22006 | None | 22001 | 22001 | 22001 | 22006 | 22006 | None | None | 22006 | 22006 | 22001 | 22001 | 22001 | 22006 | 22006 | 22001 | None | 22006 | 22001 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22001 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22001 | 22006 | 22006 | 22006 | 22006 | 22001 | None | 22001 | 22006 | None | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 |
filer_id | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
session_id | 1999 | 1997 | 2009 | 2007 | 2011 | 2013 | 2017 | 2019 | 2015 | 2021 | 2023 | |||||||||||
interest_cd | 40310 | 40311 | 40310 | 40310 | 40310 | 40310 | 40310 | 40310 | 40310 | 40310 | 40310 | |||||||||||
effect_date | 1999-01-01 00:00:00 | 1997-04-01 00:00:00 | 2009-01-01 00:00:00 | 2008-03-16 00:00:00 | 2011-01-01 00:00:00 | 2013-01-01 00:00:00 | 2017-03-01 00:00:00 | 2019-01-01 00:00:00 | 2015-01-01 00:00:00 | 2021-01-01 00:00:00 | 2023-01-01 00:00:00 |
filer_id | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_type | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | |||||||||||
active | Y | T | Y | Y | Y | Y | Y | Y | Y | Y | N | |||||||||||
race | 0 | 0 | None | None | None | 0 | None | None | None | None | None | |||||||||||
session_id | 1997 | 1999 | 2013 | 2011 | 2009 | 2007 | 2017 | 2019 | 2021 | 2015 | 2023 | |||||||||||
category | 0 | 0 | None | None | None | 0 | None | None | None | None | None | |||||||||||
category_type | 0 | 0 | None | None | None | 0 | None | None | None | None | None | |||||||||||
sub_category | 0 | 0 | None | None | None | 0 | None | None | None | None | None | |||||||||||
effect_dt | 1997-04-01 00:00:00 | 1999-01-01 00:00:00 | 2013-01-01 00:00:00 | 2011-01-01 00:00:00 | 2009-01-01 00:00:00 | 2008-03-16 00:00:00 | 2017-03-01 00:00:00 | 2019-01-01 00:00:00 | 2021-01-01 00:00:00 | 2015-01-01 00:00:00 | 2023-01-01 00:00:00 | |||||||||||
sub_category_type | 0 | 0 | None | None | None | 0 | None | None | None | None | None | |||||||||||
election_type | 0 | 0 | None | None | None | 0 | None | None | None | None | None | |||||||||||
sub_category_a | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
nyq_dt | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
party_cd | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
county_cd | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
district_cd | None | None | None | None | None | None | None | None | None | None | None |
filer_id | 1145457 | |
---|---|---|
xref_id | C26953 | |
effect_dt | 1999-12-08 00:00:00 | |
migration_source | MASTER |
xref_filer_id | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | C26953 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_id | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
naml | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | MATTEL, INC. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
namf | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
namt | 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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
city | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
st | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
zip4 | 90245 | 902455012 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 902455012 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 902455012 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 902455012 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 902455012 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 902455012 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 902455012 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 902455012 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 902455012 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 902455012 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 902455012 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
phon | 3102525227 | 3102525203 | 7035257466 | 3102526628 | 3102526628 | 3102526628 | 3102526628 | 3102521283 | 3102521283 | 3102521283 | 3102521283 | 3102525227 | 3102525203 | 7035257466 | 3102526628 | 3102526628 | 3102526628 | 3102526628 | 3102521283 | 3102521283 | 3102521283 | 3102521283 | 3102525227 | 3102525203 | 7035257466 | 3102526628 | 3102526628 | 3102526628 | 3102526628 | 3102521283 | 3102521283 | 3102521283 | 3102521283 | 3102525227 | 3102525203 | 7035257466 | 3102526628 | 3102526628 | 3102526628 | 3102526628 | 3102521283 | 3102521283 | 3102521283 | 3102521283 | 3102525227 | 3102525203 | 7035257466 | 3102526628 | 3102526628 | 3102526628 | 3102526628 | 3102521283 | 3102521283 | 3102521283 | 3102521283 | 3102525227 | 3102525203 | 7035257466 | 3102526628 | 3102526628 | 3102526628 | 3102526628 | 3102521283 | 3102521283 | 3102521283 | 3102521283 | 3102525227 | 3102525203 | 7035257466 | 3102526628 | 3102526628 | 3102526628 | 3102526628 | 3102521283 | 3102521283 | 3102521283 | 3102521283 | 3102525227 | 3102525203 | 7035257466 | 3102526628 | 3102526628 | 3102526628 | 3102526628 | 3102521283 | 3102521283 | 3102521283 | 3102521283 | 3102525227 | 3102525203 | 7035257466 | 3102526628 | 3102526628 | 3102526628 | 3102526628 | 3102521283 | 3102521283 | 3102521283 | 3102521283 | 3102525227 | 3102525203 | 7035257466 | 3102526628 | 3102526628 | 3102526628 | 3102526628 | 3102521283 | 3102521283 | 3102521283 | 3102521283 | 3102525227 | 3102525203 | 7035257466 | 3102526628 | 3102526628 | 3102526628 | 3102526628 | 3102521283 | 3102521283 | 3102521283 | 3102521283 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fax | None | None | 7035257057 | 3102524443 | 3102524443 | 3102524443 | 3102524443 | None | None | 7035257057 | 3102524443 | 3102524443 | 3102524443 | 3102524443 | None | None | 7035257057 | 3102524443 | 3102524443 | 3102524443 | 3102524443 | None | None | 7035257057 | 3102524443 | 3102524443 | 3102524443 | 3102524443 | None | None | 7035257057 | 3102524443 | 3102524443 | 3102524443 | 3102524443 | None | None | 7035257057 | 3102524443 | 3102524443 | 3102524443 | 3102524443 | None | None | 7035257057 | 3102524443 | 3102524443 | 3102524443 | 3102524443 | None | None | 7035257057 | 3102524443 | 3102524443 | 3102524443 | 3102524443 | None | None | 7035257057 | 3102524443 | 3102524443 | 3102524443 | 3102524443 | None | None | 7035257057 | 3102524443 | 3102524443 | 3102524443 | 3102524443 | None | None | 7035257057 | 3102524443 | 3102524443 | 3102524443 | 3102524443 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | 1145457 |
---|
filer_id | 1145457 | 1145457 | ||
---|---|---|---|---|
change_no | 0 | 1 | ||
session_id | 2007 | 2013 | ||
log_dt | 2008-04-16 00:00:00 | 2013-12-30 00:00:00 | ||
filer_type | 1 | 1 | ||
correction_flg | Y | None | ||
action | ADDED | DELETED | ||
attribute_changed | FIRM | FIRM | ||
ethics_dt | None | None | ||
interests | None | None | ||
filer_full_name | MATTEL, INC. | MATTEL, INC. | ||
filer_city | None | None | ||
filer_st | None | None | ||
filer_zip | None | None | ||
filer_phone | None | None | ||
entity_type | 3 | 3 | ||
entity_name | DI MARE, VAN VLECK & BROWN, LLC | DI MARE, BROWN, HICKS & KESSLER, LLC | ||
entity_city | None | None | ||
entity_st | None | None | ||
entity_zip | None | None | ||
entity_phone | None | None | ||
entity_id | 1276403 | 1276403 | ||
responsible_officer | None | None | ||
effect_dt | 2008-03-16 00:00:00 | 2013-12-31 00:00:00 |
filer_id | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | 1145457 | |||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_file_name | 1381658_4.cal | 1381658_0.cal | 1381658_1.cal | 1381658_2.cal | 1381658_3.cal | 1321831_0.cal | 191182.cal | 191580.cal | 1543471_0.cal | 1976413_0.cal | 1965470_0.cal | 2125297_0.cal | 2005737_0.cal | 1996114_0.cal | 2100229_0.cal | 2062465_0.cal | 2036055_0.cal | |||||||||||||||||
received_date | 2009-12-21 00:00:00 | 2008-11-17 00:00:00 | 2008-11-17 00:00:00 | 2008-11-17 00:00:00 | 2008-11-17 00:00:00 | 2008-03-27 00:00:00 | 2014-04-29 00:00:00 | 2014-04-29 00:00:00 | 2010-11-08 00:00:00 | 2015-07-23 00:00:00 | 2015-04-30 00:00:00 | 2017-01-27 00:00:00 | 2016-01-22 00:00:00 | 2015-10-29 00:00:00 | 2016-10-29 00:00:00 | 2016-07-29 00:00:00 | 2016-04-29 00:00:00 | |||||||||||||||||
filing_directory | /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/temp | /cafiler/disclose/ca99/temp | /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 | 1381658 | 1381658 | 1381658 | 1381658 | 1381658 | 1321831 | None | None | 1543471 | 1976413 | 1965470 | 2125297 | 2005737 | 1996114 | 2100229 | 2062465 | 2036055 | |||||||||||||||||
form_id | F602 | F602 | F602 | F602 | F602 | F602 | None | None | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | |||||||||||||||||
receive_comment | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted |