filer_id | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
adrid | 1113344 | 2044289 | 2078253 | 2118872 | 2162467 | 2205164 | 2415204 | 2471842 | 2550021 | 2509034 | 2276565 | 2339482 | ||||||||||||
effect_dt | 1998-03-10 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 | 2023-01-01 00:00:00 | 2021-01-01 00:00:00 | 2013-01-01 00:00:00 | 2015-01-01 00:00:00 | ||||||||||||
add_type | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | ||||||||||||
session_id | 1997 | 2003 | 2005 | 2007 | 2009 | 2011 | 2017 | 2019 | 2023 | 2021 | 2013 | 2015 |
filer_id | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 467432 | 472806 | 478391 | 617699 | 628265 | 664307 | 680731 | 708799 | 695479 | 713795 | 753118 | 744111 | 736579 | 789575 | 782221 | 769400 | 769858 | 808369 | 796935 | 838531 | 824229 | 861324 | 843925 | 853599 | 881203 | 891912 | 905843 | 902432 | 927385 | 930300 | 933016 | 954057 | 945775 | 971255 | 988050 | 969035 | 994308 | 1011694 | 1025964 | 1030170 | 1014797 | 1075750 | 1069632 | 1056079 | 1088928 | 1060808 | 1079878 | 1113998 | 1103257 | 1132338 | 1165592 | 1145209 | 1187793 | 1215444 | 1225659 | 1234197 | 1284780 | 1246306 | 1307241 | 1296204 | 1262532 | 1973635 | 1966671 | 1973635 | 1966671 | 1866744 | 1782298 | 1933784 | 1943170 | 1329754 | 1329754 | 1349495 | 1378334 | 1395604 | 1423248 | 1421968 | 1437792 | 1450303 | 1462956 | 1506243 | 1485547 | 1538704 | 1556024 | 1564482 | 1571775 | 1590528 | 1606526 | 1631167 | 1622791 | 1657893 | 1675291 | 1828980 | 1796873 | 1816623 | 1866744 | 1914738 | 1866744 | 1914738 | 1922986 | 1701582 | 1744769 | 1720873 | 1734044 | 1845879 | 1827802 | 1765901 | 1996782 | 2241264 | 2206093 | 2444577 | 2331178 | 2206093 | 2299305 | 2381480 | 2011969 | 1996782 | 2011969 | 2060460 | 2036032 | 2060460 | 2098258 | 2113549 | 2130084 | 2142863 | 2176762 | 2158383 | 2206192 | 2400126 | 2487328 | 2363324 | 2582072 | 2400126 | 2552433 | 2351449 | 2420479 | 2176762 | 2311077 | 2679640 | 2469398 | 2538728 | 2628832 | 2569804 | 2644709 | 2744909 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
period_id | 157 | 158 | 159 | 160 | 161 | 162 | 163 | None | 163 | 164 | 165 | 165 | 164 | 167 | None | 162 | 166 | 168 | None | 169 | None | None | None | 170 | 171 | None | 172 | None | None | 173 | None | None | 174 | None | 176 | 175 | None | 177 | 178 | None | None | 180 | 181 | 179 | None | None | None | 182 | 181 | 183 | 185 | 184 | 186 | 187 | 188 | 188 | 190 | None | 192 | 191 | 189 | 222 | 221 | 222 | 221 | 218 | 214 | 220 | None | 193 | 193 | 194 | 195 | 196 | None | 197 | 198 | 199 | 200 | 202 | 201 | 203 | 204 | None | 204 | 205 | 206 | 208 | 207 | 209 | 210 | None | 215 | 216 | 218 | 219 | 218 | 219 | 220 | 211 | None | 212 | 212 | 217 | 217 | 213 | 223 | 233 | 232 | 240 | 236 | 232 | 234 | 237 | 224 | 223 | 224 | 226 | 225 | 226 | 227 | 228 | 228 | None | 230 | 229 | 231 | 238 | 242 | 236 | 245 | 238 | 244 | None | 239 | 230 | 235 | 249 | 241 | 244 | 247 | None | 248 | 251 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F602 | F602 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F602 | F635 | F635 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_sequence | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 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 | 1 | 1 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 1 | 1 | 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_date | 1999-06-16 00:00:00 | 1999-07-27 00:00:00 | 1999-11-01 00:00:00 | 2000-01-26 00:00:00 | 2000-04-28 00:00:00 | 2000-07-31 00:00:00 | 2000-10-30 00:00:00 | 2001-01-02 00:00:00 | 2000-10-31 00:00:00 | 2001-01-24 00:00:00 | 2001-04-27 00:00:00 | 2001-04-26 00:00:00 | 2001-01-26 00:00:00 | 2001-10-26 00:00:00 | 2001-07-31 00:00:00 | 2001-07-24 00:00:00 | 2001-07-25 00:00:00 | 2002-01-21 00:00:00 | 2001-10-26 00:00:00 | 2002-04-29 00:00:00 | 2002-01-23 00:00:00 | 2002-07-30 00:00:00 | 2002-04-30 00:00:00 | 2002-07-29 00:00:00 | 2002-10-28 00:00:00 | 2002-10-29 00:00:00 | 2003-01-24 00:00:00 | 2002-12-31 00:00:00 | 2003-01-24 00:00:00 | 2003-04-29 00:00:00 | 2003-04-30 00:00:00 | 2003-07-30 00:00:00 | 2003-07-29 00:00:00 | 2003-10-30 00:00:00 | 2004-01-29 00:00:00 | 2003-10-30 00:00:00 | 2004-01-30 00:00:00 | 2004-04-27 00:00:00 | 2004-07-27 00:00:00 | 2004-07-27 00:00:00 | 2004-04-28 00:00:00 | 2005-01-26 00:00:00 | 2005-01-03 00:00:00 | 2004-10-28 00:00:00 | 2004-12-31 00:00:00 | 2004-10-28 00:00:00 | 2005-01-26 00:00:00 | 2005-07-25 00:00:00 | 2005-04-27 00:00:00 | 2005-10-28 00:00:00 | 2006-04-27 00:00:00 | 2006-01-27 00:00:00 | 2006-07-26 00:00:00 | 2006-10-30 00:00:00 | 2007-01-02 00:00:00 | 2007-01-29 00:00:00 | 2007-07-31 00:00:00 | 2007-01-02 00:00:00 | 2008-01-28 00:00:00 | 2007-10-30 00:00:00 | 2007-04-30 00:00:00 | 2015-07-28 00:00:00 | 2015-05-01 00:00:00 | 2015-07-09 00:00:00 | 2015-07-09 00:00:00 | 2014-07-25 00:00:00 | 2013-07-31 00:00:00 | 2015-01-30 00:00:00 | 2015-01-05 00:00:00 | 2008-04-30 00:00:00 | 2008-06-06 00:00:00 | 2008-07-30 00:00:00 | 2008-10-31 00:00:00 | 2009-01-30 00:00:00 | 2009-01-26 00:00:00 | 2009-04-30 00:00:00 | 2009-07-31 00:00:00 | 2009-10-27 00:00:00 | 2010-01-29 00:00:00 | 2010-07-30 00:00:00 | 2010-04-30 00:00:00 | 2010-10-29 00:00:00 | 2010-12-30 00:00:00 | 2010-12-30 00:00:00 | 2011-01-31 00:00:00 | 2011-04-29 00:00:00 | 2011-07-29 00:00:00 | 2012-01-24 00:00:00 | 2011-10-31 00:00:00 | 2012-04-30 00:00:00 | 2012-07-26 00:00:00 | 2014-03-13 00:00:00 | 2013-10-24 00:00:00 | 2014-01-30 00:00:00 | 2014-11-12 00:00:00 | 2014-11-20 00:00:00 | 2014-11-20 00:00:00 | 2014-11-12 00:00:00 | 2015-01-05 00:00:00 | 2012-10-23 00:00:00 | 2012-12-27 00:00:00 | 2012-12-27 00:00:00 | 2013-01-28 00:00:00 | 2014-04-30 00:00:00 | 2014-03-13 00:00:00 | 2013-04-30 00:00:00 | 2015-10-30 00:00:00 | 2018-04-30 00:00:00 | 2018-01-26 00:00:00 | 2020-02-02 00:00:00 | 2018-12-31 00:00:00 | 2018-01-26 00:00:00 | 2018-10-01 00:00:00 | 2019-04-30 00:00:00 | 2016-02-01 00:00:00 | 2016-01-27 00:00:00 | 2016-04-29 00:00:00 | 2016-08-01 00:00:00 | 2016-04-29 00:00:00 | 2016-07-28 00:00:00 | 2016-10-27 00:00:00 | 2016-12-22 00:00:00 | 2017-01-31 00:00:00 | 2016-12-22 00:00:00 | 2017-07-31 00:00:00 | 2017-05-02 00:00:00 | 2018-01-26 00:00:00 | 2019-07-31 00:00:00 | 2020-07-31 00:00:00 | 2019-02-26 00:00:00 | 2021-05-03 00:00:00 | 2019-09-25 00:00:00 | 2021-01-31 00:00:00 | 2018-12-31 00:00:00 | 2019-11-04 00:00:00 | 2018-01-26 00:00:00 | 2018-10-23 00:00:00 | 2022-05-05 00:00:00 | 2020-04-29 00:00:00 | 2020-12-28 00:00:00 | 2021-11-17 00:00:00 | 2020-12-30 00:00:00 | 2022-01-31 00:00:00 | 2022-10-28 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_type | 10001 | 10001 | 10001 | 10005 | 10005 | 10005 | 10001 | 10005 | 10005 | 10001 | 10005 | 10001 | 10005 | 10001 | 10005 | 10001 | 10001 | 10001 | 10005 | 10001 | 10005 | 10005 | 10005 | 10001 | 10001 | 10005 | 10001 | 10005 | 10005 | 10001 | 10005 | 10005 | 10001 | 10005 | 10001 | 10001 | 10005 | 10001 | 10001 | 10005 | 10005 | 10001 | 10001 | 10001 | 10005 | 10005 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10002 | 10001 | 10001 | 10002 | 10001 | 10001 | 10001 | 10005 | 10001 | 10002 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10002 | 10002 | 10002 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | 10001 | 10001 | 10002 | 10002 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | 10001 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_status | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 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 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
session_id | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 2001 | 1999 | 1999 | 2001 | 2001 | 1999 | 2001 | 2001 | 1999 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2003 | 2001 | 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 | 2007 | 2005 | 2007 | 2007 | 2007 | 2007 | 2007 | 2015 | 2015 | 2015 | 2015 | 2013 | 2013 | 2013 | 2015 | 2007 | 2007 | 2007 | 2007 | 2007 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2011 | 2011 | 2009 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2013 | 2013 | 2013 | 2013 | 2013 | 2013 | 2013 | 2015 | 2011 | 2013 | 2013 | 2011 | 2013 | 2013 | 2013 | 2015 | 2017 | 2017 | 2019 | 2019 | 2017 | 2017 | 2019 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2017 | 2015 | 2017 | 2017 | 2017 | 2017 | 2019 | 2019 | 2017 | 2021 | 2019 | 2019 | 2019 | 2019 | 2017 | 2017 | 2021 | 2019 | 2021 | 2021 | 2021 | 2021 | 2021 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
user_id | * | * | * | * | TTHAM | YBONILLA | * | GKURIMOT | YBONILLA | * | LTHIBAUL | DBARRICK | LTHIBAUL | DMCCASTL | LTHIBAUL | * | * | * | LTHIBAUL | * | LTHIBAUL | LTHIBAUL | LTHIBAUL | * | * | LTHIBAUL | COMPLETED | PBANFORD | LTHIBAUL | COMPLETED | LTHIBAUL | LTHIBAUL | COMPLETED | LTHIBAUL | COMPLETED | COMPLETED | LTHIBAUL | COMPLETED | COMPLETED | LTHIBAUL | LTHIBAUL | COMPLETED | COMPLETED | COMPLETED | SARRIAGA | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | * | LTHIBAUL | LTHIBAUL | PBANFORD | LTHIBAUL | LTHIBAUL | LTHIBAUL | MPACHECO | AGLADNEY | MPACHECO | MPACHECO | AGLADNEY | AGLADNEY | MPACHECO | GKURIMOT | LTHIBAUL | LTHIBAUL | YRODRIGU | JGRISSUM | JGRISSUM | PBANFORD | JGRISSUM | JGRISSUM | MGUERRA | JINGRAM | ASAETERN | ASAETERN | ASAETERN | * | CFLAGG | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | YRODRIGU | AGLADNEY | AGLADNEY | AGLADNEY | GCLARA | AGLADNEY | GCLARA | YRODRIGU | AGLADNEY | PBANFORD | PBANFORD | ASAETERN | AGLADNEY | YRODRIGU | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | DWALKER | PBANFORD | AGLADNEY | KBANH | SUSHAKOV | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | JINGRAM | AGLADNEY | AGLADNEY | CAFILER | AGLADNEY | GPEREZ | AGLADNEY | KBANH | AGLADNEY | GTAYLOR | GTAYLOR | KBANH | AROJAS | GTAYLOR | GTAYLOR | PBANFORD | KBANH | AGLADNEY | AGLADNEY | LPHEAV | SUSHAKOV | MMERCHANT | AROJAS | MMERCHANT | GTAYLOR | CAFILER | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
special_audit | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11002 | 11002 | 11002 | 11003 | 11003 | 11002 | 11003 | 11003 | 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fine_audit | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_start | 1999-01-01 00:00:00 | 1999-04-01 00:00:00 | 1999-07-01 00:00:00 | 1999-10-01 00:00:00 | 2000-01-01 00:00:00 | 2000-04-01 00:00:00 | 2000-07-01 00:00:00 | 1900-01-01 00:00:00 | 2000-07-01 00:00:00 | 2000-10-01 00:00:00 | 2001-01-01 00:00:00 | 2001-01-01 00:00:00 | 2000-10-01 00:00:00 | 2001-07-01 00:00:00 | 2001-04-01 00:00:00 | 2000-04-01 00:00:00 | 2001-04-01 00:00:00 | 2001-10-01 00:00:00 | 2001-07-01 00:00:00 | 2002-01-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 | 1900-01-01 00:00:00 | 2002-10-01 00:00:00 | 2003-01-01 00:00:00 | 2003-01-01 00:00:00 | 2003-04-01 00:00:00 | 2003-04-01 00:00:00 | 2003-07-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-04-01 00:00:00 | 2004-04-01 00:00:00 | 2004-01-01 00:00:00 | 2004-10-01 00:00:00 | 2005-01-03 00:00:00 | 2004-07-01 00:00:00 | 1900-01-01 00:00:00 | 2004-07-01 00:00:00 | 2004-10-01 00:00:00 | 2005-04-01 00:00:00 | 2005-01-01 00:00:00 | 2005-07-01 00:00:00 | 2006-01-01 00:00:00 | 2005-10-01 00:00:00 | 2006-04-01 00:00:00 | 2006-07-01 00:00:00 | 2006-12-19 00:00:00 | 2006-10-01 00:00:00 | 2007-04-01 00:00:00 | 1900-01-01 00:00:00 | 2007-10-01 00:00:00 | 2007-07-01 00:00:00 | 2007-01-01 00:00:00 | 2015-04-01 00:00:00 | 2015-01-01 00:00:00 | 2015-04-01 00:00:00 | 2015-01-01 00:00:00 | 2014-04-01 00:00:00 | 2013-04-01 00:00:00 | 2014-10-01 00:00:00 | 1900-01-01 00:00:00 | 2008-01-01 00:00:00 | 2008-01-01 00:00:00 | 2008-04-01 00:00:00 | 2008-07-01 00:00:00 | 2008-10-01 00:00:00 | 1900-01-01 00:00:00 | 2009-01-01 00:00:00 | 2009-04-01 00:00:00 | 2009-07-01 00:00:00 | 2009-10-01 00:00:00 | 2010-04-01 00:00:00 | 2010-01-01 00:00:00 | 2010-07-01 00:00:00 | 2010-11-20 00:00:00 | 1900-01-01 00:00:00 | 2010-10-01 00:00:00 | 2011-01-01 00:00:00 | 2011-04-01 00:00:00 | 2011-10-01 00:00:00 | 2011-07-01 00:00:00 | 2012-01-01 00:00:00 | 2012-04-01 00:00:00 | 1900-01-01 00:00:00 | 2013-07-01 00:00:00 | 2013-10-01 00:00:00 | 2014-04-01 00:00:00 | 2014-07-01 00:00:00 | 2014-04-01 00:00:00 | 2014-07-01 00:00:00 | 2014-11-13 00:00:00 | 2012-07-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 | 2014-03-04 00:00:00 | 2013-01-01 00:00:00 | 2015-07-01 00:00:00 | 2018-01-01 00:00:00 | 2017-10-31 00:00:00 | 2019-10-01 00:00:00 | 2018-12-30 00:00:00 | 2017-10-31 00:00:00 | 2018-05-01 00:00:00 | 2019-01-01 00:00:00 | 2015-10-01 00:00:00 | 2015-07-01 00:00:00 | 2015-10-01 00:00:00 | 2016-04-01 00:00:00 | 2016-01-01 00:00:00 | 2016-04-01 00:00:00 | 2016-07-01 00:00:00 | 2016-11-15 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 | 2017-07-01 00:00:00 | 2019-04-01 00:00:00 | 2020-04-04 00:00:00 | 2018-10-01 00:00:00 | 2021-01-01 00:00:00 | 2019-04-01 00:00:00 | 2020-10-01 00:00:00 | 1900-01-01 00:00:00 | 2019-07-01 00:00:00 | 2017-04-01 00:00:00 | 2018-07-01 00:00:00 | 2022-01-01 00:00:00 | 2020-01-01 00:00:00 | 2020-12-31 00:00:00 | 2021-07-01 00:00:00 | 1900-01-01 00:00:00 | 2021-10-01 00:00:00 | 2022-07-01 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_end | 1999-03-31 00:00:00 | 1999-06-30 00:00:00 | 1999-09-30 00:00:00 | 1999-12-31 00:00:00 | 2000-03-31 00:00:00 | 2000-06-30 00:00:00 | 2000-09-30 00:00:00 | 1900-01-01 00:00:00 | 2000-09-30 00:00:00 | 2000-12-31 00:00:00 | 2001-03-31 00:00:00 | 2001-03-31 00:00:00 | 2000-12-31 00:00:00 | 2001-09-30 00:00:00 | 2001-06-30 00:00:00 | 2000-06-30 00:00:00 | 2001-06-30 00:00:00 | 2001-12-31 00:00:00 | 2001-09-30 00:00:00 | 2002-03-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 | 1900-01-01 00:00:00 | 2002-12-31 00:00:00 | 2003-03-31 00:00:00 | 2003-03-31 00:00:00 | 2003-06-30 00:00:00 | 2003-06-30 00:00:00 | 2003-09-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-06-30 00:00:00 | 2004-06-30 00:00:00 | 2004-03-31 00:00:00 | 2004-12-31 00:00:00 | 2005-01-03 00:00:00 | 2004-09-30 00:00:00 | 1900-01-01 00:00:00 | 2004-09-30 00:00:00 | 2004-12-31 00:00:00 | 2005-06-30 00:00:00 | 2005-03-31 00:00:00 | 2005-09-30 00:00:00 | 2006-03-31 00:00:00 | 2005-12-31 00:00:00 | 2006-06-30 00:00:00 | 2006-09-30 00:00:00 | 2006-12-19 00:00:00 | 2006-12-31 00:00:00 | 2007-06-30 00:00:00 | 1900-01-01 00:00:00 | 2007-12-31 00:00:00 | 2007-09-30 00:00:00 | 2007-03-31 00:00:00 | 2015-06-30 00:00:00 | 2015-03-31 00:00:00 | 2015-06-30 00:00:00 | 2015-03-31 00:00:00 | 2014-06-30 00:00:00 | 2013-06-30 00:00:00 | 2014-12-31 00:00:00 | 1900-01-01 00:00:00 | 2008-03-31 00:00:00 | 2008-03-31 00:00:00 | 2008-06-30 00:00:00 | 2008-09-30 00:00:00 | 2008-12-31 00:00:00 | 1900-01-01 00:00:00 | 2009-03-31 00:00:00 | 2009-06-30 00:00:00 | 2009-09-30 00:00:00 | 2009-12-31 00:00:00 | 2010-06-30 00:00:00 | 2010-03-31 00:00:00 | 2010-09-30 00:00:00 | 2010-11-20 00:00:00 | 1900-01-01 00:00:00 | 2010-12-31 00:00:00 | 2011-03-31 00:00:00 | 2011-06-30 00:00:00 | 2011-12-31 00:00:00 | 2011-09-30 00:00:00 | 2012-03-31 00:00:00 | 2012-06-30 00:00:00 | 1900-01-01 00:00:00 | 2013-09-30 00:00:00 | 2013-12-31 00:00:00 | 2014-06-30 00:00:00 | 2014-10-31 00:00:00 | 2014-06-30 00:00:00 | 2014-10-31 00:00:00 | 2014-11-13 00:00:00 | 2012-09-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 | 2014-03-04 00:00:00 | 2013-03-31 00:00:00 | 2015-09-30 00:00:00 | 2018-03-31 00:00:00 | 2017-12-31 00:00:00 | 2019-12-31 00:00:00 | 2018-12-30 00:00:00 | 2017-12-31 00:00:00 | 2018-07-31 00:00:00 | 2019-03-31 00:00:00 | 2015-12-31 00:00:00 | 2015-09-30 00:00:00 | 2015-12-31 00:00:00 | 2016-06-30 00:00:00 | 2016-04-30 00:00:00 | 2016-06-30 00:00:00 | 2016-09-30 00:00:00 | 2016-11-15 00:00:00 | 2016-12-31 00:00:00 | 1900-01-01 00:00:00 | 2017-07-31 00:00:00 | 2017-04-30 00:00:00 | 2017-09-30 00:00:00 | 2019-06-30 00:00:00 | 2020-06-30 00:00:00 | 2018-12-31 00:00:00 | 2021-03-31 00:00:00 | 2019-06-30 00:00:00 | 2020-12-31 00:00:00 | 1900-01-01 00:00:00 | 2019-09-30 00:00:00 | 2017-06-30 00:00:00 | 2018-09-30 00:00:00 | 2022-03-31 00:00:00 | 2020-03-31 00:00:00 | 2020-12-31 00:00:00 | 2021-09-30 00:00:00 | 1900-01-01 00:00:00 | 2021-12-31 00:00:00 | 2022-09-30 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_date | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_type | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 22001 | None | None | 22001 | None | None | 22001 | None | 22001 | 22001 | None | 22001 | 22001 | None | None | 22001 | 22001 | 22001 | None | None | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22006 | 22006 | 22006 | 22006 | 22006 | 22001 | 22006 | None | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22006 | 22006 | 22006 | 22006 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22006 | 22006 | 22006 | 22006 | 22001 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22001 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22001 | 22006 | None | 22006 | 22006 |
filer_id | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
session_id | 2001 | 1999 | 1997 | 2003 | 2009 | 2013 | 2007 | 2005 | 2011 | 2021 | 2017 | 2015 | 2019 | 2023 | ||||||||||||||
interest_cd | 40306 | 40306 | 40306 | 40306 | 40306 | 40306 | 40306 | 40306 | 40306 | 40312 | 40312 | 40312 | 40312 | 40312 | ||||||||||||||
effect_date | 2001-01-01 00:00:00 | 1999-01-01 00:00:00 | 1998-03-10 00:00:00 | 2003-01-01 00:00:00 | 2009-01-01 00:00:00 | 2013-01-01 00:00:00 | 2007-01-01 00:00:00 | 2005-01-01 00:00:00 | 2011-01-01 00:00:00 | 2021-01-01 00:00:00 | 2017-01-01 00:00:00 | 2015-01-01 00:00:00 | 2019-01-01 00:00:00 | 2023-01-01 00:00:00 |
filer_id | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_type | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | ||||||||||||||
active | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | N | ||||||||||||||
race | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
session_id | 1997 | 1999 | 2001 | 2003 | 2005 | 2007 | 2011 | 2013 | 2009 | 2015 | 2021 | 2019 | 2017 | 2023 | ||||||||||||||
category | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
category_type | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
sub_category | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
effect_dt | 1998-03-10 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 | 2011-01-01 00:00:00 | 2013-01-01 00:00:00 | 2009-01-01 00:00:00 | 2015-01-01 00:00:00 | 2021-01-01 00:00:00 | 2019-01-01 00:00:00 | 2017-01-01 00:00:00 | 2023-01-01 00:00:00 | ||||||||||||||
sub_category_type | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
election_type | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
sub_category_a | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
nyq_dt | None | None | None | None | 2000-07-01 00:00:00 | 2000-07-01 00:00:00 | None | None | None | None | None | None | None | None | ||||||||||||||
party_cd | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
county_cd | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
district_cd | None | None | None | None | None | None | None | None | None | None | None | None | None | None |
filer_id | 1145840 | |
---|---|---|
xref_id | C27361 | |
effect_dt | 1999-12-08 00:00:00 | |
migration_source | MASTER |
xref_filer_id | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | C27361 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_id | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS OF CALIFORNIA | AMERICAN RED CROSS OF CALIFORNIA | AMERICAN RED CROSS OF CALIFORNIA | AMERICAN RED CROSS OF CALIFORNIA | AMERICAN RED CROSS OF CALIFORNIA | AMERICAN RED CROSS OF CALIFORNIA | AMERICAN RED CROSS OF CALIFORNIA | AMERICAN RED CROSS OF CALIFORNIA | AMERICAN RED CROSS OF CALIFORNIA | AMERICAN RED CROSS OF CALIFORNIA | AMERICAN RED CROSS OF CALIFORNIA | AMERICAN RED CROSS OF CALIFORNIA | AMERICAN RED CROSS OF CALIFORNIA | AMERICAN RED CROSS OF CALIFORNIA | AMERICAN RED CROSS OF CALIFORNIA | AMERICAN RED CROSS OF CALIFORNIA | AMERICAN RED CROSS OF CALIFORNIA | AMERICAN RED CROSS OF CALIFORNIA | AMERICAN RED CROSS OF CALIFORNIA | AMERICAN RED CROSS OF CALIFORNIA | AMERICAN RED CROSS OF CALIFORNIA | AMERICAN RED CROSS OF CALIFORNIA | AMERICAN RED CROSS OF CALIFORNIA | AMERICAN RED CROSS OF CALIFORNIA | AMERICAN RED CROSS OF CALIFORNIA | AMERICAN RED CROSS OF CALIFORNIA | AMERICAN RED CROSS OF CALIFORNIA | AMERICAN RED CROSS OF CALIFORNIA | AMERICAN RED CROSS OF CALIFORNIA | AMERICAN RED CROSS OF CALIFORNIA | AMERICAN RED CROSS OF CALIFORNIA | AMERICAN RED CROSS OF CALIFORNIA | AMERICAN RED CROSS OF CALIFORNIA | AMERICAN RED CROSS OF CALIFORNIA | AMERICAN RED CROSS OF CALIFORNIA | AMERICAN RED CROSS OF CALIFORNIA | AMERICAN RED CROSS, CALIFORNIA CHAPTER | AMERICAN RED CROSS, CALIFORNIA CHAPTER | AMERICAN RED CROSS, CALIFORNIA CHAPTER | AMERICAN RED CROSS, CALIFORNIA CHAPTER | AMERICAN RED CROSS, CALIFORNIA CHAPTER | AMERICAN RED CROSS, CALIFORNIA CHAPTER | AMERICAN RED CROSS, CALIFORNIA CHAPTER | AMERICAN RED CROSS, CALIFORNIA CHAPTER | AMERICAN RED CROSS, CALIFORNIA CHAPTER | AMERICAN RED CROSS, CALIFORNIA CHAPTER | AMERICAN RED CROSS, CALIFORNIA CHAPTER | AMERICAN RED CROSS, CALIFORNIA CHAPTER | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | 958263221 | 95826 | 95826 | 95826 | 94105 | 94105 | 94105 | 95815 | 95815 | 95815 | 95815 | 95815 | 958263221 | 95826 | 95826 | 95826 | 94105 | 94105 | 94105 | 95815 | 95815 | 95815 | 95815 | 95815 | 958263221 | 95826 | 95826 | 95826 | 94105 | 94105 | 94105 | 95815 | 95815 | 95815 | 95815 | 95815 | 958263221 | 95826 | 95826 | 95826 | 94105 | 94105 | 94105 | 95815 | 95815 | 95815 | 95815 | 95815 | 958263221 | 95826 | 95826 | 95826 | 94105 | 94105 | 94105 | 95815 | 95815 | 95815 | 95815 | 95815 | 958263221 | 95826 | 95826 | 95826 | 94105 | 94105 | 94105 | 95815 | 95815 | 95815 | 95815 | 95815 | 958263221 | 95826 | 95826 | 95826 | 94105 | 94105 | 94105 | 95815 | 95815 | 95815 | 95815 | 95815 | 958263221 | 95826 | 95826 | 95826 | 94105 | 94105 | 94105 | 95815 | 95815 | 95815 | 95815 | 95815 | 958263221 | 95826 | 95826 | 95826 | 94105 | 94105 | 94105 | 95815 | 95815 | 95815 | 95815 | 95815 | 958263221 | 95826 | 95826 | 95826 | 94105 | 94105 | 94105 | 95815 | 95815 | 95815 | 95815 | 95815 | 958263221 | 95826 | 95826 | 95826 | 94105 | 94105 | 94105 | 95815 | 95815 | 95815 | 95815 | 95815 | 958263221 | 95826 | 95826 | 95826 | 94105 | 94105 | 94105 | 95815 | 95815 | 95815 | 95815 | 95815 | 958263221 | 95826 | 95826 | 95826 | 94105 | 94105 | 94105 | 95815 | 95815 | 95815 | 95815 | 95815 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
phon | 9163683166 | 9163683170 | 9163683170 | 9163683170 | 4154278104 | 4154278104 | 4154278104 | 9169937072 | 9169937072 | 9169937072 | 9169937072 | 9169937072 | 9163683166 | 9163683170 | 9163683170 | 9163683170 | 4154278104 | 4154278104 | 4154278104 | 9169937072 | 9169937072 | 9169937072 | 9169937072 | 9169937072 | 9163683166 | 9163683170 | 9163683170 | 9163683170 | 4154278104 | 4154278104 | 4154278104 | 9169937072 | 9169937072 | 9169937072 | 9169937072 | 9169937072 | 9163683166 | 9163683170 | 9163683170 | 9163683170 | 4154278104 | 4154278104 | 4154278104 | 9169937072 | 9169937072 | 9169937072 | 9169937072 | 9169937072 | 9163683166 | 9163683170 | 9163683170 | 9163683170 | 4154278104 | 4154278104 | 4154278104 | 9169937072 | 9169937072 | 9169937072 | 9169937072 | 9169937072 | 9163683166 | 9163683170 | 9163683170 | 9163683170 | 4154278104 | 4154278104 | 4154278104 | 9169937072 | 9169937072 | 9169937072 | 9169937072 | 9169937072 | 9163683166 | 9163683170 | 9163683170 | 9163683170 | 4154278104 | 4154278104 | 4154278104 | 9169937072 | 9169937072 | 9169937072 | 9169937072 | 9169937072 | 9163683166 | 9163683170 | 9163683170 | 9163683170 | 4154278104 | 4154278104 | 4154278104 | 9169937072 | 9169937072 | 9169937072 | 9169937072 | 9169937072 | 9163683166 | 9163683170 | 9163683170 | 9163683170 | 4154278104 | 4154278104 | 4154278104 | 9169937072 | 9169937072 | 9169937072 | 9169937072 | 9169937072 | 9163683166 | 9163683170 | 9163683170 | 9163683170 | 4154278104 | 4154278104 | 4154278104 | 9169937072 | 9169937072 | 9169937072 | 9169937072 | 9169937072 | 9163683166 | 9163683170 | 9163683170 | 9163683170 | 4154278104 | 4154278104 | 4154278104 | 9169937072 | 9169937072 | 9169937072 | 9169937072 | 9169937072 | 9163683166 | 9163683170 | 9163683170 | 9163683170 | 4154278104 | 4154278104 | 4154278104 | 9169937072 | 9169937072 | 9169937072 | 9169937072 | 9169937072 | 9163683166 | 9163683170 | 9163683170 | 9163683170 | 4154278104 | 4154278104 | 4154278104 | 9169937072 | 9169937072 | 9169937072 | 9169937072 | 9169937072 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fax | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None |
filer_id | 1145840 |
---|
filer_id | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | ||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
change_no | 1 | 2 | 3 | 4 | 0 | 5 | ||||||
session_id | 2001 | 2001 | 2001 | 2001 | 2013 | 2013 | ||||||
log_dt | 2001-03-22 00:00:00 | 2001-03-22 00:00:00 | 2001-03-22 00:00:00 | 2001-03-22 00:00:00 | 2014-03-13 00:00:00 | 2014-03-05 00:00:00 | ||||||
filer_type | 1 | 1 | 1 | 1 | 1 | 1 | ||||||
correction_flg | None | None | None | None | None | Y | ||||||
action | IN SUSPENSE | IN SUSPENSE | SET ACTIVE | IN SUSPENSE | ADDED | DELETED | ||||||
attribute_changed | CLIENT | CLIENT | CLIENT | CLIENT | FIRM | FIRM | ||||||
ethics_dt | None | None | None | None | None | None | ||||||
interests | None | None | None | None | None | None | ||||||
filer_full_name | AMERICAN RED CROSS OF CALIFORNIA | AMERICAN RED CROSS OF CALIFORNIA | AMERICAN RED CROSS OF CALIFORNIA | AMERICAN RED CROSS OF CALIFORNIA | AMERICAN RED CROSS CALIFORNIA CHAPTER | AMERICAN RED CROSS CALIFORNIA CHAPTER | ||||||
filer_city | None | SACRAMENTO | ARLINGTON | ARLINGTON | None | None | ||||||
filer_st | None | CA | VA | VA | None | None | ||||||
filer_zip | None | 95841 | 22209 | 22209 | None | None | ||||||
filer_phone | None | 9163444985 | 7037415000 | 7037415000 | None | None | ||||||
entity_type | 3 | 3 | 3 | 3 | 3 | 3 | ||||||
entity_name | SACRAMENTO ADVOCATES, INC. | SACRAMENTO ADVOCATES, INC. | SACRAMENTO ADVOCATES, INC. | SACRAMENTO ADVOCATES, INC. | POLITICAL SOLUTIONS, LLC | SACRAMENTO ADVOCATES INC. | ||||||
entity_city | None | None | None | None | None | None | ||||||
entity_st | None | None | None | None | None | None | ||||||
entity_zip | None | None | None | None | None | None | ||||||
entity_phone | None | None | None | None | None | None | ||||||
entity_id | 1147285 | 1147285 | 1147285 | 1147285 | 1261533 | 1147285 | ||||||
responsible_officer | None | None | None | None | None | None | ||||||
effect_dt | None | None | None | None | 2014-03-01 00:00:00 | 2014-02-28 00:00:00 |
filer_id | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | 1145840 | ||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_file_name | 680731_0.cal | 713795_0.cal | 744111_0.cal | 769400_0.cal | 139238.cal | 769858_0.cal | 789550_0.cal | 29088.cal | 29119.cal | 29360.cal | 80330.cal | 808369_0.cal | 838531_0.cal | 853599_0.cal | 881203_0.cal | 905843_0.cal | 930300_0.cal | 945775_0.cal | 969035_0.cal | 132716.cal | ||||||||||||||||||||
received_date | 2000-10-30 00:00:00 | 2001-01-24 00:00:00 | 2001-04-26 00:00:00 | 2001-07-24 00:00:00 | 2001-07-25 00:00:00 | 2001-07-25 00:00:00 | 2001-10-26 00:00:00 | 2001-10-26 00:00:00 | 2001-10-26 00:00:00 | 2001-10-26 00:00:00 | 2002-01-21 00:00:00 | 2002-01-21 00:00:00 | 2002-04-29 00:00:00 | 2002-07-29 00:00:00 | 2002-10-28 00:00:00 | 2003-01-24 00:00:00 | 2003-04-29 00:00:00 | 2003-07-29 00:00:00 | 2003-10-30 00:00:00 | 2006-07-26 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/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/temp | /usr/users/cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | ||||||||||||||||||||
filing_id | 680731 | 713795 | 744111 | 769400 | None | 769858 | 789550 | None | None | None | None | 808369 | 838531 | 853599 | 881203 | 905843 | 930300 | 945775 | 969035 | None | ||||||||||||||||||||
form_id | F635 | F635 | F635 | F635 | None | F635 | F635 | None | None | None | None | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | None | ||||||||||||||||||||
receive_comment | Filing accepted, but with warnings | Filing accepted, but with warnings | Filing accepted, but with warnings | Filing accepted, but with warnings | Filing passed validation, but failed DB constraints | Filing accepted, but with warnings | Filing accepted, but with warnings | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing accepted, but with warnings | Filing 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, but with warnings | Filing accepted, but with warnings | Filing passed validation, but failed DB constraints |