acronym | SCPPA | |
---|---|---|
filer_id | 1145113 |
filer_id | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
adrid | 1110923 | 2042356 | 2081656 | 2505817 | 2418631 | 2471475 | 2284064 | 2342530 | 2550885 | |||||||||
effect_dt | 1999-01-01 00:00:00 | 2003-01-01 00:00:00 | 2005-01-01 00:00:00 | 2021-01-01 00:00:00 | 2017-01-01 00:00:00 | 2019-01-01 00:00:00 | 2013-01-01 00:00:00 | 2015-01-01 00:00:00 | 2023-01-01 00:00:00 | |||||||||
add_type | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | |||||||||
session_id | 1999 | 2003 | 2005 | 2021 | 2017 | 2019 | 2013 | 2015 | 2023 |
filer_id | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 474626 | 477756 | 472199 | 466866 | 486806 | 496633 | 490452 | 469098 | 493034 | 494121 | 497725 | 483281 | 480211 | 615978 | 630517 | 660225 | 683373 | 692712 | 719111 | 701861 | 766559 | 742133 | 758059 | 734275 | 784744 | 777653 | 795694 | 811093 | 837333 | 819216 | 862377 | 854528 | 842649 | 892903 | 884417 | 936418 | 912747 | 900389 | 898638 | 906542 | 930039 | 935715 | 945228 | 961510 | 949721 | 955130 | 989404 | 973551 | 1017961 | 1012129 | 1002428 | 1030141 | 1033755 | 1057341 | 1064852 | 1070246 | 1069006 | 1093443 | 1094971 | 1094995 | 1081392 | 1104710 | 1112605 | 1127964 | 1148786 | 1782924 | 1980145 | 1962294 | 1947227 | 1941720 | 1800850 | 1935672 | 1816816 | 1816816 | 1910667 | 1873429 | 1723846 | 1845024 | 1741686 | 1751496 | 1762122 | 1766009 | 2484488 | 2236152 | 2343554 | 2338455 | 2330381 | 2470556 | 1997583 | 2009837 | 2028714 | 2028714 | 2054084 | 1935672 | 2095380 | 2122181 | 2152953 | 2133245 | 2151329 | 2161316 | 2209914 | 2327922 | 2376998 | 2525606 | 2242589 | 2234157 | 2319966 | 2353076 | 2536960 | 2537648 | 2182039 | 2592851 | 2395117 | 2552554 | 2436383 | 2541505 | 2275739 | 2182039 | 2194091 | 2552554 | 2420039 | 2525606 | 2576690 | 2598759 | 2484488 | 2576690 | 2598759 | 2675524 | 2623128 | 2566630 | 2705944 | 2623128 | 2573863 | 2608197 | 2552554 | 2645231 | 2567932 | 2705944 | 2570841 | 2598759 | 2705944 | 2705944 | 2705944 | 2740177 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
period_id | 158 | 151 | 150 | 149 | 153 | 148 | 154 | 157 | 147 | 155 | 156 | 152 | 159 | 160 | 161 | 162 | 163 | 163 | 164 | None | 166 | 165 | 165 | 164 | 167 | None | None | 168 | 169 | None | None | 170 | None | None | 171 | None | None | None | None | 172 | 173 | None | 174 | 175 | 174 | None | 176 | None | None | 177 | None | 178 | None | 179 | None | 181 | 180 | None | None | None | 180 | 181 | 182 | 183 | 184 | 214 | 222 | 221 | None | None | 215 | 220 | 216 | 216 | 219 | 218 | 213 | 217 | 213 | None | None | 213 | 242 | 233 | 236 | None | 236 | 241 | 223 | 224 | 225 | 225 | 226 | 220 | 227 | 228 | 229 | None | 230 | None | 232 | 236 | 237 | 243 | 234 | None | 235 | None | 244 | 244 | 230 | None | 238 | 244 | 240 | 244 | 234 | 230 | 231 | 244 | 239 | 243 | 245 | 246 | 242 | 245 | 246 | 249 | 247 | None | 250 | 247 | None | None | 244 | 248 | 245 | 250 | None | 246 | 250 | 250 | 250 | 251 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F602 | F635 | F602 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F602 | F602 | F602 | F635 | F635 | F635 | F635 | F602 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F602 | F602 | F635 | F602 | F635 | F635 | F602 | F602 | F635 | F602 | F602 | F602 | F635 | F602 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F602 | F602 | F635 | F635 | F602 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_sequence | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 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 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 2 | 2 | 3 | 4 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_date | 1999-07-27 00:00:00 | 1997-10-31 00:00:00 | 1997-07-28 00:00:00 | 1997-04-30 00:00:00 | 1998-04-30 00:00:00 | 1997-01-24 00:00:00 | 1998-07-27 00:00:00 | 1999-04-29 00:00:00 | 1996-10-25 00:00:00 | 1998-10-23 00:00:00 | 1999-01-26 00:00:00 | 1998-01-23 00:00:00 | 1999-10-29 00:00:00 | 2000-01-31 00:00:00 | 2000-04-27 00:00:00 | 2000-07-31 00:00:00 | 2000-11-01 00:00:00 | 2000-10-16 00:00:00 | 2001-01-31 00:00:00 | 2000-12-22 00:00:00 | 2001-07-06 00:00:00 | 2001-04-19 00:00:00 | 2001-04-30 00:00:00 | 2001-01-30 00:00:00 | 2001-10-02 00:00:00 | 2001-07-30 00:00:00 | 2001-10-29 00:00:00 | 2002-01-28 00:00:00 | 2002-04-25 00:00:00 | 2002-01-28 00:00:00 | 2002-07-30 00:00:00 | 2002-07-30 00:00:00 | 2002-04-25 00:00:00 | 2002-10-31 00:00:00 | 2002-10-31 00:00:00 | 2003-04-30 00:00:00 | 2003-01-29 00:00:00 | 2002-12-30 00:00:00 | 2002-12-27 00:00:00 | 2003-01-27 00:00:00 | 2003-04-29 00:00:00 | 2003-04-30 00:00:00 | 2003-07-28 00:00:00 | 2003-10-02 00:00:00 | 2003-07-30 00:00:00 | 2003-07-31 00:00:00 | 2004-01-30 00:00:00 | 2003-10-31 00:00:00 | 2004-04-30 00:00:00 | 2004-04-28 00:00:00 | 2004-01-29 00:00:00 | 2004-07-30 00:00:00 | 2004-07-30 00:00:00 | 2004-10-29 00:00:00 | 2004-10-29 00:00:00 | 2005-01-05 00:00:00 | 2004-12-30 00:00:00 | 2005-01-31 00:00:00 | 2004-12-30 00:00:00 | 2005-01-18 00:00:00 | 2005-01-31 00:00:00 | 2005-04-29 00:00:00 | 2005-07-19 00:00:00 | 2005-10-13 00:00:00 | 2006-01-31 00:00:00 | 2013-07-31 00:00:00 | 2015-07-30 00:00:00 | 2015-04-27 00:00:00 | 2014-12-30 00:00:00 | 2014-12-30 00:00:00 | 2013-10-31 00:00:00 | 2015-02-01 00:00:00 | 2014-03-10 00:00:00 | 2014-01-30 00:00:00 | 2014-10-30 00:00:00 | 2014-08-01 00:00:00 | 2013-01-10 00:00:00 | 2014-04-30 00:00:00 | 2013-02-01 00:00:00 | 2013-01-18 00:00:00 | 2013-02-01 00:00:00 | 2013-04-30 00:00:00 | 2020-07-30 00:00:00 | 2018-04-25 00:00:00 | 2019-01-29 00:00:00 | 2019-01-07 00:00:00 | 2018-12-28 00:00:00 | 2020-04-30 00:00:00 | 2015-10-31 00:00:00 | 2016-01-29 00:00:00 | 2016-04-15 00:00:00 | 2016-05-02 00:00:00 | 2016-07-08 00:00:00 | 2016-11-03 00:00:00 | 2016-10-25 00:00:00 | 2017-01-23 00:00:00 | 2017-04-24 00:00:00 | 2016-12-27 00:00:00 | 2017-04-17 00:00:00 | 2017-04-19 00:00:00 | 2018-01-31 00:00:00 | 2018-12-12 00:00:00 | 2019-04-25 00:00:00 | 2020-10-28 00:00:00 | 2018-04-30 00:00:00 | 2018-04-19 00:00:00 | 2018-10-31 00:00:00 | 2018-12-28 00:00:00 | 2020-12-15 00:00:00 | 2020-12-21 00:00:00 | 2017-11-17 00:00:00 | 2021-03-19 00:00:00 | 2019-07-29 00:00:00 | 2021-01-31 00:00:00 | 2020-01-27 00:00:00 | 2020-12-31 00:00:00 | 2018-07-31 00:00:00 | 2017-08-25 00:00:00 | 2017-10-31 00:00:00 | 2021-01-31 00:00:00 | 2019-10-31 00:00:00 | 2021-12-01 00:00:00 | 2022-06-03 00:00:00 | 2022-06-03 00:00:00 | 2021-09-17 00:00:00 | 2021-04-26 00:00:00 | 2021-07-29 00:00:00 | 2022-04-30 00:00:00 | 2022-07-31 00:00:00 | 2020-12-30 00:00:00 | 2022-07-31 00:00:00 | 2021-10-29 00:00:00 | 2020-12-16 00:00:00 | 2021-04-26 00:00:00 | 2022-01-31 00:00:00 | 2022-01-31 00:00:00 | 2021-03-18 00:00:00 | 2022-07-31 00:00:00 | 2020-12-31 00:00:00 | 2022-07-31 00:00:00 | 2022-07-31 00:00:00 | 2022-07-31 00:00:00 | 2022-07-31 00:00:00 | 2022-10-24 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_type | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10005 | 10005 | 10001 | 10005 | 10001 | 10005 | 10001 | 10001 | 10005 | 10005 | 10001 | 10005 | 10005 | 10001 | 10001 | 10005 | 10005 | 10001 | 10005 | 10005 | 10001 | 10005 | 10005 | 10005 | 10005 | 10001 | 10001 | 10005 | 10001 | 10001 | 10005 | 10005 | 10001 | 10005 | 10005 | 10001 | 10005 | 10001 | 10005 | 10001 | 10005 | 10001 | 10001 | 10005 | 10005 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10005 | 10001 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | 10002 | 10001 | 10001 | 10001 | 10005 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10005 | 10001 | 10001 | 10002 | 10005 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10002 | 10002 | 10002 | 10001 | 10001 | 10001 | 10002 | 10005 | 10002 | 10001 | 10005 | 10005 | 10002 | 10001 | 10001 | 10001 | 10005 | 10002 | 10002 | 10002 | 10002 | 10001 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_status | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | 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 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
session_id | 1999 | 1997 | 1997 | 1997 | 1997 | 1995 | 1997 | 1999 | 1995 | 1997 | 1997 | 1997 | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 2001 | 2001 | 2001 | 2001 | 1999 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2003 | 2001 | 2003 | 2003 | 2001 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2005 | 2005 | 2003 | 2005 | 2005 | 2003 | 2005 | 2005 | 2005 | 2005 | 2013 | 2015 | 2015 | 2015 | 2015 | 2013 | 2013 | 2013 | 2013 | 2013 | 2013 | 2013 | 2013 | 2013 | 2013 | 2013 | 2013 | 2019 | 2017 | 2017 | 2019 | 2019 | 2019 | 2015 | 2015 | 2015 | 2015 | 2015 | 2013 | 2015 | 2015 | 2017 | 2017 | 2017 | 2017 | 2017 | 2019 | 2019 | 2019 | 2017 | 2017 | 2017 | 2019 | 2019 | 2021 | 2017 | 2021 | 2019 | 2019 | 2019 | 2021 | 2017 | 2017 | 2017 | 2019 | 2019 | 2019 | 2021 | 2021 | 2019 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2019 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
user_id | * | * | * | * | * | * | * | * | * | * | * | * | * | * | GGILMORE | YBONILLA | * | YBONILLA | * | TTHAM | * | * | YBONILLA | GPEREZ | * | LTHIBAUL | LTHIBAUL | * | * | LTHIBAUL | LTHIBAUL | * | LTHIBAUL | LTHIBAUL | * | LTHIBAUL | LTHIBAUL | BSMITH | CFLAGG | COMPLETED | COMPLETED | LTHIBAUL | COMPLETED | COMPLETED | CFLAGG | MHOANG | COMPLETED | LTHIBAUL | LTHIBAUL | COMPLETED | LTHIBAUL | COMPLETED | LTHIBAUL | COMPLETED | LTHIBAUL | YRODRIGU | YRODRIGU | LTHIBAUL | PBANFORD | PBANFORD | COMPLETED | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | AGLADNEY | AGLADNEY | AGLADNEY | YRODRIGU | GPEREZ | ASAETERN | MPACHECO | ASAETERN | ASAETERN | AGLADNEY | RGEREMIA | YRODRIGU | AGLADNEY | YRODRIGU | YRODRIGU | PBANFORD | AGLADNEY | MKIRKHAM | AGLADNEY | AGLADNEY | DMCCASTL | PBANFORD | VUKSTINA | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | CAFILER | AGLADNEY | AGLADNEY | AGLADNEY | SARRIAGA | YRODRIGU | YRODRIGU | AGLADNEY | CAFILER | GTAYLOR | GTAYLOR | CAFILER | GPEREZ | AGLADNEY | PBANFORD | CAFILER | MMERCHANT | AGLADNEY | MKIRKHAM | GTAYLOR | GTAYLOR | GTAYLOR | CVANLIEW | AGLADNEY | AGLADNEY | AGLADNEY | GTAYLOR | VUKSTINA | CAFILER | GTAYLOR | GTAYLOR | CAFILER | MKIRKHAM | CHATRIDGE | CAFILER | CAFILER | MMERCHANT | CAFILER | GTAYLOR | MMERCHANT | MKIRKHAM | CAFILER | RATTIYEH | MKIRKHAM | CAFILER | CVANLIEW | CAFILER | CAFILER | CAFILER | CAFILER | CAFILER | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
special_audit | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11002 | 11002 | 11003 | 11002 | 11002 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fine_audit | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_start | 1999-04-01 00:00:00 | 1997-07-01 00:00:00 | 1997-04-01 00:00:00 | 1997-01-01 00:00:00 | 1998-01-01 00:00:00 | 1996-10-01 00:00:00 | 1998-04-01 00:00:00 | 1999-01-01 00:00:00 | 1996-07-01 00:00:00 | 1998-07-01 00:00:00 | 1998-10-01 00:00:00 | 1997-10-01 00:00:00 | 1999-07-01 00:00:00 | 1999-10-01 00:00:00 | 2000-01-01 00:00:00 | 2000-04-01 00:00:00 | 2000-07-01 00:00:00 | 2000-07-01 00:00:00 | 2000-10-01 00:00:00 | 1900-01-01 00:00:00 | 2001-04-01 00:00:00 | 2001-01-01 00:00:00 | 2001-01-01 00:00:00 | 2000-10-01 00:00:00 | 2001-07-01 00:00:00 | 2001-04-01 00:00:00 | 2001-07-01 00:00:00 | 2001-10-01 00:00:00 | 2002-01-01 00:00:00 | 2001-10-01 00:00:00 | 2002-04-01 00:00:00 | 2002-04-01 00:00:00 | 2002-01-01 00:00:00 | 2002-07-01 00:00:00 | 2002-07-01 00:00:00 | 2003-01-01 00:00:00 | 2002-10-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2002-10-01 00:00:00 | 2003-01-01 00:00:00 | 2003-01-01 00:00:00 | 2003-04-01 00:00:00 | 2003-07-01 00:00:00 | 2003-04-01 00:00:00 | 2003-04-01 00:00:00 | 2003-10-01 00:00:00 | 2003-07-01 00:00:00 | 2004-01-01 00:00:00 | 2004-01-01 00:00:00 | 2003-10-01 00:00:00 | 2004-04-01 00:00:00 | 2004-04-01 00:00:00 | 2004-07-01 00:00:00 | 2004-07-01 00:00:00 | 2005-01-05 00:00:00 | 2004-12-02 00:00:00 | 2004-10-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2004-10-01 00:00:00 | 2005-01-01 00:00:00 | 2005-04-01 00:00:00 | 2005-07-01 00:00:00 | 2005-10-01 00:00:00 | 2013-04-01 00:00:00 | 2015-04-01 00:00:00 | 2015-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2013-07-01 00:00:00 | 2014-10-01 00:00:00 | 2013-10-01 00:00:00 | 2013-10-01 00:00:00 | 2014-07-01 00:00:00 | 2014-04-01 00:00:00 | 2013-01-10 00:00:00 | 2014-01-01 00:00:00 | 2013-02-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2013-01-01 00:00:00 | 2020-04-01 00:00:00 | 2018-01-01 00:00:00 | 2018-10-01 00:00:00 | 1900-01-01 00:00:00 | 2018-12-28 00:00:00 | 2020-01-01 00:00:00 | 2015-07-01 00:00:00 | 2015-10-01 00:00:00 | 2016-01-01 00:00:00 | 2016-01-01 00:00:00 | 2016-04-01 00:00:00 | 2014-10-01 00:00:00 | 2016-07-01 00:00:00 | 2016-10-01 00:00:00 | 2017-01-01 00:00:00 | 1900-01-01 00:00:00 | 2017-04-17 00:00:00 | 1900-01-01 00:00:00 | 2017-10-01 00:00:00 | 2018-12-12 00:00:00 | 2019-01-01 00:00:00 | 2020-07-01 00:00:00 | 2018-04-30 00:00:00 | 1900-01-01 00:00:00 | 2018-07-01 00:00:00 | 1900-01-01 00:00:00 | 2020-12-02 00:00:00 | 2020-12-21 00:00:00 | 2017-04-01 00:00:00 | 1900-01-01 00:00:00 | 2019-04-01 00:00:00 | 2020-10-01 00:00:00 | 2019-10-01 00:00:00 | 2020-12-31 00:00:00 | 2018-04-01 00:00:00 | 2017-04-01 00:00:00 | 2017-07-01 00:00:00 | 2020-10-01 00:00:00 | 2019-07-01 00:00:00 | 2020-07-01 00:00:00 | 2021-01-01 00:00:00 | 2021-04-01 00:00:00 | 2020-04-01 00:00:00 | 2021-01-01 00:00:00 | 2021-04-01 00:00:00 | 2022-01-01 00:00:00 | 2021-07-01 00:00:00 | 1900-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 | 2020-10-01 00:00:00 | 2021-10-01 00:00:00 | 2021-03-18 00:00:00 | 2022-04-01 00:00:00 | 1900-01-01 00:00:00 | 2021-04-01 00:00:00 | 2022-04-01 00:00:00 | 2022-04-01 00:00:00 | 2022-04-01 00:00:00 | 2022-07-01 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_end | 1999-06-30 00:00:00 | 1997-09-30 00:00:00 | 1997-06-30 00:00:00 | 1997-03-31 00:00:00 | 1998-03-31 00:00:00 | 1996-12-31 00:00:00 | 1998-06-30 00:00:00 | 1999-03-31 00:00:00 | 1996-09-30 00:00:00 | 1998-09-30 00:00:00 | 1998-12-31 00:00:00 | 1997-12-31 00:00:00 | 1999-09-30 00:00:00 | 1999-12-31 00:00:00 | 2000-03-31 00:00:00 | 2000-06-30 00:00:00 | 2000-09-30 00:00:00 | 2000-09-30 00:00:00 | 2000-12-31 00:00:00 | 1900-01-01 00:00:00 | 2001-06-30 00:00:00 | 2001-03-31 00:00:00 | 2001-03-31 00:00:00 | 2000-12-31 00:00:00 | 2001-09-30 00:00:00 | 2001-06-30 00:00:00 | 2001-09-30 00:00:00 | 2001-12-31 00:00:00 | 2002-03-31 00:00:00 | 2001-12-31 00:00:00 | 2002-06-30 00:00:00 | 2002-06-30 00:00:00 | 2002-03-31 00:00:00 | 2002-09-30 00:00:00 | 2002-09-30 00:00:00 | 2003-03-31 00:00:00 | 2002-12-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2002-12-31 00:00:00 | 2003-03-31 00:00:00 | 2003-03-31 00:00:00 | 2003-06-30 00:00:00 | 2003-09-30 00:00:00 | 2003-06-30 00:00:00 | 2003-06-30 00:00:00 | 2003-12-31 00:00:00 | 2003-09-30 00:00:00 | 2004-03-31 00:00:00 | 2004-03-31 00:00:00 | 2003-12-30 00:00:00 | 2004-06-30 00:00:00 | 2004-06-30 00:00:00 | 2004-09-30 00:00:00 | 2004-09-30 00:00:00 | 2005-01-05 00:00:00 | 2004-12-02 00:00:00 | 2004-12-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2004-12-31 00:00:00 | 2005-03-31 00:00:00 | 2005-06-30 00:00:00 | 2005-09-30 00:00:00 | 2005-12-31 00:00:00 | 2013-06-30 00:00:00 | 2015-06-30 00:00:00 | 2015-03-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2013-09-30 00:00:00 | 2014-12-31 00:00:00 | 2013-12-31 00:00:00 | 2013-12-31 00:00:00 | 2014-09-30 00:00:00 | 2014-06-30 00:00:00 | 2013-01-10 00:00:00 | 2014-03-31 00:00:00 | 2013-02-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2013-03-31 00:00:00 | 2020-06-30 00:00:00 | 2018-03-31 00:00:00 | 2018-12-31 00:00:00 | 1900-01-01 00:00:00 | 2018-12-28 00:00:00 | 2020-03-31 00:00:00 | 2015-09-30 00:00:00 | 2015-12-31 00:00:00 | 2016-03-31 00:00:00 | 2016-03-31 00:00:00 | 2016-06-30 00:00:00 | 2014-12-31 00:00:00 | 2016-09-30 00:00:00 | 2016-12-31 00:00:00 | 2017-03-31 00:00:00 | 1900-01-01 00:00:00 | 2017-04-17 00:00:00 | 1900-01-01 00:00:00 | 2017-12-31 00:00:00 | 2018-12-12 00:00:00 | 2019-03-31 00:00:00 | 2020-09-30 00:00:00 | 2018-04-30 00:00:00 | 1900-01-01 00:00:00 | 2018-09-30 00:00:00 | 1900-01-01 00:00:00 | 2020-12-02 00:00:00 | 2020-12-21 00:00:00 | 2017-06-30 00:00:00 | 1900-01-01 00:00:00 | 2019-06-30 00:00:00 | 2020-12-31 00:00:00 | 2019-12-31 00:00:00 | 2020-12-31 00:00:00 | 2018-06-30 00:00:00 | 2017-06-30 00:00:00 | 2017-09-30 00:00:00 | 2020-12-31 00:00:00 | 2019-09-30 00:00:00 | 2020-09-30 00:00:00 | 2021-03-31 00:00:00 | 2021-06-30 00:00:00 | 2020-06-30 00:00:00 | 2021-03-31 00:00:00 | 2021-06-30 00:00:00 | 2022-03-31 00:00:00 | 2021-09-30 00:00:00 | 1900-01-01 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 | 2020-12-31 00:00:00 | 2021-12-31 00:00:00 | 2021-03-18 00:00:00 | 2022-06-30 00:00:00 | 1900-01-01 00:00:00 | 2021-06-30 00:00:00 | 2022-06-30 00:00:00 | 2022-06-30 00:00:00 | 2022-06-30 00:00:00 | 2022-09-30 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_date | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_type | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 22001 | 22001 | None | 22001 | 22001 | None | None | 22001 | None | None | 22001 | None | 22001 | None | 22001 | None | 22001 | 22001 | None | None | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22006 | 22001 | 22001 | None | None | 22006 | 22001 | 22001 | 22001 | 22001 | 22001 | 22006 | 22001 | 22006 | None | None | 22006 | 22006 | 22006 | 22006 | None | 22001 | 22006 | 22001 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22001 | None | 22006 | None | 22001 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22001 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | None | None | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 |
filer_id | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
session_id | 2001 | 2003 | 1999 | 1997 | 1995 | 2005 | 2013 | 2017 | 2015 | 2021 | 2019 | 2023 | ||||||||||||
interest_cd | 40319 | 40319 | 40319 | 40319 | 40319 | 40319 | 40319 | 40319 | 40319 | 40319 | 40319 | 40319 | ||||||||||||
effect_date | 2001-01-01 00:00:00 | 2003-01-01 00:00:00 | 1999-01-01 00:00:00 | 1997-01-01 00:00:00 | 1996-08-19 00:00:00 | 2005-01-01 00:00:00 | 2013-01-01 00:00:00 | 2017-01-01 00:00:00 | 2015-01-01 00:00:00 | 2021-01-01 00:00:00 | 2019-01-01 00:00:00 | 2023-01-01 00:00:00 |
filer_id | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_type | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | |||||||||||||||
active | Y | Y | Y | Y | Y | Y | T | Y | Y | T | Y | Y | Y | Y | N | |||||||||||||||
race | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
session_id | 1999 | 1997 | 1995 | 2001 | 2003 | 2005 | 2005 | 2013 | 2017 | 2017 | 2021 | 2017 | 2015 | 2019 | 2023 | |||||||||||||||
category | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
category_type | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
sub_category | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
effect_dt | 1999-01-01 00:00:00 | 1997-01-01 00:00:00 | 1996-08-19 00:00:00 | 2001-01-01 00:00:00 | 2003-01-01 00:00:00 | 2005-01-01 00:00:00 | 2006-03-01 00:00:00 | 2013-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017-03-09 00:00:00 | 2021-01-01 00:00:00 | 2017-04-20 00:00:00 | 2015-01-01 00:00:00 | 2019-01-01 00:00:00 | 2023-01-01 00:00:00 | |||||||||||||||
sub_category_type | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
election_type | 0 | 0 | 0 | 0 | None | None | None | None | 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 | |||||||||||||||
nyq_dt | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
county_cd | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
district_cd | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None |
filer_id | 1145113 | |
---|---|---|
xref_id | C26548 | |
effect_dt | 1999-12-08 00:00:00 | |
migration_source | MASTER |
xref_filer_id | C26548 | C26548 | C26548 | C26548 | C26548 | C26548 | C26548 | C26548 | C26548 | C26548 | C26548 | C26548 | C26548 | C26548 | C26548 | C26548 | C26548 | C26548 | C26548 | C26548 | C26548 | C26548 | C26548 | C26548 | C26548 | C26548 | C26548 | C26548 | C26548 | C26548 | C26548 | C26548 | C26548 | C26548 | C26548 | C26548 | C26548 | C26548 | C26548 | C26548 | C26548 | C26548 | C26548 | C26548 | C26548 | C26548 | C26548 | C26548 | C26548 | C26548 | C26548 | C26548 | C26548 | C26548 | C26548 | C26548 | C26548 | C26548 | C26548 | C26548 | C26548 | C26548 | C26548 | C26548 | C26548 | C26548 | C26548 | C26548 | C26548 | C26548 | C26548 | C26548 | C26548 | C26548 | C26548 | C26548 | C26548 | C26548 | C26548 | C26548 | C26548 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_id | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filer_type | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
status | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
effect_dt | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
naml | SOUTHERN CALIFORNIA PUBLIC POWER AUTHORITY | SOUTHERN CALIFORNIA PUBLIC POWER AUTHORITY | SOUTHERN CALIFORNIA PUBLIC POWER AUTHORITY | SOUTHERN CALIFORNIA PUBLIC POWER AUTHORITY | SOUTHERN CALIFORNIA PUBLIC POWER AUTHORITY | SOUTHERN CALIFORNIA PUBLIC POWER AUTHORITY | SOUTHERN CALIFORNIA PUBLIC POWER AUTHORITY | SOUTHERN CALIFORNIA PUBLIC POWER AUTHORITY | SOUTHERN CALIFORNIA PUBLIC POWER AUTHORITY | SOUTHERN CALIFORNIA PUBLIC POWER AUTHORITY (SCPPA) | SOUTHERN CALIFORNIA PUBLIC POWER AUTHORITY (SCPPA) | SOUTHERN CALIFORNIA PUBLIC POWER AUTHORITY (SCPPA) | SOUTHERN CALIFORNIA PUBLIC POWER AUTHORITY (SCPPA) | SOUTHERN CALIFORNIA PUBLIC POWER AUTHORITY (SCPPA) | SOUTHERN CALIFORNIA PUBLIC POWER AUTHORITY (SCPPA) | SOUTHERN CALIFORNIA PUBLIC POWER AUTHORITY (SCPPA) | SOUTHERN CALIFORNIA PUBLIC POWER AUTHORITY (SCPPA) | SOUTHERN CALIFORNIA PUBLIC POWER AUTHORITY (SCPPA) | SOUTHERN CALIFORNIA PUBLIC POWER AUTHORITY (SCPPA) | SOUTHERN CALIFORNIA PUBLIC POWER AUTHORITY (SCPPA) | SOUTHERN CALIFORNIA PUBLIC POWER AUTHORITY (SCPPA) | SOUTHERN CALIFORNIA PUBLIC POWER AUTHORITY (SCPPA) | SOUTHERN CALIFORNIA PUBLIC POWER AUTHORITY (SCPPA) | SOUTHERN CALIFORNIA PUBLIC POWER AUTHORITY (SCPPA) | SOUTHERN CALIFORNIA PUBLIC POWER AUTHORITY (SCPPA) | SOUTHERN CALIFORNIA PUBLIC POWER AUTHORITY (SCPPA) | SOUTHERN CALIFORNIA PUBLIC POWER AUTHORITY (SCPPA) | SOUTHERN CALIFORNIA PUBLIC POWER AUTHORITY (SCPPA) | SOUTHERN CALIFORNIA PUBLIC POWER AUTHORITY (SCPPA) | SOUTHERN CALIFORNIA PUBLIC POWER AUTHORITY (SCPPA) | SOUTHERN CALIFORNIA PUBLIC POWER AUTHORITY (SCPPA) | SOUTHERN CALIFORNIA PUBLIC POWER AUTHORITY (SCPPA) | SOUTHERN CALIFORNIA PUBLIC POWER AUTHORITY (SCPPA) | SOUTHERN CALIFORNIA PUBLIC POWER AUTHORITY (SCPPA) | SOUTHERN CALIFORNIA PUBLIC POWER AUTHORITY (SCPPA) | SOUTHERN CALIFORNIA PUBLIC POWER AUTHORITY (SCPPA) | SOUTHERN CALIFORNIA PUBLIC POWER AUTHORITY | SOUTHERN CALIFORNIA PUBLIC POWER AUTHORITY | SOUTHERN CALIFORNIA PUBLIC POWER AUTHORITY | SOUTHERN CALIFORNIA PUBLIC POWER AUTHORITY | SOUTHERN CALIFORNIA PUBLIC POWER AUTHORITY | SOUTHERN CALIFORNIA PUBLIC POWER AUTHORITY | SOUTHERN CALIFORNIA PUBLIC POWER AUTHORITY | SOUTHERN CALIFORNIA PUBLIC POWER AUTHORITY | SOUTHERN CALIFORNIA PUBLIC POWER AUTHORITY | SOUTHERN CALIFORNIA PUBLIC POWER AUTHORITY | SOUTHERN CALIFORNIA PUBLIC POWER AUTHORITY | SOUTHERN CALIFORNIA PUBLIC POWER AUTHORITY | SOUTHERN CALIFORNIA PUBLIC POWER AUTHORITY | SOUTHERN CALIFORNIA PUBLIC POWER AUTHORITY | SOUTHERN CALIFORNIA PUBLIC POWER AUTHORITY | SOUTHERN CALIFORNIA PUBLIC POWER AUTHORITY | SOUTHERN CALIFORNIA PUBLIC POWER AUTHORITY | SOUTHERN CALIFORNIA PUBLIC POWER AUTHORITY | SOUTHERN CALIFORNIA PUBLIC POWER AUTHORITY | SOUTHERN CALIFORNIA PUBLIC POWER AUTHORITY | SOUTHERN CALIFORNIA PUBLIC POWER AUTHORITY | SOUTHERN CALIFORNIA PUBLIC POWER AUTHORITY | SOUTHERN CALIFORNIA PUBLIC POWER AUTHORITY | SOUTHERN CALIFORNIA PUBLIC POWER AUTHORITY | SOUTHERN CALIFORNIA PUBLIC POWER AUTHORITY | SOUTHERN CALIFORNIA PUBLIC POWER AUTHORITY | SOUTHERN CALIFORNIA PUBLIC POWER AUTHORITY | SOUTHERN CALIFORNIA PUBLIC POWER AUTHORITY | SOUTHERN CALIFORNIA PUBLIC POWER AUTHORITY | SOUTHERN CALIFORNIA PUBLIC POWER AUTHORITY | SOUTHERN CALIFORNIA PUBLIC POWER AUTHORITY | SOUTHERN CALIFORNIA PUBLIC POWER AUTHORITY | SOUTHERN CALIFORNIA PUBLIC POWER AUTHORITY | SOUTHERN CALIFORNIA PUBLIC POWER AUTHORITY | SOUTHERN CALIFORNIA PUBLIC POWER AUTHORITY | SOUTHERN CALIFORNIA PUBLIC POWER AUTHORITY | SOUTHERN CALIFORNIA PUBLIC POWER AUTHORITY | SOUTHERN CALIFORNIA PUBLIC POWER AUTHORITY | SOUTHERN CALIFORNIA PUBLIC POWER AUTHORITY | SOUTHERN CALIFORNIA PUBLIC POWER AUTHORITY | SOUTHERN CALIFORNIA PUBLIC POWER AUTHORITY | SOUTHERN CALIFORNIA PUBLIC POWER AUTHORITY | SOUTHERN CALIFORNIA PUBLIC POWER AUTHORITY | SOUTHERN CALIFORNIA PUBLIC POWER AUTHORITY | SOUTHERN CALIFORNIA PUBLIC POWER AUTHORITY | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
namf | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
namt | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
nams | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
adr1 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
adr2 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
city | PASADENA | PASADENA | PASADENA | GLENDORA | GLENDORA | GLENDORA | GLENDORA | GLENDORA | GLENDORA | PASADENA | PASADENA | PASADENA | GLENDORA | GLENDORA | GLENDORA | GLENDORA | GLENDORA | GLENDORA | PASADENA | PASADENA | PASADENA | GLENDORA | GLENDORA | GLENDORA | GLENDORA | GLENDORA | GLENDORA | PASADENA | PASADENA | PASADENA | GLENDORA | GLENDORA | GLENDORA | GLENDORA | GLENDORA | GLENDORA | PASADENA | PASADENA | PASADENA | GLENDORA | GLENDORA | GLENDORA | GLENDORA | GLENDORA | GLENDORA | PASADENA | PASADENA | PASADENA | GLENDORA | GLENDORA | GLENDORA | GLENDORA | GLENDORA | GLENDORA | PASADENA | PASADENA | PASADENA | GLENDORA | GLENDORA | GLENDORA | GLENDORA | GLENDORA | GLENDORA | PASADENA | PASADENA | PASADENA | GLENDORA | GLENDORA | GLENDORA | GLENDORA | GLENDORA | GLENDORA | PASADENA | PASADENA | PASADENA | GLENDORA | GLENDORA | GLENDORA | GLENDORA | GLENDORA | GLENDORA | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
st | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
zip4 | 91101 | 91101 | 91101 | 91740 | 91740 | 91740 | 91740 | 91740 | 91740 | 91101 | 91101 | 91101 | 91740 | 91740 | 91740 | 91740 | 91740 | 91740 | 91101 | 91101 | 91101 | 91740 | 91740 | 91740 | 91740 | 91740 | 91740 | 91101 | 91101 | 91101 | 91740 | 91740 | 91740 | 91740 | 91740 | 91740 | 91101 | 91101 | 91101 | 91740 | 91740 | 91740 | 91740 | 91740 | 91740 | 91101 | 91101 | 91101 | 91740 | 91740 | 91740 | 91740 | 91740 | 91740 | 91101 | 91101 | 91101 | 91740 | 91740 | 91740 | 91740 | 91740 | 91740 | 91101 | 91101 | 91101 | 91740 | 91740 | 91740 | 91740 | 91740 | 91740 | 91101 | 91101 | 91101 | 91740 | 91740 | 91740 | 91740 | 91740 | 91740 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
phon | 6267939461 | 6267939364 | 6267939364 | 6267939364 | 6267939364 | 6267939364 | 6267939364 | 6267939364 | 6267939364 | 6267939461 | 6267939364 | 6267939364 | 6267939364 | 6267939364 | 6267939364 | 6267939364 | 6267939364 | 6267939364 | 6267939461 | 6267939364 | 6267939364 | 6267939364 | 6267939364 | 6267939364 | 6267939364 | 6267939364 | 6267939364 | 6267939461 | 6267939364 | 6267939364 | 6267939364 | 6267939364 | 6267939364 | 6267939364 | 6267939364 | 6267939364 | 6267939461 | 6267939364 | 6267939364 | 6267939364 | 6267939364 | 6267939364 | 6267939364 | 6267939364 | 6267939364 | 6267939461 | 6267939364 | 6267939364 | 6267939364 | 6267939364 | 6267939364 | 6267939364 | 6267939364 | 6267939364 | 6267939461 | 6267939364 | 6267939364 | 6267939364 | 6267939364 | 6267939364 | 6267939364 | 6267939364 | 6267939364 | 6267939461 | 6267939364 | 6267939364 | 6267939364 | 6267939364 | 6267939364 | 6267939364 | 6267939364 | 6267939364 | 6267939461 | 6267939364 | 6267939364 | 6267939364 | 6267939364 | 6267939364 | 6267939364 | 6267939364 | 6267939364 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fax | None | 6267939461 | None | 6267939461 | None | 6267939461 | None | 6267939461 | None | 6267939461 | None | 6267939461 | None | 6267939461 | None | 6267939461 | None | 6267939461 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] |
filer_id | 1145113 |
---|
filer_id | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | ||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
change_no | 2 | 1 | 0 | 4 | 3 | 5 | ||||||
session_id | 2005 | 2005 | 2013 | 2017 | 2015 | 2017 | ||||||
log_dt | 2006-03-15 00:00:00 | 2005-12-29 00:00:00 | 2013-02-01 00:00:00 | 2017-03-07 00:00:00 | 2015-11-05 00:00:00 | 2018-04-19 00:00:00 | ||||||
filer_type | 1 | 1 | 1 | 1 | 1 | 2 | ||||||
correction_flg | None | None | Y | Y | Y | Y | ||||||
action | DELETED | DELETED | ADDED | DELETED | DELETED | ADDED | ||||||
attribute_changed | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | ||||||
ethics_dt | None | None | None | None | None | None | ||||||
interests | None | None | None | None | None | None | ||||||
filer_full_name | SOUTHERN CALIFORNIA PUBLIC POWER AUTHORITY (SCPPA) | SOUTHERN CALIFORNIA PUBLIC POWER AUTHORITY (SCPPA) | SOUTHERN CALIFORNIA PUBLIC POWER AUTHORITY (SCPPA) | SOUTHERN CALIFORNIA PUBLIC POWER AUTHORITY | SOUTHERN CALIFORNIA PUBLIC POWER AUTHORITY | SOUTHERN CALIFORNIA PUBLIC POWER AUTHORITY | ||||||
filer_city | None | None | None | PASADENA | PASADENA | PASADENA | ||||||
filer_st | None | None | None | CA | CA | CA | ||||||
filer_zip | None | None | None | 91101 | 91101 | 91101 | ||||||
filer_phone | None | None | None | 6267939364 | 6267939364 | 6267939461 | ||||||
entity_type | 3 | 3 | 3 | 3 | 3 | 3 | ||||||
entity_name | GOVERNMENT AFFAIRS CONSULTING | GALATI & BLEK LLP | GONZALEZ, QUINTANA & HUNTER, LLC | GONZALEZ, QUINTANA, HUNTER & CRUZ, LLC | DI MARE, BROWN, HICKS & KESSLER, LLC | MANATT, PHELPS & PHILLIPS, LLP | ||||||
entity_city | None | None | None | None | None | None | ||||||
entity_st | None | None | None | None | None | None | ||||||
entity_zip | None | None | None | None | None | None | ||||||
entity_phone | None | None | None | None | None | None | ||||||
entity_id | 1147554 | 1251442 | 1334301 | None | None | None | ||||||
responsible_officer | None | None | None | None | None | None | ||||||
effect_dt | 2006-03-01 00:00:00 | 2005-12-31 00:00:00 | 2013-01-01 00:00:00 | 2017-03-09 00:00:00 | 2015-11-07 00:00:00 | 2018-02-01 00:00:00 |
filer_id | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | 1145113 | ||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_file_name | 3639.cal | 3509.cal | 683373_0.cal | 719111_0.cal | 766559_0.cal | 742133_0.cal | 784744_0.cal | 811093_0.cal | 837333_0.cal | 854528_0.cal | 884417_0.cal | 906542_0.cal | 930039_0.cal | 336881.cal | 333161.cal | 274251.cal | 274157.cal | 273982.cal | 945228_0.cal | 333361.cal | 333360.cal | 961510_0.cal | 989404_0.cal | 1012129_0.cal | 1030141_0.cal | 1057341_0.cal | 1081392_0.cal | 1104710_0.cal | 1127964_0.cal | 1112605_0.cal | 1148786_0.cal | 1845024_0.cal | 1997583_0.cal | 1873429_0.cal | 1910667_0.cal | 1935672_0.cal | 1962294_0.cal | 1980145_0.cal | ||||||||||||||||||||||||||||||||||||||
received_date | 2000-10-31 00:00:00 | 2000-10-31 00:00:00 | 2000-11-01 00:00:00 | 2001-01-31 00:00:00 | 2001-07-06 00:00:00 | 2001-04-19 00:00:00 | 2001-10-02 00:00:00 | 2002-01-28 00:00:00 | 2002-04-25 00:00:00 | 2002-07-30 00:00:00 | 2002-10-31 00:00:00 | 2003-01-27 00:00:00 | 2003-04-29 00:00:00 | 2003-04-30 00:00:00 | 2003-04-30 00:00:00 | 2003-07-31 00:00:00 | 2003-07-31 00:00:00 | 2003-07-31 00:00:00 | 2003-07-28 00:00:00 | 2003-04-29 00:00:00 | 2003-04-29 00:00:00 | 2003-10-02 00:00:00 | 2004-01-30 00:00:00 | 2004-04-28 00:00:00 | 2004-07-30 00:00:00 | 2004-10-29 00:00:00 | 2005-01-31 00:00:00 | 2005-04-29 00:00:00 | 2005-10-13 00:00:00 | 2005-07-19 00:00:00 | 2006-01-31 00:00:00 | 2014-04-30 00:00:00 | 2015-10-31 00:00:00 | 2014-08-01 00:00:00 | 2014-10-30 00:00:00 | 2015-02-01 00:00:00 | 2015-04-27 00:00:00 | 2015-07-30 00:00:00 | ||||||||||||||||||||||||||||||||||||||
filing_directory | /usr/users/cafiler/disclose/ca99/temp | /usr/users/cafiler/disclose/ca99/temp | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /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/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 | ||||||||||||||||||||||||||||||||||||||
filing_id | None | None | 683373 | 719111 | 766559 | 742133 | 784744 | 811093 | 837333 | 854528 | 884417 | 906542 | 930039 | None | None | None | None | None | 945228 | None | None | 961510 | 989404 | 1012129 | 1030141 | 1057341 | 1081392 | 1104710 | 1127964 | 1112605 | 1148786 | 1845024 | 1997583 | 1873429 | 1910667 | 1935672 | 1962294 | 1980145 | ||||||||||||||||||||||||||||||||||||||
form_id | None | None | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | None | None | None | None | None | F635 | None | None | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | ||||||||||||||||||||||||||||||||||||||
receive_comment | Filing pass validation, but failed DB constraints | Filing pass validation, but failed DB constraints | Filing accepted, but with warnings | Filing accepted, but with warnings | Filing accepted, but with warnings | Filing accepted, but with warnings | Filing accepted, but with warnings | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing accepted, but with warnings | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted |