filer_id | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
adrid | 1107529 | 1107553 | 2048789 | 2080623 | 2116838 | 2165144 | 2206301 | 2417306 | 2277507 | 2509097 | 2339395 | 2550394 | 2468590 | |||||||||||||
effect_dt | 1997-01-01 00:00:00 | 1995-01-01 00:00:00 | 2003-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 | 2013-01-01 00:00:00 | 2021-01-01 00:00:00 | 2015-01-01 00:00:00 | 2023-01-01 00:00:00 | 2019-01-01 00:00:00 | |||||||||||||
add_type | 7051 | 7050 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | |||||||||||||
session_id | 1997 | 1995 | 2003 | 2005 | 2007 | 2009 | 2011 | 2017 | 2013 | 2021 | 2015 | 2023 | 2019 |
filer_id | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 467785 | 476544 | 469382 | 480489 | 465749 | 482103 | 473212 | 489391 | 485703 | 478763 | 491400 | 495081 | 496719 | 487683 | 540620 | 470995 | 464253 | 496719 | 493107 | 484057 | 629211 | 635641 | 620635 | 659680 | 682378 | 660348 | 653599 | 651381 | 651383 | 696476 | 712885 | 739891 | 754295 | 763935 | 773206 | 768894 | 773206 | 777585 | 796665 | 812162 | 798700 | 798508 | 838164 | 841019 | 821748 | 822113 | 862469 | 890464 | 852740 | 908169 | 882653 | 930391 | 956437 | 944846 | 923656 | 928412 | 912143 | 966899 | 966664 | 928412 | 984822 | 980887 | 974534 | 966664 | 992146 | 1010974 | 1025533 | 1028803 | 997170 | 1016673 | 1065924 | 1049589 | 1068832 | 1073726 | 1083039 | 1092259 | 1102137 | 1113689 | 1144345 | 1102137 | 1129361 | 1164224 | 1113689 | 1189492 | 1184674 | 1192028 | 1212578 | 1259021 | 1225468 | 1259021 | 1285068 | 1235099 | 1245200 | 1307124 | 1295856 | 1965724 | 1818729 | 1780158 | 1798864 | 1936604 | 1942737 | 1911094 | 1316042 | 1315856 | 1327815 | 1346716 | 1375872 | 1385376 | 1395644 | 1416053 | 1431767 | 1430830 | 1433928 | 1419276 | 1462691 | 1419276 | 1433928 | 1482874 | 1450454 | 1442547 | 1504636 | 1504939 | 1535829 | 1565014 | 1556096 | 1553498 | 1619678 | 1603786 | 1588135 | 1632071 | 1655346 | 1675095 | 1818729 | 1655346 | 1923651 | 1706634 | 1719514 | 1872264 | 1872264 | 1735192 | 1849790 | 1746474 | 1763290 | 1994182 | 1965724 | 1980783 | 1994182 | 1965724 | 1980783 | 2419453 | 2193721 | 2241270 | 2273409 | 2463481 | 2581499 | 2582561 | 2350191 | 1994182 | 2010533 | 2036180 | 2061146 | 2102256 | 2114400 | 2130444 | 2130444 | 2143816 | 2176047 | 2130444 | 2157359 | 2102256 | 2399338 | 2381304 | 2486596 | 2429960 | 2319122 | 2211996 | 2444168 | 2554211 | 2330206 | 2351102 | 2531599 | 2444168 | 2470174 | 2645663 | 2677015 | 2708122 | 2542300 | 2602001 | 2624698 | 2749204 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
period_id | 157 | 151 | 142 | 144 | 149 | 152 | 158 | 154 | 153 | 159 | 147 | 148 | 156 | 146 | 143 | 150 | 141 | 156 | 155 | 145 | None | None | 160 | 162 | 163 | 162 | 162 | 159 | 160 | 163 | None | 164 | 165 | 165 | 166 | 165 | 166 | None | None | 168 | 167 | 165 | 169 | None | None | None | None | None | 170 | 172 | 171 | None | None | 174 | None | 173 | None | None | 175 | 173 | 176 | None | None | 175 | None | 177 | 178 | None | None | None | None | 179 | 180 | 180 | None | None | 181 | 182 | 184 | 181 | 183 | 185 | 182 | 186 | None | 187 | 187 | 189 | 188 | 189 | 190 | 188 | None | 192 | 191 | 221 | 216 | 214 | 215 | 220 | None | 219 | 193 | None | 193 | 194 | 195 | 196 | 196 | None | None | 199 | 198 | 197 | 200 | 197 | 198 | 201 | 199 | None | 202 | None | 203 | 204 | None | 204 | 207 | 206 | 205 | 208 | 209 | 210 | 216 | 209 | 220 | 211 | 212 | 218 | 218 | 212 | 217 | None | 213 | 223 | 221 | 222 | 223 | 221 | 222 | 239 | 231 | 233 | 234 | 240 | 245 | None | 236 | 223 | 224 | 225 | 226 | 227 | 228 | 228 | 228 | None | 230 | 228 | 229 | 227 | 238 | 237 | 242 | None | 235 | 232 | 240 | 244 | 236 | None | 243 | 240 | 241 | 248 | 249 | 250 | 244 | 246 | 247 | 251 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F690 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F690 | F690 | F690 | F635 | F602 | F635 | F635 | F690 | F635 | 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 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F602 | F635 | F635 | F602 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F602 | F602 | F635 | F635 | F635 | F602 | F635 | F602 | F602 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F605 | F635 | F635 | F602 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F602 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F602 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_sequence | 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 | 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 | 1 | 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 | 1 | 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 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 2 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_date | 1999-05-03 00:00:00 | 1997-10-31 00:00:00 | 1995-07-31 00:00:00 | 1996-01-31 00:00:00 | 1997-04-30 00:00:00 | 1998-02-02 00:00:00 | 1999-08-02 00:00:00 | 1998-08-03 00:00:00 | 1998-04-30 00:00:00 | 1999-11-01 00:00:00 | 1996-10-31 00:00:00 | 1997-01-31 00:00:00 | 1999-02-01 00:00:00 | 1996-07-31 00:00:00 | 1995-10-31 00:00:00 | 1997-07-31 00:00:00 | 1995-05-01 00:00:00 | 1999-02-10 00:00:00 | 1998-11-02 00:00:00 | 1996-04-30 00:00:00 | 2000-05-01 00:00:00 | 2000-06-09 00:00:00 | 2000-02-03 00:00:00 | 2000-07-31 00:00:00 | 2000-10-31 00:00:00 | 2000-07-31 00:00:00 | 2000-08-18 00:00:00 | 2000-07-31 00:00:00 | 2000-07-31 00:00:00 | 2000-10-31 00:00:00 | 2001-01-02 00:00:00 | 2001-01-31 00:00:00 | 2001-04-30 00:00:00 | 2001-05-08 00:00:00 | 2001-07-31 00:00:00 | 2001-04-30 00:00:00 | 2001-07-31 00:00:00 | 2001-07-31 00:00:00 | 2001-10-31 00:00:00 | 2002-01-29 00:00:00 | 2001-11-21 00:00:00 | 2001-11-20 00:00:00 | 2002-04-29 00:00:00 | 2002-04-29 00:00:00 | 2002-02-11 00:00:00 | 2002-01-31 00:00:00 | 2002-07-30 00:00:00 | 2002-10-30 00:00:00 | 2002-07-26 00:00:00 | 2003-01-29 00:00:00 | 2002-10-30 00:00:00 | 2003-04-24 00:00:00 | 2003-07-29 00:00:00 | 2003-07-28 00:00:00 | 2003-02-27 00:00:00 | 2003-04-22 00:00:00 | 2003-01-30 00:00:00 | 2003-08-08 00:00:00 | 2003-10-24 00:00:00 | 2003-08-05 00:00:00 | 2004-01-22 00:00:00 | 2003-11-10 00:00:00 | 2003-10-27 00:00:00 | 2003-11-04 00:00:00 | 2004-02-05 00:00:00 | 2004-04-26 00:00:00 | 2004-07-26 00:00:00 | 2004-07-27 00:00:00 | 2004-01-26 00:00:00 | 2004-04-27 00:00:00 | 2004-10-21 00:00:00 | 2004-10-20 00:00:00 | 2004-12-29 00:00:00 | 2005-01-20 00:00:00 | 2004-12-30 00:00:00 | 2005-01-24 00:00:00 | 2005-04-22 00:00:00 | 2005-07-25 00:00:00 | 2006-01-25 00:00:00 | 2005-10-21 00:00:00 | 2005-10-21 00:00:00 | 2006-04-25 00:00:00 | 2006-02-23 00:00:00 | 2006-07-28 00:00:00 | 2006-07-17 00:00:00 | 2006-07-31 00:00:00 | 2006-10-26 00:00:00 | 2007-04-24 00:00:00 | 2006-12-29 00:00:00 | 2007-07-31 00:00:00 | 2007-07-31 00:00:00 | 2007-01-30 00:00:00 | 2006-12-29 00:00:00 | 2008-01-28 00:00:00 | 2007-10-29 00:00:00 | 2015-04-30 00:00:00 | 2014-06-12 00:00:00 | 2013-07-29 00:00:00 | 2013-10-29 00:00:00 | 2015-02-02 00:00:00 | 2015-01-08 00:00:00 | 2014-10-31 00:00:00 | 2008-02-20 00:00:00 | 2008-02-14 00:00:00 | 2008-04-28 00:00:00 | 2008-07-28 00:00:00 | 2008-10-30 00:00:00 | 2008-12-24 00:00:00 | 2009-01-30 00:00:00 | 2008-12-30 00:00:00 | 2009-07-16 00:00:00 | 2009-07-15 00:00:00 | 2009-07-27 00:00:00 | 2009-04-28 00:00:00 | 2010-01-29 00:00:00 | 2009-10-08 00:00:00 | 2009-10-08 00:00:00 | 2010-04-27 00:00:00 | 2009-10-28 00:00:00 | 2009-08-07 00:00:00 | 2010-07-28 00:00:00 | 2010-07-27 00:00:00 | 2010-10-26 00:00:00 | 2011-01-24 00:00:00 | 2010-12-23 00:00:00 | 2010-12-22 00:00:00 | 2011-10-26 00:00:00 | 2011-07-26 00:00:00 | 2011-04-25 00:00:00 | 2012-01-26 00:00:00 | 2012-04-26 00:00:00 | 2012-07-26 00:00:00 | 2014-01-31 00:00:00 | 2012-06-07 00:00:00 | 2015-01-07 00:00:00 | 2012-10-29 00:00:00 | 2012-12-21 00:00:00 | 2014-07-31 00:00:00 | 2014-08-01 00:00:00 | 2013-01-29 00:00:00 | 2014-05-14 00:00:00 | 2012-12-27 00:00:00 | 2013-04-29 00:00:00 | 2015-10-26 00:00:00 | 2015-11-18 00:00:00 | 2015-11-18 00:00:00 | 2015-11-18 00:00:00 | 2015-07-30 00:00:00 | 2015-07-30 00:00:00 | 2019-10-31 00:00:00 | 2017-10-31 00:00:00 | 2018-04-30 00:00:00 | 2018-07-30 00:00:00 | 2020-03-18 00:00:00 | 2021-04-30 00:00:00 | 2021-01-06 00:00:00 | 2019-01-31 00:00:00 | 2016-02-22 00:00:00 | 2016-01-29 00:00:00 | 2016-04-29 00:00:00 | 2016-07-29 00:00:00 | 2016-10-31 00:00:00 | 2016-12-28 00:00:00 | 2017-01-31 00:00:00 | 2017-02-22 00:00:00 | 2016-12-29 00:00:00 | 2017-07-31 00:00:00 | 2017-05-16 00:00:00 | 2017-05-01 00:00:00 | 2017-05-16 00:00:00 | 2019-07-31 00:00:00 | 2019-04-30 00:00:00 | 2020-07-31 00:00:00 | 2020-01-08 00:00:00 | 2018-10-31 00:00:00 | 2018-01-31 00:00:00 | 2020-03-06 00:00:00 | 2021-02-01 00:00:00 | 2018-12-28 00:00:00 | 2018-12-28 00:00:00 | 2020-11-02 00:00:00 | 2020-01-31 00:00:00 | 2020-04-30 00:00:00 | 2022-01-31 00:00:00 | 2022-05-02 00:00:00 | 2022-08-01 00:00:00 | 2021-01-05 00:00:00 | 2021-08-01 00:00:00 | 2021-11-01 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 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10005 | 10005 | 10005 | 10001 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10006 | 10001 | 10001 | 10002 | 10005 | 10005 | 10001 | 10001 | 10001 | 10001 | 10005 | 10005 | 10005 | 10005 | 10005 | 10001 | 10001 | 10001 | 10005 | 10005 | 10001 | 10005 | 10001 | 10005 | 10006 | 10001 | 10002 | 10001 | 10006 | 10005 | 10002 | 10005 | 10001 | 10001 | 10005 | 10005 | 10005 | 10005 | 10001 | 10001 | 10001 | 10005 | 10005 | 10001 | 10001 | 10001 | 10002 | 10001 | 10001 | 10002 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10002 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10005 | 10001 | 10001 | 10001 | 10001 | 10002 | 10002 | 10001 | 10001 | 10005 | 10001 | 10006 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | 10001 | 10005 | 10001 | 10001 | 10002 | 10002 | 10002 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10005 | 10001 | 10002 | 10001 | 10002 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_status | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
session_id | 1999 | 1997 | 1995 | 1995 | 1997 | 1997 | 1999 | 1997 | 1997 | 1999 | 1995 | 1995 | 1997 | 1995 | 1995 | 1997 | 1995 | 1997 | 1997 | 1995 | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 2001 | 1999 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2003 | 2003 | 2003 | 2003 | 2003 | 2001 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2005 | 2003 | 2005 | 2003 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2007 | 2007 | 2007 | 2007 | 2005 | 2007 | 2007 | 2007 | 2015 | 2013 | 2013 | 2013 | 2013 | 2015 | 2013 | 2007 | 2007 | 2007 | 2007 | 2007 | 2009 | 2007 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2013 | 2011 | 2015 | 2011 | 2013 | 2013 | 2013 | 2011 | 2013 | 2013 | 2013 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2019 | 2017 | 2017 | 2017 | 2019 | 2021 | 2021 | 2017 | 2015 | 2015 | 2015 | 2015 | 2015 | 2017 | 2015 | 2015 | 2017 | 2017 | 2015 | 2017 | 2015 | 2019 | 2019 | 2019 | 2019 | 2017 | 2017 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
user_id | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | TTHAM | CFLAGG | * | YBONILLA | * | YBONILLA | JLEHMAN | JLEHMAN | JLEHMAN | YBONILLA | NJACKSON | YBONILLA | LTHIBAUL | YBONILLA | * | MHOANG | * | LTHIBAUL | LTHIBAUL | * | DHORRELL | * | * | LTHIBAUL | SARRIAGA | LTHIBAUL | LTHIBAUL | LTHIBAUL | * | COMPLETED | * | LTHIBAUL | LTHIBAUL | COMPLETED | CFLAGG | COMPLETED | DBARRICK | KVOONG1 | COMPLETED | COMPLETED | COMPLETED | YBONILLA | LTHIBAUL | COMPLETED | GPEREZ | COMPLETED | COMPLETED | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | COMPLETED | COMPLETED | COMPLETED | PBANFORD | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | * | LTHIBAUL | CFLAGG | * | LTHIBAUL | LTHIBAUL | * | LTHIBAUL | YRODRIGU | LTHIBAUL | GPEREZ | LTHIBAUL | YRODRIGU | AGLADNEY | ASAETERN | AGLADNEY | AGLADNEY | AGLADNEY | GKURIMOT | AGLADNEY | * | GPEREZ | LTHIBAUL | LTHIBAUL | CFLAGG | YRODRIGU | CFLAGG | PBANFORD | YRODRIGU | YRODRIGU | WBROWN | WBROWN | WBROWN | WBROWN | WBROWN | ASAETERN | MGUERRA | YRODRIGU | ASAETERN | YRODRIGU | ASAETERN | AGLADNEY | PBANFORD | PBANFORD | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | ASAETERN | ASAETERN | AGLADNEY | CAFILER | AGLADNEY | SARRIAGA | ASAETERN | ASAETERN | AGLADNEY | RGEREMIA | SARRIAGA | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | CAFILER | GTAYLOR | SARRIAGA | AGLADNEY | JINGRAM | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | CAFILER | AGLADNEY | AGLADNEY | GPEREZ | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | SUSHAKOV | GTAYLOR | GTAYLOR | AROJAS | AGLADNEY | AGLADNEY | GTAYLOR | GTAYLOR | PBANFORD | PBANFORD | GTAYLOR | VUKSTINA | VUKSTINA | CHATRIDGE | CAFILER | CAFILER | SARRIAGA | CHATRIDGE | CHATRIDGE | CAFILER | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
special_audit | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11002 | 11003 | 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 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fine_audit | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 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 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_start | 1999-01-01 00:00:00 | 1997-07-01 00:00:00 | 1995-04-01 00:00:00 | 1995-10-01 00:00:00 | 1997-01-01 00:00:00 | 1997-10-01 00:00:00 | 1999-04-01 00:00:00 | 1998-04-01 00:00:00 | 1998-01-01 00:00:00 | 1999-07-01 00:00:00 | 1996-07-01 00:00:00 | 1996-10-01 00:00:00 | 1998-10-01 00:00:00 | 1996-04-01 00:00:00 | 1995-07-01 00:00:00 | 1997-04-01 00:00:00 | 1995-01-01 00:00:00 | 1998-10-01 00:00:00 | 1998-07-01 00:00:00 | 1996-01-01 00:00:00 | 2000-01-01 00:00:00 | None | 1999-10-01 00:00:00 | 2000-04-01 00:00:00 | 2000-07-01 00:00:00 | 2000-04-01 00:00:00 | 2000-04-01 00:00:00 | 1999-07-01 00:00:00 | 1999-10-01 00:00:00 | 2000-07-01 00:00:00 | 1900-01-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 | None | 2001-04-01 00:00:00 | 2001-04-01 00:00:00 | 2001-07-01 00:00:00 | 2001-10-01 00:00:00 | 2001-07-01 00:00:00 | 2001-01-01 00:00:00 | 2002-01-01 00:00:00 | 2002-01-01 00:00:00 | 1900-01-01 00:00:00 | 2001-10-01 00:00:00 | 2002-04-01 00:00:00 | 2002-07-01 00:00:00 | 2002-04-01 00:00:00 | 2002-10-01 00:00:00 | 2002-07-01 00:00:00 | 2003-01-01 00:00:00 | 2003-04-01 00:00:00 | 2003-04-01 00:00:00 | 1900-01-01 00:00:00 | 2003-01-01 00:00:00 | 2002-10-01 00:00:00 | 2003-01-01 00:00:00 | 2003-07-01 00:00:00 | 2003-01-01 00:00:00 | 2003-10-01 00:00:00 | 2003-07-01 00:00:00 | 2003-07-01 00:00:00 | 2003-07-01 00:00:00 | 1900-01-01 00:00:00 | 2004-01-01 00:00:00 | 2004-04-01 00:00:00 | 2004-04-01 00:00:00 | 2003-10-01 00:00:00 | 2004-01-01 00:00:00 | 2004-07-01 00:00:00 | 2004-07-01 00:00:00 | 2004-12-29 00:00:00 | 2004-10-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-10-01 00:00:00 | 2005-01-01 00:00:00 | 2005-07-01 00:00:00 | 2006-01-01 00:00:00 | 2005-04-01 00:00:00 | 2006-04-01 00:00:00 | 1900-01-01 00:00:00 | 2006-07-17 00:00:00 | 2006-07-01 00:00:00 | 2007-01-01 00:00:00 | 2006-12-13 00:00:00 | 2007-01-01 00:00:00 | 2007-04-01 00:00:00 | 2006-10-01 00:00:00 | 1900-01-01 00:00:00 | 2007-10-01 00:00:00 | 2007-07-01 00:00:00 | 2015-01-01 00:00:00 | 2013-10-01 00:00:00 | 2013-04-01 00:00:00 | 2013-07-01 00:00:00 | 2014-10-01 00:00:00 | 1900-01-01 00:00:00 | 2014-07-01 00:00:00 | 2008-02-20 00:00:00 | 1900-01-01 00:00:00 | 2008-01-01 00:00:00 | 2008-04-01 00:00:00 | 2008-07-01 00:00:00 | 2008-12-20 00:00:00 | 2008-10-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2009-07-15 00:00:00 | 2009-04-01 00:00:00 | 2009-01-01 00:00:00 | 2009-10-01 00:00:00 | 2009-01-01 00:00:00 | 2009-04-01 00:00:00 | 2010-01-01 00:00:00 | 2009-07-01 00:00:00 | 1900-01-01 00:00:00 | 2010-04-01 00:00:00 | 1900-01-01 00:00:00 | 2010-07-01 00:00:00 | 2010-10-01 00:00:00 | 1900-01-01 00:00:00 | 2010-11-15 00:00:00 | 2011-07-01 00:00:00 | 2011-04-01 00:00:00 | 2011-01-01 00:00:00 | 2011-10-01 00:00:00 | 2012-01-01 00:00:00 | 2012-04-01 00:00:00 | 2013-10-01 00:00:00 | 2012-01-01 00:00:00 | 2014-11-13 00:00:00 | 2012-07-01 00:00:00 | 2012-11-14 00:00:00 | 2014-04-01 00:00:00 | 2014-04-01 00:00:00 | 2012-10-01 00:00:00 | 2014-01-01 00:00:00 | 1900-01-01 00:00:00 | 2013-01-01 00:00:00 | 2015-07-01 00:00:00 | 2015-01-01 00:00:00 | 2015-04-01 00:00:00 | 2015-07-01 00:00:00 | 2015-01-01 00:00:00 | 2015-04-01 00:00:00 | 2019-07-01 00:00:00 | 2017-07-01 00:00:00 | 2018-01-01 00:00:00 | 2018-04-01 00:00:00 | 2019-11-06 00:00:00 | 2021-01-01 00:00:00 | 1900-01-01 00:00:00 | 2018-10-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-11-16 00:00:00 | 2016-10-01 00:00:00 | 2016-10-01 00:00:00 | 1900-01-01 00:00:00 | 2017-04-01 00:00:00 | 2016-10-01 00:00:00 | 2017-01-01 00:00:00 | 2016-07-01 00:00:00 | 2019-04-01 00:00:00 | 2019-01-01 00:00:00 | 2020-04-01 00:00:00 | 1900-01-01 00:00:00 | 2018-07-01 00:00:00 | 2017-10-01 00:00:00 | 2019-10-01 00:00:00 | 2020-10-01 00:00:00 | 2018-11-01 00:00:00 | 1900-01-01 00:00:00 | 2020-07-01 00:00:00 | 2019-10-01 00:00:00 | 2020-01-01 00:00:00 | 2021-10-01 00:00:00 | 2022-01-01 00:00:00 | 2022-04-01 00:00:00 | 2020-11-23 00:00:00 | 2021-04-01 00:00:00 | 2021-07-01 00:00:00 | 2022-07-01 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_end | 1999-03-31 00:00:00 | 1997-09-30 00:00:00 | 1995-06-30 00:00:00 | 1995-12-31 00:00:00 | 1997-03-31 00:00:00 | 1997-12-31 00:00:00 | 1999-06-30 00:00:00 | 1998-06-30 00:00:00 | 1998-03-31 00:00:00 | 1999-09-30 00:00:00 | 1996-09-30 00:00:00 | 1996-12-31 00:00:00 | 1998-12-31 00:00:00 | 1996-06-30 00:00:00 | 1995-09-30 00:00:00 | 1997-06-30 00:00:00 | 1995-03-31 00:00:00 | 1998-12-31 00:00:00 | 1998-09-30 00:00:00 | 1996-03-31 00:00:00 | 2000-03-31 00:00:00 | None | 1999-12-31 00:00:00 | 2000-06-30 00:00:00 | 2000-09-30 00:00:00 | 2000-06-30 00:00:00 | 2000-06-30 00:00:00 | 1999-09-30 00:00:00 | 1999-12-31 00:00:00 | 2000-09-30 00:00:00 | 1900-01-01 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 | None | 2001-06-30 00:00:00 | 2001-06-30 00:00:00 | 2001-09-30 00:00:00 | 2001-12-31 00:00:00 | 2001-09-30 00:00:00 | 2001-03-31 00:00:00 | 2002-03-31 00:00:00 | 2002-03-31 00:00:00 | 1900-01-01 00:00:00 | 2001-12-31 00:00:00 | 2002-06-30 00:00:00 | 2002-09-30 00:00:00 | 2002-06-30 00:00:00 | 2002-12-31 00:00:00 | 2002-09-30 00:00:00 | 2003-03-31 00:00:00 | 2003-06-30 00:00:00 | 2003-06-30 00:00:00 | 1900-01-01 00:00:00 | 2003-03-31 00:00:00 | 2002-12-31 00:00:00 | 2003-03-31 00:00:00 | 2003-09-30 00:00:00 | 2003-03-31 00:00:00 | 2003-12-31 00:00:00 | 2003-09-30 00:00:00 | 2003-09-30 00:00:00 | 2003-09-30 00:00:00 | 1900-01-01 00:00:00 | 2004-03-31 00:00:00 | 2004-06-30 00:00:00 | 2004-06-30 00:00:00 | 2003-12-31 00:00:00 | 2004-03-31 00:00:00 | 2004-09-30 00:00:00 | 2004-09-30 00:00:00 | 2004-12-29 00:00:00 | 2004-12-31 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-12-31 00:00:00 | 2005-03-31 00:00:00 | 2005-09-30 00:00:00 | 2006-03-31 00:00:00 | 2005-06-30 00:00:00 | 2006-06-30 00:00:00 | 1900-01-01 00:00:00 | 2006-07-17 00:00:00 | 2006-09-30 00:00:00 | 2007-03-31 00:00:00 | 2006-12-13 00:00:00 | 2007-03-31 00:00:00 | 2007-06-30 00:00:00 | 2006-12-31 00:00:00 | 1900-01-01 00:00:00 | 2007-12-31 00:00:00 | 2007-09-30 00:00:00 | 2015-03-31 00:00:00 | 2013-12-31 00:00:00 | 2013-06-30 00:00:00 | 2013-09-30 00:00:00 | 2014-12-31 00:00:00 | 1900-01-01 00:00:00 | 2014-09-30 00:00:00 | 2008-02-20 00:00:00 | 1900-01-01 00:00:00 | 2008-03-31 00:00:00 | 2008-06-30 00:00:00 | 2008-09-30 00:00:00 | 2008-12-20 00:00:00 | 2008-12-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2009-07-15 00:00:00 | 2009-06-30 00:00:00 | 2009-03-31 00:00:00 | 2009-12-31 00:00:00 | 2009-03-31 00:00:00 | 2009-06-30 00:00:00 | 2010-03-31 00:00:00 | 2009-09-30 00:00:00 | 1900-01-01 00:00:00 | 2010-06-30 00:00:00 | 1900-01-01 00:00:00 | 2010-09-30 00:00:00 | 2010-12-31 00:00:00 | 1900-01-01 00:00:00 | 2010-11-15 00:00:00 | 2011-09-30 00:00:00 | 2011-06-30 00:00:00 | 2011-03-31 00:00:00 | 2011-12-31 00:00:00 | 2012-03-31 00:00:00 | 2012-06-30 00:00:00 | 2013-12-31 00:00:00 | 2012-03-31 00:00:00 | 2014-11-13 00:00:00 | 2012-09-30 00:00:00 | 2012-11-14 00:00:00 | 2014-06-30 00:00:00 | 2014-06-30 00:00:00 | 2012-12-31 00:00:00 | 2014-03-31 00:00:00 | 1900-01-01 00:00:00 | 2013-03-31 00:00:00 | 2015-09-30 00:00:00 | 2015-03-31 00:00:00 | 2015-06-30 00:00:00 | 2015-09-30 00:00:00 | 2015-03-31 00:00:00 | 2015-06-30 00:00:00 | 2019-09-30 00:00:00 | 2017-09-30 00:00:00 | 2018-03-31 00:00:00 | 2018-06-30 00:00:00 | 2019-11-06 00:00:00 | 2021-03-31 00:00:00 | 1900-01-01 00:00:00 | 2018-12-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-11-16 00:00:00 | 2016-12-31 00:00:00 | 2016-12-31 00:00:00 | 1900-01-01 00:00:00 | 2017-06-30 00:00:00 | 2016-12-31 00:00:00 | 2017-03-31 00:00:00 | 2016-09-30 00:00:00 | 2019-06-30 00:00:00 | 2019-03-31 00:00:00 | 2020-06-30 00:00:00 | 1900-01-01 00:00:00 | 2018-09-30 00:00:00 | 2017-12-31 00:00:00 | 2019-12-31 00:00:00 | 2020-12-31 00:00:00 | 2018-11-01 00:00:00 | 1900-01-01 00:00:00 | 2020-09-30 00:00:00 | 2019-12-31 00:00:00 | 2020-03-31 00:00:00 | 2021-12-31 00:00:00 | 2022-03-31 00:00:00 | 2022-06-30 00:00:00 | 2020-11-23 00:00:00 | 2021-06-30 00:00:00 | 2021-09-30 00:00:00 | 2022-09-30 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_date | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | 22001 | None | None | None | 22001 | None | 22001 | None | None | 22001 | 22001 | 22001 | None | None | 22001 | None | 22001 | 22001 | None | None | None | None | 22001 | 22001 | 22001 | None | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22006 | 22001 | 22001 | 22001 | None | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | None | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | None | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22006 | 22001 | 22001 | 22001 | 22001 | 22006 | 22006 | 22001 | 22006 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 |
filer_id | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
session_id | 1999 | 1997 | 1995 | 2003 | 2001 | 2007 | 2013 | 2005 | 2009 | 2011 | 2021 | 2019 | 2017 | 2015 | 2023 | |||||||||||||||
interest_cd | 40305 | 40305 | 40305 | 40305 | 40305 | 40305 | 40305 | 40305 | 40305 | 40305 | 40305 | 40305 | 40305 | 40305 | 40305 | |||||||||||||||
effect_date | 1999-01-01 00:00:00 | 1997-01-01 00:00:00 | 1995-01-01 00:00:00 | 2003-01-01 00:00:00 | 2001-01-01 00:00:00 | 2007-01-01 00:00:00 | 2013-01-01 00:00:00 | 2005-01-01 00:00:00 | 2009-01-01 00:00:00 | 2011-01-01 00:00:00 | 2021-01-01 00:00:00 | 2019-01-01 00:00:00 | 2017-01-01 00:00:00 | 2015-01-01 00:00:00 | 2023-01-01 00:00:00 |
filer_id | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_type | 1 | 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 | Y | N | |||||||||||||||
race | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
session_id | 1995 | 1997 | 1999 | 2001 | 2003 | 2005 | 2007 | 2013 | 2011 | 2009 | 2017 | 2019 | 2015 | 2021 | 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 | 1995-01-01 00:00:00 | 1997-01-01 00:00:00 | 1999-01-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 | 2015-01-01 00:00:00 | 2021-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 | 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 | 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 | 1143017 | |
---|---|---|
xref_id | C00650 | |
effect_dt | 1999-12-08 00:00:00 | |
migration_source | MASTER |
xref_filer_id | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | C00650 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_id | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE, COUNTY OF | ORANGE, COUNTY OF | ORANGE, COUNTY OF | ORANGE, COUNTY OF | ORANGE, COUNTY OF | ORANGE, COUNTY OF | ORANGE, COUNTY OF | ORANGE, COUNTY OF | ORANGE, COUNTY OF | ORANGE, COUNTY OF | ORANGE, COUNTY OF | ORANGE, COUNTY OF | ORANGE, COUNTY OF | ORANGE, COUNTY OF | ORANGE, COUNTY OF | ORANGE, COUNTY OF | ORANGE, COUNTY OF | ORANGE, COUNTY OF | ORANGE, COUNTY OF | ORANGE, COUNTY OF | ORANGE, COUNTY OF | ORANGE, COUNTY OF | ORANGE, COUNTY OF | ORANGE, COUNTY OF | ORANGE, COUNTY OF | ORANGE, COUNTY OF | ORANGE, COUNTY OF | ORANGE, COUNTY OF | ORANGE, COUNTY OF | ORANGE, COUNTY OF | ORANGE, COUNTY OF | ORANGE, COUNTY OF | ORANGE, COUNTY OF | ORANGE, COUNTY OF | ORANGE, COUNTY OF | ORANGE, COUNTY OF | ORANGE, COUNTY OF | ORANGE, COUNTY OF | ORANGE, COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | SANTA ANA | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | 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 | 92701 | 92702 | 92701 | 92701 | 92701 | 92701 | 92701 | 92701 | 92701 | 92701 | 92701 | 92701 | 92701 | 92701 | 92702 | 92701 | 92701 | 92701 | 92701 | 92701 | 92701 | 92701 | 92701 | 92701 | 92701 | 92701 | 92701 | 92702 | 92701 | 92701 | 92701 | 92701 | 92701 | 92701 | 92701 | 92701 | 92701 | 92701 | 92701 | 92701 | 92702 | 92701 | 92701 | 92701 | 92701 | 92701 | 92701 | 92701 | 92701 | 92701 | 92701 | 92701 | 92701 | 92702 | 92701 | 92701 | 92701 | 92701 | 92701 | 92701 | 92701 | 92701 | 92701 | 92701 | 92701 | 92701 | 92702 | 92701 | 92701 | 92701 | 92701 | 92701 | 92701 | 92701 | 92701 | 92701 | 92701 | 92701 | 92701 | 92702 | 92701 | 92701 | 92701 | 92701 | 92701 | 92701 | 92701 | 92701 | 92701 | 92701 | 92701 | 92701 | 92702 | 92701 | 92701 | 92701 | 92701 | 92701 | 92701 | 92701 | 92701 | 92701 | 92701 | 92701 | 92701 | 92702 | 92701 | 92701 | 92701 | 92701 | 92701 | 92701 | 92701 | 92701 | 92701 | 92701 | 92701 | 92701 | 92702 | 92701 | 92701 | 92701 | 92701 | 92701 | 92701 | 92701 | 92701 | 92701 | 92701 | 92701 | 92701 | 92702 | 92701 | 92701 | 92701 | 92701 | 92701 | 92701 | 92701 | 92701 | 92701 | 92701 | 92701 | 92701 | 92702 | 92701 | 92701 | 92701 | 92701 | 92701 | 92701 | 92701 | 92701 | 92701 | 92701 | 92701 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
phon | 7148636200 | 7148343645 | 7148346200 | 7148346200 | 7148346200 | 7148347010 | 7148347218 | 7148347218 | 7148347219 | 7148347219 | 7148347219 | 7148345777 | 7148345777 | 7148636200 | 7148343645 | 7148346200 | 7148346200 | 7148346200 | 7148347010 | 7148347218 | 7148347218 | 7148347219 | 7148347219 | 7148347219 | 7148345777 | 7148345777 | 7148636200 | 7148343645 | 7148346200 | 7148346200 | 7148346200 | 7148347010 | 7148347218 | 7148347218 | 7148347219 | 7148347219 | 7148347219 | 7148345777 | 7148345777 | 7148636200 | 7148343645 | 7148346200 | 7148346200 | 7148346200 | 7148347010 | 7148347218 | 7148347218 | 7148347219 | 7148347219 | 7148347219 | 7148345777 | 7148345777 | 7148636200 | 7148343645 | 7148346200 | 7148346200 | 7148346200 | 7148347010 | 7148347218 | 7148347218 | 7148347219 | 7148347219 | 7148347219 | 7148345777 | 7148345777 | 7148636200 | 7148343645 | 7148346200 | 7148346200 | 7148346200 | 7148347010 | 7148347218 | 7148347218 | 7148347219 | 7148347219 | 7148347219 | 7148345777 | 7148345777 | 7148636200 | 7148343645 | 7148346200 | 7148346200 | 7148346200 | 7148347010 | 7148347218 | 7148347218 | 7148347219 | 7148347219 | 7148347219 | 7148345777 | 7148345777 | 7148636200 | 7148343645 | 7148346200 | 7148346200 | 7148346200 | 7148347010 | 7148347218 | 7148347218 | 7148347219 | 7148347219 | 7148347219 | 7148345777 | 7148345777 | 7148636200 | 7148343645 | 7148346200 | 7148346200 | 7148346200 | 7148347010 | 7148347218 | 7148347218 | 7148347219 | 7148347219 | 7148347219 | 7148345777 | 7148345777 | 7148636200 | 7148343645 | 7148346200 | 7148346200 | 7148346200 | 7148347010 | 7148347218 | 7148347218 | 7148347219 | 7148347219 | 7148347219 | 7148345777 | 7148345777 | 7148636200 | 7148343645 | 7148346200 | 7148346200 | 7148346200 | 7148347010 | 7148347218 | 7148347218 | 7148347219 | 7148347219 | 7148347219 | 7148345777 | 7148345777 | 7148636200 | 7148343645 | 7148346200 | 7148346200 | 7148346200 | 7148347010 | 7148347218 | 7148347218 | 7148347219 | 7148347219 | 7148347219 | 7148345777 | 7148345777 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fax | None | None | 7148347650 | 7148347650 | None | None | 7148347650 | 7148347650 | None | None | 7148347650 | 7148347650 | None | None | 7148347650 | 7148347650 | None | None | 7148347650 | 7148347650 | None | None | 7148347650 | 7148347650 | None | None | 7148347650 | 7148347650 | None | None | 7148347650 | 7148347650 | None | None | 7148347650 | 7148347650 | None | None | 7148347650 | 7148347650 | None | None | 7148347650 | 7148347650 | None | None | 7148347650 | 7148347650 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | 1143017 |
---|
filer_id | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
change_no | 1 | 2 | 0 | 4 | 3 | 5 | 6 | 7 | 8 | 9 | ||||||||||
session_id | 1999 | 1999 | 2001 | 2003 | 2001 | 2003 | 2005 | 2007 | 2009 | 2019 | ||||||||||
log_dt | 2000-10-17 00:00:00 | 2000-11-21 00:00:00 | 2002-02-11 00:00:00 | 2003-03-05 00:00:00 | 2002-04-02 00:00:00 | 2004-02-13 00:00:00 | 2006-06-30 00:00:00 | 2008-02-14 00:00:00 | 2009-07-16 00:00:00 | 2019-10-30 00:00:00 | ||||||||||
filer_type | 1 | 1 | 2 | 1 | 2 | 1 | 1 | 1 | 1 | 1 | ||||||||||
correction_flg | Y | None | Y | None | Y | None | None | Y | Y | None | ||||||||||
action | DELETED | SET ACTIVE | ADDED | CHANGED | DELETED | DELETED | DELETED | ADDED | ADDED | DELETED | ||||||||||
attribute_changed | EMPLOYER | CLIENT | FIRM | RESPONSIBLE OFFICER | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | ||||||||||
ethics_dt | None | None | None | None | None | None | None | None | None | None | ||||||||||
interests | None | None | None | None | None | None | None | None | None | None | ||||||||||
filer_full_name | ORANGE, COUNTY OF | ORANGE, COUNTY OF | ORANGE, COUNTY OF | ORANGE, COUNTY OF | ORANGE, COUNTY OF | ORANGE, COUNTY OF | ORANGE, COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ORANGE; COUNTY OF | ||||||||||
filer_city | None | MODESTO | None | None | None | None | None | SANTA ANA | SANTA ANA | None | ||||||||||
filer_st | None | CA | None | None | None | None | None | CA | CA | None | ||||||||||
filer_zip | None | 95352 | None | None | None | None | None | 92701 | 92701 | None | ||||||||||
filer_phone | None | 2095746203 | None | None | None | None | None | 7148636200 | 7148636200 | None | ||||||||||
entity_type | 2 | 3 | 3 | 20 | 3 | 3 | 3 | 3 | 3 | 3 | ||||||||||
entity_name | PRINGLE & ASSOCIATES, CURT | CARPENTER SNODGRASS & ASSOCIATES | MANATT, PHELPS & PHILLIPS, LLP | ASSISTANT COUNTY EXECUTIVE OFFICER WILLIAM D. MAHONEY | CARPENTER SNODGRASS & ASSOCIATES | MANATT, PHELPS & PHILLIPS, LLP | MAYER, BROWN, ROWE & MAW LLP | TOWNSEND PUBLIC AFFAIRS, INC | TOWNSEND PUBLIC AFFAIRS, INC. | PLATINUM ADVISORS, LLC | ||||||||||
entity_city | None | None | None | None | None | None | None | None | None | None | ||||||||||
entity_st | None | None | None | None | None | None | None | None | None | None | ||||||||||
entity_zip | None | None | None | None | None | None | None | None | None | None | ||||||||||
entity_phone | None | None | None | None | None | None | None | None | None | None | ||||||||||
entity_id | 1224235 | 1147269 | 1147762 | 1253784 | 1147269 | 1147762 | 1229399 | None | None | 1147749 | ||||||||||
responsible_officer | None | None | None | None | None | None | None | None | None | None | ||||||||||
effect_dt | 2000-10-01 00:00:00 | None | 2002-02-08 00:00:00 | 2003-01-01 00:00:00 | 2001-12-31 00:00:00 | 2004-02-14 00:00:00 | 2006-06-20 00:00:00 | 2008-01-01 00:00:00 | 2009-01-01 00:00:00 | 2019-11-01 00:00:00 |
filer_id | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | 1143017 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_file_name | 14554.cal | 14876.cal | 15055.cal | 15374.cal | 682378_0.cal | 2377.cal | 2338.cal | 17548.cal | 5482.cal | 31325.cal | 31356.cal | 31309.cal | 31475.cal | 31088.cal | 14991.cal | 14924.cal | 15543.cal | 14226.cal | 285975.cal | 285908.cal | 773206_0.cal | 287058.cal | 773206_1.cal | 280035.cal | 280099.cal | 281112.cal | 281697.cal | 798508_0.cal | 798700_0.cal | 282498.cal | 32432.cal | 500336.cal | 812162_0.cal | 838164_0.cal | 852740_0.cal | 162556.cal | 431847.cal | 882653_0.cal | 419300.cal | 419373.cal | 908169_0.cal | 928412_0.cal | 928412_1.cal | 944846_0.cal | 966664_0.cal | 966664_1.cal | 1395644_0.cal | 1327815_0.cal | 1346716_0.cal | 1259021_0.cal | 1295856_0.cal | 1285068_0.cal | 1259021_1.cal | 1375872_0.cal | 1307124_0.cal | 512180.cal | 1965724_1.cal | 1965724_0.cal | 86020.cal | 1965724_2.cal | 86031.cal | 1936604_0.cal | 2176047_0.cal | 2157359_0.cal | 2193721_0.cal | 2241270_0.cal | 2273409_0.cal | 2350191_0.cal | 2444168_0.cal | 2470174_0.cal | 2419453_0.cal | 2486596_0.cal | 2319122_0.cal | 2211996_0.cal | 2444168_1.cal | 2381304_0.cal | 2399338_0.cal | 2645663_0.cal | 2749204_0.cal | 2708122_0.cal | 2531599_0.cal | 2554211_0.cal | 2677015_0.cal | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
received_date | 2000-10-31 00:00:00 | 2000-10-31 00:00:00 | 2000-10-31 00:00:00 | 2000-10-31 00:00:00 | 2000-10-31 00:00:00 | 2000-10-31 00:00:00 | 2000-10-31 00:00:00 | 2000-10-31 00:00:00 | 2000-10-31 00:00:00 | 2001-02-02 00:00:00 | 2001-02-02 00:00:00 | 2001-02-02 00:00:00 | 2001-02-02 00:00:00 | 2001-01-31 00:00:00 | 2001-01-31 00:00:00 | 2001-01-31 00:00:00 | 2001-01-31 00:00:00 | 2001-01-31 00:00:00 | 2001-07-31 00:00:00 | 2001-07-31 00:00:00 | 2001-07-31 00:00:00 | 2001-07-31 00:00:00 | 2001-07-31 00:00:00 | 2001-07-31 00:00:00 | 2001-07-31 00:00:00 | 2001-07-31 00:00:00 | 2001-07-31 00:00:00 | 2001-11-20 00:00:00 | 2001-11-21 00:00:00 | 2001-07-31 00:00:00 | 2002-01-30 00:00:00 | 2002-01-29 00:00:00 | 2002-01-29 00:00:00 | 2002-04-29 00:00:00 | 2002-07-26 00:00:00 | 2002-07-26 00:00:00 | 2002-10-30 00:00:00 | 2002-10-30 00:00:00 | 2003-01-29 00:00:00 | 2003-01-29 00:00:00 | 2003-01-29 00:00:00 | 2003-04-22 00:00:00 | 2003-08-05 00:00:00 | 2003-07-28 00:00:00 | 2003-10-24 00:00:00 | 2003-11-04 00:00:00 | 2009-01-30 00:00:00 | 2008-04-28 00:00:00 | 2008-07-28 00:00:00 | 2007-04-24 00:00:00 | 2007-10-29 00:00:00 | 2007-07-31 00:00:00 | 2007-07-31 00:00:00 | 2008-10-30 00:00:00 | 2008-01-28 00:00:00 | 2013-01-29 00:00:00 | 2015-07-30 00:00:00 | 2015-04-30 00:00:00 | 2015-11-18 00:00:00 | 2015-11-18 00:00:00 | 2015-11-18 00:00:00 | 2015-02-02 00:00:00 | 2017-07-31 00:00:00 | 2017-05-01 00:00:00 | 2017-10-31 00:00:00 | 2018-04-30 00:00:00 | 2018-07-30 00:00:00 | 2019-01-31 00:00:00 | 2020-01-31 00:00:00 | 2020-04-30 00:00:00 | 2019-10-31 00:00:00 | 2020-07-31 00:00:00 | 2018-10-31 00:00:00 | 2018-01-31 00:00:00 | 2020-03-06 00:00:00 | 2019-04-30 00:00:00 | 2019-07-31 00:00:00 | 2022-01-31 00:00:00 | 2022-10-31 00:00:00 | 2022-08-01 00:00:00 | 2020-11-02 00:00:00 | 2021-02-01 00:00:00 | 2022-05-02 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_directory | /usr/users/cafiler/disclose/ca99/temp | /usr/users/cafiler/disclose/ca99/temp | /usr/users/cafiler/disclose/ca99/temp | /usr/users/cafiler/disclose/ca99/temp | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/temp | /usr/users/cafiler/disclose/ca99/temp | /usr/users/cafiler/disclose/ca99/temp | /usr/users/cafiler/disclose/ca99/temp | /usr/users/cafiler/disclose/ca99/temp | /usr/users/cafiler/disclose/ca99/temp | /usr/users/cafiler/disclose/ca99/temp | /usr/users/cafiler/disclose/ca99/temp | /usr/users/cafiler/disclose/ca99/temp | /usr/users/cafiler/disclose/ca99/temp | /usr/users/cafiler/disclose/ca99/temp | /usr/users/cafiler/disclose/ca99/temp | /usr/users/cafiler/disclose/ca99/temp | /usr/users/cafiler/disclose/ca99/temp | /usr/users/cafiler/disclose/ca99/temp | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/temp | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/temp | /usr/users/cafiler/disclose/ca99/temp | /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/temp | /usr/users/cafiler/disclose/ca99/temp | /usr/users/cafiler/disclose/ca99/temp | /usr/users/cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /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/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /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 | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_id | None | None | None | None | 682378 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 773206 | None | 773206 | None | None | None | None | 798508 | 798700 | None | None | None | 812162 | 838164 | 852740 | None | None | 882653 | None | None | 908169 | 928412 | 928412 | 944846 | 966664 | 966664 | 1395644 | 1327815 | 1346716 | 1259021 | 1295856 | 1285068 | 1259021 | 1375872 | 1307124 | None | 1965724 | 1965724 | None | 1965724 | None | 1936604 | 2176047 | 2157359 | 2193721 | 2241270 | 2273409 | 2350191 | 2444168 | 2470174 | 2419453 | 2486596 | 2319122 | 2211996 | 2444168 | 2381304 | 2399338 | 2645663 | 2749204 | 2708122 | 2531599 | 2554211 | 2677015 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | None | None | None | None | F635 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | F635 | None | F635 | None | None | None | None | F635 | F635 | None | None | None | F635 | F635 | F635 | None | None | F635 | None | None | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | None | F635 | F635 | None | F635 | None | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
receive_comment | Filing did not pass validation | Filing did not pass validation | Filing did not pass validation | Filing did not pass validation | Filing accepted | Filing did not pass validation | Filing did not pass validation | Filing did not pass validation | Filing did not pass validation | Filing did not pass validation | Filing did not pass validation | Filing did not pass validation | Filing did not pass validation | Filing did not pass validation | Filing did not pass validation | Filing did not pass validation | Filing did not pass validation | Filing did not pass validation | Filing did not pass validation | Filing did not pass validation | Filing accepted | Filing passed validation, but failed DB constraints | Filing accepted | Filing did not pass validation | Filing did not pass validation | Filing did not pass validation | Filing did not pass validation | Filing accepted | Filing accepted | Filing did not pass validation | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing accepted | Filing accepted | Filing accepted | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing accepted | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing accepted | 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 accepted | Filing accepted | Filing accepted | Filing passed validation, but failed DB constraints | Filing accepted | Filing accepted | Filing did not pass validation | Filing accepted | Filing did not pass validation | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted |