filer_id | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
adrid | 1112591 | 2179002 | 2208130 | 2514584 | 2416169 | 2469655 | 2553831 | 2276021 | 2343410 | |||||||||
effect_dt | 1999-02-01 00:00:00 | 2010-02-11 00:00:00 | 2011-01-01 00:00:00 | 2021-01-01 00:00:00 | 2017-01-01 00:00:00 | 2019-01-01 00:00:00 | 2023-01-01 00:00:00 | 2013-01-01 00:00:00 | 2015-01-01 00:00:00 | |||||||||
add_type | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | |||||||||
session_id | 1999 | 2009 | 2011 | 2021 | 2017 | 2019 | 2023 | 2013 | 2015 |
filer_id | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 478567 | 473005 | 467633 | 614633 | 631484 | 642568 | 802953 | 807129 | 819763 | 813505 | 801505 | 839247 | 862980 | 842608 | 852939 | 880724 | 926198 | 894911 | 924276 | 911717 | 467633 | 971326 | 1781284 | 1965783 | 1976709 | 1868573 | 1799260 | 1951272 | 1908686 | 1470395 | 1469946 | 1504627 | 1485442 | 1538729 | 1564681 | 1578153 | 1619318 | 1603484 | 1589834 | 1634963 | 1656041 | 1677916 | 1814935 | 1934711 | 1921946 | 1706715 | 1739950 | 1721908 | 1844004 | 1844005 | 1764347 | 1751921 | 1997399 | 2275926 | 2470928 | 2442338 | 2395714 | 2522579 | 2358868 | 2319319 | 2010664 | 2036218 | 2059216 | 2099587 | 2138392 | 2127963 | 2176618 | 2157603 | 2193855 | 2416673 | 2240280 | 2210623 | 2345797 | 2395714 | 2541227 | 2565161 | 2482696 | 2381014 | 2598506 | 2550921 | 2578516 | 2621411 | 2674808 | 2641703 | 2705400 | 2734415 | 2734415 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
period_id | 159 | 158 | 157 | 160 | None | 162 | None | None | None | 168 | None | 169 | None | None | 170 | 171 | None | None | None | 172 | 157 | None | 214 | 221 | 222 | 218 | 215 | None | 219 | None | None | 202 | 201 | 203 | None | 204 | 207 | 206 | 205 | 208 | 209 | 210 | 216 | 220 | 220 | 211 | 212 | 212 | 217 | 217 | 213 | None | 223 | 234 | 241 | 240 | 238 | 243 | None | 235 | 224 | 225 | 226 | 227 | None | 228 | 230 | 229 | 231 | 239 | 233 | 232 | 236 | 238 | 244 | None | 242 | 237 | 246 | 244 | 245 | 247 | 249 | 248 | 250 | 251 | 251 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F635 | F635 | F635 | F635 | F635 | F635 | F999 | F602 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F690 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F999 | F602 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F602 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | 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 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_date | 1999-10-20 00:00:00 | 1999-09-03 00:00:00 | 1999-04-19 00:00:00 | 2000-01-12 00:00:00 | 2000-04-21 00:00:00 | 2000-07-17 00:00:00 | 2001-12-19 00:00:00 | 2002-01-08 00:00:00 | 2002-01-22 00:00:00 | 2002-01-31 00:00:00 | 2001-12-12 00:00:00 | 2002-04-30 00:00:00 | 2002-07-25 00:00:00 | 2002-04-25 00:00:00 | 2002-07-29 00:00:00 | 2002-10-27 00:00:00 | 2003-03-27 00:00:00 | 2002-11-15 00:00:00 | 2003-01-27 00:00:00 | 2003-01-31 00:00:00 | 1999-04-19 00:00:00 | 1999-07-02 00:00:00 | 2013-07-30 00:00:00 | 2015-04-30 00:00:00 | 2015-07-23 00:00:00 | 2014-07-29 00:00:00 | 2013-10-30 00:00:00 | 2014-12-30 00:00:00 | 2014-10-29 00:00:00 | 2010-02-23 00:00:00 | 2010-02-11 00:00:00 | 2010-07-28 00:00:00 | 2010-04-30 00:00:00 | 2010-10-29 00:00:00 | 2010-12-29 00:00:00 | 2011-02-22 00:00:00 | 2011-10-25 00:00:00 | 2011-07-26 00:00:00 | 2011-04-28 00:00:00 | 2012-01-30 00:00:00 | 2012-04-27 00:00:00 | 2012-07-30 00:00:00 | 2014-01-29 00:00:00 | 2015-01-30 00:00:00 | 2014-12-30 00:00:00 | 2012-10-29 00:00:00 | 2013-01-31 00:00:00 | 2012-12-31 00:00:00 | 2014-04-29 00:00:00 | 2014-04-29 00:00:00 | 2013-04-30 00:00:00 | 2012-12-27 00:00:00 | 2015-10-30 00:00:00 | 2018-07-31 00:00:00 | 2020-04-30 00:00:00 | 2020-01-31 00:00:00 | 2019-07-29 00:00:00 | 2020-10-25 00:00:00 | 2018-12-31 00:00:00 | 2018-10-31 00:00:00 | 2016-01-29 00:00:00 | 2016-04-29 00:00:00 | 2016-07-27 00:00:00 | 2016-10-28 00:00:00 | 2016-12-29 00:00:00 | 2017-01-30 00:00:00 | 2017-07-31 00:00:00 | 2017-05-01 00:00:00 | 2017-10-31 00:00:00 | 2019-10-28 00:00:00 | 2018-04-29 00:00:00 | 2018-01-31 00:00:00 | 2019-01-30 00:00:00 | 2019-10-28 00:00:00 | 2020-12-30 00:00:00 | 2020-12-28 00:00:00 | 2020-07-29 00:00:00 | 2019-04-30 00:00:00 | 2021-07-28 00:00:00 | 2021-01-29 00:00:00 | 2021-04-28 00:00:00 | 2021-10-28 00:00:00 | 2022-04-29 00:00:00 | 2022-01-28 00:00:00 | 2022-07-30 00:00:00 | 2022-10-16 00:00:00 | 2022-10-16 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_type | 10001 | 10001 | 10001 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10001 | 10005 | 10001 | 10005 | 10005 | 10001 | 10001 | 10005 | 10006 | 10005 | 10001 | 10002 | 10006 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10005 | 10005 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_status | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 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 | 11003 | 11003 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
session_id | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 1999 | 1999 | 2013 | 2015 | 2015 | 2013 | 2013 | 2015 | 2013 | 2009 | 2009 | 2009 | 2009 | 2009 | 2011 | 2009 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2013 | 2013 | 2015 | 2011 | 2011 | 2013 | 2013 | 2013 | 2013 | 2013 | 2015 | 2017 | 2019 | 2019 | 2019 | 2019 | 2019 | 2017 | 2015 | 2015 | 2015 | 2015 | 2017 | 2015 | 2017 | 2017 | 2017 | 2019 | 2017 | 2017 | 2017 | 2019 | 2021 | 2021 | 2019 | 2019 | 2021 | 2019 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
user_id | * | * | * | CFLAGG | GGILMORE | TTHAM | SARRIAGA | GPEREZ | DHORRELL | * | SARRIAGA | * | LTHIBAUL | LTHIBAUL | * | * | LTHIBAUL | LTHIBAUL | LTHIBAUL | COMPLETED | YBONILLA | EMCENTEE | ASAETERN | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | GPEREZ | AGLADNEY | YRODRIGU | YRODRIGU | ASAETERN | ASAETERN | ASAETERN | YRODRIGU | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | MPACHECO | CAFILER | AGLADNEY | ASAETERN | CAFILER | AGLADNEY | AGLADNEY | ASAETERN | GPEREZ | AGLADNEY | AGLADNEY | VUKSTINA | VUKSTINA | VUKSTINA | JMAVES | DMCCASTL | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | YRODRIGU | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | VUKSTINA | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | MMERCHANT | MMERCHANT | GTAYLOR | VUKSTINA | MKIRKHAM | GTAYLOR | CHATRIDGE | GTAYLOR | CAFILER | RATTIYEH | CAFILER | CAFILER | CAFILER | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
special_audit | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11002 | 11003 | 11003 | 11003 | 11002 | 11002 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fine_audit | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 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 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_start | 1999-07-01 00:00:00 | 1999-04-01 00:00:00 | 1999-01-01 00:00:00 | 1999-10-01 00:00:00 | 2000-01-01 00:00:00 | 2000-04-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2001-10-01 00:00:00 | 2001-10-01 00:00:00 | 1900-01-01 00:00:00 | 2002-01-01 00:00:00 | 2002-04-01 00:00:00 | 2002-01-01 00:00:00 | 2002-04-01 00:00:00 | 2002-07-01 00:00:00 | 2002-07-01 00:00:00 | 2001-10-01 00:00:00 | 2002-10-01 00:00:00 | 2002-10-01 00:00:00 | 1999-01-01 00:00:00 | 1999-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 | 1900-01-01 00:00:00 | 2014-07-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2010-04-01 00:00:00 | 2010-01-01 00:00:00 | 2010-07-01 00:00:00 | 1900-01-01 00:00:00 | 2010-10-01 00:00:00 | 2011-07-01 00:00:00 | 2011-04-01 00:00:00 | 2011-01-01 00:00:00 | 2011-10-01 00:00:00 | 2012-01-01 00:00:00 | 2012-04-01 00:00:00 | 2013-10-01 00:00:00 | 2014-10-01 00:00:00 | 2014-12-30 00:00:00 | 2012-07-01 00:00:00 | 2012-10-01 00:00:00 | 2012-12-31 00:00:00 | 2014-01-01 00:00:00 | 2014-01-01 00:00:00 | 2013-01-01 00:00:00 | 1900-01-01 00:00:00 | 2015-07-01 00:00:00 | 2018-04-01 00:00:00 | 2020-01-01 00:00:00 | 2019-10-01 00:00:00 | 2019-04-01 00:00:00 | 2020-07-01 00:00:00 | 1900-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 | 1900-01-01 00:00:00 | 2016-10-01 00:00:00 | 2017-04-01 00:00:00 | 2017-01-01 00:00:00 | 2017-07-01 00:00:00 | 2019-07-01 00:00:00 | 2018-01-01 00:00:00 | 2017-10-01 00:00:00 | 2018-10-01 00:00:00 | 2019-04-01 00:00:00 | 2020-12-31 00:00:00 | 1900-01-01 00:00:00 | 2020-04-01 00:00:00 | 2019-01-01 00:00:00 | 2021-04-01 00:00:00 | 2020-10-01 00:00:00 | 2021-01-01 00:00:00 | 2021-07-01 00:00:00 | 2022-01-01 00:00:00 | 2021-10-01 00:00:00 | 2022-04-01 00:00:00 | 2022-07-01 00:00:00 | 2022-07-01 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_end | 1999-09-30 00:00:00 | 1999-06-30 00:00:00 | 1999-03-31 00:00:00 | 1999-12-31 00:00:00 | 2000-03-31 00:00:00 | 2000-06-30 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2001-12-31 00:00:00 | 2001-12-31 00:00:00 | 1900-01-01 00:00:00 | 2002-03-31 00:00:00 | 2002-06-30 00:00:00 | 2002-03-31 00:00:00 | 2002-06-30 00:00:00 | 2002-09-30 00:00:00 | 2002-09-30 00:00:00 | 2001-12-31 00:00:00 | 2002-12-31 00:00:00 | 2002-12-31 00:00:00 | 1999-03-31 00:00:00 | 1999-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 | 1900-01-01 00:00:00 | 2014-09-30 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2010-06-30 00:00:00 | 2010-03-31 00:00:00 | 2010-09-30 00:00:00 | 1900-01-01 00:00:00 | 2010-12-31 00:00:00 | 2011-09-30 00:00:00 | 2011-06-30 00:00:00 | 2011-03-31 00:00:00 | 2011-12-31 00:00:00 | 2012-03-31 00:00:00 | 2012-06-30 00:00:00 | 2013-12-31 00:00:00 | 2014-12-31 00:00:00 | 2014-12-30 00:00:00 | 2012-09-30 00:00:00 | 2012-12-31 00:00:00 | 2012-12-31 00:00:00 | 2014-03-31 00:00:00 | 2014-03-31 00:00:00 | 2013-03-31 00:00:00 | 1900-01-01 00:00:00 | 2015-09-30 00:00:00 | 2018-06-30 00:00:00 | 2020-03-31 00:00:00 | 2019-12-31 00:00:00 | 2019-06-30 00:00:00 | 2020-09-30 00:00:00 | 1900-01-01 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 | 1900-01-01 00:00:00 | 2016-12-31 00:00:00 | 2017-06-30 00:00:00 | 2017-03-31 00:00:00 | 2017-09-30 00:00:00 | 2019-09-30 00:00:00 | 2018-03-31 00:00:00 | 2017-12-31 00:00:00 | 2018-12-31 00:00:00 | 2019-06-30 00:00:00 | 2020-12-31 00:00:00 | 1900-01-01 00:00:00 | 2020-06-30 00:00:00 | 2019-03-31 00:00:00 | 2021-06-30 00:00:00 | 2020-12-31 00:00:00 | 2021-03-31 00:00:00 | 2021-09-30 00:00:00 | 2022-03-31 00:00:00 | 2021-12-31 00:00:00 | 2022-06-30 00:00:00 | 2022-09-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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_type | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 22001 | None | None | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | None | None | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 |
filer_id | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
session_id | 1999 | 2001 | 2017 | 2013 | 2009 | 2011 | 2015 | 2019 | 2023 | 2021 | ||||||||||
interest_cd | 40306 | 40306 | 40306 | 40306 | 40306 | 40306 | 40306 | 40306 | 40306 | 40306 | ||||||||||
effect_date | 1999-02-01 00:00:00 | 2001-12-01 00:00:00 | 2017-01-01 00:00:00 | 2013-01-01 00:00:00 | 2010-02-11 00:00:00 | 2011-01-01 00:00:00 | 2015-01-01 00:00:00 | 2019-01-01 00:00:00 | 2023-01-01 00:00:00 | 2021-01-01 00:00:00 |
filer_id | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_type | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | ||||||||||
active | T | Y | Y | Y | Y | Y | Y | Y | Y | N | ||||||||||
race | 0 | 0 | 0 | None | None | None | None | None | None | None | ||||||||||
session_id | 1999 | 2001 | 2009 | 2013 | 2011 | 2021 | 2015 | 2019 | 2017 | 2023 | ||||||||||
category | 0 | 0 | 0 | None | None | None | None | None | None | None | ||||||||||
category_type | 0 | 0 | 0 | None | None | None | None | None | None | None | ||||||||||
sub_category | 0 | 0 | 0 | None | None | None | None | None | None | None | ||||||||||
effect_dt | 1999-02-01 00:00:00 | 2001-12-01 00:00:00 | 2010-02-11 00:00:00 | 2013-01-01 00:00:00 | 2011-01-01 00:00:00 | 2021-01-01 00:00:00 | 2015-01-01 00:00:00 | 2019-01-01 00:00:00 | 2017-01-01 00:00:00 | 2023-01-01 00:00:00 | ||||||||||
sub_category_type | 0 | 0 | 0 | None | None | None | None | None | None | None | ||||||||||
election_type | 0 | 0 | 0 | None | None | None | None | None | None | None | ||||||||||
sub_category_a | None | None | None | None | None | None | None | None | None | None | ||||||||||
nyq_dt | None | 2001-10-01 00:00:00 | 2001-10-01 00:00:00 | None | None | None | None | None | None | None | ||||||||||
party_cd | None | None | None | None | None | None | None | None | None | None | ||||||||||
county_cd | None | None | None | None | None | None | None | None | None | None | ||||||||||
district_cd | None | None | None | None | None | None | None | None | None | None |
filer_id | 1146249 | |
---|---|---|
xref_id | C27799 | |
effect_dt | 1999-12-08 00:00:00 | |
migration_source | MASTER |
xref_filer_id | C27799 | C27799 | C27799 | C27799 | C27799 | C27799 | C27799 | C27799 | C27799 | C27799 | C27799 | C27799 | C27799 | C27799 | C27799 | C27799 | C27799 | C27799 | C27799 | C27799 | C27799 | C27799 | C27799 | C27799 | C27799 | C27799 | C27799 | C27799 | C27799 | C27799 | C27799 | C27799 | C27799 | C27799 | C27799 | C27799 | C27799 | C27799 | C27799 | C27799 | C27799 | C27799 | C27799 | C27799 | C27799 | C27799 | C27799 | C27799 | C27799 | C27799 | C27799 | C27799 | C27799 | C27799 | C27799 | C27799 | C27799 | C27799 | C27799 | C27799 | C27799 | C27799 | C27799 | C27799 | C27799 | C27799 | C27799 | C27799 | C27799 | C27799 | C27799 | C27799 | C27799 | C27799 | C27799 | C27799 | C27799 | C27799 | C27799 | C27799 | C27799 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_id | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
naml | CHILDREN'S HOSPITAL OAKLAND | CHILDREN'S HOSPITAL OAKLAND | CHILDREN'S HOSPITAL OAKLAND | CHILDREN'S HOSPITAL OAKLAND | CHILDREN'S HOSPITAL OAKLAND | CHILDREN'S HOSPITAL OAKLAND | CHILDREN'S HOSPITAL OAKLAND | CHILDREN'S HOSPITAL OAKLAND | CHILDREN'S HOSPITAL OAKLAND | CHILDREN'S HOSPITAL - OAKLAND | CHILDREN'S HOSPITAL - OAKLAND | CHILDREN'S HOSPITAL - OAKLAND | CHILDREN'S HOSPITAL - OAKLAND | CHILDREN'S HOSPITAL - OAKLAND | CHILDREN'S HOSPITAL - OAKLAND | CHILDREN'S HOSPITAL - OAKLAND | CHILDREN'S HOSPITAL - OAKLAND | CHILDREN'S HOSPITAL - OAKLAND | CHILDREN'S HOSPITAL OAKLAND | CHILDREN'S HOSPITAL OAKLAND | CHILDREN'S HOSPITAL OAKLAND | CHILDREN'S HOSPITAL OAKLAND | CHILDREN'S HOSPITAL OAKLAND | CHILDREN'S HOSPITAL OAKLAND | CHILDREN'S HOSPITAL OAKLAND | CHILDREN'S HOSPITAL OAKLAND | CHILDREN'S HOSPITAL OAKLAND | CHILDREN'S HOSPITAL OAKLAND | CHILDREN'S HOSPITAL OAKLAND | CHILDREN'S HOSPITAL OAKLAND | CHILDREN'S HOSPITAL OAKLAND | CHILDREN'S HOSPITAL OAKLAND | CHILDREN'S HOSPITAL OAKLAND | CHILDREN'S HOSPITAL OAKLAND | CHILDREN'S HOSPITAL OAKLAND | CHILDREN'S HOSPITAL OAKLAND | CHILDREN'S HOSPITAL OAKLAND | CHILDREN'S HOSPITAL OAKLAND | CHILDREN'S HOSPITAL OAKLAND | CHILDREN'S HOSPITAL OAKLAND | CHILDREN'S HOSPITAL OAKLAND | CHILDREN'S HOSPITAL OAKLAND | CHILDREN'S HOSPITAL OAKLAND | CHILDREN'S HOSPITAL OAKLAND | CHILDREN'S HOSPITAL OAKLAND | CHILDREN'S HOSPITAL OAKLAND | CHILDREN'S HOSPITAL OAKLAND | CHILDREN'S HOSPITAL OAKLAND | CHILDREN'S HOSPITAL OAKLAND | CHILDREN'S HOSPITAL OAKLAND | CHILDREN'S HOSPITAL OAKLAND | CHILDREN'S HOSPITAL OAKLAND | CHILDREN'S HOSPITAL OAKLAND | CHILDREN'S HOSPITAL OAKLAND | CHILDREN'S HOSPITAL OAKLAND | CHILDREN'S HOSPITAL OAKLAND | CHILDREN'S HOSPITAL OAKLAND | CHILDREN'S HOSPITAL OAKLAND | CHILDREN'S HOSPITAL OAKLAND | CHILDREN'S HOSPITAL OAKLAND | CHILDREN'S HOSPITAL OAKLAND | CHILDREN'S HOSPITAL OAKLAND | CHILDREN'S HOSPITAL OAKLAND | CHILDREN'S HOSPITAL OAKLAND | CHILDREN'S HOSPITAL OAKLAND | CHILDREN'S HOSPITAL OAKLAND | CHILDREN'S HOSPITAL OAKLAND | CHILDREN'S HOSPITAL OAKLAND | CHILDREN'S HOSPITAL OAKLAND | CHILDREN'S HOSPITAL OAKLAND | CHILDREN'S HOSPITAL OAKLAND | CHILDREN'S HOSPITAL OAKLAND | CHILDREN'S HOSPITAL OAKLAND | CHILDREN'S HOSPITAL OAKLAND | CHILDREN'S HOSPITAL OAKLAND | CHILDREN'S HOSPITAL OAKLAND | CHILDREN'S HOSPITAL OAKLAND | CHILDREN'S HOSPITAL OAKLAND | CHILDREN'S HOSPITAL OAKLAND | CHILDREN'S HOSPITAL OAKLAND | CHILDREN'S HOSPITAL OAKLAND | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
city | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
zip4 | 94609 | 94609 | 94609 | 94609 | 94609 | 94609 | 94609 | 94609 | 94609 | 94609 | 94609 | 94609 | 94609 | 94609 | 94609 | 94609 | 94609 | 94609 | 94609 | 94609 | 94609 | 94609 | 94609 | 94609 | 94609 | 94609 | 94609 | 94609 | 94609 | 94609 | 94609 | 94609 | 94609 | 94609 | 94609 | 94609 | 94609 | 94609 | 94609 | 94609 | 94609 | 94609 | 94609 | 94609 | 94609 | 94609 | 94609 | 94609 | 94609 | 94609 | 94609 | 94609 | 94609 | 94609 | 94609 | 94609 | 94609 | 94609 | 94609 | 94609 | 94609 | 94609 | 94609 | 94609 | 94609 | 94609 | 94609 | 94609 | 94609 | 94609 | 94609 | 94609 | 94609 | 94609 | 94609 | 94609 | 94609 | 94609 | 94609 | 94609 | 94609 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
phon | 5104283461 | 5104283461 | 5104283461 | 5104283461 | 5104283461 | 5104283461 | 5104283461 | 5104283461 | 5104283461 | 5104283461 | 5104283461 | 5104283461 | 5104283461 | 5104283461 | 5104283461 | 5104283461 | 5104283461 | 5104283461 | 5104283461 | 5104283461 | 5104283461 | 5104283461 | 5104283461 | 5104283461 | 5104283461 | 5104283461 | 5104283461 | 5104283461 | 5104283461 | 5104283461 | 5104283461 | 5104283461 | 5104283461 | 5104283461 | 5104283461 | 5104283461 | 5104283461 | 5104283461 | 5104283461 | 5104283461 | 5104283461 | 5104283461 | 5104283461 | 5104283461 | 5104283461 | 5104283461 | 5104283461 | 5104283461 | 5104283461 | 5104283461 | 5104283461 | 5104283461 | 5104283461 | 5104283461 | 5104283461 | 5104283461 | 5104283461 | 5104283461 | 5104283461 | 5104283461 | 5104283461 | 5104283461 | 5104283461 | 5104283461 | 5104283461 | 5104283461 | 5104283461 | 5104283461 | 5104283461 | 5104283461 | 5104283461 | 5104283461 | 5104283461 | 5104283461 | 5104283461 | 5104283461 | 5104283461 | 5104283461 | 5104283461 | 5104283461 | 5104283461 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fax | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None |
filer_id | 1146249 |
---|
filer_id | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | ||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
change_no | 2 | 0 | 5 | 6 | 4 | 7 | ||||||
session_id | 1999 | 2001 | 2001 | 2001 | 1999 | 2021 | ||||||
log_dt | 2000-10-31 00:00:00 | 2001-12-12 00:00:00 | 2001-12-14 00:00:00 | 2002-01-08 00:00:00 | 2001-12-12 00:00:00 | 2020-12-28 00:00:00 | ||||||
filer_type | 1 | 1 | 1 | 1 | 1 | 1 | ||||||
correction_flg | Y | Y | None | Y | None | None | ||||||
action | TERMINATED | ADDED | CHANGED | ADDED | CHANGED | CHANGED | ||||||
attribute_changed | BASE RECORD | EMPLOYER | RESPONSIBLE OFFICER | EMPLOYER | ADDRESS | RESPONSIBLE OFFICER | ||||||
ethics_dt | None | None | None | None | None | None | ||||||
interests | None | None | None | None | None | None | ||||||
filer_full_name | CHILDREN'S HOSPITAL OAKLAND | CHILDREN'S HOSPITAL OAKLAND | CHILDREN'S HOSPITAL OAKLAND | CHILDREN'S HOSPITAL OAKLAND | FILER INFORMATION | CHILDREN'S HOSPITAL OAKLAND | ||||||
filer_city | None | None | None | None | OAKLAND | None | ||||||
filer_st | None | None | None | None | CA | None | ||||||
filer_zip | None | None | None | 94609 | None | |||||||
filer_phone | None | None | None | 5104283461 | None | |||||||
entity_type | 1 | 2 | 20 | 2 | 1 | 20 | ||||||
entity_name | CHILDREN'S HOSPITAL OAKLAND | ARNOLD & ASSOCIATES | VICE PRESIDENT PEGGY BAXTER | COWGER & ASSOCIATES | None | CHIEF FINANCIAL OFFICER TED WANG | ||||||
entity_city | None | None | None | None | None | None | ||||||
entity_st | None | None | None | None | None | None | ||||||
entity_zip | None | None | None | None | None | None | ||||||
entity_phone | None | None | None | None | None | None | ||||||
entity_id | 0 | 1147311 | 1241558 | None | 0 | 1436767 | ||||||
responsible_officer | None | None | None | None | None | None | ||||||
effect_dt | None | 2001-12-01 00:00:00 | 2001-12-01 00:00:00 | 2001-12-01 00:00:00 | 1999-02-01 00:00:00 | 2021-01-01 00:00:00 |
filer_id | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | 1146249 | |||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_file_name | 813505_0.cal | 839247_0.cal | 852939_0.cal | 880724_0.cal | 911717_0.cal | 1504627_0.cal | 1485442_0.cal | 1739950_0.cal | 1677916_0.cal | 1538729_0.cal | 1578153_0.cal | 1603484_0.cal | 1589834_0.cal | 1619318_0.cal | 1634963_0.cal | 1656041_0.cal | 1706715_0.cal | 42523.cal | 2674808_0.cal | 2734415_1.cal | 2734415_0.cal | 71426.cal | 2621411_0.cal | 2705400_0.cal | 2641703_0.cal | |||||||||||||||||||||||||
received_date | 2002-01-31 00:00:00 | 2002-04-30 00:00:00 | 2002-07-29 00:00:00 | 2002-10-27 00:00:00 | 2003-01-31 00:00:00 | 2010-07-28 00:00:00 | 2010-04-30 00:00:00 | 2013-01-31 00:00:00 | 2012-07-30 00:00:00 | 2010-10-29 00:00:00 | 2011-02-22 00:00:00 | 2011-07-26 00:00:00 | 2011-04-28 00:00:00 | 2011-10-25 00:00:00 | 2012-01-30 00:00:00 | 2012-04-27 00:00:00 | 2012-10-29 00:00:00 | 2015-01-30 00:00:00 | 2022-04-29 00:00:00 | 2022-10-16 00:00:00 | 2022-10-16 00:00:00 | 2022-04-29 00:00:00 | 2021-10-28 00:00:00 | 2022-07-30 00:00:00 | 2022-01-28 00:00:00 | |||||||||||||||||||||||||
filing_directory | /usr/users/cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | |||||||||||||||||||||||||
filing_id | 813505 | 839247 | 852939 | 880724 | 911717 | 1504627 | 1485442 | 1739950 | 1677916 | 1538729 | 1578153 | 1603484 | 1589834 | 1619318 | 1634963 | 1656041 | 1706715 | None | 2674808 | 2734415 | 2734415 | None | 2621411 | 2705400 | 2641703 | |||||||||||||||||||||||||
form_id | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | None | F635 | F635 | F635 | None | F635 | F635 | F635 | |||||||||||||||||||||||||
receive_comment | Filing accepted | Filing accepted | Filing accepted, but with warnings | Filing accepted, but with warnings | Filing accepted, but with warnings | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing passed validation, but failed DB constraints | Filing accepted | Filing accepted | Filing accepted | Filing passed validation, but failed DB constraints | Filing accepted | Filing accepted | Filing accepted |