filer_id | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
adrid | 1110764 | 2047031 | 2012093 | 2080727 | 2117276 | 2165178 | 2206355 | 2417330 | 2506228 | 2551945 | 2284131 | 2342420 | 2468628 | |||||||||||||
effect_dt | 1999-01-01 00:00:00 | 2003-01-01 00:00:00 | 2001-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 | 2017-01-01 00:00:00 | 2021-01-01 00:00:00 | 2023-01-01 00:00:00 | 2013-01-01 00:00:00 | 2015-01-01 00:00:00 | 2019-01-01 00:00:00 | |||||||||||||
add_type | 7050 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | |||||||||||||
session_id | 1999 | 2003 | 2001 | 2005 | 2007 | 2009 | 2011 | 2017 | 2021 | 2023 | 2013 | 2015 | 2019 |
filer_id | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 472183 | 483264 | 480182 | 497711 | 490440 | 494108 | 474594 | 486791 | 490440 | 469064 | 477741 | 486791 | 483264 | 474594 | 636939 | 624817 | 614188 | 642553 | 677884 | 705779 | 718332 | 695128 | 729932 | 756750 | 743560 | 770143 | 787354 | 779681 | 797048 | 819777 | 810495 | 836332 | 851415 | 842449 | 861764 | 889977 | 889984 | 876504 | 909520 | 909585 | 916815 | 896062 | 930588 | 927960 | 943151 | 943690 | 974756 | 982944 | 969224 | 1010876 | 997584 | 1024487 | 1017156 | 1023695 | 1049647 | 1074485 | 1066000 | 1068657 | 1085974 | 1092230 | 1132541 | 1117114 | 1104534 | 1146940 | 1167692 | 1166650 | 1211119 | 1195778 | 1191120 | 1231485 | 1246787 | 1256112 | 1277523 | 1292391 | 1775890 | 1703484 | 1963303 | 1982692 | 1963303 | 1932332 | 1865364 | 1941594 | 1932332 | 1899347 | 1326063 | 1306236 | 1320299 | 1345536 | 1344608 | 1368624 | 1391692 | 1386504 | 1386724 | 1413854 | 1417369 | 1413284 | 1413297 | 1449949 | 1436408 | 1463533 | 1505285 | 1481951 | 1524138 | 1566515 | 1567005 | 1556218 | 1585735 | 1606520 | 1630633 | 1617475 | 1652402 | 1675151 | 1814807 | 1799398 | 1932332 | 1932332 | 1703484 | 1717868 | 1732495 | 1725299 | 1840943 | 1762386 | 1982692 | 2390775 | 2480641 | 2316706 | 2332169 | 2378003 | 1996287 | 2007751 | 2034098 | 2059961 | 2101015 | 2127717 | 2155908 | 2127717 | 2133209 | 2173366 | 2235161 | 2209950 | 2435487 | 2468180 | 2550631 | 2191460 | 2468180 | 2496263 | 2527277 | 2340518 | 2416425 | 2264238 | 2339480 | 2390775 | 2173366 | 2416425 | 2435487 | 2575039 | 2620796 | 2550631 | 2600524 | 2620796 | 2378003 | 2570743 | 2600524 | 2542024 | 2641272 | 2672753 | 2704423 | 2641272 | 2527277 | 2600524 | 2748322 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
period_id | 150 | 152 | 159 | 156 | 154 | 155 | 158 | 153 | 154 | 157 | 151 | 153 | 152 | 158 | None | 161 | 160 | 162 | 163 | None | 164 | 163 | 164 | 165 | 165 | 166 | 167 | None | None | None | 168 | 169 | 170 | None | None | None | None | 171 | None | 172 | None | 172 | None | 173 | 174 | 174 | None | 176 | 175 | 177 | None | None | None | 178 | 179 | 180 | None | 180 | None | None | 183 | 182 | 181 | 184 | None | 185 | 187 | None | 186 | 188 | None | 189 | 190 | 191 | 214 | 211 | 221 | 222 | 221 | 220 | 218 | None | 220 | 219 | 193 | 192 | None | 195 | 194 | 195 | 196 | 196 | 196 | None | 197 | None | None | 199 | 198 | 200 | 202 | 201 | 203 | 204 | None | 204 | 205 | 206 | 208 | 207 | 209 | 210 | 216 | 215 | 220 | 220 | 211 | 212 | 212 | None | 217 | 213 | 222 | 238 | 242 | 235 | 237 | 237 | 223 | 224 | 225 | 226 | 227 | 228 | 229 | 228 | None | 230 | 233 | 232 | 240 | 241 | 244 | 231 | 241 | None | 243 | 236 | 239 | 234 | None | 238 | 230 | 239 | 240 | 245 | 247 | 244 | 246 | 247 | 237 | None | 246 | 245 | 248 | 249 | 250 | 248 | 243 | 246 | 251 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F690 | F690 | F635 | F635 | F635 | F690 | F690 | F999 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F615 | 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 | F602 | F602 | F635 | F635 | F635 | F635 | F635 | F888 | F635 | F635 | F602 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F602 | F602 | F635 | F635 | F635 | F602 | F602 | F602 | F635 | F602 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_sequence | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 3 | 0 | 0 | 2 | 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 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 2 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_date | 1997-07-29 00:00:00 | 1998-01-28 00:00:00 | 1999-10-20 00:00:00 | 1999-02-01 00:00:00 | 1998-07-29 00:00:00 | 1998-10-30 00:00:00 | 1999-07-29 00:00:00 | 1998-10-30 00:00:00 | 1998-10-30 00:00:00 | 1999-04-29 00:00:00 | 1997-10-31 00:00:00 | 1998-05-01 00:00:00 | 1998-07-09 00:00:00 | 1999-08-06 00:00:00 | 2000-04-20 00:00:00 | 2000-04-21 00:00:00 | 2000-01-28 00:00:00 | 2000-07-17 00:00:00 | 2000-10-26 00:00:00 | 2000-12-29 00:00:00 | 2001-01-31 00:00:00 | 2000-10-26 00:00:00 | 2001-01-30 00:00:00 | 2001-04-30 00:00:00 | 2001-04-25 00:00:00 | 2001-07-26 00:00:00 | 2001-10-16 00:00:00 | 2001-07-31 00:00:00 | 2001-10-22 00:00:00 | 2002-01-22 00:00:00 | 2002-01-25 00:00:00 | 2002-04-22 00:00:00 | 2002-07-24 00:00:00 | 2002-04-23 00:00:00 | 2002-07-29 00:00:00 | 2002-10-25 00:00:00 | 2002-10-25 00:00:00 | 2002-10-22 00:00:00 | 2003-01-28 00:00:00 | 2003-01-30 00:00:00 | 2002-12-31 00:00:00 | 2002-12-13 00:00:00 | 2003-04-21 00:00:00 | 2003-04-18 00:00:00 | 2003-07-21 00:00:00 | 2003-07-22 00:00:00 | 2003-10-30 00:00:00 | 2004-01-16 00:00:00 | 2003-10-30 00:00:00 | 2004-04-23 00:00:00 | 2004-01-20 00:00:00 | 2004-07-20 00:00:00 | 2004-04-28 00:00:00 | 2004-07-19 00:00:00 | 2004-10-20 00:00:00 | 2005-01-24 00:00:00 | 2004-10-21 00:00:00 | 2004-12-29 00:00:00 | 2004-12-30 00:00:00 | 2005-01-24 00:00:00 | 2005-10-28 00:00:00 | 2005-07-29 00:00:00 | 2005-04-29 00:00:00 | 2006-01-30 00:00:00 | 2006-04-28 00:00:00 | 2006-04-28 00:00:00 | 2006-10-25 00:00:00 | 2006-08-10 00:00:00 | 2006-07-31 00:00:00 | 2007-01-25 00:00:00 | 2007-01-11 00:00:00 | 2007-04-11 00:00:00 | 2007-07-16 00:00:00 | 2007-10-10 00:00:00 | 2013-07-16 00:00:00 | 2013-05-06 00:00:00 | 2015-04-28 00:00:00 | 2015-07-31 00:00:00 | 2015-07-29 00:00:00 | 2015-04-27 00:00:00 | 2014-07-23 00:00:00 | 2014-12-30 00:00:00 | 2015-04-01 00:00:00 | 2014-10-16 00:00:00 | 2008-04-22 00:00:00 | 2008-01-25 00:00:00 | 2008-03-21 00:00:00 | 2008-07-24 00:00:00 | 2008-07-21 00:00:00 | 2008-10-22 00:00:00 | 2009-01-26 00:00:00 | 2008-12-30 00:00:00 | 2008-12-30 00:00:00 | 2009-01-02 00:00:00 | 2009-04-15 00:00:00 | 2008-12-31 00:00:00 | 2009-02-11 00:00:00 | 2009-10-27 00:00:00 | 2009-07-30 00:00:00 | 2010-01-29 00:00:00 | 2010-07-29 00:00:00 | 2010-04-23 00:00:00 | 2010-10-08 00:00:00 | 2011-01-26 00:00:00 | 2010-12-31 00:00:00 | 2010-12-30 00:00:00 | 2011-04-11 00:00:00 | 2011-07-29 00:00:00 | 2012-01-23 00:00:00 | 2011-10-14 00:00:00 | 2012-04-17 00:00:00 | 2012-07-26 00:00:00 | 2014-01-29 00:00:00 | 2013-10-30 00:00:00 | 2015-01-29 00:00:00 | 2015-01-29 00:00:00 | 2012-10-25 00:00:00 | 2012-12-18 00:00:00 | 2013-01-25 00:00:00 | 2012-12-18 00:00:00 | 2014-04-24 00:00:00 | 2013-04-26 00:00:00 | 2015-10-06 00:00:00 | 2019-07-17 00:00:00 | 2020-07-24 00:00:00 | 2018-10-30 00:00:00 | 2019-01-04 00:00:00 | 2019-04-26 00:00:00 | 2015-10-29 00:00:00 | 2016-01-27 00:00:00 | 2016-04-28 00:00:00 | 2016-07-28 00:00:00 | 2016-10-31 00:00:00 | 2017-01-30 00:00:00 | 2017-04-28 00:00:00 | 2017-03-10 00:00:00 | 2016-12-27 00:00:00 | 2017-07-28 00:00:00 | 2018-04-24 00:00:00 | 2018-01-31 00:00:00 | 2020-01-24 00:00:00 | 2020-04-28 00:00:00 | 2021-01-29 00:00:00 | 2017-10-27 00:00:00 | 2020-07-15 00:00:00 | 2020-08-12 00:00:00 | 2020-10-30 00:00:00 | 2019-01-25 00:00:00 | 2019-10-28 00:00:00 | 2018-07-12 00:00:00 | 2018-12-21 00:00:00 | 2020-07-13 00:00:00 | 2017-10-27 00:00:00 | 2020-07-13 00:00:00 | 2020-07-14 00:00:00 | 2021-04-19 00:00:00 | 2021-10-27 00:00:00 | 2022-02-23 00:00:00 | 2021-07-30 00:00:00 | 2022-06-20 00:00:00 | 2020-07-13 00:00:00 | 2020-12-28 00:00:00 | 2022-06-20 00:00:00 | 2021-01-04 00:00:00 | 2022-01-28 00:00:00 | 2022-04-28 00:00:00 | 2022-07-29 00:00:00 | 2022-09-20 00:00:00 | 2022-02-23 00:00:00 | 2022-05-19 00:00:00 | 2022-10-31 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_type | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10005 | 10005 | 10005 | 10001 | 10005 | 10001 | 10005 | 10005 | 10005 | 10001 | 10001 | 10001 | 10005 | 10005 | 10005 | 10001 | 10001 | 10001 | 10005 | 10005 | 10005 | 10005 | 10001 | 10005 | 10001 | 10005 | 10001 | 10005 | 10001 | 10001 | 10005 | 10005 | 10001 | 10001 | 10001 | 10005 | 10005 | 10005 | 10001 | 10001 | 10001 | 10005 | 10001 | 10005 | 10005 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10005 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | 10001 | 10002 | 10002 | 10001 | 10005 | 10002 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10005 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10002 | 10002 | 10002 | 10001 | 10001 | 10002 | 10001 | 10002 | 10002 | 10005 | 10002 | 10001 | 10001 | 10001 | 10001 | 10002 | 10002 | 10002 | 10001 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_status | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 11003 | 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 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
session_id | 1997 | 1997 | 1999 | 1997 | 1997 | 1997 | 1999 | 1997 | 1997 | 1999 | 1997 | 1997 | 1997 | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 2001 | 1999 | 1999 | 1999 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2005 | 2005 | 2003 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2007 | 2007 | 2007 | 2007 | 2013 | 2011 | 2015 | 2015 | 2015 | 2013 | 2013 | 2015 | 2013 | 2013 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2013 | 2013 | 2013 | 2013 | 2011 | 2013 | 2011 | 2013 | 2013 | 2013 | 2015 | 2019 | 2019 | 2017 | 2019 | 2019 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2017 | 2015 | 2017 | 2017 | 2017 | 2017 | 2019 | 2019 | 2019 | 2017 | 2019 | 2019 | 2019 | 2017 | 2019 | 2017 | 2019 | 2019 | 2017 | 2019 | 2019 | 2021 | 2021 | 2019 | 2021 | 2021 | 2019 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2019 | 2021 | 2021 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
user_id | * | * | * | * | * | * | * | * | * | * | * | * | * | * | TTHAM | TTHAM | * | TTHAM | * | SARRIAGA | * | YBONILLA | GPEREZ | YBONILLA | * | * | * | LTHIBAUL | GGILMORE | LTHIBAUL | * | * | * | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | * | LTHIBAUL | COMPLETED | PBANFORD | * | LTHIBAUL | COMPLETED | COMPLETED | LTHIBAUL | LTHIBAUL | COMPLETED | COMPLETED | COMPLETED | EMCENTEE | LTHIBAUL | LTHIBAUL | COMPLETED | COMPLETED | COMPLETED | LTHIBAUL | BSMITH | BSMITH | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | CFLAGG | LTHIBAUL | LTHIBAUL | CFLAGG | LTHIBAUL | LTHIBAUL | GPEREZ | LTHIBAUL | YRODRIGU | YRODRIGU | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | MPACHECO | AGLADNEY | GPEREZ | MPACHECO | AGLADNEY | LTHIBAUL | LTHIBAUL | YRODRIGU | * | LTHIBAUL | MGUERRA | MGUERRA | * | * | DMCCASTL | MGUERRA | MMORENO | DMCCASTL | MGUERRA | MGUERRA | MGUERRA | ASAETERN | ASAETERN | ASAETERN | ASAETERN | SARRIAGA | * | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | ASAETERN | ASAETERN | AGLADNEY | AGLADNEY | AGLADNEY | PBANFORD | ASAETERN | PBANFORD | ASAETERN | AGLADNEY | AGLADNEY | SUSHAKOV | GTAYLOR | AGLADNEY | YRODRIGU | SUSHAKOV | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | SARRIAGA | AGLADNEY | AGLADNEY | AGLADNEY | GTAYLOR | VUKSTINA | CREYNOLDS2 | AGLADNEY | GTAYLOR | GPEREZ | GTAYLOR | AGLADNEY | VUKSTINA | AGLADNEY | YRODRIGU | GTAYLOR | AGLADNEY | GTAYLOR | GTAYLOR | CHATRIDGE | GTAYLOR | CAFILER | MKIRKHAM | CAFILER | GTAYLOR | AROJAS | CAFILER | AROJAS | CHATRIDGE | CAFILER | CAFILER | CAFILER | CAFILER | GTAYLOR | CAFILER | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
special_audit | 11001 | 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 | 11002 | 11003 | 11003 | 11003 | 11002 | 11002 | 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 | 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 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_start | 1997-04-01 00:00:00 | 1997-10-01 00:00:00 | 1999-07-01 00:00:00 | 1998-10-01 00:00:00 | 1998-04-01 00:00:00 | 1998-07-01 00:00:00 | 1999-04-01 00:00:00 | 1998-01-01 00:00:00 | 1998-04-01 00:00:00 | 1999-01-01 00:00:00 | 1997-07-01 00:00:00 | 1998-01-01 00:00:00 | 1997-10-01 00:00:00 | 1999-04-01 00:00:00 | None | 2000-01-01 00:00:00 | 1999-10-01 00:00:00 | 2000-04-01 00:00:00 | 2000-07-01 00:00:00 | 1900-01-01 00:00:00 | 2000-10-01 00:00:00 | 2000-07-01 00:00:00 | 2000-10-01 00:00:00 | 2001-01-01 00:00:00 | 2001-01-01 00:00:00 | 2001-04-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 | 2001-10-01 00:00:00 | 2002-01-01 00:00:00 | 2002-04-01 00:00:00 | 2002-01-01 00:00:00 | 2002-04-01 00:00:00 | 2002-07-01 00:00:00 | 2002-07-01 00:00:00 | 2002-07-01 00:00:00 | 2002-10-01 00:00:00 | 2002-10-01 00:00:00 | 1900-01-01 00:00:00 | 2002-12-10 00:00:00 | 2003-01-01 00:00:00 | 2003-01-01 00:00:00 | 2003-04-01 00:00:00 | 2003-04-01 00:00:00 | 2003-07-01 00:00:00 | 2003-10-01 00:00:00 | 2003-07-01 00:00:00 | 2004-01-01 00:00:00 | 2003-10-01 00:00:00 | 2004-04-01 00:00:00 | 2004-01-01 00:00:00 | 2004-04-01 00:00:00 | 2004-07-01 00:00:00 | 2004-10-01 00:00:00 | 2004-07-01 00:00:00 | 2004-12-15 00:00:00 | 1900-01-01 00:00:00 | 2004-10-01 00:00:00 | 2005-07-01 00:00:00 | 2005-04-01 00:00:00 | 2005-01-01 00:00:00 | 2005-10-01 00:00:00 | None | 2006-01-01 00:00:00 | 2006-07-01 00:00:00 | 1900-01-01 00:00:00 | 2006-04-01 00:00:00 | 2006-10-01 00:00:00 | 1900-01-01 00:00:00 | 2007-01-01 00:00:00 | 2007-04-01 00:00:00 | 2007-07-01 00:00:00 | 2013-04-01 00:00:00 | 2012-07-01 00:00:00 | 2015-01-01 00:00:00 | 2015-04-01 00:00:00 | 2015-01-01 00:00:00 | 2014-10-01 00:00:00 | 2014-04-01 00:00:00 | 1900-01-01 00:00:00 | 2014-10-01 00:00:00 | 2014-07-01 00:00:00 | 2008-01-01 00:00:00 | 2007-10-01 00:00:00 | 1900-01-01 00:00:00 | 2008-07-24 00:00:00 | 2008-04-01 00:00:00 | 2008-07-01 00:00:00 | 2008-10-01 00:00:00 | 2008-12-30 00:00:00 | 2008-12-30 00:00:00 | 1900-01-01 00:00:00 | 2009-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2009-07-01 00:00:00 | 2009-04-01 00:00:00 | 2009-10-01 00:00:00 | 2010-04-01 00:00:00 | 2010-01-01 00:00:00 | 2010-07-01 00:00:00 | 2010-10-01 00:00:00 | 1900-01-01 00:00:00 | 2010-12-30 00:00:00 | 2011-01-01 00:00:00 | 2011-04-01 00:00:00 | 2011-10-01 00:00:00 | 2011-07-01 00:00:00 | 2012-01-01 00:00:00 | 2012-04-01 00:00:00 | 2013-10-01 00:00:00 | 2013-07-01 00:00:00 | 2014-10-01 00:00:00 | 2014-10-01 00:00:00 | 2012-07-01 00:00:00 | 2012-12-18 00:00:00 | 2012-10-01 00:00:00 | 1900-01-01 00:00:00 | 2014-01-01 00:00:00 | 2013-01-01 00:00:00 | 2015-04-01 00:00:00 | 2019-04-01 00:00:00 | 2020-04-01 00:00:00 | 2018-07-01 00:00:00 | 2019-01-04 00:00:00 | 2019-01-01 00:00:00 | 2015-07-01 00:00:00 | 2015-10-01 00:00:00 | 2016-01-01 00:00:00 | 2016-04-01 00:00:00 | 2016-07-01 00:00:00 | 2016-10-01 00:00:00 | 2017-01-01 00:00:00 | 2016-10-01 00:00:00 | 1900-01-01 00:00:00 | 2017-04-01 00:00:00 | 2018-01-01 00:00:00 | 2017-10-01 00:00:00 | 2019-10-01 00:00:00 | 2020-01-01 00:00:00 | 2020-10-01 00:00:00 | 2017-07-01 00:00:00 | 2020-01-01 00:00:00 | 1900-01-01 00:00:00 | 2020-07-01 00:00:00 | 2018-10-01 00:00:00 | 2019-07-01 00:00:00 | 2018-04-01 00:00:00 | 1900-01-01 00:00:00 | 2019-04-01 00:00:00 | 2017-04-01 00:00:00 | 2019-07-01 00:00:00 | 2019-10-01 00:00:00 | 2021-01-01 00:00:00 | 2021-07-01 00:00:00 | 2020-10-01 00:00:00 | 2021-04-01 00:00:00 | 2021-07-01 00:00:00 | 2019-01-01 00:00:00 | 1900-01-01 00:00:00 | 2021-04-01 00:00:00 | 2021-01-04 00:00:00 | 2021-10-01 00:00:00 | 2022-01-01 00:00:00 | 2022-04-01 00:00:00 | 2021-10-01 00:00:00 | 2020-07-01 00:00:00 | 2021-04-01 00:00:00 | 2022-07-01 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_end | 1997-06-30 00:00:00 | 1997-12-31 00:00:00 | 1999-09-30 00:00:00 | 1998-12-31 00:00:00 | 1998-06-30 00:00:00 | 1998-09-30 00:00:00 | 1999-06-30 00:00:00 | 1998-03-31 00:00:00 | 1998-06-30 00:00:00 | 1999-03-31 00:00:00 | 1997-09-30 00:00:00 | 1998-03-31 00:00:00 | 1997-12-31 00:00:00 | 1999-06-30 00:00:00 | None | 2000-03-31 00:00:00 | 1999-12-31 00:00:00 | 2000-06-30 00:00:00 | 2000-09-30 00:00:00 | 1900-01-01 00:00:00 | 2000-12-31 00:00:00 | 2000-09-30 00:00:00 | 2000-12-31 00:00:00 | 2001-03-31 00:00:00 | 2001-03-31 00:00:00 | 2001-06-30 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 | 2001-12-31 00:00:00 | 2002-03-31 00:00:00 | 2002-06-30 00:00:00 | 2002-03-31 00:00:00 | 2002-06-30 00:00:00 | 2002-09-30 00:00:00 | 2002-09-30 00:00:00 | 2002-09-30 00:00:00 | 2002-12-31 00:00:00 | 2002-12-31 00:00:00 | 1900-01-01 00:00:00 | 2002-12-10 00:00:00 | 2003-03-31 00:00:00 | 2003-03-31 00:00:00 | 2003-06-30 00:00:00 | 2003-06-30 00:00:00 | 2003-09-30 00:00:00 | 2003-12-31 00:00:00 | 2003-09-30 00:00:00 | 2004-03-31 00:00:00 | 2003-12-31 00:00:00 | 2004-06-30 00:00:00 | 2004-03-31 00:00:00 | 2004-06-30 00:00:00 | 2004-09-30 00:00:00 | 2004-12-31 00:00:00 | 2004-09-30 00:00:00 | 2004-12-15 00:00:00 | 1900-01-01 00:00:00 | 2004-12-31 00:00:00 | 2005-09-30 00:00:00 | 2005-06-30 00:00:00 | 2005-03-31 00:00:00 | 2005-12-31 00:00:00 | None | 2006-03-31 00:00:00 | 2006-09-30 00:00:00 | 1900-01-01 00:00:00 | 2006-06-30 00:00:00 | 2006-12-31 00:00:00 | 1900-01-01 00:00:00 | 2007-03-31 00:00:00 | 2007-06-30 00:00:00 | 2007-09-30 00:00:00 | 2013-06-30 00:00:00 | 2012-09-30 00:00:00 | 2015-03-31 00:00:00 | 2015-06-30 00:00:00 | 2015-03-31 00:00:00 | 2014-12-31 00:00:00 | 2014-06-30 00:00:00 | 1900-01-01 00:00:00 | 2014-12-31 00:00:00 | 2014-09-30 00:00:00 | 2008-03-31 00:00:00 | 2007-12-31 00:00:00 | 1900-01-01 00:00:00 | 2008-07-24 00:00:00 | 2008-06-30 00:00:00 | 2008-09-30 00:00:00 | 2008-12-31 00:00:00 | 2008-12-30 00:00:00 | 2008-12-30 00:00:00 | 1900-01-01 00:00:00 | 2009-03-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2009-09-30 00:00:00 | 2009-06-30 00:00:00 | 2009-12-31 00:00:00 | 2010-06-30 00:00:00 | 2010-03-31 00:00:00 | 2010-09-30 00:00:00 | 2010-12-31 00:00:00 | 1900-01-01 00:00:00 | 2010-12-30 00:00:00 | 2011-03-31 00:00:00 | 2011-06-30 00:00:00 | 2011-12-31 00:00:00 | 2011-09-30 00:00:00 | 2012-03-31 00:00:00 | 2012-06-30 00:00:00 | 2013-12-31 00:00:00 | 2013-09-30 00:00:00 | 2014-12-31 00:00:00 | 2014-12-31 00:00:00 | 2012-09-30 00:00:00 | 2012-12-18 00:00:00 | 2012-12-31 00:00:00 | 1900-01-01 00:00:00 | 2014-03-31 00:00:00 | 2013-03-31 00:00:00 | 2015-06-30 00:00:00 | 2019-06-30 00:00:00 | 2020-06-30 00:00:00 | 2018-09-30 00:00:00 | 2019-01-04 00:00:00 | 2019-03-31 00:00:00 | 2015-09-30 00:00:00 | 2015-12-31 00:00:00 | 2016-03-31 00:00:00 | 2016-06-30 00:00:00 | 2016-09-30 00:00:00 | 2016-12-31 00:00:00 | 2017-03-31 00:00:00 | 2016-12-31 00:00:00 | 1900-01-01 00:00:00 | 2017-06-30 00:00:00 | 2018-03-31 00:00:00 | 2017-12-31 00:00:00 | 2019-12-31 00:00:00 | 2020-03-31 00:00:00 | 2020-12-31 00:00:00 | 2017-09-30 00:00:00 | 2020-03-31 00:00:00 | 1900-01-01 00:00:00 | 2020-09-30 00:00:00 | 2018-12-31 00:00:00 | 2019-09-30 00:00:00 | 2018-06-30 00:00:00 | 1900-01-01 00:00:00 | 2019-06-30 00:00:00 | 2017-06-30 00:00:00 | 2019-09-30 00:00:00 | 2019-12-31 00:00:00 | 2021-03-31 00:00:00 | 2021-09-30 00:00:00 | 2020-12-31 00:00:00 | 2021-06-30 00:00:00 | 2021-09-30 00:00:00 | 2019-03-31 00:00:00 | 1900-01-01 00:00:00 | 2021-06-30 00:00:00 | 2021-01-04 00:00:00 | 2021-12-31 00:00:00 | 2022-03-31 00:00:00 | 2022-06-30 00:00:00 | 2021-12-31 00:00:00 | 2020-09-30 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | 22001 | 22001 | None | None | 22001 | 22001 | 22001 | None | None | None | 22001 | 22001 | 22001 | None | 22001 | None | None | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22006 | None | 22001 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | None | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22001 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 |
filer_id | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
session_id | 2003 | 2001 | 1999 | 1997 | 2011 | 2009 | 2007 | 2013 | 2005 | 2015 | 2019 | 2021 | 2017 | 2023 | ||||||||||||||
interest_cd | 40319 | 40319 | 40319 | 40319 | 40319 | 40319 | 40319 | 40319 | 40319 | 40319 | 40319 | 40319 | 40319 | 40319 | ||||||||||||||
effect_date | 2003-01-01 00:00:00 | 2001-01-01 00:00:00 | 1999-01-01 00:00:00 | 1997-04-01 00:00:00 | 2011-01-01 00:00:00 | 2009-01-01 00:00:00 | 2007-01-01 00:00:00 | 2013-01-01 00:00:00 | 2005-01-01 00:00:00 | 2015-01-01 00:00:00 | 2019-01-01 00:00:00 | 2021-01-01 00:00:00 | 2017-01-01 00:00:00 | 2023-01-01 00:00:00 |
filer_id | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_type | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | ||||||||||||||
active | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | N | ||||||||||||||
race | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
session_id | 1999 | 1997 | 2001 | 2003 | 2005 | 2007 | 2013 | 2011 | 2009 | 2017 | 2019 | 2021 | 2015 | 2023 | ||||||||||||||
category | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
category_type | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
sub_category | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
effect_dt | 1999-01-01 00:00:00 | 1997-04-01 00:00:00 | 2001-01-01 00:00:00 | 2003-01-01 00:00:00 | 2005-01-01 00:00:00 | 2007-01-01 00:00:00 | 2013-01-01 00:00:00 | 2011-01-01 00:00:00 | 2009-01-01 00:00:00 | 2017-01-01 00:00:00 | 2019-01-01 00:00:00 | 2021-01-01 00:00:00 | 2015-01-01 00:00:00 | 2023-01-01 00:00:00 | ||||||||||||||
sub_category_type | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
election_type | 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 | ||||||||||||||
nyq_dt | None | None | None | None | 2000-07-01 00:00:00 | 2000-07-01 00:00:00 | None | None | None | None | None | None | None | None | ||||||||||||||
party_cd | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
county_cd | 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 |
filer_id | 1145547 | |
---|---|---|
xref_id | C27049 | |
effect_dt | 1999-12-08 00:00:00 | |
migration_source | MASTER |
xref_filer_id | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | C27049 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_id | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
naml | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
city | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | PORTLAND | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
st | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | OR | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
zip4 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | 97232 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
phon | 5034645767 | 5038137202 | 5038135395 | 5038135678 | 5038137202 | 5038137202 | 5038137202 | 5038137202 | 5038136019 | 5038136019 | 5038136019 | 5038136019 | 5038136019 | 5034645767 | 5038137202 | 5038135395 | 5038135678 | 5038137202 | 5038137202 | 5038137202 | 5038137202 | 5038136019 | 5038136019 | 5038136019 | 5038136019 | 5038136019 | 5034645767 | 5038137202 | 5038135395 | 5038135678 | 5038137202 | 5038137202 | 5038137202 | 5038137202 | 5038136019 | 5038136019 | 5038136019 | 5038136019 | 5038136019 | 5034645767 | 5038137202 | 5038135395 | 5038135678 | 5038137202 | 5038137202 | 5038137202 | 5038137202 | 5038136019 | 5038136019 | 5038136019 | 5038136019 | 5038136019 | 5034645767 | 5038137202 | 5038135395 | 5038135678 | 5038137202 | 5038137202 | 5038137202 | 5038137202 | 5038136019 | 5038136019 | 5038136019 | 5038136019 | 5038136019 | 5034645767 | 5038137202 | 5038135395 | 5038135678 | 5038137202 | 5038137202 | 5038137202 | 5038137202 | 5038136019 | 5038136019 | 5038136019 | 5038136019 | 5038136019 | 5034645767 | 5038137202 | 5038135395 | 5038135678 | 5038137202 | 5038137202 | 5038137202 | 5038137202 | 5038136019 | 5038136019 | 5038136019 | 5038136019 | 5038136019 | 5034645767 | 5038137202 | 5038135395 | 5038135678 | 5038137202 | 5038137202 | 5038137202 | 5038137202 | 5038136019 | 5038136019 | 5038136019 | 5038136019 | 5038136019 | 5034645767 | 5038137202 | 5038135395 | 5038135678 | 5038137202 | 5038137202 | 5038137202 | 5038137202 | 5038136019 | 5038136019 | 5038136019 | 5038136019 | 5038136019 | 5034645767 | 5038137202 | 5038135395 | 5038135678 | 5038137202 | 5038137202 | 5038137202 | 5038137202 | 5038136019 | 5038136019 | 5038136019 | 5038136019 | 5038136019 | 5034645767 | 5038137202 | 5038135395 | 5038135678 | 5038137202 | 5038137202 | 5038137202 | 5038137202 | 5038136019 | 5038136019 | 5038136019 | 5038136019 | 5038136019 | 5034645767 | 5038137202 | 5038135395 | 5038135678 | 5038137202 | 5038137202 | 5038137202 | 5038137202 | 5038136019 | 5038136019 | 5038136019 | 5038136019 | 5038136019 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fax | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | 1145547 |
---|
filer_id | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | |||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
change_no | 1 | 2 | 3 | 4 | 5 | 0 | 6 | |||||||
session_id | 1999 | 2001 | 2001 | 2001 | 2005 | 2005 | 2007 | |||||||
log_dt | 2000-11-16 00:00:00 | 2001-03-21 00:00:00 | 2001-04-09 00:00:00 | 2001-07-03 00:00:00 | 2006-10-05 00:00:00 | 2006-08-10 00:00:00 | 2008-03-21 00:00:00 | |||||||
filer_type | 1 | 1 | 1 | 1 | 1 | 1 | 1 | |||||||
correction_flg | None | None | None | None | None | None | Y | |||||||
action | SET ACTIVE | IN SUSPENSE | IN SUSPENSE | SET ACTIVE | DELETED | ADDED | ADDED | |||||||
attribute_changed | CLIENT | FIRM | CLIENT | FIRM | FIRM | FIRM | FIRM | |||||||
ethics_dt | None | None | None | None | None | None | None | |||||||
interests | None | None | None | None | None | None | None | |||||||
filer_full_name | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | PACIFICORP | |||||||
filer_city | SAN MARCOS | SACRAMENTO | LEBEC | SACRAMENTO | None | None | PORTLAND | |||||||
filer_st | CA | CA | CA | CA | None | None | OR | |||||||
filer_zip | 92069 | 95814 | 93243 | 95814 | None | None | 97232 | |||||||
filer_phone | 7607441050 | 9164478229 | 6612483000 | 9164477933 | None | None | 5034645767 | |||||||
entity_type | 3 | 3 | 3 | 3 | 3 | 3 | 3 | |||||||
entity_name | SMITH & KEMPTON | SMITH, KEMPTON & WATTS | SMITH, KEMPTON & WATTS | SMITH, KEMPTON & WATTS | SMITH WATTS & COMPANY | PAUL, HASTINGS, JANOFSKY & WALKER LLP | DEWEY SQUARE GROUP | |||||||
entity_city | None | None | None | None | None | None | None | |||||||
entity_st | None | None | None | None | None | None | None | |||||||
entity_zip | None | None | None | None | None | None | None | |||||||
entity_phone | None | None | None | None | None | None | None | |||||||
entity_id | 1147283 | 1147283 | 1147283 | 1147283 | 1147283 | 1223535 | 1305400 | |||||||
responsible_officer | None | None | None | None | None | None | None | |||||||
effect_dt | None | None | None | None | 2006-10-01 00:00:00 | 2006-08-01 00:00:00 | 2008-03-12 00:00:00 |
filer_id | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | 1145547 | |||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_file_name | 677884_0.cal | 718332_0.cal | 743560_0.cal | 770143_0.cal | 787354_0.cal | 810495_0.cal | 836332_0.cal | 851415_0.cal | 876504_0.cal | 896062_0.cal | 909585_0.cal | 927960_0.cal | 943151_0.cal | 969224_0.cal | 982944_0.cal | 1010876_0.cal | 1023695_0.cal | 1049647_0.cal | 1074485_0.cal | 1068657_0.cal | 1104534_0.cal | 1117114_0.cal | 1132541_0.cal | 1146940_0.cal | 1166650_0.cal | 1191120_0.cal | 1556218_0.cal | |||||||||||||||||||||||||||
received_date | 2000-10-26 00:00:00 | 2001-01-31 00:00:00 | 2001-04-25 00:00:00 | 2001-07-26 00:00:00 | 2001-10-16 00:00:00 | 2002-01-25 00:00:00 | 2002-04-22 00:00:00 | 2002-07-24 00:00:00 | 2002-10-22 00:00:00 | 2002-12-13 00:00:00 | 2003-01-30 00:00:00 | 2003-04-18 00:00:00 | 2003-07-21 00:00:00 | 2003-10-30 00:00:00 | 2004-01-16 00:00:00 | 2004-04-23 00:00:00 | 2004-07-19 00:00:00 | 2004-10-20 00:00:00 | 2005-01-24 00:00:00 | 2004-12-29 00:00:00 | 2005-04-29 00:00:00 | 2005-07-29 00:00:00 | 2005-10-28 00:00:00 | 2006-01-30 00:00:00 | 2006-04-28 00:00:00 | 2006-07-31 00:00:00 | 2010-12-30 00:00:00 | |||||||||||||||||||||||||||
filing_directory | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /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 | 677884 | 718332 | 743560 | 770143 | 787354 | 810495 | 836332 | 851415 | 876504 | 896062 | 909585 | 927960 | 943151 | 969224 | 982944 | 1010876 | 1023695 | 1049647 | 1074485 | 1068657 | 1104534 | 1117114 | 1132541 | 1146940 | 1166650 | 1191120 | 1556218 | |||||||||||||||||||||||||||
form_id | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | |||||||||||||||||||||||||||
receive_comment | Filing accepted, but but with warnings | Filing accepted, but with warnings | Filing accepted, but with warnings | Filing accepted, but with warnings | Filing accepted, but with warnings | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | 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 |