filer_id | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
adrid | 1113307 | 2138297 | 2178714 | 2205306 | 2217053 | 2415365 | 2278177 | 2515120 | 2341754 | 2550687 | 2471975 | |||||||||||
effect_dt | 1998-06-01 00:00:00 | 2008-05-23 00:00:00 | 2010-02-01 00:00:00 | 2011-01-01 00:00:00 | 2011-06-15 00:00:00 | 2017-01-01 00:00:00 | 2013-01-01 00:00:00 | 2021-01-01 00:00:00 | 2015-01-01 00:00:00 | 2023-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 | 1997 | 2007 | 2009 | 2011 | 2011 | 2017 | 2013 | 2021 | 2015 | 2023 | 2019 |
filer_id | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 494622 | 490979 | 498204 | 1774120 | 1755011 | 1959890 | 1975476 | 1810470 | 1795539 | 1949303 | 1337941 | 1337943 | 1349146 | 1372225 | 1393371 | 1468881 | 1469497 | 1506108 | 1484739 | 1540199 | 1561494 | 1506108 | 1559631 | 1589268 | 1598300 | 1571371 | 1618906 | 1629377 | 1606393 | 1655124 | 1675097 | 1931603 | 1902424 | 1921297 | 1706190 | 1863521 | 1733105 | 1741977 | 1721240 | 1842258 | 1991786 | 2311713 | 2005705 | 2033212 | 2056524 | 2090783 | 2090783 | 2124616 | 2143405 | 2150428 | 2155165 | 2167934 | 2266676 | 2543712 | 2232002 | 2335005 | 2524839 | 2477132 | 2540499 | 2186419 | 2330260 | 2232002 | 2399045 | 2377019 | 2204948 | 2414730 | 2437191 | 2359718 | 2620627 | 2641246 | 2567706 | 2466687 | 2594315 | 2577684 | 2612881 | 2543712 | 2594315 | 2675970 | 2577684 | 2701763 | 2620627 | 2626928 | 2626930 | 2701763 | 2744883 | 2744883 | 2675970 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
period_id | 155 | 154 | 156 | 214 | 213 | 221 | 222 | 216 | 215 | None | None | None | 194 | 195 | 196 | 201 | None | 202 | 201 | 203 | None | 202 | 204 | 205 | None | 204 | 207 | 208 | 206 | 209 | 210 | 220 | 219 | 220 | 211 | 218 | 212 | None | 213 | 217 | 223 | 235 | 224 | 225 | 226 | 227 | 227 | 228 | None | 228 | 229 | 230 | 234 | 244 | 233 | 236 | 243 | 242 | 244 | 231 | 236 | 233 | 238 | 237 | 232 | 239 | 240 | None | 247 | 248 | None | 241 | 246 | 245 | 247 | 244 | 246 | 249 | 245 | 250 | 247 | None | None | 250 | 251 | 251 | 249 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F602 | F999 | F635 | F635 | F635 | F602 | F602 | F635 | F635 | F635 | F602 | F635 | F602 | F635 | F605 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F602 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F602 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F999 | F602 | 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 | 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 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_date | 1998-11-02 00:00:00 | 1998-07-29 00:00:00 | 1999-01-28 00:00:00 | 2013-07-09 00:00:00 | 2013-04-05 00:00:00 | 2015-04-21 00:00:00 | 2015-07-21 00:00:00 | 2014-01-16 00:00:00 | 2013-10-18 00:00:00 | 2014-12-30 00:00:00 | 2008-05-27 00:00:00 | 2008-05-28 00:00:00 | 2008-07-30 00:00:00 | 2008-10-26 00:00:00 | 2009-01-28 00:00:00 | 2010-02-10 00:00:00 | 2010-02-10 00:00:00 | 2010-07-30 00:00:00 | 2010-04-30 00:00:00 | 2010-11-01 00:00:00 | 2011-01-13 00:00:00 | 2010-11-01 00:00:00 | 2011-01-13 00:00:00 | 2011-04-28 00:00:00 | 2011-06-23 00:00:00 | 2011-01-31 00:00:00 | 2011-10-24 00:00:00 | 2012-01-19 00:00:00 | 2011-07-29 00:00:00 | 2012-04-26 00:00:00 | 2012-07-26 00:00:00 | 2015-01-28 00:00:00 | 2014-10-22 00:00:00 | 2014-12-29 00:00:00 | 2012-10-29 00:00:00 | 2014-07-16 00:00:00 | 2013-01-28 00:00:00 | 2012-12-28 00:00:00 | 2012-12-28 00:00:00 | 2014-04-28 00:00:00 | 2015-10-13 00:00:00 | 2018-10-24 00:00:00 | 2016-01-22 00:00:00 | 2016-04-27 00:00:00 | 2016-07-20 00:00:00 | 2016-10-18 00:00:00 | 2016-11-03 00:00:00 | 2017-01-26 00:00:00 | 2016-12-29 00:00:00 | 2017-04-11 00:00:00 | 2017-04-28 00:00:00 | 2017-07-17 00:00:00 | 2018-07-19 00:00:00 | 2021-01-12 00:00:00 | 2018-04-17 00:00:00 | 2019-01-17 00:00:00 | 2020-10-28 00:00:00 | 2020-07-07 00:00:00 | 2020-12-30 00:00:00 | 2017-10-04 00:00:00 | 2018-12-28 00:00:00 | 2019-03-12 00:00:00 | 2019-07-31 00:00:00 | 2019-04-25 00:00:00 | 2018-01-24 00:00:00 | 2019-10-23 00:00:00 | 2020-01-28 00:00:00 | 2018-12-28 00:00:00 | 2021-12-20 00:00:00 | 2022-01-28 00:00:00 | 2020-12-30 00:00:00 | 2020-04-21 00:00:00 | 2021-07-19 00:00:00 | 2021-04-27 00:00:00 | 2021-09-27 00:00:00 | 2021-12-20 00:00:00 | 2021-12-20 00:00:00 | 2022-05-02 00:00:00 | 2021-12-20 00:00:00 | 2022-07-27 00:00:00 | 2021-10-27 00:00:00 | 2021-09-29 00:00:00 | 2021-09-29 00:00:00 | 2022-10-28 00:00:00 | 2022-10-28 00:00:00 | 2022-10-28 00:00:00 | 2022-10-28 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_type | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10005 | 10005 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10005 | 10002 | 10001 | 10001 | 10006 | 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 | 10001 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10002 | 10002 | 10001 | 10002 | 10001 | 10001 | 10005 | 10005 | 10002 | 10002 | 10001 | 10002 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | 11001 | 11001 | 11001 | 11003 | 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 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
session_id | 1997 | 1997 | 1997 | 2013 | 2013 | 2015 | 2015 | 2013 | 2013 | 2015 | 2007 | 2007 | 2007 | 2007 | 2007 | 2009 | 2009 | 2009 | 2009 | 2009 | 2011 | 2009 | 2011 | 2011 | 2011 | 2009 | 2011 | 2011 | 2011 | 2011 | 2011 | 2013 | 2013 | 2015 | 2011 | 2013 | 2011 | 2013 | 2013 | 2013 | 2015 | 2017 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2017 | 2017 | 2017 | 2017 | 2017 | 2019 | 2017 | 2017 | 2019 | 2019 | 2021 | 2017 | 2019 | 2017 | 2019 | 2019 | 2017 | 2019 | 2019 | 2019 | 2021 | 2021 | 2021 | 2019 | 2021 | 2021 | 2021 | 2019 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
user_id | * | * | * | AGLADNEY | AGLADNEY | MPACHECO | MPACHECO | AGLADNEY | AGLADNEY | GPEREZ | YRODRIGU | YRODRIGU | YRODRIGU | JINGRAM | JINGRAM | YRODRIGU | YRODRIGU | ASAETERN | ASAETERN | ASAETERN | YRODRIGU | ASAETERN | YRODRIGU | AGLADNEY | YRODRIGU | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | CAFILER | AGLADNEY | AGLADNEY | ASAETERN | SARRIAGA | SARRIAGA | AGLADNEY | MPACHECO | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | YRODRIGU | CAFILER | AGLADNEY | AGLADNEY | AGLADNEY | GTAYLOR | AGLADNEY | AGLADNEY | GTAYLOR | VUKSTINA | MMERCHANT | AGLADNEY | CAFILER | AGLADNEY | VUKSTINA | SUSHAKOV | AGLADNEY | VUKSTINA | VUKSTINA | DMCCASTL | MKIRKHAM | CHATRIDGE | MMERCHANT | VUKSTINA | GTAYLOR | CHATRIDGE | MKIRKHAM | CAFILER | GTAYLOR | CAFILER | CHATRIDGE | CAFILER | MKIRKHAM | MKIRKHAM | MKIRKHAM | CAFILER | CAFILER | CAFILER | CAFILER | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
special_audit | 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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fine_audit | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_start | 1998-07-01 00:00:00 | 1998-04-01 00:00:00 | 1998-10-01 00:00:00 | 2013-04-01 00:00:00 | 2013-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-04-01 00:00:00 | 2013-10-01 00:00:00 | 2013-07-01 00:00:00 | 1900-01-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-10-01 00:00:00 | 2010-02-10 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-04-01 00:00:00 | 2010-11-19 00:00:00 | 2011-01-01 00:00:00 | 1900-01-01 00:00:00 | 2010-10-01 00:00:00 | 2011-07-01 00:00:00 | 2011-10-01 00:00:00 | 2011-04-01 00:00:00 | 2012-01-01 00:00:00 | 2012-04-01 00:00:00 | 2014-10-01 00:00:00 | 2014-07-01 00:00:00 | 2014-11-06 00:00:00 | 2012-07-01 00:00:00 | 2014-04-01 00:00:00 | 2012-10-01 00:00:00 | 1900-01-01 00:00:00 | 2013-01-01 00:00:00 | 2014-01-01 00:00:00 | 2015-07-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 | 2016-07-01 00:00:00 | 2016-10-01 00:00:00 | 1900-01-01 00:00:00 | 2016-11-10 00:00:00 | 2017-01-01 00:00:00 | 2017-04-01 00:00:00 | 2018-04-01 00:00:00 | 2020-10-01 00:00:00 | 2018-01-01 00:00:00 | 2018-10-01 00:00:00 | 2020-07-01 00:00:00 | 2020-04-01 00:00:00 | 2020-11-15 00:00:00 | 2017-07-01 00:00:00 | 2018-11-26 00:00:00 | 2018-01-01 00:00:00 | 2019-04-01 00:00:00 | 2019-01-01 00:00:00 | 2017-10-01 00:00:00 | 2019-07-01 00:00:00 | 2019-10-01 00:00:00 | 1900-01-01 00:00:00 | 2021-07-01 00:00:00 | 2021-10-01 00:00:00 | 1900-01-01 00:00:00 | 2020-01-01 00:00:00 | 2021-04-01 00:00:00 | 2021-01-01 00:00:00 | 2021-09-27 00:00:00 | 2020-10-01 00:00:00 | 2021-04-01 00:00:00 | 2022-01-01 00:00:00 | 2021-01-01 00:00:00 | 2022-04-01 00:00:00 | 2021-07-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2022-04-01 00:00:00 | 2022-07-01 00:00:00 | 2022-07-01 00:00:00 | 2022-01-01 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_end | 1998-09-30 00:00:00 | 1998-06-30 00:00:00 | 1998-12-31 00:00:00 | 2013-06-30 00:00:00 | 2013-03-31 00:00:00 | 2015-03-31 00:00:00 | 2015-06-30 00:00:00 | 2013-12-31 00:00:00 | 2013-09-30 00:00:00 | 1900-01-01 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-12-31 00:00:00 | 2010-02-10 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-06-30 00:00:00 | 2010-11-19 00:00:00 | 2011-03-31 00:00:00 | 1900-01-01 00:00:00 | 2010-12-31 00:00:00 | 2011-09-30 00:00:00 | 2011-12-31 00:00:00 | 2011-06-30 00:00:00 | 2012-03-31 00:00:00 | 2012-06-30 00:00:00 | 2014-12-31 00:00:00 | 2014-09-30 00:00:00 | 2014-11-06 00:00:00 | 2012-09-30 00:00:00 | 2014-06-30 00:00:00 | 2012-12-31 00:00:00 | 1900-01-01 00:00:00 | 2013-01-01 00:00:00 | 2014-03-31 00:00:00 | 2015-09-30 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 | 2016-09-30 00:00:00 | 2016-12-31 00:00:00 | 1900-01-01 00:00:00 | 2016-11-10 00:00:00 | 2017-03-31 00:00:00 | 2017-06-30 00:00:00 | 2018-06-30 00:00:00 | 2020-12-31 00:00:00 | 2018-03-31 00:00:00 | 2018-12-31 00:00:00 | 2020-09-30 00:00:00 | 2020-06-30 00:00:00 | 2020-11-15 00:00:00 | 2017-09-30 00:00:00 | 2018-11-26 00:00:00 | 2018-03-31 00:00:00 | 2019-06-30 00:00:00 | 2019-03-31 00:00:00 | 2017-12-31 00:00:00 | 2019-09-30 00:00:00 | 2019-12-31 00:00:00 | 1900-01-01 00:00:00 | 2021-09-30 00:00:00 | 2021-12-31 00:00:00 | 1900-01-01 00:00:00 | 2020-03-31 00:00:00 | 2021-06-30 00:00:00 | 2021-03-31 00:00:00 | 2021-09-27 00:00:00 | 2020-12-31 00:00:00 | 2021-06-30 00:00:00 | 2022-03-31 00:00:00 | 2021-03-31 00:00:00 | 2022-06-30 00:00:00 | 2021-09-30 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2022-06-30 00:00:00 | 2022-09-30 00:00:00 | 2022-09-30 00:00:00 | 2022-03-31 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 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | None | None | 22001 | 22001 | 22001 | 22006 | None | 22006 | 22006 | 22001 | None | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22006 | 22006 | 22001 | 22006 | 22006 | 22006 | None | 22001 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22001 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22001 | 22006 | 22001 | 22001 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | None | 22006 | 22006 | 22006 | 22006 |
filer_id | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
session_id | 1997 | 2013 | 2007 | 2011 | 2009 | 2019 | 2015 | 2017 | 2023 | 2021 | ||||||||||
interest_cd | 40306 | 40310 | 40306 | 40310 | 40310 | 40310 | 40310 | 40310 | 40310 | 40310 | ||||||||||
effect_date | 1998-06-01 00:00:00 | 2013-01-01 00:00:00 | 2008-05-23 00:00:00 | 2011-01-01 00:00:00 | 2010-02-01 00:00:00 | 2019-01-01 00:00:00 | 2015-01-01 00:00:00 | 2017-01-01 00:00:00 | 2023-01-01 00:00:00 | 2021-01-01 00:00:00 |
filer_id | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_type | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | ||||||||||
active | Y | Y | Y | Y | Y | Y | Y | Y | Y | N | ||||||||||
race | 0 | None | None | 0 | 0 | None | None | None | None | None | ||||||||||
session_id | 1997 | 2011 | 2013 | 2007 | 2009 | 2019 | 2015 | 2021 | 2017 | 2023 | ||||||||||
category | 0 | None | None | 0 | 0 | None | None | None | None | None | ||||||||||
category_type | 0 | None | None | 0 | 0 | None | None | None | None | None | ||||||||||
sub_category | 0 | None | None | 0 | 0 | None | None | None | None | None | ||||||||||
effect_dt | 1998-06-01 00:00:00 | 2011-01-01 00:00:00 | 2013-01-01 00:00:00 | 2008-05-23 00:00:00 | 2010-02-01 00:00:00 | 2019-01-01 00:00:00 | 2015-01-01 00:00:00 | 2021-01-01 00:00:00 | 2017-01-01 00:00:00 | 2023-01-01 00:00:00 | ||||||||||
sub_category_type | 0 | None | None | 0 | 0 | None | None | None | None | None | ||||||||||
election_type | 0 | None | None | 0 | 0 | None | None | None | None | None | ||||||||||
sub_category_a | None | None | None | None | None | None | None | None | None | None | ||||||||||
nyq_dt | None | None | None | 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 | 1145974 | |
---|---|---|
xref_id | C27498 | |
effect_dt | 1999-12-08 00:00:00 | |
migration_source | MASTER |
xref_filer_id | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | C27498 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_id | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filer_type | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
status | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
effect_dt | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
naml | BECTON DICKINSON AND COMPANY | BECTON DICKINSON AND COMPANY | BECTON DICKINSON AND COMPANY | BECTON DICKINSON AND COMPANY | BECTON DICKINSON AND COMPANY | BECTON DICKINSON AND COMPANY | BECTON DICKINSON AND COMPANY | BECTON DICKINSON AND COMPANY | BECTON DICKINSON AND COMPANY | BECTON DICKINSON AND COMPANY | BECTON DICKINSON AND COMPANY | BD | BD | BD | BD | BD | BD | BD | BD | BD | BD | BD | BD | BD | BD | BD | BD | BD | BD | BD | BD | BD | BD | BD | BD | BD | BD | BD | BD | BD | BD | BD | BD | BD | BECTON, DICKINSON & COMPANY (BD) | BECTON, DICKINSON & COMPANY (BD) | BECTON, DICKINSON & COMPANY (BD) | BECTON, DICKINSON & COMPANY (BD) | BECTON, DICKINSON & COMPANY (BD) | BECTON, DICKINSON & COMPANY (BD) | BECTON, DICKINSON & COMPANY (BD) | BECTON, DICKINSON & COMPANY (BD) | BECTON, DICKINSON & COMPANY (BD) | BECTON, DICKINSON & COMPANY (BD) | BECTON, DICKINSON & COMPANY (BD) | BD | BD | BD | BD | BD | BD | BD | BD | BD | BD | BD | BD | BD | BD | BD | BD | BD | BD | BD | BD | BD | BD | BD | BD | BD | BD | BD | BD | BD | BD | BD | BD | BD | BD | BD | BD | BD | BD | BD | BD | BD | BD | BD | BD | BD | BD | BD | BD | BD | BD | BD | BD | BD | BD | BD | BD AND ITS AFFILIATE, VELANO VASCULAR | BD AND ITS AFFILIATE, VELANO VASCULAR | BD AND ITS AFFILIATE, VELANO VASCULAR | BD AND ITS AFFILIATE, VELANO VASCULAR | BD AND ITS AFFILIATE, VELANO VASCULAR | BD AND ITS AFFILIATE, VELANO VASCULAR | BD AND ITS AFFILIATE, VELANO VASCULAR | BD AND ITS AFFILIATE, VELANO VASCULAR | BD AND ITS AFFILIATE, VELANO VASCULAR | BD AND ITS AFFILIATE, VELANO VASCULAR | BD AND ITS AFFILIATE, VELANO VASCULAR | BD | BD | BD | BD | BD | BD | BD | BD | BD | BD | BD | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
namf | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
namt | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
nams | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
adr1 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
adr2 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
city | Franklin Lakes | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | Franklin Lakes | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | Franklin Lakes | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | Franklin Lakes | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | Franklin Lakes | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | Franklin Lakes | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | Franklin Lakes | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | Franklin Lakes | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | Franklin Lakes | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | Franklin Lakes | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | Franklin Lakes | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | Franklin Lakes | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
st | NJ | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | NJ | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | NJ | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | NJ | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | NJ | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | NJ | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | NJ | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | NJ | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | NJ | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | NJ | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | NJ | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | NJ | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
zip4 | 07417 | 20005 | 20005 | 20005 | 20001 | 20001 | 20001 | 20001 | 20001 | 20001 | 20001 | 07417 | 20005 | 20005 | 20005 | 20001 | 20001 | 20001 | 20001 | 20001 | 20001 | 20001 | 07417 | 20005 | 20005 | 20005 | 20001 | 20001 | 20001 | 20001 | 20001 | 20001 | 20001 | 07417 | 20005 | 20005 | 20005 | 20001 | 20001 | 20001 | 20001 | 20001 | 20001 | 20001 | 07417 | 20005 | 20005 | 20005 | 20001 | 20001 | 20001 | 20001 | 20001 | 20001 | 20001 | 07417 | 20005 | 20005 | 20005 | 20001 | 20001 | 20001 | 20001 | 20001 | 20001 | 20001 | 07417 | 20005 | 20005 | 20005 | 20001 | 20001 | 20001 | 20001 | 20001 | 20001 | 20001 | 07417 | 20005 | 20005 | 20005 | 20001 | 20001 | 20001 | 20001 | 20001 | 20001 | 20001 | 07417 | 20005 | 20005 | 20005 | 20001 | 20001 | 20001 | 20001 | 20001 | 20001 | 20001 | 07417 | 20005 | 20005 | 20005 | 20001 | 20001 | 20001 | 20001 | 20001 | 20001 | 20001 | 07417 | 20005 | 20005 | 20005 | 20001 | 20001 | 20001 | 20001 | 20001 | 20001 | 20001 | 07417 | 20005 | 20005 | 20005 | 20001 | 20001 | 20001 | 20001 | 20001 | 20001 | 20001 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
phon | 2018476731 | 2027771584 | 2027771584 | 2027771595 | 2027771585 | 2027771585 | 2027771585 | 2027771585 | 2027771585 | 2027771585 | 2027771585 | 2018476731 | 2027771584 | 2027771584 | 2027771595 | 2027771585 | 2027771585 | 2027771585 | 2027771585 | 2027771585 | 2027771585 | 2027771585 | 2018476731 | 2027771584 | 2027771584 | 2027771595 | 2027771585 | 2027771585 | 2027771585 | 2027771585 | 2027771585 | 2027771585 | 2027771585 | 2018476731 | 2027771584 | 2027771584 | 2027771595 | 2027771585 | 2027771585 | 2027771585 | 2027771585 | 2027771585 | 2027771585 | 2027771585 | 2018476731 | 2027771584 | 2027771584 | 2027771595 | 2027771585 | 2027771585 | 2027771585 | 2027771585 | 2027771585 | 2027771585 | 2027771585 | 2018476731 | 2027771584 | 2027771584 | 2027771595 | 2027771585 | 2027771585 | 2027771585 | 2027771585 | 2027771585 | 2027771585 | 2027771585 | 2018476731 | 2027771584 | 2027771584 | 2027771595 | 2027771585 | 2027771585 | 2027771585 | 2027771585 | 2027771585 | 2027771585 | 2027771585 | 2018476731 | 2027771584 | 2027771584 | 2027771595 | 2027771585 | 2027771585 | 2027771585 | 2027771585 | 2027771585 | 2027771585 | 2027771585 | 2018476731 | 2027771584 | 2027771584 | 2027771595 | 2027771585 | 2027771585 | 2027771585 | 2027771585 | 2027771585 | 2027771585 | 2027771585 | 2018476731 | 2027771584 | 2027771584 | 2027771595 | 2027771585 | 2027771585 | 2027771585 | 2027771585 | 2027771585 | 2027771585 | 2027771585 | 2018476731 | 2027771584 | 2027771584 | 2027771595 | 2027771585 | 2027771585 | 2027771585 | 2027771585 | 2027771585 | 2027771585 | 2027771585 | 2018476731 | 2027771584 | 2027771584 | 2027771595 | 2027771585 | 2027771585 | 2027771585 | 2027771585 | 2027771585 | 2027771585 | 2027771585 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | [email protected] | None | None | None | None | None | None | None | None | None | None | [email protected] | None | None | None | None | None | None | None | None | None | None | [email protected] | None | None | None | None | None | None | None | None | None | None | [email protected] | None | None | None | None | None | None | None | None | None | None | [email protected] | None | None | None | None | None | None | None | None | None | None | [email protected] | None | None | None | None | None | None | None | None | None | None | [email protected] | None | None | None | None | None | None | None | None | None | None | [email protected] | None | None | None | None | None | None | None | None | None | None | [email protected] | None | None | None | None | None | None | None | None | None | None | [email protected] | None | None | None | None | None | None | None | None | None | None | [email protected] | None | None | None | None | None | None | None | None | None | None | [email protected] | None | None | None | None | None | None | None | None | None |
filer_id | 1145974 |
---|
filer_id | 1145974 | 1145974 | 1145974 | 1145974 | ||||
---|---|---|---|---|---|---|---|---|
change_no | 0 | 1 | 2 | 3 | ||||
session_id | 2007 | 2009 | 2011 | 2021 | ||||
log_dt | 2008-05-27 00:00:00 | 2010-02-10 00:00:00 | 2011-06-23 00:00:00 | 2020-12-30 00:00:00 | ||||
filer_type | 1 | 1 | 1 | 1 | ||||
correction_flg | Y | Y | Y | None | ||||
action | ADDED | ADDED | CHANGED | CHANGED | ||||
attribute_changed | FIRM | FIRM | NAME FROM | RESPONSIBLE OFFICER | ||||
ethics_dt | None | None | None | None | ||||
interests | None | None | None | None | ||||
filer_full_name | BECTON DICKINSON AND COMPANY | BD | BECTON, DICKINSON & COMPANY (BD) | BD | ||||
filer_city | None | Franklin Lakes | None | None | ||||
filer_st | None | NJ | None | None | ||||
filer_zip | None | 07417 | None | None | ||||
filer_phone | None | 2018476731 | None | None | ||||
entity_type | 3 | 3 | 2 | 20 | ||||
entity_name | CARPENTER HAWKINS SIEVERS LLC | CARPENTER HAWKINS SIEVERS LLC | BD | VICE PRESIDENT, US PUBLIC POLICY/GOVERNMENT AFFAIRS ELIZABETH K. WOODY | ||||
entity_city | None | None | None | None | ||||
entity_st | None | None | None | None | ||||
entity_zip | None | None | None | None | ||||
entity_phone | None | None | None | None | ||||
entity_id | 1275439 | None | 0 | 1339545 | ||||
responsible_officer | None | None | None | None | ||||
effect_dt | 2008-05-23 00:00:00 | 2010-02-01 00:00:00 | 2011-06-15 00:00:00 | 2021-01-01 00:00:00 |
filer_id | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | 1145974 | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_file_name | 383026.cal | 314215.cal | 314330.cal | 1540199_0.cal | 1506108_1.cal | 1589268_0.cal | 1571371_0.cal | 2232002_1.cal | ||||||||
received_date | 2008-07-30 00:00:00 | 2010-11-01 00:00:00 | 2010-11-01 00:00:00 | 2010-11-01 00:00:00 | 2010-11-01 00:00:00 | 2011-04-28 00:00:00 | 2011-01-31 00:00:00 | 2019-03-12 00:00:00 | ||||||||
filing_directory | /cafiler/disclose/ca99/temp | /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 | ||||||||
filing_id | None | None | None | 1540199 | 1506108 | 1589268 | 1571371 | 2232002 | ||||||||
form_id | None | None | None | F635 | F635 | F635 | F635 | F635 | ||||||||
receive_comment | Filing did not pass validation | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted |