filer_id | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
adrid | 2012438 | 1111699 | 2189569 | 2206559 | 2545244 | 2416874 | 2286759 | 2510604 | 2344900 | 2467810 | ||||||||||
effect_dt | 2001-01-01 00:00:00 | 1999-11-10 00:00:00 | 2010-05-01 00:00:00 | 2011-01-01 00:00:00 | 2023-01-01 00:00:00 | 2017-01-01 00:00:00 | 2013-03-01 00:00:00 | 2021-01-01 00:00:00 | 2015-01-01 00:00:00 | 2019-01-01 00:00:00 | ||||||||||
add_type | 7051 | 7050 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | ||||||||||
session_id | 2001 | 1999 | 2009 | 2011 | 2023 | 2017 | 2013 | 2021 | 2015 | 2019 |
filer_id | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 614220 | 631093 | 664959 | 675953 | 696803 | 704968 | 716451 | 740306 | 745681 | 755299 | 795624 | 778317 | 769948 | 790783 | 811072 | 824132 | 836365 | 841115 | 881126 | 854184 | 861761 | 909279 | 924933 | 924934 | 1781422 | 1965970 | 1799776 | 1938103 | 1953503 | 1496771 | 1496773 | 1498061 | 1506914 | 1541283 | 1541283 | 1570046 | 1577821 | 1607618 | 1579239 | 1591215 | 1637934 | 1623342 | 1659331 | 1681375 | 1913660 | 1920380 | 1710152 | 1874658 | 1816770 | 1846739 | 1763864 | 1761488 | 1753213 | 1983206 | 1998885 | 2377133 | 2232757 | 2428281 | 2579840 | 2368604 | 2232757 | 2232757 | 2212373 | 2232757 | 2308473 | 2013583 | 2038205 | 2066929 | 2102792 | 2123352 | 2130525 | 2135801 | 2177463 | 2157822 | 2412738 | 2264933 | 2390613 | 2264933 | 2520234 | 2327749 | 2232757 | 2358202 | 2390613 | 2520234 | 2336926 | 2479892 | 2196094 | 2412738 | 2645220 | 2428281 | 2467012 | 2623193 | 2598755 | 2551370 | 2675089 | 2579840 | 2704969 | 2588353 | 2551370 | 2704969 | 2740147 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
period_id | 160 | None | 162 | 163 | 163 | None | 164 | 164 | 165 | 165 | None | None | 166 | 167 | 168 | None | 169 | None | 171 | 170 | None | 172 | None | None | 214 | 221 | 215 | 220 | None | None | None | 202 | 202 | 203 | 203 | 204 | 205 | 206 | None | 205 | 208 | 207 | 209 | 210 | 219 | 220 | 211 | 218 | 216 | 217 | 213 | None | 213 | 222 | 223 | 237 | 233 | 240 | 245 | None | 233 | 233 | 232 | 233 | 235 | 224 | 225 | 226 | 227 | 229 | 228 | None | 230 | 229 | 239 | 234 | 238 | 234 | 243 | 236 | 233 | None | 238 | 243 | 236 | 242 | 231 | 239 | 248 | 240 | 241 | 247 | 246 | 244 | 249 | 245 | 250 | None | 244 | 250 | 251 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F602 | F999 | F602 | F635 | F635 | F635 | F635 | F602 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F602 | F602 | F635 | F635 | F635 | 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 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_sequence | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | 0 | 0 | 0 | 2 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 3 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_date | 2000-01-28 00:00:00 | 2000-04-17 00:00:00 | 2000-07-27 00:00:00 | 2000-10-25 00:00:00 | 2000-10-31 00:00:00 | 2000-12-28 00:00:00 | 2001-01-29 00:00:00 | 2001-02-01 00:00:00 | 2001-04-30 00:00:00 | 2001-04-23 00:00:00 | 2001-10-29 00:00:00 | 2001-07-05 00:00:00 | 2001-07-25 00:00:00 | 2001-10-30 00:00:00 | 2002-01-28 00:00:00 | 2002-01-14 00:00:00 | 2002-04-22 00:00:00 | 2002-04-26 00:00:00 | 2002-10-28 00:00:00 | 2002-07-30 00:00:00 | 2002-07-30 00:00:00 | 2003-01-29 00:00:00 | 2003-03-11 00:00:00 | 2003-03-11 00:00:00 | 2013-07-30 00:00:00 | 2015-04-30 00:00:00 | 2013-10-30 00:00:00 | 2015-02-03 00:00:00 | 2014-12-26 00:00:00 | 2010-05-21 00:00:00 | 2010-06-10 00:00:00 | 2010-06-18 00:00:00 | 2010-07-31 00:00:00 | 2010-11-01 00:00:00 | 2010-12-14 00:00:00 | 2011-01-31 00:00:00 | 2011-02-18 00:00:00 | 2011-07-31 00:00:00 | 2011-02-23 00:00:00 | 2011-05-01 00:00:00 | 2012-01-31 00:00:00 | 2011-10-31 00:00:00 | 2012-05-03 00:00:00 | 2012-08-01 00:00:00 | 2014-11-03 00:00:00 | 2014-12-23 00:00:00 | 2012-10-31 00:00:00 | 2014-08-06 00:00:00 | 2014-01-30 00:00:00 | 2014-05-01 00:00:00 | 2013-04-29 00:00:00 | 2013-03-22 00:00:00 | 2013-03-15 00:00:00 | 2015-07-31 00:00:00 | 2015-11-05 00:00:00 | 2019-04-25 00:00:00 | 2018-09-13 00:00:00 | 2020-01-06 00:00:00 | 2021-04-29 00:00:00 | 2019-03-14 00:00:00 | 2018-04-19 00:00:00 | 2018-05-01 00:00:00 | 2018-01-31 00:00:00 | 2018-04-25 00:00:00 | 2018-10-18 00:00:00 | 2016-02-02 00:00:00 | 2016-05-02 00:00:00 | 2016-08-09 00:00:00 | 2016-10-31 00:00:00 | 2017-01-25 00:00:00 | 2017-01-31 00:00:00 | 2017-02-07 00:00:00 | 2017-07-31 00:00:00 | 2017-05-01 00:00:00 | 2019-10-11 00:00:00 | 2018-09-13 00:00:00 | 2019-11-04 00:00:00 | 2018-07-16 00:00:00 | 2020-10-21 00:00:00 | 2018-12-11 00:00:00 | 2018-07-23 00:00:00 | 2018-12-19 00:00:00 | 2019-07-17 00:00:00 | 2020-10-30 00:00:00 | 2019-01-22 00:00:00 | 2020-07-22 00:00:00 | 2017-11-14 00:00:00 | 2019-11-04 00:00:00 | 2022-01-31 00:00:00 | 2020-01-27 00:00:00 | 2020-04-23 00:00:00 | 2021-10-30 00:00:00 | 2021-07-29 00:00:00 | 2021-01-29 00:00:00 | 2022-04-29 00:00:00 | 2021-07-28 00:00:00 | 2022-07-29 00:00:00 | 2021-02-08 00:00:00 | 2022-03-10 00:00:00 | 2022-07-29 00:00:00 | 2022-10-24 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_type | 10005 | 10005 | 10005 | 10001 | 10005 | 10005 | 10001 | 10005 | 10001 | 10005 | 10005 | 10005 | 10001 | 10001 | 10001 | 10005 | 10001 | 10005 | 10001 | 10001 | 10005 | 10001 | 10005 | 10005 | 10001 | 10001 | 10001 | 10001 | 10005 | 10005 | 10005 | 10001 | 10001 | 10001 | 10002 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | 10001 | 10002 | 10001 | 10002 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10002 | 10002 | 10001 | 10001 | 10001 | 10002 | 10005 | 10001 | 10002 | 10001 | 10001 | 10001 | 10002 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10002 | 10005 | 10002 | 10001 | 10001 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_status | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11003 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 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 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
session_id | 1999 | 1999 | 1999 | 1999 | 1999 | 2001 | 1999 | 1999 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2013 | 2015 | 2013 | 2013 | 2015 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2013 | 2015 | 2011 | 2013 | 2013 | 2013 | 2013 | 2013 | 2013 | 2015 | 2015 | 2019 | 2017 | 2019 | 2021 | 2019 | 2017 | 2017 | 2017 | 2017 | 2017 | 2015 | 2015 | 2015 | 2015 | 2017 | 2015 | 2017 | 2017 | 2017 | 2019 | 2017 | 2019 | 2017 | 2019 | 2019 | 2017 | 2019 | 2019 | 2019 | 2017 | 2019 | 2017 | 2019 | 2021 | 2019 | 2019 | 2021 | 2021 | 2019 | 2021 | 2021 | 2021 | 2021 | 2019 | 2021 | 2021 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
user_id | * | TTHAM | YBONILLA | * | YBONILLA | GGILMORE | * | YBONILLA | * | LTHIBAUL | LTHIBAUL | LTHIBAUL | * | * | * | LTHIBAUL | * | LTHIBAUL | * | * | LTHIBAUL | COMPLETED | DHORRELL | DHORRELL | ASAETERN | AGLADNEY | AGLADNEY | GCLARA | YRODRIGU | YRODRIGU | YRODRIGU | * | ASAETERN | ASAETERN | ASAETERN | AGLADNEY | * | AGLADNEY | CFLAGG | CFLAGG | AGLADNEY | ASAETERN | GCLARA | GCLARA | GCLARA | YRODRIGU | AGLADNEY | RGEREMIA | ASAETERN | RGEREMIA | ASAETERN | SARRIAGA | SARRIAGA | AGLADNEY | GCLARA | VUKSTINA | AGLADNEY | VUKSTINA | CHATRIDGE | GPEREZ | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | GPEREZ | AGLADNEY | SARRIAGA | AGLADNEY | AGLADNEY | GTAYLOR | AGLADNEY | GTAYLOR | AGLADNEY | GTAYLOR | GPEREZ | AGLADNEY | GPEREZ | SUSHAKOV | GTAYLOR | AGLADNEY | GTAYLOR | AGLADNEY | AGLADNEY | RATTIYEH | GTAYLOR | VUKSTINA | GTAYLOR | CHATRIDGE | GTAYLOR | CAFILER | CHATRIDGE | CAFILER | SARRIAGA | CAFILER | CAFILER | CAFILER | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
special_audit | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11002 | 11003 | 11002 | 11003 | 11003 | 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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fine_audit | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_start | 1999-10-01 00:00:00 | 2000-01-01 00:00:00 | 2000-04-01 00:00:00 | 2000-07-01 00:00:00 | 2000-07-01 00:00:00 | 1900-01-01 00:00:00 | 2000-10-01 00:00:00 | 2000-10-01 00:00:00 | 2001-01-01 00:00:00 | 2001-01-01 00:00:00 | 2001-07-01 00:00:00 | 2001-04-01 00:00:00 | 2001-04-01 00:00:00 | 2001-07-01 00:00:00 | 2001-10-01 00:00:00 | 2001-10-01 00:00:00 | 2002-01-01 00:00:00 | 2002-01-01 00:00:00 | 2002-07-01 00:00:00 | 2002-04-01 00:00:00 | 2002-04-01 00:00:00 | 2002-10-01 00:00:00 | 2002-07-01 00:00:00 | 2002-10-01 00:00:00 | 2013-04-01 00:00:00 | 2015-01-01 00:00:00 | 2013-07-01 00:00:00 | 2014-10-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2010-06-18 00:00:00 | 2010-04-01 00:00:00 | 2010-07-01 00:00:00 | 2010-07-01 00:00:00 | 2010-10-01 00:00:00 | 2011-02-18 00:00:00 | 2011-04-01 00:00:00 | 1900-01-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 | 2014-07-01 00:00:00 | 2014-12-23 00:00:00 | 2012-07-01 00:00:00 | 2014-04-01 00:00:00 | 2013-10-01 00:00:00 | 2014-01-01 00:00:00 | 2013-01-01 00:00:00 | 1900-01-01 00:00:00 | 2013-03-15 00:00:00 | 2015-04-01 00:00:00 | 2015-07-01 00:00:00 | 2019-01-01 00:00:00 | 2018-01-01 00:00:00 | 2019-10-01 00:00:00 | 2021-01-01 00:00:00 | 1900-01-01 00:00:00 | 2018-01-01 00:00:00 | 2018-01-01 00:00:00 | 2017-10-01 00:00:00 | 2018-01-01 00:00:00 | 2018-07-01 00:00:00 | 2015-10-01 00:00:00 | 2016-01-01 00:00:00 | 2016-04-01 00:00:00 | 2016-07-01 00:00:00 | 2017-01-25 00:00:00 | 2016-10-01 00:00:00 | 1900-01-01 00:00:00 | 2017-04-01 00:00:00 | 2017-01-01 00:00:00 | 2019-07-01 00:00:00 | 2018-04-01 00:00:00 | 2019-04-01 00:00:00 | 2018-04-01 00:00:00 | 2020-07-01 00:00:00 | 2018-12-11 00:00:00 | 2018-01-01 00:00:00 | 1900-01-01 00:00:00 | 2019-04-01 00:00:00 | 2020-07-01 00:00:00 | 2018-10-01 00:00:00 | 2020-04-01 00:00:00 | 2017-07-01 00:00:00 | 2019-07-01 00:00:00 | 2021-10-01 00:00:00 | 2019-10-01 00:00:00 | 2020-01-01 00:00:00 | 2021-07-01 00:00:00 | 2021-04-01 00:00:00 | 2020-10-01 00:00:00 | 2022-01-01 00:00:00 | 2021-01-01 00:00:00 | 2022-04-01 00:00:00 | 1900-01-01 00:00:00 | 2020-10-01 00:00:00 | 2022-04-01 00:00:00 | 2022-07-01 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_end | 1999-12-31 00:00:00 | 2000-03-31 00:00:00 | 2000-06-30 00:00:00 | 2000-09-30 00:00:00 | 2000-09-30 00:00:00 | 1900-01-01 00:00:00 | 2000-12-31 00:00:00 | 2000-12-31 00:00:00 | 2001-03-31 00:00:00 | 2001-03-31 00:00:00 | 2001-09-30 00:00:00 | 2001-06-30 00:00:00 | 2001-06-30 00:00:00 | 2001-09-30 00:00:00 | 2001-12-31 00:00:00 | 2001-12-31 00:00:00 | 2002-03-31 00:00:00 | 2002-03-31 00:00:00 | 2002-09-30 00:00:00 | 2002-06-30 00:00:00 | 2002-06-30 00:00:00 | 2002-12-31 00:00:00 | 2002-09-30 00:00:00 | 2002-12-31 00:00:00 | 2013-06-30 00:00:00 | 2015-03-31 00:00:00 | 2013-09-30 00:00:00 | 2014-12-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2010-06-18 00:00:00 | 2010-06-30 00:00:00 | 2010-10-31 00:00:00 | 2010-09-30 00:00:00 | 2010-12-31 00:00:00 | 2011-02-18 00:00:00 | 2011-06-30 00:00:00 | 1900-01-01 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 | 2014-09-30 00:00:00 | 2014-12-23 00:00:00 | 2012-09-30 00:00:00 | 2014-06-30 00:00:00 | 2013-12-31 00:00:00 | 2014-03-31 00:00:00 | 2013-03-31 00:00:00 | 1900-01-01 00:00:00 | 2013-03-15 00:00:00 | 2015-06-30 00:00:00 | 2015-09-30 00:00:00 | 2019-03-31 00:00:00 | 2018-03-31 00:00:00 | 2019-12-31 00:00:00 | 2021-03-31 00:00:00 | 1900-01-01 00:00:00 | 2018-03-31 00:00:00 | 2018-03-31 00:00:00 | 2017-12-31 00:00:00 | 2018-03-31 00:00:00 | 2018-09-30 00:00:00 | 2015-12-31 00:00:00 | 2016-03-31 00:00:00 | 2016-06-30 00:00:00 | 2016-09-30 00:00:00 | 2017-01-25 00:00:00 | 2016-12-31 00:00:00 | 1900-01-01 00:00:00 | 2017-06-30 00:00:00 | 2017-03-31 00:00:00 | 2019-09-30 00:00:00 | 2018-06-30 00:00:00 | 2019-06-30 00:00:00 | 2018-06-30 00:00:00 | 2020-09-30 00:00:00 | 2018-12-11 00:00:00 | 2018-03-31 00:00:00 | 1900-01-01 00:00:00 | 2019-06-30 00:00:00 | 2020-09-30 00:00:00 | 2018-12-31 00:00:00 | 2020-06-30 00:00:00 | 2017-09-30 00:00:00 | 2019-09-30 00:00:00 | 2021-12-31 00:00:00 | 2019-12-31 00:00:00 | 2020-03-31 00:00:00 | 2021-09-30 00:00:00 | 2021-06-30 00:00:00 | 2020-12-31 00:00:00 | 2022-03-31 00:00:00 | 2021-03-31 00:00:00 | 2022-06-30 00:00:00 | 1900-01-01 00:00:00 | 2020-12-31 00:00:00 | 2022-06-30 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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_type | 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 | 22006 | None | None | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 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 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 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 |
filer_id | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
session_id | 2001 | 1999 | 2011 | 2013 | 2009 | 2019 | 2015 | 2017 | 2021 | 2023 | ||||||||||
interest_cd | 40312 | 40312 | 40312 | 40312 | 40312 | 40312 | 40312 | 40312 | 40312 | 40312 | ||||||||||
effect_date | 2001-01-01 00:00:00 | 1999-11-10 00:00:00 | 2011-01-01 00:00:00 | 2013-03-01 00:00:00 | 2010-05-01 00:00:00 | 2019-01-01 00:00:00 | 2015-01-01 00:00:00 | 2017-01-01 00:00:00 | 2021-01-01 00:00:00 | 2023-01-01 00:00:00 |
filer_id | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_type | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | ||||||||||||
active | Y | Y | T | Y | T | Y | Y | Y | Y | Y | Y | N | ||||||||||||
race | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | ||||||||||||
session_id | 1999 | 2001 | 2001 | 2009 | 2011 | 2011 | 2013 | 2017 | 2019 | 2015 | 2021 | 2023 | ||||||||||||
category | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | ||||||||||||
category_type | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | ||||||||||||
sub_category | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | ||||||||||||
effect_dt | 1999-11-10 00:00:00 | 2001-01-01 00:00:00 | 2002-06-30 00:00:00 | 2010-05-01 00:00:00 | 2012-09-30 00:00:00 | 2011-01-01 00:00:00 | 2013-03-01 00:00:00 | 2017-01-01 00:00:00 | 2019-01-01 00:00:00 | 2015-01-01 00:00:00 | 2021-01-01 00:00:00 | 2023-01-01 00:00:00 | ||||||||||||
sub_category_type | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | ||||||||||||
election_type | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | ||||||||||||
sub_category_a | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
nyq_dt | None | None | 2000-07-01 00:00:00 | 2000-07-01 00:00:00 | None | None | None | None | None | None | None | None | ||||||||||||
party_cd | 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 | ||||||||||||
district_cd | None | None | None | None | None | None | None | None | None | None | None | None |
filer_id | 1146741 | |
---|---|---|
xref_id | C28301 | |
effect_dt | 1999-12-08 00:00:00 | |
migration_source | MASTER |
xref_filer_id | C28301 | C28301 | C28301 | C28301 | C28301 | C28301 | C28301 | C28301 | C28301 | C28301 | C28301 | C28301 | C28301 | C28301 | C28301 | C28301 | C28301 | C28301 | C28301 | C28301 | C28301 | C28301 | C28301 | C28301 | C28301 | C28301 | C28301 | C28301 | C28301 | C28301 | C28301 | C28301 | C28301 | C28301 | C28301 | C28301 | C28301 | C28301 | C28301 | C28301 | C28301 | C28301 | C28301 | C28301 | C28301 | C28301 | C28301 | C28301 | C28301 | C28301 | C28301 | C28301 | C28301 | C28301 | C28301 | C28301 | C28301 | C28301 | C28301 | C28301 | C28301 | C28301 | C28301 | C28301 | C28301 | C28301 | C28301 | C28301 | C28301 | C28301 | C28301 | C28301 | C28301 | C28301 | C28301 | C28301 | C28301 | C28301 | C28301 | C28301 | C28301 | C28301 | C28301 | C28301 | C28301 | C28301 | C28301 | C28301 | C28301 | C28301 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_id | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
naml | HEAL THE BAY | HEAL THE BAY | HEAL THE BAY | HEAL THE BAY | HEAL THE BAY | HEAL THE BAY | HEAL THE BAY | HEAL THE BAY | HEAL THE BAY | HEAL THE BAY | HEAL THE BAY | HEAL THE BAY | HEAL THE BAY | HEAL THE BAY | HEAL THE BAY | HEAL THE BAY | HEAL THE BAY | HEAL THE BAY | HEAL THE BAY | HEAL THE BAY | HEAL THE BAY | HEAL THE BAY | HEAL THE BAY | HEAL THE BAY | HEAL THE BAY | HEAL THE BAY | HEAL THE BAY | HEAL THE BAY | HEAL THE BAY | HEAL THE BAY | HEAL THE BAY | HEAL THE BAY | HEAL THE BAY | HEAL THE BAY | HEAL THE BAY | HEAL THE BAY | HEAL THE BAY | HEAL THE BAY | HEAL THE BAY | HEAL THE BAY | HEAL THE BAY | HEAL THE BAY | HEAL THE BAY | HEAL THE BAY | HEAL THE BAY | HEAL THE BAY | HEAL THE BAY | HEAL THE BAY | HEAL THE BAY | HEAL THE BAY | HEAL THE BAY | HEAL THE BAY | HEAL THE BAY | HEAL THE BAY | HEAL THE BAY | HEAL THE BAY | HEAL THE BAY | HEAL THE BAY | HEAL THE BAY | HEAL THE BAY | HEAL THE BAY | HEAL THE BAY | HEAL THE BAY | HEAL THE BAY | HEAL THE BAY | HEAL THE BAY | HEAL THE BAY | HEAL THE BAY | HEAL THE BAY | HEAL THE BAY | HEAL THE BAY | HEAL THE BAY | HEAL THE BAY | HEAL THE BAY | HEAL THE BAY | HEAL THE BAY | HEAL THE BAY | HEAL THE BAY | HEAL THE BAY | HEAL THE BAY | HEAL THE BAY | HEAL THE BAY | HEAL THE BAY | HEAL THE BAY | HEAL THE BAY | HEAL THE BAY | HEAL THE BAY | HEAL THE BAY | HEAL THE BAY | HEAL THE BAY | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
city | Santa Monica | SANTA MONICA | SANTA MONICA | SANTA MONICA | SANTA MONICA | SANTA MONICA | SANTA MONICA | SANTA MONICA | SANTA MONICA | SANTA MONICA | Santa Monica | SANTA MONICA | SANTA MONICA | SANTA MONICA | SANTA MONICA | SANTA MONICA | SANTA MONICA | SANTA MONICA | SANTA MONICA | SANTA MONICA | Santa Monica | SANTA MONICA | SANTA MONICA | SANTA MONICA | SANTA MONICA | SANTA MONICA | SANTA MONICA | SANTA MONICA | SANTA MONICA | SANTA MONICA | Santa Monica | SANTA MONICA | SANTA MONICA | SANTA MONICA | SANTA MONICA | SANTA MONICA | SANTA MONICA | SANTA MONICA | SANTA MONICA | SANTA MONICA | Santa Monica | SANTA MONICA | SANTA MONICA | SANTA MONICA | SANTA MONICA | SANTA MONICA | SANTA MONICA | SANTA MONICA | SANTA MONICA | SANTA MONICA | Santa Monica | SANTA MONICA | SANTA MONICA | SANTA MONICA | SANTA MONICA | SANTA MONICA | SANTA MONICA | SANTA MONICA | SANTA MONICA | SANTA MONICA | Santa Monica | SANTA MONICA | SANTA MONICA | SANTA MONICA | SANTA MONICA | SANTA MONICA | SANTA MONICA | SANTA MONICA | SANTA MONICA | SANTA MONICA | Santa Monica | SANTA MONICA | SANTA MONICA | SANTA MONICA | SANTA MONICA | SANTA MONICA | SANTA MONICA | SANTA MONICA | SANTA MONICA | SANTA MONICA | Santa Monica | SANTA MONICA | SANTA MONICA | SANTA MONICA | SANTA MONICA | SANTA MONICA | SANTA MONICA | SANTA MONICA | SANTA MONICA | SANTA MONICA | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
zip4 | 90405 | 90404 | 90401 | 90401 | 90401 | 90401 | 90401 | 90401 | 90401 | 90401 | 90405 | 90404 | 90401 | 90401 | 90401 | 90401 | 90401 | 90401 | 90401 | 90401 | 90405 | 90404 | 90401 | 90401 | 90401 | 90401 | 90401 | 90401 | 90401 | 90401 | 90405 | 90404 | 90401 | 90401 | 90401 | 90401 | 90401 | 90401 | 90401 | 90401 | 90405 | 90404 | 90401 | 90401 | 90401 | 90401 | 90401 | 90401 | 90401 | 90401 | 90405 | 90404 | 90401 | 90401 | 90401 | 90401 | 90401 | 90401 | 90401 | 90401 | 90405 | 90404 | 90401 | 90401 | 90401 | 90401 | 90401 | 90401 | 90401 | 90401 | 90405 | 90404 | 90401 | 90401 | 90401 | 90401 | 90401 | 90401 | 90401 | 90401 | 90405 | 90404 | 90401 | 90401 | 90401 | 90401 | 90401 | 90401 | 90401 | 90401 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
phon | 3105814188 | 3104530395 | 3104511500 | 3104511500 | 3104511500 | 3104511500 | 3104511500 | 3104511500 | 3104511500 | 3104511500 | 3105814188 | 3104530395 | 3104511500 | 3104511500 | 3104511500 | 3104511500 | 3104511500 | 3104511500 | 3104511500 | 3104511500 | 3105814188 | 3104530395 | 3104511500 | 3104511500 | 3104511500 | 3104511500 | 3104511500 | 3104511500 | 3104511500 | 3104511500 | 3105814188 | 3104530395 | 3104511500 | 3104511500 | 3104511500 | 3104511500 | 3104511500 | 3104511500 | 3104511500 | 3104511500 | 3105814188 | 3104530395 | 3104511500 | 3104511500 | 3104511500 | 3104511500 | 3104511500 | 3104511500 | 3104511500 | 3104511500 | 3105814188 | 3104530395 | 3104511500 | 3104511500 | 3104511500 | 3104511500 | 3104511500 | 3104511500 | 3104511500 | 3104511500 | 3105814188 | 3104530395 | 3104511500 | 3104511500 | 3104511500 | 3104511500 | 3104511500 | 3104511500 | 3104511500 | 3104511500 | 3105814188 | 3104530395 | 3104511500 | 3104511500 | 3104511500 | 3104511500 | 3104511500 | 3104511500 | 3104511500 | 3104511500 | 3105814188 | 3104530395 | 3104511500 | 3104511500 | 3104511500 | 3104511500 | 3104511500 | 3104511500 | 3104511500 | 3104511500 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] |
filer_id | 1146741 |
---|
filer_id | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | |||||
---|---|---|---|---|---|---|---|---|---|---|
change_no | 1 | 2 | 0 | 3 | 4 | |||||
session_id | 2001 | 2001 | 2009 | 2011 | 2013 | |||||
log_dt | 2003-03-24 00:00:00 | 2003-03-24 00:00:00 | 2010-05-21 00:00:00 | 2013-01-24 00:00:00 | 2013-03-22 00:00:00 | |||||
filer_type | 1 | 1 | 1 | 1 | 1 | |||||
correction_flg | None | None | Y | None | Y | |||||
action | DELETED | TERMINATED | ADDED | DELETED | ADDED | |||||
attribute_changed | FIRM | FIRM | FIRM | FIRM | ||||||
ethics_dt | None | None | None | None | None | |||||
interests | None | None | None | None | None | |||||
filer_full_name | FILER INFORMATION | FILER INFORMATION | HEAL THE BAY | HEAL THE BAY | HEAL THE BAY | |||||
filer_city | None | None | None | None | SANTA MONICA | |||||
filer_st | None | None | None | None | CA | |||||
filer_zip | None | None | None | None | 90404 | |||||
filer_phone | None | None | None | None | 3104530395 | |||||
entity_type | 3 | 1 | 3 | 3 | 3 | |||||
entity_name | MC CABE & COMPANY | None | ECOCONSULT | ECOCONSULT | ECOCONSULT | |||||
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 | 1147780 | 0 | 1147546 | 1147546 | None | |||||
responsible_officer | None | None | None | None | None | |||||
effect_dt | 2002-06-30 00:00:00 | 2002-06-30 00:00:00 | 2010-05-01 00:00:00 | 2012-09-30 00:00:00 | 2013-03-01 00:00:00 |
filer_id | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | 1146741 | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_file_name | 716451_0.cal | 675953_0.cal | 745681_0.cal | 769948_0.cal | 790783_0.cal | 811072_0.cal | 836365_0.cal | 854184_0.cal | 881126_0.cal | 909279_0.cal | ||||||||||
received_date | 2001-01-29 00:00:00 | 2000-10-25 00:00:00 | 2001-04-30 00:00:00 | 2001-07-25 00:00:00 | 2001-10-30 00:00:00 | 2002-01-28 00:00:00 | 2002-04-22 00:00:00 | 2002-07-30 00:00:00 | 2002-10-28 00:00:00 | 2003-01-29 00:00:00 | ||||||||||
filing_directory | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | ||||||||||
filing_id | 716451 | 675953 | 745681 | 769948 | 790783 | 811072 | 836365 | 854184 | 881126 | 909279 | ||||||||||
form_id | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | ||||||||||
receive_comment | Filing accepted, but with warnings | Filing accepted, but 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, but with warnings | Filing accepted, but with warnings | Filing accepted, but with warnings | Filing accepted, but with warnings |