filer_id | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
adrid | 1110830 | 2003950 | 2063940 | 2078441 | 2115340 | 2163179 | 2207961 | 2415956 | 2508513 | 2271398 | 2338095 | 2472521 | 2549782 | |||||||||||||
effect_dt | 1999-01-01 00:00:00 | 2000-07-01 00:00:00 | 2004-02-24 00:00:00 | 2005-01-01 00:00:00 | 2007-01-01 00:00:00 | 2009-01-01 00:00:00 | 2011-01-01 00:00:00 | 2017-01-01 00:00:00 | 2021-01-01 00:00:00 | 2013-01-01 00:00:00 | 2015-01-01 00:00:00 | 2019-01-01 00:00:00 | 2023-01-01 00:00:00 | |||||||||||||
add_type | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | |||||||||||||
session_id | 1999 | 1999 | 2003 | 2005 | 2007 | 2009 | 2011 | 2017 | 2021 | 2013 | 2015 | 2019 | 2023 |
filer_id | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 469078 | 483234 | 474607 | 494071 | 480194 | 497680 | 486749 | 490399 | 615778 | 631334 | 673050 | 660695 | 692288 | 711797 | 715943 | 744480 | 757170 | 738760 | 771386 | 781458 | 1009918 | 1002030 | 1002032 | 1000120 | 1011140 | 1026199 | 1023995 | 1049938 | 1072971 | 1069002 | 1061436 | 1095613 | 1101446 | 1082334 | 1116627 | 1163046 | 1128687 | 1142929 | 1186770 | 1231685 | 1225824 | 1244302 | 1213170 | 1261086 | 1297532 | 1289287 | 1778789 | 1962171 | 1869151 | 1951810 | 1911385 | 1327596 | 1311881 | 1311881 | 1348034 | 1391883 | 1384306 | 1378598 | 1414439 | 1419748 | 1431852 | 1458144 | 1448155 | 1482041 | 1506088 | 1540980 | 1551485 | 1551683 | 1564320 | 1608018 | 1621305 | 1587397 | 1630828 | 1652579 | 1652579 | 1678626 | 1813368 | 1796977 | 1699132 | 1933466 | 1918865 | 1718461 | 1742323 | 1728973 | 1842150 | 1763008 | 1996920 | 1982301 | 2418460 | 2193184 | 2482064 | 2527286 | 2318728 | 2341397 | 2209912 | 2398186 | 2579067 | 2276433 | 2347120 | 2380566 | 2008227 | 2037556 | 2062292 | 2101585 | 2117245 | 2121860 | 2137152 | 2175219 | 2157192 | 2471457 | 2438679 | 2551672 | 2583459 | 2334773 | 2242518 | 2541658 | 2622192 | 2704393 | 2541658 | 2674748 | 2641870 | 2599203 | 2746186 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
period_id | 157 | 152 | 158 | 155 | 159 | 156 | 153 | 154 | 160 | None | 163 | 162 | 163 | 164 | None | 165 | 165 | 164 | 166 | None | 177 | None | None | None | None | None | 178 | 179 | 180 | 180 | None | None | 181 | None | 182 | 185 | 183 | 184 | 186 | 188 | 188 | None | 187 | 189 | 191 | None | 214 | 221 | 218 | None | 219 | 193 | 192 | 192 | 194 | 196 | 196 | 195 | None | 197 | 198 | 200 | 199 | 201 | 202 | 203 | 204 | None | 204 | 206 | 207 | 205 | 208 | 209 | 209 | 210 | 216 | 215 | 211 | 220 | 220 | 212 | None | 212 | 217 | 213 | 223 | 222 | 239 | 231 | 242 | 243 | 235 | None | 232 | 238 | 245 | 234 | 236 | 237 | 224 | 225 | 226 | 227 | 228 | 228 | None | 230 | 229 | 241 | 240 | 244 | None | 236 | 233 | 246 | 247 | 250 | 244 | 249 | 248 | 246 | 251 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F999 | F602 | F602 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F602 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F602 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F602 | F602 | F635 | F602 | F635 | F635 | 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 | 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 | 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 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_date | 1999-04-28 00:00:00 | 1998-01-16 00:00:00 | 1999-07-27 00:00:00 | 1998-10-28 00:00:00 | 1999-10-18 00:00:00 | 1999-01-20 00:00:00 | 1998-04-22 00:00:00 | 1998-07-22 00:00:00 | 2000-01-31 00:00:00 | 2000-04-14 00:00:00 | 2000-10-20 00:00:00 | 2000-07-28 00:00:00 | 2000-10-19 00:00:00 | 2001-01-19 00:00:00 | 2001-01-04 00:00:00 | 2001-04-27 00:00:00 | 2001-04-27 00:00:00 | 2001-01-24 00:00:00 | 2001-07-30 00:00:00 | 2001-07-30 00:00:00 | 2004-04-20 00:00:00 | 2004-02-26 00:00:00 | 2004-02-25 00:00:00 | 2004-02-24 00:00:00 | 2004-04-22 00:00:00 | 2004-07-26 00:00:00 | 2004-07-20 00:00:00 | 2004-10-20 00:00:00 | 2005-01-18 00:00:00 | 2004-12-30 00:00:00 | 2004-10-21 00:00:00 | 2005-01-04 00:00:00 | 2005-04-20 00:00:00 | 2005-01-20 00:00:00 | 2005-07-28 00:00:00 | 2006-04-19 00:00:00 | 2005-10-18 00:00:00 | 2006-01-20 00:00:00 | 2006-07-24 00:00:00 | 2007-01-25 00:00:00 | 2007-01-02 00:00:00 | 2006-12-21 00:00:00 | 2006-10-26 00:00:00 | 2007-04-28 00:00:00 | 2007-10-31 00:00:00 | 2007-08-13 00:00:00 | 2013-07-26 00:00:00 | 2015-04-26 00:00:00 | 2014-07-29 00:00:00 | 2014-12-17 00:00:00 | 2014-10-31 00:00:00 | 2008-04-28 00:00:00 | 2008-03-03 00:00:00 | 2008-01-31 00:00:00 | 2008-07-29 00:00:00 | 2009-01-26 00:00:00 | 2008-12-18 00:00:00 | 2008-10-31 00:00:00 | 2008-12-17 00:00:00 | 2009-04-28 00:00:00 | 2009-07-20 00:00:00 | 2010-01-18 00:00:00 | 2009-10-17 00:00:00 | 2010-04-24 00:00:00 | 2010-07-30 00:00:00 | 2010-11-01 00:00:00 | 2010-12-17 00:00:00 | 2010-12-16 00:00:00 | 2011-01-24 00:00:00 | 2011-08-01 00:00:00 | 2011-10-28 00:00:00 | 2011-04-21 00:00:00 | 2012-01-23 00:00:00 | 2012-04-17 00:00:00 | 2012-04-25 00:00:00 | 2012-07-31 00:00:00 | 2014-01-26 00:00:00 | 2013-10-24 00:00:00 | 2012-10-16 00:00:00 | 2015-01-30 00:00:00 | 2014-12-18 00:00:00 | 2012-12-19 00:00:00 | 2012-12-18 00:00:00 | 2013-01-18 00:00:00 | 2014-04-28 00:00:00 | 2013-04-28 00:00:00 | 2015-10-30 00:00:00 | 2015-07-31 00:00:00 | 2019-10-30 00:00:00 | 2017-10-31 00:00:00 | 2020-07-28 00:00:00 | 2020-10-30 00:00:00 | 2018-10-31 00:00:00 | 2019-01-11 00:00:00 | 2018-01-31 00:00:00 | 2019-07-31 00:00:00 | 2021-04-29 00:00:00 | 2018-07-31 00:00:00 | 2019-01-31 00:00:00 | 2019-04-30 00:00:00 | 2016-01-27 00:00:00 | 2016-05-02 00:00:00 | 2016-07-29 00:00:00 | 2016-10-31 00:00:00 | 2017-01-04 00:00:00 | 2017-01-22 00:00:00 | 2016-12-30 00:00:00 | 2017-07-31 00:00:00 | 2017-05-01 00:00:00 | 2020-04-30 00:00:00 | 2020-01-29 00:00:00 | 2021-01-30 00:00:00 | 2021-01-04 00:00:00 | 2019-01-16 00:00:00 | 2018-04-30 00:00:00 | 2021-05-25 00:00:00 | 2021-10-29 00:00:00 | 2022-07-29 00:00:00 | 2020-12-31 00:00:00 | 2022-04-29 00:00:00 | 2022-01-29 00:00:00 | 2021-07-29 00:00:00 | 2022-10-29 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_type | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10005 | 10001 | 10005 | 10005 | 10001 | 10005 | 10001 | 10005 | 10005 | 10001 | 10005 | 10001 | 10005 | 10005 | 10005 | 10005 | 10005 | 10001 | 10001 | 10001 | 10001 | 10005 | 10005 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_status | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11003 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
session_id | 1999 | 1997 | 1999 | 1997 | 1999 | 1997 | 1997 | 1997 | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 2001 | 2001 | 2001 | 1999 | 2001 | 2001 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2005 | 2003 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2007 | 2007 | 2005 | 2007 | 2007 | 2007 | 2013 | 2015 | 2013 | 2015 | 2013 | 2007 | 2007 | 2007 | 2007 | 2007 | 2009 | 2007 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2011 | 2011 | 2009 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2013 | 2013 | 2011 | 2013 | 2015 | 2013 | 2013 | 2011 | 2013 | 2013 | 2015 | 2015 | 2019 | 2017 | 2019 | 2019 | 2017 | 2019 | 2017 | 2019 | 2021 | 2017 | 2017 | 2019 | 2015 | 2015 | 2015 | 2015 | 2017 | 2015 | 2017 | 2017 | 2017 | 2019 | 2019 | 2019 | 2021 | 2019 | 2017 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
user_id | * | * | * | * | * | * | * | * | CFLAGG | GGILMORE | * | TTHAM | YBONILLA | * | GKURIMOT | * | YBONILLA | YBONILLA | * | GPEREZ | COMPLETED | GPEREZ | GPEREZ | GPEREZ | LTHIBAUL | LTHIBAUL | COMPLETED | COMPLETED | COMPLETED | COMPLETED | LTHIBAUL | SARRIAGA | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | * | SARRIAGA | LTHIBAUL | LTHIBAUL | LTHIBAUL | SARRIAGA | AGLADNEY | AGLADNEY | AGLADNEY | SARRIAGA | AGLADNEY | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | JGRISSUM | * | JGRISSUM | PBANFORD | JGRISSUM | JGRISSUM | JINGRAM | MGUERRA | ASAETERN | ASAETERN | ASAETERN | * | DMCCASTL | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | MPACHECO | SARRIAGA | PBANFORD | PBANFORD | ASAETERN | AGLADNEY | ASAETERN | MPACHECO | AGLADNEY | VUKSTINA | AGLADNEY | MMERCHANT | GTAYLOR | AGLADNEY | PBANFORD | AGLADNEY | VUKSTINA | CHATRIDGE | AGLADNEY | AGLADNEY | VUKSTINA | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | CAFILER | AGLADNEY | GPEREZ | AGLADNEY | AGLADNEY | VUKSTINA | VUKSTINA | CREYNOLDS2 | MMERCHANT | PBANFORD | AGLADNEY | CAFILER | GTAYLOR | CAFILER | MMERCHANT | CAFILER | RATTIYEH | MKIRKHAM | CAFILER | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
special_audit | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 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 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 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 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 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 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_start | 1999-01-01 00:00:00 | 1997-10-01 00:00:00 | 1999-04-01 00:00:00 | 1998-07-01 00:00:00 | 1999-07-01 00:00:00 | 1998-10-01 00:00:00 | 1998-01-01 00:00:00 | 1998-04-01 00:00:00 | 1999-10-01 00:00:00 | 2000-01-01 00:00:00 | 2000-07-01 00:00:00 | 2000-04-01 00:00:00 | 2000-07-01 00:00:00 | 2000-10-01 00:00:00 | 1900-01-01 00:00:00 | 2001-01-01 00:00:00 | 2001-01-01 00:00:00 | 2000-10-01 00:00:00 | 2001-04-01 00:00:00 | 2001-04-01 00:00:00 | 2004-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2004-01-01 00:00:00 | 2004-04-01 00:00:00 | 2004-04-01 00:00:00 | 2004-07-01 00:00:00 | 2004-10-01 00:00:00 | 2004-12-25 00:00:00 | 2004-07-01 00:00:00 | 1900-01-01 00:00:00 | 2005-01-01 00:00:00 | 2004-10-01 00:00:00 | 2005-04-01 00:00:00 | 2006-01-01 00:00:00 | 2005-07-01 00:00:00 | 2005-10-01 00:00:00 | 2006-04-01 00:00:00 | 2006-10-01 00:00:00 | 2006-12-12 00:00:00 | 1900-01-01 00:00:00 | 2006-07-01 00:00:00 | 2007-01-01 00:00:00 | 2007-07-01 00:00:00 | 1900-01-01 00:00:00 | 2013-04-01 00:00:00 | 2015-01-01 00:00:00 | 2014-04-01 00:00:00 | 1900-01-01 00:00:00 | 2014-07-01 00:00:00 | 2008-01-01 00:00:00 | 2007-10-01 00:00:00 | 2007-10-01 00:00:00 | 2008-04-01 00:00:00 | 2008-10-01 00:00:00 | 2008-12-18 00:00:00 | 2008-07-01 00:00:00 | 1900-01-01 00:00:00 | 2009-01-01 00:00:00 | 2009-04-01 00:00:00 | 2009-10-01 00:00:00 | 2009-07-01 00:00:00 | 2010-01-01 00:00:00 | 2010-04-01 00:00:00 | 2010-07-01 00:00:00 | 2010-12-15 00:00:00 | 1900-01-01 00:00:00 | 2010-10-01 00:00:00 | 2011-04-01 00:00:00 | 2011-07-01 00:00:00 | 2011-01-01 00:00:00 | 2011-10-01 00:00:00 | 2012-01-01 00:00:00 | 2012-01-01 00:00:00 | 2012-04-01 00:00:00 | 2013-10-01 00:00:00 | 2013-07-01 00:00:00 | 2012-07-01 00:00:00 | 2014-10-01 00:00:00 | 2014-12-15 00:00:00 | 2012-12-15 00:00:00 | 1900-01-01 00:00:00 | 2012-10-01 00:00:00 | 2014-01-01 00:00:00 | 2013-01-01 00:00:00 | 2015-07-01 00:00:00 | 2015-04-01 00:00:00 | 2019-07-01 00:00:00 | 2017-07-01 00:00:00 | 2020-04-01 00:00:00 | 2020-07-01 00:00:00 | 2018-07-01 00:00:00 | 1900-01-01 00:00:00 | 2017-10-01 00:00:00 | 2019-04-01 00:00:00 | 2021-01-01 00:00:00 | 2018-04-01 00:00:00 | 2018-10-01 00:00:00 | 2019-01-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-12-31 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 | 2020-01-01 00:00:00 | 2019-10-01 00:00:00 | 2020-10-01 00:00:00 | 1900-01-01 00:00:00 | 2018-12-31 00:00:00 | 2018-01-01 00:00:00 | 2021-05-25 00:00:00 | 2021-07-01 00:00:00 | 2022-04-01 00:00:00 | 2020-12-31 00:00:00 | 2022-01-01 00:00:00 | 2021-10-01 00:00:00 | 2021-04-01 00:00:00 | 2022-07-01 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_end | 1999-03-31 00:00:00 | 1997-12-31 00:00:00 | 1999-06-30 00:00:00 | 1998-09-30 00:00:00 | 1999-09-30 00:00:00 | 1998-12-31 00:00:00 | 1998-03-31 00:00:00 | 1998-06-30 00:00:00 | 1999-12-31 00:00:00 | 2000-03-31 00:00:00 | 2000-09-30 00:00:00 | 2000-06-30 00:00:00 | 2000-09-30 00:00:00 | 2000-12-31 00:00:00 | 1900-01-01 00:00:00 | 2001-03-31 00:00:00 | 2001-03-31 00:00:00 | 2000-12-31 00:00:00 | 2001-06-30 00:00:00 | 2001-06-30 00:00:00 | 2004-03-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2004-03-31 00:00:00 | 2004-06-30 00:00:00 | 2004-06-30 00:00:00 | 2004-09-30 00:00:00 | 2004-12-31 00:00:00 | 2004-12-25 00:00:00 | 2004-09-30 00:00:00 | 1900-01-01 00:00:00 | 2005-03-31 00:00:00 | 2004-12-31 00:00:00 | 2005-06-30 00:00:00 | 2006-03-31 00:00:00 | 2005-09-30 00:00:00 | 2005-12-31 00:00:00 | 2006-06-30 00:00:00 | 2006-12-31 00:00:00 | 2006-12-12 00:00:00 | 1900-01-01 00:00:00 | 2006-09-30 00:00:00 | 2007-03-31 00:00:00 | 2007-09-30 00:00:00 | 1900-01-01 00:00:00 | 2013-06-30 00:00:00 | 2015-03-31 00:00:00 | 2014-06-30 00:00:00 | 1900-01-01 00:00:00 | 2014-09-30 00:00:00 | 2008-03-31 00:00:00 | 2007-12-31 00:00:00 | 2007-12-31 00:00:00 | 2008-06-30 00:00:00 | 2008-12-31 00:00:00 | 2008-12-18 00:00:00 | 2008-09-30 00:00:00 | 1900-01-01 00:00:00 | 2009-03-31 00:00:00 | 2009-06-30 00:00:00 | 2009-12-31 00:00:00 | 2009-09-30 00:00:00 | 2010-03-31 00:00:00 | 2010-06-30 00:00:00 | 2010-09-30 00:00:00 | 2010-12-15 00:00:00 | 1900-01-01 00:00:00 | 2010-12-31 00:00:00 | 2011-06-30 00:00:00 | 2011-09-30 00:00:00 | 2011-03-31 00:00:00 | 2011-12-31 00:00:00 | 2012-03-31 00:00:00 | 2012-03-31 00:00:00 | 2012-06-30 00:00:00 | 2013-12-31 00:00:00 | 2013-09-30 00:00:00 | 2012-09-30 00:00:00 | 2014-12-31 00:00:00 | 2014-12-15 00:00:00 | 2012-12-15 00:00:00 | 1900-01-01 00:00:00 | 2012-12-31 00:00:00 | 2014-03-31 00:00:00 | 2013-03-31 00:00:00 | 2015-09-30 00:00:00 | 2015-06-30 00:00:00 | 2019-09-30 00:00:00 | 2017-09-30 00:00:00 | 2020-06-30 00:00:00 | 2020-09-30 00:00:00 | 2018-09-30 00:00:00 | 1900-01-01 00:00:00 | 2017-12-31 00:00:00 | 2019-06-30 00:00:00 | 2021-03-31 00:00:00 | 2018-06-30 00:00:00 | 2018-12-31 00:00:00 | 2019-03-31 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-12-31 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 | 2020-03-31 00:00:00 | 2019-12-31 00:00:00 | 2020-12-31 00:00:00 | 1900-01-01 00:00:00 | 2018-12-31 00:00:00 | 2018-03-31 00:00:00 | 2021-05-25 00:00:00 | 2021-09-30 00:00:00 | 2022-06-30 00:00:00 | 2020-12-31 00:00:00 | 2022-03-31 00:00:00 | 2021-12-31 00:00:00 | 2021-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 | 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 | 22001 | None | None | None | None | None | 22001 | 22001 | 22001 | 22001 | None | None | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 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 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 |
filer_id | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
session_id | 2003 | 2001 | 1999 | 1997 | 2017 | 2005 | 2007 | 2009 | 2011 | 2013 | 2019 | 2015 | 2021 | 2023 | ||||||||||||||
interest_cd | 40312 | 40310 | 40306 | 40306 | 40306 | 40312 | 40312 | 40306 | 40306 | 40306 | 40306 | 40306 | 40306 | 40306 | ||||||||||||||
effect_date | 2004-02-24 00:00:00 | 2001-01-01 00:00:00 | 1999-01-01 00:00:00 | 1997-10-01 00:00:00 | 2017-01-01 00:00:00 | 2005-01-01 00:00:00 | 2007-01-01 00:00:00 | 2009-01-01 00:00:00 | 2011-01-01 00:00:00 | 2013-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 |
filer_id | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | |||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_type | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | |||||||||||||||||
active | Y | Y | Y | T | Y | Y | Y | Y | T | Y | Y | Y | Y | Y | Y | Y | N | |||||||||||||||||
race | 0 | 0 | 0 | 0 | 0 | 0 | 0 | None | 0 | 0 | None | None | None | None | None | None | None | |||||||||||||||||
session_id | 1999 | 1997 | 2001 | 2001 | 2003 | 2005 | 2007 | 2013 | 2007 | 2007 | 2011 | 2009 | 2019 | 2021 | 2015 | 2017 | 2023 | |||||||||||||||||
category | 0 | 0 | 0 | 0 | 0 | 0 | 0 | None | 0 | 0 | None | None | None | None | None | None | None | |||||||||||||||||
category_type | 0 | 0 | 0 | 0 | 0 | 0 | 0 | None | 0 | 0 | None | None | None | None | None | None | None | |||||||||||||||||
sub_category | 0 | 0 | 0 | 0 | 0 | 0 | 0 | None | 0 | 0 | None | None | None | None | None | None | None | |||||||||||||||||
effect_dt | 1999-01-01 00:00:00 | 1997-10-01 00:00:00 | 2001-01-01 00:00:00 | 2001-06-30 00:00:00 | 2004-02-24 00:00:00 | 2005-01-01 00:00:00 | 2007-01-01 00:00:00 | 2013-01-01 00:00:00 | 2007-03-31 00:00:00 | 2007-08-01 00:00:00 | 2011-01-01 00:00:00 | 2009-01-01 00:00:00 | 2019-01-01 00:00:00 | 2021-01-01 00:00:00 | 2015-01-01 00:00:00 | 2017-01-01 00:00:00 | 2023-01-01 00:00:00 | |||||||||||||||||
sub_category_type | 0 | 0 | 0 | 0 | 0 | 0 | 0 | None | 0 | 0 | None | None | None | None | None | None | None | |||||||||||||||||
election_type | 0 | 0 | 0 | 0 | 0 | 0 | 0 | None | 0 | 0 | None | None | None | None | None | None | None | |||||||||||||||||
sub_category_a | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||
nyq_dt | None | None | None | None | None | 2000-07-01 00:00:00 | 2000-07-01 00:00:00 | None | 2000-07-01 00:00:00 | 2000-07-01 00:00:00 | None | None | None | None | None | None | None | |||||||||||||||||
party_cd | None | None | None | 0 | 0 | 0 | 0 | None | 0 | 0 | None | None | None | None | None | None | None | |||||||||||||||||
county_cd | None | None | None | 0 | 0 | 0 | 0 | None | 0 | 0 | None | None | None | None | None | None | None | |||||||||||||||||
district_cd | None | None | None | 0 | 0 | 0 | 0 | None | 0 | 0 | None | None | None | None | None | None | None |
filer_id | 1145721 | |
---|---|---|
xref_id | C27234 | |
effect_dt | 1999-12-08 00:00:00 | |
migration_source | MASTER |
xref_filer_id | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | C27234 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_id | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filer_type | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
status | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
effect_dt | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 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 | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH AND AFFILIATED ENTITIES | CARDINAL HEALTH AND AFFILIATED ENTITIES | CARDINAL HEALTH AND AFFILIATED ENTITIES | CARDINAL HEALTH AND AFFILIATED ENTITIES | CARDINAL HEALTH AND AFFILIATED ENTITIES | CARDINAL HEALTH AND AFFILIATED ENTITIES | CARDINAL HEALTH AND AFFILIATED ENTITIES | CARDINAL HEALTH AND AFFILIATED ENTITIES | CARDINAL HEALTH AND AFFILIATED ENTITIES | CARDINAL HEALTH AND AFFILIATED ENTITIES | CARDINAL HEALTH AND AFFILIATED ENTITIES | CARDINAL HEALTH AND AFFILIATED ENTITIES | CARDINAL HEALTH AND AFFILIATED ENTITIES | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH, INC. | CARDINAL HEALTH, INC. | CARDINAL HEALTH, INC. | CARDINAL HEALTH, INC. | CARDINAL HEALTH, INC. | CARDINAL HEALTH, INC. | CARDINAL HEALTH, INC. | CARDINAL HEALTH, INC. | CARDINAL HEALTH, INC. | CARDINAL HEALTH, INC. | CARDINAL HEALTH, INC. | CARDINAL HEALTH, INC. | CARDINAL HEALTH, INC. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
namf | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
namt | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
nams | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
adr1 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
adr2 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
city | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | DUBLIN | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
st | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | OH | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
zip4 | 43016 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | 43016 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | 43016 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | 43016 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | 43016 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | 43016 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | 43016 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | 43016 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | 43016 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | 43016 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | 43016 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | 43016 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | 43016 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | 43017 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
phon | 6147177721 | 6147577159 | 6147577159 | 6147577159 | 6146571392 | 6146571392 | 6146571392 | 6146571392 | 6146571392 | 6146571392 | 6146571392 | 6146571392 | 6146571392 | 6147177721 | 6147577159 | 6147577159 | 6147577159 | 6146571392 | 6146571392 | 6146571392 | 6146571392 | 6146571392 | 6146571392 | 6146571392 | 6146571392 | 6146571392 | 6147177721 | 6147577159 | 6147577159 | 6147577159 | 6146571392 | 6146571392 | 6146571392 | 6146571392 | 6146571392 | 6146571392 | 6146571392 | 6146571392 | 6146571392 | 6147177721 | 6147577159 | 6147577159 | 6147577159 | 6146571392 | 6146571392 | 6146571392 | 6146571392 | 6146571392 | 6146571392 | 6146571392 | 6146571392 | 6146571392 | 6147177721 | 6147577159 | 6147577159 | 6147577159 | 6146571392 | 6146571392 | 6146571392 | 6146571392 | 6146571392 | 6146571392 | 6146571392 | 6146571392 | 6146571392 | 6147177721 | 6147577159 | 6147577159 | 6147577159 | 6146571392 | 6146571392 | 6146571392 | 6146571392 | 6146571392 | 6146571392 | 6146571392 | 6146571392 | 6146571392 | 6147177721 | 6147577159 | 6147577159 | 6147577159 | 6146571392 | 6146571392 | 6146571392 | 6146571392 | 6146571392 | 6146571392 | 6146571392 | 6146571392 | 6146571392 | 6147177721 | 6147577159 | 6147577159 | 6147577159 | 6146571392 | 6146571392 | 6146571392 | 6146571392 | 6146571392 | 6146571392 | 6146571392 | 6146571392 | 6146571392 | 6147177721 | 6147577159 | 6147577159 | 6147577159 | 6146571392 | 6146571392 | 6146571392 | 6146571392 | 6146571392 | 6146571392 | 6146571392 | 6146571392 | 6146571392 | 6147177721 | 6147577159 | 6147577159 | 6147577159 | 6146571392 | 6146571392 | 6146571392 | 6146571392 | 6146571392 | 6146571392 | 6146571392 | 6146571392 | 6146571392 | 6147177721 | 6147577159 | 6147577159 | 6147577159 | 6146571392 | 6146571392 | 6146571392 | 6146571392 | 6146571392 | 6146571392 | 6146571392 | 6146571392 | 6146571392 | 6147177721 | 6147577159 | 6147577159 | 6147577159 | 6146571392 | 6146571392 | 6146571392 | 6146571392 | 6146571392 | 6146571392 | 6146571392 | 6146571392 | 6146571392 | 6147177721 | 6147577159 | 6147577159 | 6147577159 | 6146571392 | 6146571392 | 6146571392 | 6146571392 | 6146571392 | 6146571392 | 6146571392 | 6146571392 | 6146571392 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fax | None | 6147578159 | 6147578159 | 6146524159 | 6146524195 | 6146524195 | 6146524195 | 6146524195 | 6146524195 | 6146524195 | 6146524195 | None | 6147578159 | 6147578159 | 6146524159 | 6146524195 | 6146524195 | 6146524195 | 6146524195 | 6146524195 | 6146524195 | 6146524195 | None | 6147578159 | 6147578159 | 6146524159 | 6146524195 | 6146524195 | 6146524195 | 6146524195 | 6146524195 | 6146524195 | 6146524195 | None | 6147578159 | 6147578159 | 6146524159 | 6146524195 | 6146524195 | 6146524195 | 6146524195 | 6146524195 | 6146524195 | 6146524195 | None | 6147578159 | 6147578159 | 6146524159 | 6146524195 | 6146524195 | 6146524195 | 6146524195 | 6146524195 | 6146524195 | 6146524195 | None | 6147578159 | 6147578159 | 6146524159 | 6146524195 | 6146524195 | 6146524195 | 6146524195 | 6146524195 | 6146524195 | 6146524195 | None | 6147578159 | 6147578159 | 6146524159 | 6146524195 | 6146524195 | 6146524195 | 6146524195 | 6146524195 | 6146524195 | 6146524195 | None | 6147578159 | 6147578159 | 6146524159 | 6146524195 | 6146524195 | 6146524195 | 6146524195 | 6146524195 | 6146524195 | 6146524195 | None | 6147578159 | 6147578159 | 6146524159 | 6146524195 | 6146524195 | 6146524195 | 6146524195 | 6146524195 | 6146524195 | 6146524195 | None | 6147578159 | 6147578159 | 6146524159 | 6146524195 | 6146524195 | 6146524195 | 6146524195 | 6146524195 | 6146524195 | 6146524195 | None | 6147578159 | 6147578159 | 6146524159 | 6146524195 | 6146524195 | 6146524195 | 6146524195 | 6146524195 | 6146524195 | 6146524195 | None | 6147578159 | 6147578159 | 6146524159 | 6146524195 | 6146524195 | 6146524195 | 6146524195 | 6146524195 | 6146524195 | 6146524195 | None | 6147578159 | 6147578159 | 6146524159 | 6146524195 | 6146524195 | 6146524195 | 6146524195 | 6146524195 | 6146524195 | 6146524195 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | 1145721 |
---|
filer_id | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
change_no | 1 | 6 | 2 | 3 | 4 | 8 | 12 | 0 | 14 | 13 | 15 | |||||||||||
session_id | 1999 | 1999 | 2001 | 2001 | 2001 | 2001 | 2003 | 2003 | 2007 | 2007 | 2021 | |||||||||||
log_dt | 2000-08-22 00:00:00 | 2001-03-21 00:00:00 | 2001-02-21 00:00:00 | 2001-03-19 00:00:00 | 2001-03-19 00:00:00 | 2001-07-06 00:00:00 | 2004-02-24 00:00:00 | 2004-02-24 00:00:00 | 2007-08-13 00:00:00 | 2007-04-19 00:00:00 | 2021-01-04 00:00:00 | |||||||||||
filer_type | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | |||||||||||
correction_flg | None | None | Y | None | None | Y | None | None | Y | Y | None | |||||||||||
action | CHANGED | CHANGED | CHANGED | IN SUSPENSE | IN SUSPENSE | DELETED | CHANGED | ADDED | ADDED | DELETED | CHANGED | |||||||||||
attribute_changed | ADDRESS AND PHONE | ADDRESS | ADDRESS | CLIENT | CLIENT | EMPLOYER | NAME | FIRM | FIRM | FIRM | RESPONSIBLE OFFICER | |||||||||||
ethics_dt | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
interests | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
filer_full_name | CARDINAL HEALTH, INC. | CARDINAL HEALTH, INC. | CARDINAL HEALTH, INC. | CARDINAL HEALTH, INC. | CARDINAL HEALTH, INC. | CARDINAL HEALTH, INC. | CARDINAL HEALTH, INC. | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | CARDINAL HEALTH | |||||||||||
filer_city | DUBLIN | DUBLIN | None | Los Angeles | None | None | None | None | DUBLIN | None | None | |||||||||||
filer_st | OH | OH | None | CA | None | None | None | None | OH | None | None | |||||||||||
filer_zip | 43017 | 43017 | None | 90027 | None | None | None | None | 43016 | None | None | |||||||||||
filer_phone | 6147575003 | 6147577159 | None | 3236692299 | None | None | None | None | 6147177721 | None | None | |||||||||||
entity_type | 1 | 1 | 2 | 3 | 3 | 2 | 1 | 3 | 3 | 3 | 20 | |||||||||||
entity_name | CARDINAL HEALTH, INC. | None | STEFFES, FOLEY & LARDNER | STEFFES, FOLEY & LARDNER, INC. | STEFFES, FOLEY & LARDNER, INC. | STEFFES, FOLEY & LARDNER, INC. | CARDINAL HEALTH, | GOVERNMENT STRATEGIES, INC. | NIELSEN, MARKSAMER, PARRINELLO, MUELLER & NAYLOR, LLP | GOVERNMENT STRATEGIES, INC. | VICE PRESIDENT, GOVERNMENT RELATIONS AND PUBLIC POLICY REBECCA MC GRATH | |||||||||||
entity_city | DUBLIN | None | None | None | None | None | None | None | None | None | None | |||||||||||
entity_st | OH | None | None | None | None | None | None | None | None | None | None | |||||||||||
entity_zip | 43017 | None | None | None | None | None | None | None | None | None | None | |||||||||||
entity_phone | 6147575003 | None | None | None | None | None | None | None | None | None | None | |||||||||||
entity_id | 1145721 | 0 | 1147230 | 1147230 | 1147230 | 1147230 | 0 | 1147643 | None | 1147643 | 1438342 | |||||||||||
responsible_officer | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
effect_dt | None | None | None | None | None | 2001-06-30 00:00:00 | 2004-02-24 00:00:00 | 2004-02-24 00:00:00 | 2007-08-01 00:00:00 | 2007-03-31 00:00:00 | 2021-01-01 00:00:00 |
filer_id | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | 1145721 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_file_name | 673050_0.cal | 711797_0.cal | 744480_0.cal | 771386_0.cal | 1009918_0.cal | 1023995_0.cal | 1049938_0.cal | 1072971_0.cal | 1101446_0.cal | 1116627_0.cal | 1128687_0.cal | 1142929_0.cal | 1163046_0.cal | 1186770_0.cal | 1213170_0.cal | 1327596_0.cal | 1391883_0.cal | 1348034_0.cal | 1506088_0.cal | 1458144_0.cal | 1448155_0.cal | 1231685_0.cal | 1482041_0.cal | 1261086_0.cal | 1431852_0.cal | 1419748_0.cal | 1297532_0.cal | 1378598_0.cal | 1311881_0.cal | 1311881_1.cal | 1842150_0.cal | 1869151_0.cal | 1728973_0.cal | 1678626_0.cal | 1796977_0.cal | 1587397_0.cal | 1540980_0.cal | 1699132_0.cal | 1564320_0.cal | 1813368_0.cal | 1608018_0.cal | 1778789_0.cal | 1763008_0.cal | 1630828_0.cal | 1621305_0.cal | 1652579_0.cal | 255547.cal | 1652579_1.cal | 189845.cal | 190238.cal | 120488.cal | 1911385_0.cal | 337204.cal | 210613.cal | 1962171_0.cal | 1933466_0.cal | 77492.cal | 103141.cal | 46048.cal | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
received_date | 2000-10-20 00:00:00 | 2001-01-19 00:00:00 | 2001-04-27 00:00:00 | 2001-07-30 00:00:00 | 2004-04-20 00:00:00 | 2004-07-20 00:00:00 | 2004-10-20 00:00:00 | 2005-01-18 00:00:00 | 2005-04-20 00:00:00 | 2005-07-28 00:00:00 | 2005-10-18 00:00:00 | 2006-01-20 00:00:00 | 2006-04-19 00:00:00 | 2006-07-24 00:00:00 | 2006-10-26 00:00:00 | 2008-04-28 00:00:00 | 2009-01-26 00:00:00 | 2008-07-29 00:00:00 | 2010-07-30 00:00:00 | 2010-01-18 00:00:00 | 2009-10-17 00:00:00 | 2007-01-25 00:00:00 | 2010-04-24 00:00:00 | 2007-04-28 00:00:00 | 2009-07-20 00:00:00 | 2009-04-28 00:00:00 | 2007-10-31 00:00:00 | 2008-10-31 00:00:00 | 2008-01-31 00:00:00 | 2008-03-03 00:00:00 | 2014-04-28 00:00:00 | 2014-07-29 00:00:00 | 2013-01-18 00:00:00 | 2012-07-31 00:00:00 | 2013-10-24 00:00:00 | 2011-04-21 00:00:00 | 2010-11-01 00:00:00 | 2012-10-16 00:00:00 | 2011-01-24 00:00:00 | 2014-01-26 00:00:00 | 2011-08-01 00:00:00 | 2013-07-26 00:00:00 | 2013-04-28 00:00:00 | 2012-01-23 00:00:00 | 2011-10-28 00:00:00 | 2012-04-17 00:00:00 | 2012-04-25 00:00:00 | 2012-04-25 00:00:00 | 2015-10-30 00:00:00 | 2015-10-30 00:00:00 | 2016-10-31 00:00:00 | 2014-10-31 00:00:00 | 2016-04-29 00:00:00 | 2015-07-31 00:00:00 | 2015-04-26 00:00:00 | 2015-01-30 00:00:00 | 2018-01-31 00:00:00 | 2021-05-25 00:00:00 | 2021-04-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 | /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/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/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/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_id | 673050 | 711797 | 744480 | 771386 | 1009918 | 1023995 | 1049938 | 1072971 | 1101446 | 1116627 | 1128687 | 1142929 | 1163046 | 1186770 | 1213170 | 1327596 | 1391883 | 1348034 | 1506088 | 1458144 | 1448155 | 1231685 | 1482041 | 1261086 | 1431852 | 1419748 | 1297532 | 1378598 | 1311881 | 1311881 | 1842150 | 1869151 | 1728973 | 1678626 | 1796977 | 1587397 | 1540980 | 1699132 | 1564320 | 1813368 | 1608018 | 1778789 | 1763008 | 1630828 | 1621305 | 1652579 | None | 1652579 | None | None | None | 1911385 | None | None | 1962171 | 1933466 | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | None | F635 | None | None | None | F635 | None | None | F635 | F635 | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
receive_comment | Filing accepted, but 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 accepted | 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 accepted | 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 accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing passed validation, but failed DB constraints | Filing accepted | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing accepted | Filing did not pass validation | Filing passed validation, but failed DB constraints | Filing accepted | Filing accepted | Filing passed validation, but failed DB constraints | Filing did not pass validation | Filing passed validation, but failed DB constraints |