filer_id | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
adrid | 1112529 | 2046625 | 2078889 | 2115950 | 2163491 | 2208377 | 2416361 | 2469641 | 2276008 | 2509605 | 2343387 | 2551005 | ||||||||||||
effect_dt | 1999-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 | 2019-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 | ||||||||||||
add_type | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | ||||||||||||
session_id | 1999 | 2003 | 2005 | 2007 | 2009 | 2011 | 2017 | 2019 | 2013 | 2021 | 2015 | 2023 |
filer_id | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 473531 | 479078 | 468028 | 479078 | 629200 | 625200 | 635800 | 618581 | 659744 | 660472 | 645295 | 651818 | 683051 | 695582 | 719720 | 704334 | 753520 | 746673 | 737970 | 791938 | 781421 | 773380 | 795782 | 814671 | 840307 | 833600 | 833603 | 845552 | 819647 | 864428 | 843317 | 856300 | 893465 | 884794 | 919465 | 919486 | 913800 | 935365 | 930959 | 912225 | 965629 | 956270 | 981432 | 975091 | 1002079 | 1009451 | 1017986 | 1023960 | 1074625 | 1051891 | 1064688 | 1035860 | 1078160 | 1101924 | 1093737 | 1113067 | 1127432 | 1141414 | 1162680 | 1127546 | 1189962 | 1208572 | 1229568 | 1260077 | 1245027 | 1281480 | 1294404 | 1779152 | 1981352 | 1966396 | 1844301 | 1935186 | 1953942 | 1910747 | 1327463 | 1306829 | 1346463 | 1372996 | 1390772 | 1419783 | 1412860 | 1460296 | 1430210 | 1449482 | 1482080 | 1504817 | 1531908 | 1567167 | 1556465 | 1563726 | 1604985 | 1587972 | 1630220 | 1618809 | 1654049 | 1676289 | 1813312 | 1813312 | 1796759 | 1924920 | 1708324 | 1867097 | 1736260 | 1721680 | 1733049 | 1844301 | 1762739 | 2478682 | 2203597 | 2381825 | 2427032 | 2395713 | 2381825 | 2306320 | 2358910 | 1997550 | 2011217 | 2011217 | 2036910 | 2062564 | 2100632 | 2128267 | 2128218 | 2139336 | 2174952 | 2156338 | 2346513 | 2189353 | 2435097 | 2417379 | 2466276 | 2236549 | 2518220 | 2273540 | 2574297 | 2666742 | 2634782 | 2544800 | 2518220 | 2698929 | 2466276 | 2478682 | 2568968 | 2593246 | 2544800 | 2616007 | 2734182 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
period_id | 158 | 159 | 157 | 159 | None | 161 | None | 160 | 162 | 162 | 162 | 160 | 163 | 163 | 164 | None | 165 | 165 | 164 | 167 | None | 166 | None | 168 | 169 | None | None | None | None | None | None | 170 | None | 171 | None | None | None | None | 173 | 172 | 175 | None | 176 | None | None | 177 | None | 178 | 180 | 179 | None | None | None | 181 | None | 182 | None | 184 | 185 | 183 | 186 | 187 | 188 | 189 | None | 190 | 191 | 214 | 222 | 221 | 217 | 220 | None | 219 | 193 | 192 | 194 | 195 | 196 | 197 | None | 200 | 198 | 199 | 201 | 202 | 203 | 204 | 205 | None | 206 | 205 | 208 | 207 | 209 | 210 | 216 | 216 | 215 | 221 | 211 | 218 | None | 212 | 212 | 217 | 213 | 242 | 232 | 237 | None | 238 | 237 | 235 | None | 223 | 223 | 224 | 225 | 226 | 227 | 229 | 228 | None | 230 | 229 | 236 | 231 | 240 | 239 | 241 | 233 | 243 | 234 | 245 | 249 | 248 | 244 | 243 | 250 | 241 | 242 | None | 246 | 244 | 247 | 251 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F635 | F635 | F635 | F690 | F635 | F635 | F999 | F635 | F635 | F690 | F635 | F690 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F602 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_sequence | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 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 | 1 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_date | 1999-08-02 00:00:00 | 1999-11-01 00:00:00 | 1999-04-30 00:00:00 | 1999-11-01 00:00:00 | 2000-05-01 00:00:00 | 2000-05-04 00:00:00 | 2000-04-25 00:00:00 | 2000-01-31 00:00:00 | 2000-07-31 00:00:00 | 2000-09-07 00:00:00 | 2000-08-01 00:00:00 | 2000-05-22 00:00:00 | 2000-10-31 00:00:00 | 2000-10-31 00:00:00 | 2001-01-31 00:00:00 | 2000-12-29 00:00:00 | 2001-04-30 00:00:00 | 2001-04-30 00:00:00 | 2001-01-31 00:00:00 | 2001-10-31 00:00:00 | 2001-07-31 00:00:00 | 2001-07-31 00:00:00 | 2001-10-31 00:00:00 | 2002-01-31 00:00:00 | 2002-04-30 00:00:00 | 2002-02-15 00:00:00 | 2002-01-22 00:00:00 | 2002-04-30 00:00:00 | 2002-01-31 00:00:00 | 2002-07-31 00:00:00 | 2002-04-30 00:00:00 | 2002-07-31 00:00:00 | 2002-10-31 00:00:00 | 2002-10-31 00:00:00 | 2003-01-31 00:00:00 | 2003-01-31 00:00:00 | 2002-12-31 00:00:00 | 2003-04-30 00:00:00 | 2003-04-30 00:00:00 | 2003-01-31 00:00:00 | 2003-10-21 00:00:00 | 2003-07-31 00:00:00 | 2004-01-14 00:00:00 | 2003-10-31 00:00:00 | 2004-01-30 00:00:00 | 2004-04-18 00:00:00 | 2004-04-30 00:00:00 | 2004-07-19 00:00:00 | 2005-01-24 00:00:00 | 2004-10-22 00:00:00 | 2004-11-01 00:00:00 | 2004-08-02 00:00:00 | 2004-12-31 00:00:00 | 2005-04-21 00:00:00 | 2005-01-31 00:00:00 | 2005-07-21 00:00:00 | 2005-02-18 00:00:00 | 2006-01-10 00:00:00 | 2006-04-17 00:00:00 | 2005-10-07 00:00:00 | 2006-07-30 00:00:00 | 2006-10-17 00:00:00 | 2007-01-21 00:00:00 | 2007-04-27 00:00:00 | 2007-01-09 00:00:00 | 2007-07-26 00:00:00 | 2007-10-23 00:00:00 | 2013-07-27 00:00:00 | 2015-07-30 00:00:00 | 2015-04-30 00:00:00 | 2014-07-15 00:00:00 | 2015-01-31 00:00:00 | 2014-12-30 00:00:00 | 2014-10-30 00:00:00 | 2008-04-27 00:00:00 | 2008-01-27 00:00:00 | 2008-07-27 00:00:00 | 2008-10-27 00:00:00 | 2009-01-21 00:00:00 | 2009-04-29 00:00:00 | 2008-12-24 00:00:00 | 2010-01-25 00:00:00 | 2009-07-12 00:00:00 | 2009-10-25 00:00:00 | 2010-04-24 00:00:00 | 2010-07-28 00:00:00 | 2010-10-21 00:00:00 | 2011-01-26 00:00:00 | 2011-01-02 00:00:00 | 2010-12-27 00:00:00 | 2011-07-27 00:00:00 | 2011-04-24 00:00:00 | 2012-01-21 00:00:00 | 2011-10-23 00:00:00 | 2012-04-24 00:00:00 | 2012-07-28 00:00:00 | 2014-01-26 00:00:00 | 2014-01-26 00:00:00 | 2013-10-23 00:00:00 | 2015-01-12 00:00:00 | 2012-10-31 00:00:00 | 2014-07-27 00:00:00 | 2012-12-28 00:00:00 | 2012-12-30 00:00:00 | 2013-01-27 00:00:00 | 2014-04-30 00:00:00 | 2013-04-26 00:00:00 | 2020-07-15 00:00:00 | 2018-01-20 00:00:00 | 2019-04-30 00:00:00 | 2019-12-23 00:00:00 | 2019-07-29 00:00:00 | 2019-04-30 00:00:00 | 2018-10-12 00:00:00 | 2019-01-11 00:00:00 | 2015-10-31 00:00:00 | 2016-01-30 00:00:00 | 2016-01-30 00:00:00 | 2016-04-29 00:00:00 | 2016-07-29 00:00:00 | 2016-10-30 00:00:00 | 2017-01-30 00:00:00 | 2017-01-30 00:00:00 | 2016-12-29 00:00:00 | 2017-07-30 00:00:00 | 2017-04-29 00:00:00 | 2019-01-30 00:00:00 | 2017-10-21 00:00:00 | 2020-01-23 00:00:00 | 2019-10-29 00:00:00 | 2020-04-19 00:00:00 | 2018-04-25 00:00:00 | 2020-10-19 00:00:00 | 2018-07-31 00:00:00 | 2021-04-14 00:00:00 | 2022-04-15 00:00:00 | 2022-01-17 00:00:00 | 2021-11-30 00:00:00 | 2021-11-30 00:00:00 | 2022-07-18 00:00:00 | 2021-11-30 00:00:00 | 2021-11-30 00:00:00 | 2020-12-18 00:00:00 | 2021-07-14 00:00:00 | 2021-01-17 00:00:00 | 2021-10-14 00:00:00 | 2022-10-14 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_type | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10005 | 10005 | 10005 | 10005 | 10001 | 10005 | 10001 | 10005 | 10001 | 10005 | 10005 | 10001 | 10005 | 10001 | 10005 | 10001 | 10005 | 10001 | 10001 | 10006 | 10002 | 10006 | 10005 | 10005 | 10005 | 10001 | 10005 | 10001 | 10006 | 10005 | 10005 | 10005 | 10001 | 10001 | 10001 | 10005 | 10001 | 10005 | 10005 | 10001 | 10005 | 10001 | 10001 | 10001 | 10005 | 10005 | 10005 | 10001 | 10005 | 10001 | 10006 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10002 | 10001 | 10002 | 10002 | 10005 | 10001 | 10001 | 10001 | 10001 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_status | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 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 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
session_id | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 2001 | 2001 | 2001 | 1999 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2003 | 2003 | 2003 | 2001 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2005 | 2005 | 2003 | 2005 | 2003 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2007 | 2007 | 2007 | 2007 | 2013 | 2015 | 2015 | 2013 | 2013 | 2015 | 2013 | 2007 | 2007 | 2007 | 2007 | 2007 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2013 | 2013 | 2013 | 2015 | 2011 | 2013 | 2013 | 2013 | 2011 | 2013 | 2013 | 2019 | 2017 | 2019 | 2019 | 2019 | 2019 | 2017 | 2019 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2017 | 2015 | 2017 | 2017 | 2017 | 2017 | 2017 | 2019 | 2019 | 2019 | 2017 | 2019 | 2017 | 2021 | 2021 | 2021 | 2019 | 2019 | 2021 | 2019 | 2019 | 2021 | 2021 | 2019 | 2021 | 2021 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
user_id | * | * | * | * | TTHAM | CFLAGG | TTHAM | * | YBONILLA | YBONILLA | * | JLEHMAN | * | YBONILLA | * | NJACKSON | YBONILLA | * | YBONILLA | * | LTHIBAUL | * | MANTE | * | * | DBARRICK | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | * | LTHIBAUL | * | LTHIBAUL | LTHIBAUL | GPEREZ | LTHIBAUL | COMPLETED | COMPLETED | COMPLETED | LTHIBAUL | COMPLETED | LTHIBAUL | LTHIBAUL | COMPLETED | LTHIBAUL | COMPLETED | COMPLETED | COMPLETED | LTHIBAUL | YBONILLA | CFLAGG | LTHIBAUL | LTHIBAUL | LTHIBAUL | GGILMORE | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | CFLAGG | LTHIBAUL | LTHIBAUL | AGLADNEY | AGLADNEY | AGLADNEY | ASAETERN | AGLADNEY | SARRIAGA | AGLADNEY | LTHIBAUL | LTHIBAUL | LTHIBAUL | JINGRAM | JINGRAM | MGUERRA | SARRIAGA | JINGRAM | MGUERRA | MGUERRA | ASAETERN | ASAETERN | ASAETERN | AGLADNEY | * | DMCCASTL | AGLADNEY | ASAETERN | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | SARRIAGA | AGLADNEY | AGLADNEY | GPEREZ | CAFILER | ASAETERN | AGLADNEY | ASAETERN | GTAYLOR | AGLADNEY | VUKSTINA | SARRIAGA | VUKSTINA | VUKSTINA | AGLADNEY | DMCCASTL | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | YRODRIGU | AGLADNEY | YRODRIGU | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | GTAYLOR | VUKSTINA | GTAYLOR | AGLADNEY | GTAYLOR | AGLADNEY | CHARTRIDGE | CAFILER | GTAYLOR | CAFILER | CAFILER | CAFILER | CAFILER | CAFILER | AROJAS | GTAYLOR | MKIRKHAM | CHATRIDGE | CAFILER | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
special_audit | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11002 | 11002 | 11002 | 11003 | 11002 | 11003 | 11002 | 11002 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fine_audit | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_start | 1999-04-01 00:00:00 | 1999-07-01 00:00:00 | 1999-01-01 00:00:00 | 1999-07-01 00:00:00 | 2000-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-04-01 00:00:00 | 2000-04-01 00:00:00 | 1999-10-01 00:00:00 | 2000-07-01 00:00:00 | 2000-07-01 00:00:00 | 2000-10-01 00:00:00 | 1900-01-01 00:00:00 | 2001-01-01 00:00:00 | 2001-01-01 00:00:00 | 2000-10-01 00:00:00 | 2001-07-01 00:00:00 | 2001-04-01 00:00:00 | 2001-04-01 00:00:00 | 2001-07-01 00:00:00 | 2001-10-01 00:00:00 | 2002-01-01 00:00:00 | 2001-07-01 00:00:00 | 2001-07-01 00:00:00 | 2001-10-01 00:00:00 | 2001-10-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-10-01 00:00:00 | 2002-10-01 00:00:00 | 1900-01-01 00:00:00 | 2003-01-01 00:00:00 | 2003-01-01 00:00:00 | 2002-10-01 00:00:00 | 2003-07-01 00:00:00 | 2003-04-01 00:00:00 | 2003-10-01 00:00:00 | 2003-07-01 00:00:00 | 2003-10-01 00:00:00 | 2004-01-01 00:00:00 | 2004-01-01 00:00:00 | 2004-04-01 00:00:00 | 2004-10-01 00:00:00 | 2004-07-01 00:00:00 | 2004-07-01 00:00:00 | 2004-04-01 00:00:00 | 1900-01-01 00:00:00 | 2005-01-01 00:00:00 | 2004-10-01 00:00:00 | 2005-04-01 00:00:00 | 2004-07-01 00:00:00 | 2005-10-01 00:00:00 | 2006-01-01 00:00:00 | 2005-07-01 00:00:00 | 2006-04-01 00:00:00 | 2006-07-01 00:00:00 | 2006-10-01 00:00:00 | 2007-01-01 00:00:00 | 1900-01-01 00:00:00 | 2007-04-01 00:00:00 | 2007-07-01 00:00:00 | 2013-04-01 00:00:00 | 2015-04-01 00:00:00 | 2015-01-01 00:00:00 | 2014-01-01 00:00:00 | 2014-10-01 00:00:00 | 1900-01-01 00:00:00 | 2014-07-01 00:00:00 | 2008-01-01 00:00:00 | 2007-10-01 00:00:00 | 2008-04-01 00:00:00 | 2008-07-01 00:00:00 | 2008-10-01 00:00:00 | 2009-01-01 00:00:00 | 1900-01-01 00:00:00 | 2009-10-01 00:00:00 | 2009-04-01 00:00:00 | 2009-07-01 00:00:00 | 2010-01-01 00:00:00 | 2010-04-01 00:00:00 | 2010-07-01 00:00:00 | 2010-10-01 00:00:00 | 2011-01-02 00:00:00 | 1900-01-01 00:00:00 | 2011-04-01 00:00:00 | 2011-01-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-10-01 00:00:00 | 2013-07-01 00:00:00 | 2015-01-12 00:00:00 | 2012-07-01 00:00:00 | 2014-04-01 00:00:00 | 1900-01-01 00:00:00 | 2012-12-30 00:00:00 | 2012-10-01 00:00:00 | 2014-01-01 00:00:00 | 2013-01-01 00:00:00 | 2020-04-01 00:00:00 | 2017-10-01 00:00:00 | 2019-01-01 00:00:00 | 1900-01-01 00:00:00 | 2019-04-01 00:00:00 | 2019-01-01 00:00:00 | 2018-07-01 00:00:00 | 1900-01-01 00:00:00 | 2015-07-01 00:00:00 | 2015-09-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 | 2017-01-30 00:00:00 | 2016-10-01 00:00:00 | 1900-01-01 00:00:00 | 2017-04-01 00:00:00 | 2017-01-01 00:00:00 | 2018-10-01 00:00:00 | 2017-07-01 00:00:00 | 2019-10-01 00:00:00 | 2019-07-01 00:00:00 | 2020-01-01 00:00:00 | 2018-01-01 00:00:00 | 2020-07-01 00:00:00 | 2018-04-01 00:00:00 | 2021-01-01 00:00:00 | 2022-01-01 00:00:00 | 2021-10-01 00:00:00 | 2020-10-01 00:00:00 | 2020-07-01 00:00:00 | 2022-04-01 00:00:00 | 2020-01-01 00:00:00 | 2020-04-01 00:00:00 | 1900-01-01 00:00:00 | 2021-04-01 00:00:00 | 2020-10-01 00:00:00 | 2021-07-01 00:00:00 | 2022-07-01 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_end | 1999-06-30 00:00:00 | 1999-09-30 00:00:00 | 1999-03-31 00:00:00 | 1999-09-30 00:00:00 | 2000-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-06-30 00:00:00 | 2000-06-30 00:00:00 | 1999-12-31 00:00:00 | 2000-09-30 00:00:00 | 2000-09-30 00:00:00 | 2000-12-31 00:00:00 | 1900-01-01 00:00:00 | 2001-03-31 00:00:00 | 2001-03-31 00:00:00 | 2000-12-31 00:00:00 | 2001-09-30 00:00:00 | 2001-06-30 00:00:00 | 2001-06-30 00:00:00 | 2001-09-30 00:00:00 | 2001-12-31 00:00:00 | 2002-03-31 00:00:00 | 2001-09-30 00:00:00 | 2001-09-30 00:00:00 | 2001-12-31 00:00:00 | 2001-12-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-12-31 00:00:00 | 2002-12-31 00:00:00 | 1900-01-01 00:00:00 | 2003-03-31 00:00:00 | 2003-03-31 00:00:00 | 2002-12-31 00:00:00 | 2003-09-30 00:00:00 | 2003-06-30 00:00:00 | 2003-12-31 00:00:00 | 2003-09-30 00:00:00 | 2003-12-31 00:00:00 | 2004-03-31 00:00:00 | 2004-03-31 00:00:00 | 2004-06-30 00:00:00 | 2004-12-31 00:00:00 | 2004-09-30 00:00:00 | 2004-09-30 00:00:00 | 2004-06-30 00:00:00 | 1900-01-01 00:00:00 | 2005-03-31 00:00:00 | 2004-12-31 00:00:00 | 2005-06-30 00:00:00 | 2004-09-30 00:00:00 | 2005-12-31 00:00:00 | 2006-03-31 00:00:00 | 2005-09-30 00:00:00 | 2006-06-30 00:00:00 | 2006-09-30 00:00:00 | 2006-12-31 00:00:00 | 2007-03-31 00:00:00 | 1900-01-01 00:00:00 | 2007-06-30 00:00:00 | 2007-09-30 00:00:00 | 2013-06-30 00:00:00 | 2015-06-30 00:00:00 | 2015-03-31 00:00:00 | 2014-03-31 00:00:00 | 2014-12-31 00:00:00 | 1900-01-01 00:00:00 | 2014-09-30 00:00:00 | 2008-03-31 00:00:00 | 2007-12-31 00:00:00 | 2008-06-30 00:00:00 | 2008-09-30 00:00:00 | 2008-12-31 00:00:00 | 2009-03-31 00:00:00 | 1900-01-01 00:00:00 | 2009-12-31 00:00:00 | 2009-06-30 00:00:00 | 2009-09-30 00:00:00 | 2010-03-31 00:00:00 | 2010-06-30 00:00:00 | 2010-09-30 00:00:00 | 2010-12-31 00:00:00 | 2011-01-02 00:00:00 | 1900-01-01 00:00:00 | 2011-06-30 00:00:00 | 2011-03-31 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-12-31 00:00:00 | 2013-09-30 00:00:00 | 2015-01-12 00:00:00 | 2012-09-30 00:00:00 | 2014-06-30 00:00:00 | 1900-01-01 00:00:00 | 2012-12-30 00:00:00 | 2012-12-31 00:00:00 | 2014-03-31 00:00:00 | 2013-03-31 00:00:00 | 2020-06-30 00:00:00 | 2017-12-31 00:00:00 | 2019-03-31 00:00:00 | 1900-01-01 00:00:00 | 2019-06-30 00:00:00 | 2019-03-31 00:00:00 | 2018-09-30 00:00:00 | 1900-01-01 00:00:00 | 2015-09-30 00:00:00 | 2015-12-31 00:00:00 | 2015-12-31 00:00:00 | 2016-03-31 00:00:00 | 2016-06-30 00:00:00 | 2016-09-30 00:00:00 | 2017-01-30 00:00:00 | 2016-12-31 00:00:00 | 1900-01-01 00:00:00 | 2017-06-30 00:00:00 | 2017-03-31 00:00:00 | 2018-12-31 00:00:00 | 2017-09-30 00:00:00 | 2019-12-31 00:00:00 | 2019-09-30 00:00:00 | 2020-03-31 00:00:00 | 2018-03-31 00:00:00 | 2020-09-30 00:00:00 | 2018-06-30 00:00:00 | 2021-03-31 00:00:00 | 2022-03-31 00:00:00 | 2021-12-31 00:00:00 | 2020-12-31 00:00:00 | 2020-09-30 00:00:00 | 2022-06-30 00:00:00 | 2020-03-31 00:00:00 | 2020-06-30 00:00:00 | 1900-01-01 00:00:00 | 2021-06-30 00:00:00 | 2020-12-31 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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | 22001 | 22001 | 22006 | None | 22006 | None | None | 22006 | None | 22006 | 22006 | 22006 | None | None | None | 22006 | None | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | None | 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 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 |
filer_id | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
session_id | 2003 | 2001 | 1999 | 2017 | 2013 | 2007 | 2009 | 2011 | 2005 | 2021 | 2019 | 2015 | 2023 | |||||||||||||
interest_cd | 40304 | 40304 | 40305 | 40305 | 40304 | 40304 | 40304 | 40304 | 40304 | 40305 | 40305 | 40305 | 40305 | |||||||||||||
effect_date | 2003-01-01 00:00:00 | 2001-01-01 00:00:00 | 1999-01-01 00:00:00 | 2017-01-01 00:00:00 | 2013-01-01 00:00:00 | 2007-01-01 00:00:00 | 2009-01-01 00:00:00 | 2011-01-01 00:00:00 | 2005-01-01 00:00:00 | 2021-01-01 00:00:00 | 2019-01-01 00:00:00 | 2015-01-01 00:00:00 | 2023-01-01 00:00:00 |
filer_id | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | T | Y | Y | Y | N | |||||||||||||||
race | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
session_id | 1999 | 2001 | 2003 | 2005 | 2007 | 2013 | 2009 | 2011 | 2017 | 2015 | 2019 | 2021 | 2019 | 2019 | 2023 | |||||||||||||||
category | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
category_type | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
sub_category | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
effect_dt | 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 | 2009-01-01 00:00:00 | 2011-01-01 00:00:00 | 2017-01-01 00:00:00 | 2015-01-01 00:00:00 | 2019-12-01 00:00:00 | 2021-01-01 00:00:00 | 2020-01-01 00:00:00 | 2019-01-01 00:00:00 | 2023-01-01 00:00:00 | |||||||||||||||
sub_category_type | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
election_type | 0 | 0 | None | None | 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 | 2000-01-01 00:00:00 | 2000-01-01 00:00:00 | None | None | 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 | 1146189 | |
---|---|---|
xref_id | C27729 | |
effect_dt | 1999-12-08 00:00:00 | |
migration_source | MASTER |
xref_filer_id | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | C27729 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_id | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | PUBLIC RISK INNOVATION, SOLUTIONS, AND MANAGEMENT (PRISM) | PUBLIC RISK INNOVATION, SOLUTIONS, AND MANAGEMENT (PRISM) | PUBLIC RISK INNOVATION, SOLUTIONS, AND MANAGEMENT (PRISM) | PUBLIC RISK INNOVATION, SOLUTIONS, AND MANAGEMENT (PRISM) | PUBLIC RISK INNOVATION, SOLUTIONS, AND MANAGEMENT (PRISM) | PUBLIC RISK INNOVATION, SOLUTIONS, AND MANAGEMENT (PRISM) | PUBLIC RISK INNOVATION, SOLUTIONS, AND MANAGEMENT (PRISM) | PUBLIC RISK INNOVATION, SOLUTIONS, AND MANAGEMENT (PRISM) | PUBLIC RISK INNOVATION, SOLUTIONS, AND MANAGEMENT (PRISM) | PUBLIC RISK INNOVATION, SOLUTIONS, AND MANAGEMENT (PRISM) | PUBLIC RISK INNOVATION, SOLUTIONS, AND MANAGEMENT (PRISM) | PUBLIC RISK INNOVATION, SOLUTIONS, AND MANAGEMENT (PRISM) | PUBLIC RISK INNOVATION, SOLUTIONS, AND MANAGEMENT (PRISM) | PUBLIC RISK INNOVATION, SOLUTIONS, AND MANAGEMENT (PRISM) | PUBLIC RISK INNOVATION, SOLUTIONS, AND MANAGEMENT (PRISM) | PUBLIC RISK INNOVATION, SOLUTIONS, AND MANAGEMENT (PRISM) | PUBLIC RISK INNOVATION, SOLUTIONS, AND MANAGEMENT (PRISM) | PUBLIC RISK INNOVATION, SOLUTIONS, AND MANAGEMENT (PRISM) | PUBLIC RISK INNOVATION, SOLUTIONS, AND MANAGEMENT (PRISM) | PUBLIC RISK INNOVATION, SOLUTIONS, AND MANAGEMENT (PRISM) | PUBLIC RISK INNOVATION, SOLUTIONS, AND MANAGEMENT (PRISM) | PUBLIC RISK INNOVATION, SOLUTIONS, AND MANAGEMENT (PRISM) | PUBLIC RISK INNOVATION, SOLUTIONS, AND MANAGEMENT (PRISM) | PUBLIC RISK INNOVATION, SOLUTIONS, AND MANAGEMENT (PRISM) | PUBLIC RISK INNOVATION, SOLUTIONS AND MANAGEMENT (PRISM) | PUBLIC RISK INNOVATION, SOLUTIONS AND MANAGEMENT (PRISM) | PUBLIC RISK INNOVATION, SOLUTIONS AND MANAGEMENT (PRISM) | PUBLIC RISK INNOVATION, SOLUTIONS AND MANAGEMENT (PRISM) | PUBLIC RISK INNOVATION, SOLUTIONS AND MANAGEMENT (PRISM) | PUBLIC RISK INNOVATION, SOLUTIONS AND MANAGEMENT (PRISM) | PUBLIC RISK INNOVATION, SOLUTIONS AND MANAGEMENT (PRISM) | PUBLIC RISK INNOVATION, SOLUTIONS AND MANAGEMENT (PRISM) | PUBLIC RISK INNOVATION, SOLUTIONS AND MANAGEMENT (PRISM) | PUBLIC RISK INNOVATION, SOLUTIONS AND MANAGEMENT (PRISM) | PUBLIC RISK INNOVATION, SOLUTIONS AND MANAGEMENT (PRISM) | PUBLIC RISK INNOVATION, SOLUTIONS AND MANAGEMENT (PRISM) | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
namf | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | RANCHO CORDOVA | RANCHO CORDOVA | RANCHO CORDOVA | RANCHO CORDOVA | RANCHO CORDOVA | FOLSOM | FOLSOM | FOLSOM | FOLSOM | FOLSOM | FOLSOM | FOLSOM | RANCHO CORDOVA | RANCHO CORDOVA | RANCHO CORDOVA | RANCHO CORDOVA | RANCHO CORDOVA | FOLSOM | FOLSOM | FOLSOM | FOLSOM | FOLSOM | FOLSOM | FOLSOM | RANCHO CORDOVA | RANCHO CORDOVA | RANCHO CORDOVA | RANCHO CORDOVA | RANCHO CORDOVA | FOLSOM | FOLSOM | FOLSOM | FOLSOM | FOLSOM | FOLSOM | FOLSOM | RANCHO CORDOVA | RANCHO CORDOVA | RANCHO CORDOVA | RANCHO CORDOVA | RANCHO CORDOVA | FOLSOM | FOLSOM | FOLSOM | FOLSOM | FOLSOM | FOLSOM | FOLSOM | RANCHO CORDOVA | RANCHO CORDOVA | RANCHO CORDOVA | RANCHO CORDOVA | RANCHO CORDOVA | FOLSOM | FOLSOM | FOLSOM | FOLSOM | FOLSOM | FOLSOM | FOLSOM | RANCHO CORDOVA | RANCHO CORDOVA | RANCHO CORDOVA | RANCHO CORDOVA | RANCHO CORDOVA | FOLSOM | FOLSOM | FOLSOM | FOLSOM | FOLSOM | FOLSOM | FOLSOM | RANCHO CORDOVA | RANCHO CORDOVA | RANCHO CORDOVA | RANCHO CORDOVA | RANCHO CORDOVA | FOLSOM | FOLSOM | FOLSOM | FOLSOM | FOLSOM | FOLSOM | FOLSOM | RANCHO CORDOVA | RANCHO CORDOVA | RANCHO CORDOVA | RANCHO CORDOVA | RANCHO CORDOVA | FOLSOM | FOLSOM | FOLSOM | FOLSOM | FOLSOM | FOLSOM | FOLSOM | RANCHO CORDOVA | RANCHO CORDOVA | RANCHO CORDOVA | RANCHO CORDOVA | RANCHO CORDOVA | FOLSOM | FOLSOM | FOLSOM | FOLSOM | FOLSOM | FOLSOM | FOLSOM | RANCHO CORDOVA | RANCHO CORDOVA | RANCHO CORDOVA | RANCHO CORDOVA | RANCHO CORDOVA | FOLSOM | FOLSOM | FOLSOM | FOLSOM | FOLSOM | FOLSOM | FOLSOM | RANCHO CORDOVA | RANCHO CORDOVA | RANCHO CORDOVA | RANCHO CORDOVA | RANCHO CORDOVA | FOLSOM | FOLSOM | FOLSOM | FOLSOM | FOLSOM | FOLSOM | FOLSOM | RANCHO CORDOVA | RANCHO CORDOVA | RANCHO CORDOVA | RANCHO CORDOVA | RANCHO CORDOVA | FOLSOM | FOLSOM | FOLSOM | FOLSOM | FOLSOM | FOLSOM | FOLSOM | RANCHO CORDOVA | RANCHO CORDOVA | RANCHO CORDOVA | RANCHO CORDOVA | RANCHO CORDOVA | FOLSOM | FOLSOM | FOLSOM | FOLSOM | FOLSOM | FOLSOM | FOLSOM | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | 95670 | 95670 | 95670 | 95670 | 95670 | 95630 | 95630 | 95630 | 95630 | 95630 | 95630 | 95630 | 95670 | 95670 | 95670 | 95670 | 95670 | 95630 | 95630 | 95630 | 95630 | 95630 | 95630 | 95630 | 95670 | 95670 | 95670 | 95670 | 95670 | 95630 | 95630 | 95630 | 95630 | 95630 | 95630 | 95630 | 95670 | 95670 | 95670 | 95670 | 95670 | 95630 | 95630 | 95630 | 95630 | 95630 | 95630 | 95630 | 95670 | 95670 | 95670 | 95670 | 95670 | 95630 | 95630 | 95630 | 95630 | 95630 | 95630 | 95630 | 95670 | 95670 | 95670 | 95670 | 95670 | 95630 | 95630 | 95630 | 95630 | 95630 | 95630 | 95630 | 95670 | 95670 | 95670 | 95670 | 95670 | 95630 | 95630 | 95630 | 95630 | 95630 | 95630 | 95630 | 95670 | 95670 | 95670 | 95670 | 95670 | 95630 | 95630 | 95630 | 95630 | 95630 | 95630 | 95630 | 95670 | 95670 | 95670 | 95670 | 95670 | 95630 | 95630 | 95630 | 95630 | 95630 | 95630 | 95630 | 95670 | 95670 | 95670 | 95670 | 95670 | 95630 | 95630 | 95630 | 95630 | 95630 | 95630 | 95630 | 95670 | 95670 | 95670 | 95670 | 95670 | 95630 | 95630 | 95630 | 95630 | 95630 | 95630 | 95630 | 95670 | 95670 | 95670 | 95670 | 95670 | 95630 | 95630 | 95630 | 95630 | 95630 | 95630 | 95630 | 95670 | 95670 | 95670 | 95670 | 95670 | 95630 | 95630 | 95630 | 95630 | 95630 | 95630 | 95630 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
phon | 9166317363 | 9166317363 | 9166317363 | 9166317363 | 9166317363 | 9168507300 | 9168507300 | 5598507300 | 9168507300 | 9168507300 | 9168507300 | 9168507300 | 9166317363 | 9166317363 | 9166317363 | 9166317363 | 9166317363 | 9168507300 | 9168507300 | 5598507300 | 9168507300 | 9168507300 | 9168507300 | 9168507300 | 9166317363 | 9166317363 | 9166317363 | 9166317363 | 9166317363 | 9168507300 | 9168507300 | 5598507300 | 9168507300 | 9168507300 | 9168507300 | 9168507300 | 9166317363 | 9166317363 | 9166317363 | 9166317363 | 9166317363 | 9168507300 | 9168507300 | 5598507300 | 9168507300 | 9168507300 | 9168507300 | 9168507300 | 9166317363 | 9166317363 | 9166317363 | 9166317363 | 9166317363 | 9168507300 | 9168507300 | 5598507300 | 9168507300 | 9168507300 | 9168507300 | 9168507300 | 9166317363 | 9166317363 | 9166317363 | 9166317363 | 9166317363 | 9168507300 | 9168507300 | 5598507300 | 9168507300 | 9168507300 | 9168507300 | 9168507300 | 9166317363 | 9166317363 | 9166317363 | 9166317363 | 9166317363 | 9168507300 | 9168507300 | 5598507300 | 9168507300 | 9168507300 | 9168507300 | 9168507300 | 9166317363 | 9166317363 | 9166317363 | 9166317363 | 9166317363 | 9168507300 | 9168507300 | 5598507300 | 9168507300 | 9168507300 | 9168507300 | 9168507300 | 9166317363 | 9166317363 | 9166317363 | 9166317363 | 9166317363 | 9168507300 | 9168507300 | 5598507300 | 9168507300 | 9168507300 | 9168507300 | 9168507300 | 9166317363 | 9166317363 | 9166317363 | 9166317363 | 9166317363 | 9168507300 | 9168507300 | 5598507300 | 9168507300 | 9168507300 | 9168507300 | 9168507300 | 9166317363 | 9166317363 | 9166317363 | 9166317363 | 9166317363 | 9168507300 | 9168507300 | 5598507300 | 9168507300 | 9168507300 | 9168507300 | 9168507300 | 9166317363 | 9166317363 | 9166317363 | 9166317363 | 9166317363 | 9168507300 | 9168507300 | 5598507300 | 9168507300 | 9168507300 | 9168507300 | 9168507300 | 9166317363 | 9166317363 | 9166317363 | 9166317363 | 9166317363 | 9168507300 | 9168507300 | 5598507300 | 9168507300 | 9168507300 | 9168507300 | 9168507300 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fax | 9166317112 | 9166317112 | 9166317112 | 9166317112 | 9168507800 | 9166317112 | 9166317112 | 9166317112 | 9166317112 | 9168507800 | 9166317112 | 9166317112 | 9166317112 | 9166317112 | 9168507800 | 9166317112 | 9166317112 | 9166317112 | 9166317112 | 9168507800 | 9166317112 | 9166317112 | 9166317112 | 9166317112 | 9168507800 | 9166317112 | 9166317112 | 9166317112 | 9166317112 | 9168507800 | 9166317112 | 9166317112 | 9166317112 | 9166317112 | 9168507800 | 9166317112 | 9166317112 | 9166317112 | 9166317112 | 9168507800 | 9166317112 | 9166317112 | 9166317112 | 9166317112 | 9168507800 | 9166317112 | 9166317112 | 9166317112 | 9166317112 | 9168507800 | 9166317112 | 9166317112 | 9166317112 | 9166317112 | 9168507800 | 9166317112 | 9166317112 | 9166317112 | 9166317112 | 9168507800 | 9166317112 | 9166317112 | 9166317112 | 9166317112 | 9168507800 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
None | None | None | None | None | None | None | None | None | [email protected] | None | None | None | None | None | None | None | None | None | None | None | [email protected] | None | None | None | None | None | None | None | None | None | None | None | [email protected] | None | None | None | None | None | None | None | None | None | None | None | [email protected] | None | None | None | None | None | None | None | None | None | None | None | [email protected] | None | None | None | None | None | None | None | None | None | None | None | [email protected] | None | None | None | None | None | None | None | None | None | None | None | [email protected] | None | None | None | None | None | None | None | None | None | None | None | [email protected] | None | None | None | None | None | None | None | None | None | None | None | [email protected] | None | None | None | None | None | None | None | None | None | None | None | [email protected] | None | None | None | None | None | None | None | None | None | None | None | [email protected] | None | None | None | None | None | None | None | None | None | None | None | [email protected] | None | None | None | None | None | None | None | None | None | None | None | [email protected] | None | None |
filer_id | 1146189 |
---|
filer_id | 1146189 | 1146189 | ||
---|---|---|---|---|
change_no | 1 | 2 | ||
session_id | 2001 | 2001 | ||
log_dt | 2001-03-27 00:00:00 | 2001-06-13 00:00:00 | ||
filer_type | 1 | 1 | ||
correction_flg | None | None | ||
action | IN SUSPENSE | SET ACTIVE | ||
attribute_changed | FIRM | FIRM | ||
ethics_dt | None | None | ||
interests | None | None | ||
filer_full_name | CSAC EXCESS INSURANCE AUTHORITY | CSAC EXCESS INSURANCE AUTHORITY | ||
filer_city | SACRAMENTO | SACRAMENTO | ||
filer_st | CA | CA | ||
filer_zip | 95814 | 95814 | ||
filer_phone | 9164210954 | 9164920745 | ||
entity_type | 3 | 3 | ||
entity_name | CORBETT & ASSOCIATES, MICHAEL Y. | CORBETT & ASSOCIATES, MICHAEL Y. | ||
entity_city | None | None | ||
entity_st | None | None | ||
entity_zip | None | None | ||
entity_phone | None | None | ||
entity_id | 1147408 | 1147408 | ||
responsible_officer | None | None | ||
effect_dt | None | None |
filer_id | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | 1146189 | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_file_name | 625200_0.cal | 645295_0.cal | 683051_0.cal | 719720_0.cal | 746673_0.cal | 773380_0.cal | 791938_0.cal | 814671_0.cal | 840307_0.cal | 856300_0.cal | 884794_0.cal | 912225_0.cal | 930959_0.cal | 965629_0.cal | 981432_0.cal | |||||||||||||||
received_date | 2000-05-04 00:00:00 | 2000-08-01 00:00:00 | 2000-10-31 00:00:00 | 2001-01-31 00:00:00 | 2001-04-30 00:00:00 | 2001-07-31 00:00:00 | 2001-10-31 00:00:00 | 2002-01-31 00:00:00 | 2002-04-30 00:00:00 | 2002-07-31 00:00:00 | 2002-10-31 00:00:00 | 2003-01-31 00:00:00 | 2003-04-30 00:00:00 | 2003-10-21 00:00:00 | 2004-01-14 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 | /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 | |||||||||||||||
filing_id | 625200 | 645295 | 683051 | 719720 | 746673 | 773380 | 791938 | 814671 | 840307 | 856300 | 884794 | 912225 | 930959 | 965629 | 981432 | |||||||||||||||
form_id | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | |||||||||||||||
receive_comment | 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, but with warnings | Filing accepted, but with warnings |