acronym | OCADA | |
---|---|---|
filer_id | 1043948 |
filer_id | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
adrid | 1042839 | 2095763 | 2099562 | 2175571 | 2157066 | 2441052 | 2525551 | 2525552 | 2351448 | 2351447 | 2516086 | 2516087 | ||||||||||||
effect_dt | 1990-12-01 00:00:00 | 2005-11-10 00:00:00 | 1987-07-07 00:00:00 | 2009-11-09 00:00:00 | 1987-01-01 00:00:00 | 2017-10-09 00:00:00 | 2021-10-25 00:00:00 | 2021-10-25 00:00:00 | 2015-01-15 00:00:00 | 2015-01-15 00:00:00 | 2021-02-12 00:00:00 | 2021-02-12 00:00:00 | ||||||||||||
add_type | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7082 | 7082 | 7051 | 7051 | 7082 | ||||||||||||
session_id | 1987 | 2005 | 1987 | 2009 | 1987 | 2017 | 2021 | 2021 | 2015 | 2015 | 2021 | 2021 |
filer_id | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 286031 | 286032 | 286033 | 286034 | 286035 | 286036 | 286037 | 286038 | 286039 | 286040 | 286041 | 286042 | 286043 | 427785 | 427786 | 427787 | 581795 | 612388 | 581795 | 759876 | 784708 | 806752 | 806787 | 806787 | 865603 | 866758 | 884117 | 917062 | 890981 | 943089 | 981368 | 999430 | 1025341 | 1055346 | 1107576 | 1057894 | 1107575 | 1088159 | 1111844 | 1114217 | 981368 | 1088159 | 1025341 | 1055346 | 1107575 | 1107576 | 1145556 | 1138115 | 1150380 | 1159802 | 1155167 | 1187886 | 1203012 | 1193865 | 1206323 | 1218610 | 1211518 | 1212791 | 1231903 | 1237803 | 1282350 | 1270467 | 1305840 | 1286789 | 1976949 | 1944029 | 1319741 | 1305064 | 1322759 | 1343161 | 1343839 | 1334644 | 1368930 | 1335149 | 1364455 | 1371113 | 1363020 | 1388553 | 1155167 | 1389319 | 1402165 | 1155167 | 1423219 | 1454395 | 1927472 | 1926519 | 1983484 | 2520497 | 2491665 | 2454290 | 2367311 | 2573688 | 2460799 | 2307112 | 2362360 | 2312325 | 2518526 | 2506078 | 2305300 | 2005799 | 2014407 | 2054206 | 2086843 | 2082920 | 2069977 | 2101783 | 2089109 | 2096531 | 2079366 | 2103853 | 2106610 | 2096428 | 2088947 | 2122397 | 2093177 | 2108698 | 2146112 | 2300138 | 2503228 | 2432505 | 2359918 | 2500978 | 2281782 | 2461528 | 2301601 | 2309866 | 2331677 | 2536432 | 2311854 | 2362841 | 2319800 | 2345192 | 2355535 | 2601505 | 2280687 | 2429277 | 2296173 | 2445271 | 2575297 | 2369880 | 2401764 | 2509031 | 2296173 | 2301601 | 2282165 | 2542283 | 2446938 | 2271185 | 2500832 | 2187354 | 2391882 | 2335892 | 2447119 | 2371080 | 2512099 | 2619154 | 2624525 | 2479623 | 2509747 | 2686538 | 2557987 | 2679840 | 2706462 | 2690931 | 2654936 | 2643001 | 2736155 | 2743873 | 2735182 | 2731932 | 2725663 | 2742904 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
period_id | 111 | 109 | 113 | 114 | 115 | 116 | 129 | 134 | 143 | 147 | 149 | 158 | 159 | 127 | 143 | 157 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 180 | None | 179 | None | 181 | None | None | None | None | None | 179 | 180 | 183 | None | None | None | 185 | 185 | 187 | None | None | None | 188 | 188 | 188 | None | 189 | None | None | None | 221 | None | 193 | 191 | None | 194 | None | 193 | 196 | None | None | None | 195 | 196 | 197 | None | None | 198 | None | None | None | 220 | None | None | None | 241 | None | None | 241 | 236 | None | 236 | 243 | 243 | 236 | 223 | None | 225 | 228 | 227 | None | 228 | 228 | None | 227 | 228 | None | 227 | 228 | 228 | 228 | None | None | 236 | 243 | 241 | 237 | 243 | None | None | None | 236 | 236 | 244 | 235 | 237 | None | 237 | None | 245 | None | 239 | 235 | 241 | None | 237 | None | None | 235 | None | 235 | 244 | None | 234 | 243 | None | 238 | 237 | 241 | None | 244 | None | None | 241 | 244 | 249 | None | 250 | 250 | None | None | 247 | 252 | 252 | 252 | None | 251 | 251 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F410 | F420 | F420 | F420 | F420 | F420 | F405 | F405 | F405 | F405 | F405 | F405 | F420 | F405 | F405 | F420 | F460 | F410 | F460 | F410 | F410 | F460 | F460 | F460 | F460 | F410 | F460 | F460 | F497 | F460 | F460 | F460 | F460 | F460 | F460 | F497 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F410 | F460 | F410 | F410 | F460 | F460 | F460 | F460 | F460 | F497 | F460 | F460 | F460 | F460 | F497 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F410 | F460 | F410 | F410 | F410 | F410 | F410 | F460 | F460 | F460 | F460 | F460 | F460 | F410 | F497 | F497 | F460 | F497 | F460 | F497 | F497 | F460 | F460 | F460 | F497 | F460 | F460 | F497 | F497 | F410 | F497 | F497 | F460 | F460 | F497 | F460 | F497 | F460 | F460 | F497 | F460 | F497 | F497 | F497 | F460 | F460 | F460 | F497 | F460 | F497 | F460 | F460 | F460 | F460 | F460 | F460 | F410 | F460 | F460 | F497 | F460 | F460 | F460 | F460 | F460 | F460 | F497 | F460 | F460 | F460 | F497 | F410 | F460 | F497 | F497 | F460 | F497 | F410 | F460 | F460 | F497 | F460 | F410 | F497 | F460 | F460 | F460 | F460 | F497 | F497 | F497 | F460 | F460 | F460 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_sequence | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 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 | 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_date | 1987-08-18 00:00:00 | 1988-02-01 00:00:00 | 1988-05-26 00:00:00 | 1988-08-01 00:00:00 | 1988-10-05 00:00:00 | 1989-01-31 00:00:00 | 1992-02-04 00:00:00 | 1993-04-07 00:00:00 | 1995-08-04 00:00:00 | 1996-08-05 00:00:00 | 1997-02-03 00:00:00 | 1999-06-09 00:00:00 | 1999-10-12 00:00:00 | 1991-09-09 00:00:00 | 1995-09-08 00:00:00 | 1999-08-02 00:00:00 | 2000-01-10 00:00:00 | 2000-01-12 00:00:00 | 2000-01-29 00:00:00 | 2001-02-05 00:00:00 | 2001-09-28 00:00:00 | 2002-01-10 00:00:00 | 2002-01-10 00:00:00 | 2002-01-10 00:00:00 | 2002-07-31 00:00:00 | 2002-08-02 00:00:00 | 2002-10-24 00:00:00 | 2003-01-31 00:00:00 | 2002-11-05 00:00:00 | 2003-07-18 00:00:00 | 2004-01-08 00:00:00 | 2004-02-18 00:00:00 | 2004-07-21 00:00:00 | 2004-10-21 00:00:00 | 2005-05-23 00:00:00 | 2004-10-25 00:00:00 | 2005-05-23 00:00:00 | 2005-01-31 00:00:00 | 2005-07-13 00:00:00 | 2005-07-18 00:00:00 | 2005-05-26 00:00:00 | 2005-05-26 00:00:00 | 2005-05-26 00:00:00 | 2005-05-26 00:00:00 | 2005-05-13 00:00:00 | 2005-05-13 00:00:00 | 2006-01-27 00:00:00 | 2005-11-10 00:00:00 | 2006-01-30 00:00:00 | 2006-03-13 00:00:00 | 2006-03-13 00:00:00 | 2006-07-26 00:00:00 | 2006-09-29 00:00:00 | 2006-07-31 00:00:00 | 2006-10-05 00:00:00 | 2006-10-26 00:00:00 | 2006-10-25 00:00:00 | 2006-10-26 00:00:00 | 2007-01-26 00:00:00 | 2007-01-29 00:00:00 | 2007-07-29 00:00:00 | 2006-10-25 00:00:00 | 2008-01-24 00:00:00 | 2007-07-31 00:00:00 | 2015-07-24 00:00:00 | 2015-01-21 00:00:00 | 2008-03-22 00:00:00 | 2008-01-22 00:00:00 | 2008-03-24 00:00:00 | 2008-07-14 00:00:00 | 2008-07-16 00:00:00 | 2008-05-22 00:00:00 | 2008-10-22 00:00:00 | 2008-05-22 00:00:00 | 2008-10-06 00:00:00 | 2008-10-23 00:00:00 | 2008-10-06 00:00:00 | 2009-01-09 00:00:00 | 2009-01-06 00:00:00 | 2009-01-12 00:00:00 | 2009-01-12 00:00:00 | 2009-04-07 00:00:00 | 2009-04-09 00:00:00 | 2009-11-09 00:00:00 | 2015-01-15 00:00:00 | 2015-01-16 00:00:00 | 2015-07-29 00:00:00 | 2020-10-21 00:00:00 | 2020-07-24 00:00:00 | 2020-02-19 00:00:00 | 2019-02-25 00:00:00 | 2021-04-12 00:00:00 | 2020-03-03 00:00:00 | 2018-10-16 00:00:00 | 2019-01-30 00:00:00 | 2018-10-25 00:00:00 | 2020-10-20 00:00:00 | 2020-09-25 00:00:00 | 2018-10-11 00:00:00 | 2016-01-23 00:00:00 | 2016-01-28 00:00:00 | 2016-07-08 00:00:00 | 2016-10-09 00:00:00 | 2016-09-29 00:00:00 | 2016-07-13 00:00:00 | 2016-10-31 00:00:00 | 2016-10-14 00:00:00 | 2016-10-13 00:00:00 | 2016-09-20 00:00:00 | 2016-11-02 00:00:00 | 2016-09-29 00:00:00 | 2016-10-26 00:00:00 | 2016-10-14 00:00:00 | 2017-01-23 00:00:00 | 2016-10-21 00:00:00 | 2016-10-27 00:00:00 | 2017-01-26 00:00:00 | 2018-10-02 00:00:00 | 2020-09-21 00:00:00 | 2020-01-21 00:00:00 | 2019-02-15 00:00:00 | 2020-09-12 00:00:00 | 2018-07-27 00:00:00 | 2020-02-19 00:00:00 | 2018-10-25 00:00:00 | 2018-10-22 00:00:00 | 2019-01-02 00:00:00 | 2020-12-09 00:00:00 | 2018-10-24 00:00:00 | 2019-02-25 00:00:00 | 2018-10-25 00:00:00 | 2019-01-30 00:00:00 | 2019-01-04 00:00:00 | 2021-07-30 00:00:00 | 2018-08-01 00:00:00 | 2020-01-09 00:00:00 | 2018-10-24 00:00:00 | 2020-02-04 00:00:00 | 2021-01-11 00:00:00 | 2019-04-02 00:00:00 | 2019-07-24 00:00:00 | 2020-09-24 00:00:00 | 2018-09-26 00:00:00 | 2018-09-27 00:00:00 | 2018-08-10 00:00:00 | 2021-01-05 00:00:00 | 2020-01-14 00:00:00 | 2018-07-27 00:00:00 | 2020-09-11 00:00:00 | 2017-10-09 00:00:00 | 2019-07-22 00:00:00 | 2019-01-18 00:00:00 | 2020-02-06 00:00:00 | 2019-04-04 00:00:00 | 2020-10-08 00:00:00 | 2021-10-25 00:00:00 | 2021-08-01 00:00:00 | 2020-07-21 00:00:00 | 2020-10-05 00:00:00 | 2022-05-26 00:00:00 | 2021-02-12 00:00:00 | 2022-05-06 00:00:00 | 2022-08-01 00:00:00 | 2022-05-26 00:00:00 | 2022-01-31 00:00:00 | 2022-01-31 00:00:00 | 2022-10-19 00:00:00 | 2022-10-27 00:00:00 | 2022-10-17 00:00:00 | 2022-09-29 00:00:00 | 2022-09-29 00:00:00 | 2022-10-27 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_type | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10002 | 10006 | 10002 | 10002 | 10005 | 10005 | 10006 | 10005 | 10002 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10002 | 10005 | 10002 | 10005 | 10001 | 10005 | 10006 | 10006 | 10006 | 10006 | 10001 | 10001 | 10001 | 10006 | 10005 | 10006 | 10001 | 10001 | 10001 | 10005 | 10005 | 10005 | 10001 | 10001 | 10001 | 10005 | 10001 | 10005 | 10005 | 10005 | 10001 | 10005 | 10001 | 10001 | 10005 | 10001 | 10005 | 10001 | 10001 | 10005 | 10005 | 10005 | 10001 | 10001 | 10002 | 10005 | 10006 | 10002 | 10006 | 10006 | 10006 | 10001 | 10005 | 10005 | 10005 | 10001 | 10005 | 10006 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10006 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10005 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10005 | 10006 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10005 | 10001 | 10006 | 10001 | 10002 | 10001 | 10005 | 10001 | 10005 | 10005 | 10001 | 10005 | 10001 | 10001 | 10005 | 10001 | 10001 | 10006 | 10001 | 10001 | 10001 | 10005 | 10001 | 10006 | 10005 | 10001 | 10001 | 10001 | 10006 | 10001 | 10001 | 10005 | 10005 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_status | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11003 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
session_id | 1987 | 1987 | 1987 | 1987 | 1987 | 1987 | 1991 | 1993 | 1995 | 1995 | 1997 | 1999 | 1999 | 1991 | 1995 | 1999 | 1999 | 1999 | 1999 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2005 | 2005 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2007 | 2005 | 2007 | 2007 | 2015 | 2013 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2015 | 2013 | 2015 | 2019 | 2019 | 2019 | 2019 | 2021 | 2019 | 2017 | 2019 | 2017 | 2019 | 2019 | 2017 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2017 | 2019 | 2019 | 2019 | 2019 | 2017 | 2019 | 2017 | 2017 | 2017 | 2019 | 2017 | 2019 | 2017 | 2019 | 2017 | 2021 | 2017 | 2019 | 2017 | 2019 | 2019 | 2019 | 2019 | 2019 | 2017 | 2017 | 2017 | 2019 | 2019 | 2017 | 2019 | 2017 | 2019 | 2019 | 2019 | 2019 | 2019 | 2021 | 2021 | 2019 | 2019 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
user_id | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | TTHAM | TTHAM | MKIENG | SARRIAGA | TTHAM | MHOANG | DBARRICK | TTHAM | DBARRICK | DBARRICK | KLARRY | KLARRY | GGILMORE | GKURIMOT | EMCENTEE | GKURIMOT | * | GPEREZ | * | KVOONG1 | * | SARRIAGA | KLARRY | KLARRY | KLARRY | KLARRY | * | DHORRELL | * | TTHAM | CFLAGG | TTHAM | * | * | * | GPEREZ | GPEREZ | SARRIAGA | LHOANG | * | * | GPEREZ | * | LHOANG | DMCCASTL | GPEREZ | SMCCONNAN | GCLARA | * | * | SARRIAGA | * | SARRIAGA | * | * | TMILLER | RGEREMIA | RGEREMIA | * | * | * | JVAZQUEZ | RGEREMIA | * | RGEREMIA | RGEREMIA | TRAMON | CAFILER | SMCCONNAN | IMEDINA | IMEDINA | SUSHAKOV | AROJAS | IMEDINA | CAFILER | CAFILER | JFONSECA | CAFILER | IMEDINA | CAFILER | CAFILER | CAFILER | SARRIAGA | LLEONG | PDEO | SARRIAGA | LLEONG | PDEO | PDEO | TRAMON | PDEO | PDEO | SARRIAGA | HSTOVALL | PDEO | TRAMON | PDEO | HSTOVALL | TRAMON | CAFILER | IMEDINA | CAFILER | CAFILER | CAFILER | HSTOVALL | SUSHAKOV | CSAGABAEN | CAFILER | LPHEAV | CAFILER | CSAGABAEN | AROJAS | CSAGABAEN | JFONSECA | LPHEAV | KRUSSELL | RSAGARIO | LFEDOROV | CAFILER | CAFILER | SARRIAGA | JFONSECA | BCOLON | IMEDINA | CSAGABAEN | CSAGABAEN | CAFILER | SARRIAGA | LFEDOROV | HSTOVALL | CAFILER | RSAGARIO | BCOLON | CAFILER | CAFILER | JFONSECA | CAFILER | IMEDINA | KRUSSELL | IMEDINA | CAFILER | CAFILER | IMEDINA | CAFILER | CAFILER | JMAVES | KRUSSELL | KRUSSELL | CAFILER | CAFILER | CAFILER | RGEREMIA | CAFILER | CAFILER | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
special_audit | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fine_audit | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_start | None | 1987-01-01 00:00:00 | 1988-01-01 00:00:00 | 1988-05-22 00:00:00 | 1988-07-01 00:00:00 | 1988-10-01 00:00:00 | None | None | None | None | None | None | 1999-07-01 00:00:00 | None | None | 1999-01-01 00:00:00 | 1999-10-01 00:00:00 | None | 1999-10-01 00:00:00 | 1998-10-29 00:00:00 | 2001-09-13 00:00:00 | 2001-10-01 00:00:00 | 2001-07-01 00:00:00 | 2001-07-01 00:00:00 | 2002-01-01 00:00:00 | None | 2002-07-01 00:00:00 | 2002-10-20 00:00:00 | None | 2003-01-01 00:00:00 | 2003-07-01 00:00:00 | 2004-01-01 00:00:00 | 2004-02-15 00:00:00 | 2004-07-01 00:00:00 | 2004-10-17 00:00:00 | None | 2004-07-01 00:00:00 | 2004-10-17 00:00:00 | 2005-01-01 00:00:00 | 2005-01-01 00:00:00 | 2003-07-01 00:00:00 | 2004-10-17 00:00:00 | 2004-02-15 00:00:00 | 2004-07-01 00:00:00 | 2004-07-01 00:00:00 | 2004-10-17 00:00:00 | 2005-07-01 00:00:00 | None | 2005-07-01 00:00:00 | None | 2006-03-10 00:00:00 | 2006-01-01 00:00:00 | 2006-07-01 00:00:00 | 2006-01-01 00:00:00 | 2006-07-01 00:00:00 | 2006-10-01 00:00:00 | 2006-10-25 00:00:00 | 2006-10-01 00:00:00 | 2006-10-22 00:00:00 | 2006-10-22 00:00:00 | 2007-01-01 00:00:00 | None | 2007-07-01 00:00:00 | 2007-01-01 00:00:00 | 2015-01-01 00:00:00 | 2014-10-19 00:00:00 | 2008-01-01 00:00:00 | 2007-07-01 00:00:00 | 2008-01-01 00:00:00 | 2008-05-18 00:00:00 | 2008-05-18 00:00:00 | 2008-03-18 00:00:00 | 2008-10-01 00:00:00 | 2008-03-18 00:00:00 | 2008-07-01 00:00:00 | 2008-10-01 00:00:00 | 2008-07-01 00:00:00 | 2008-10-19 00:00:00 | 2009-01-06 00:00:00 | 2008-10-19 00:00:00 | None | 2009-04-03 00:00:00 | None | None | None | 2014-10-19 00:00:00 | 2015-01-01 00:00:00 | 2020-09-20 00:00:00 | 2020-02-16 00:00:00 | 2020-01-01 00:00:00 | 2019-01-27 00:00:00 | None | 2020-03-03 00:00:00 | 2018-10-16 00:00:00 | 2019-01-01 00:00:00 | 2018-10-25 00:00:00 | 2020-09-20 00:00:00 | 2020-09-25 00:00:00 | 2018-10-11 00:00:00 | 2015-07-01 00:00:00 | 2015-07-01 00:00:00 | 2016-01-01 00:00:00 | 2016-10-09 00:00:00 | 2016-07-01 00:00:00 | 2016-01-01 00:00:00 | 2016-10-31 00:00:00 | 2016-10-14 00:00:00 | None | 2016-09-20 00:00:00 | 2016-11-02 00:00:00 | 2016-07-01 00:00:00 | 2016-09-25 00:00:00 | 2016-10-14 00:00:00 | 2016-10-23 00:00:00 | 2016-10-21 00:00:00 | 2016-09-25 00:00:00 | 2016-10-23 00:00:00 | 2018-10-02 00:00:00 | 2020-07-01 00:00:00 | 2020-01-21 00:00:00 | 2019-02-15 00:00:00 | 2020-09-12 00:00:00 | 2018-05-20 00:00:00 | 2020-01-01 00:00:00 | 2018-07-01 00:00:00 | 2018-10-22 00:00:00 | 2018-10-21 00:00:00 | 2020-12-09 00:00:00 | 2018-09-23 00:00:00 | 2019-01-27 00:00:00 | 2018-09-23 00:00:00 | 2019-01-01 00:00:00 | 2018-10-21 00:00:00 | 2021-01-01 00:00:00 | None | 2019-07-01 00:00:00 | 2018-07-01 00:00:00 | 2020-02-04 00:00:00 | 2020-10-18 00:00:00 | 2019-02-24 00:00:00 | 2019-04-01 00:00:00 | 2020-07-01 00:00:00 | 2018-07-01 00:00:00 | 2018-07-01 00:00:00 | 2018-08-10 00:00:00 | 2020-10-18 00:00:00 | 2019-07-01 00:00:00 | 2018-05-20 00:00:00 | 2020-09-11 00:00:00 | None | 2019-04-01 00:00:00 | 2019-01-18 00:00:00 | 2020-02-06 00:00:00 | 2019-02-24 00:00:00 | 2020-10-08 00:00:00 | None | 2021-01-01 00:00:00 | 2020-02-16 00:00:00 | 2020-10-05 00:00:00 | 2022-01-01 00:00:00 | None | 2022-05-06 00:00:00 | 2022-05-22 00:00:00 | 2022-01-01 00:00:00 | 2021-07-01 00:00:00 | 2021-07-01 00:00:00 | 2022-10-19 00:00:00 | 2022-10-27 00:00:00 | 2022-10-17 00:00:00 | 2022-07-01 00:00:00 | 2022-07-01 00:00:00 | 2022-09-25 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_end | None | 1987-12-31 00:00:00 | 1988-05-21 00:00:00 | 1988-06-30 00:00:00 | 1988-09-30 00:00:00 | 1988-12-31 00:00:00 | None | None | None | None | None | None | 1999-09-30 00:00:00 | None | None | 1999-06-30 00:00:00 | 1999-12-31 00:00:00 | None | 1999-12-31 00:00:00 | 1998-10-29 00:00:00 | 2001-09-13 00:00:00 | 2001-12-31 00:00:00 | 2001-09-30 00:00:00 | 2001-09-30 00:00:00 | 2002-06-30 00:00:00 | None | 2002-10-19 00:00:00 | 2002-12-31 00:00:00 | None | 2003-06-30 00:00:00 | 2003-12-31 00:00:00 | 2004-02-14 00:00:00 | 2004-06-30 00:00:00 | 2004-10-16 00:00:00 | 2004-12-31 00:00:00 | None | 2004-10-16 00:00:00 | 2004-12-31 00:00:00 | 2005-06-30 00:00:00 | 2005-06-30 00:00:00 | 2003-12-31 00:00:00 | 2004-12-31 00:00:00 | 2004-06-30 00:00:00 | 2004-10-16 00:00:00 | 2004-10-16 00:00:00 | 2004-12-31 00:00:00 | 2005-12-31 00:00:00 | None | 2005-12-31 00:00:00 | None | 2006-03-10 00:00:00 | 2006-06-30 00:00:00 | 2006-09-30 00:00:00 | 2006-06-30 00:00:00 | 2006-09-30 00:00:00 | 2006-10-21 00:00:00 | 2006-10-25 00:00:00 | 2006-10-21 00:00:00 | 2006-12-31 00:00:00 | 2006-12-31 00:00:00 | 2007-06-30 00:00:00 | None | 2007-12-31 00:00:00 | 2007-06-30 00:00:00 | 2015-06-30 00:00:00 | 2014-12-31 00:00:00 | 2008-03-17 00:00:00 | 2007-12-31 00:00:00 | 2008-03-17 00:00:00 | 2008-06-30 00:00:00 | 2008-06-30 00:00:00 | 2008-05-17 00:00:00 | 2008-10-18 00:00:00 | 2008-05-17 00:00:00 | 2008-09-30 00:00:00 | 2008-10-18 00:00:00 | 2008-09-30 00:00:00 | 2008-12-31 00:00:00 | 2009-01-06 00:00:00 | 2008-12-31 00:00:00 | None | 2009-04-03 00:00:00 | None | None | None | 2014-12-31 00:00:00 | 2015-06-30 00:00:00 | 2020-10-17 00:00:00 | 2020-06-30 00:00:00 | 2020-02-15 00:00:00 | 2019-02-23 00:00:00 | None | 2020-03-03 00:00:00 | 2018-10-16 00:00:00 | 2019-01-26 00:00:00 | 2018-10-25 00:00:00 | 2020-10-17 00:00:00 | 2020-09-25 00:00:00 | 2018-10-11 00:00:00 | 2015-12-31 00:00:00 | 2015-12-31 00:00:00 | 2016-06-30 00:00:00 | 2016-10-09 00:00:00 | 2016-09-24 00:00:00 | 2016-06-30 00:00:00 | 2016-10-31 00:00:00 | 2016-10-14 00:00:00 | None | 2016-09-20 00:00:00 | 2016-11-02 00:00:00 | 2016-09-24 00:00:00 | 2016-10-22 00:00:00 | 2016-10-14 00:00:00 | 2016-12-31 00:00:00 | 2016-10-21 00:00:00 | 2016-10-22 00:00:00 | 2016-12-31 00:00:00 | 2018-10-02 00:00:00 | 2020-09-19 00:00:00 | 2020-01-21 00:00:00 | 2019-02-15 00:00:00 | 2020-09-12 00:00:00 | 2018-06-30 00:00:00 | 2020-02-15 00:00:00 | 2018-09-22 00:00:00 | 2018-10-22 00:00:00 | 2018-12-31 00:00:00 | 2020-12-09 00:00:00 | 2018-10-20 00:00:00 | 2019-02-23 00:00:00 | 2018-10-20 00:00:00 | 2019-01-26 00:00:00 | 2018-12-31 00:00:00 | 2021-06-30 00:00:00 | None | 2019-12-31 00:00:00 | 2018-09-22 00:00:00 | 2020-02-04 00:00:00 | 2020-12-31 00:00:00 | 2019-03-31 00:00:00 | 2019-06-30 00:00:00 | 2020-09-19 00:00:00 | 2018-09-22 00:00:00 | 2018-09-22 00:00:00 | 2018-08-10 00:00:00 | 2020-12-31 00:00:00 | 2019-12-31 00:00:00 | 2018-06-30 00:00:00 | 2020-09-11 00:00:00 | None | 2019-06-30 00:00:00 | 2019-01-18 00:00:00 | 2020-02-06 00:00:00 | 2019-03-31 00:00:00 | 2020-10-08 00:00:00 | None | 2021-06-30 00:00:00 | 2020-06-30 00:00:00 | 2020-10-05 00:00:00 | 2022-05-21 00:00:00 | None | 2022-05-06 00:00:00 | 2022-06-30 00:00:00 | 2022-05-21 00:00:00 | 2021-12-31 00:00:00 | 2021-12-31 00:00:00 | 2022-10-19 00:00:00 | 2022-10-27 00:00:00 | 2022-10-17 00:00:00 | 2022-09-24 00:00:00 | 2022-09-24 00:00:00 | 2022-10-22 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 | 2005-05-23 00:00:00 | None | 2005-05-23 00:00:00 | None | 2005-07-13 00:00:00 | None | None | None | None | None | 2005-05-13 00:00:00 | 2005-05-13 00:00:00 | 2006-01-27 00:00:00 | None | None | None | None | 2006-07-26 00:00:00 | 2006-09-29 00:00:00 | None | None | None | 2006-10-25 00:00:00 | 2006-10-26 00:00:00 | 2007-01-26 00:00:00 | None | 2007-07-28 00:00:00 | None | None | None | 2015-07-22 00:00:00 | None | 2008-03-21 00:00:00 | 2008-01-14 00:00:00 | None | 2008-07-09 00:00:00 | None | 2008-05-21 00:00:00 | 2008-10-21 00:00:00 | None | None | None | 2008-10-04 00:00:00 | 2009-01-06 00:00:00 | None | None | None | None | None | None | None | 2015-01-14 00:00:00 | None | None | None | 2020-02-18 00:00:00 | None | None | 2020-03-03 00:00:00 | 2018-10-16 00:00:00 | None | 2018-10-25 00:00:00 | 2020-10-19 00:00:00 | 2020-09-25 00:00:00 | 2018-10-11 00:00:00 | 2016-01-11 00:00:00 | None | 2016-07-08 00:00:00 | 2016-10-09 00:00:00 | 2016-09-27 00:00:00 | None | 2016-10-31 00:00:00 | 2016-10-14 00:00:00 | None | 2016-09-20 00:00:00 | 2016-11-02 00:00:00 | None | 2016-10-25 00:00:00 | 2016-10-14 00:00:00 | 2017-01-19 00:00:00 | 2016-10-21 00:00:00 | None | None | 2018-10-02 00:00:00 | 2020-09-20 00:00:00 | 2020-01-21 00:00:00 | 2019-02-15 00:00:00 | 2020-09-12 00:00:00 | None | None | None | 2018-10-22 00:00:00 | 2019-01-02 00:00:00 | 2020-12-09 00:00:00 | 2018-10-23 00:00:00 | 2019-02-25 00:00:00 | None | 2019-01-29 00:00:00 | None | 2021-08-02 00:00:00 | None | 2020-01-09 00:00:00 | 2018-10-23 00:00:00 | 2020-02-04 00:00:00 | None | 2019-04-01 00:00:00 | None | None | 2018-09-25 00:00:00 | None | 2018-08-10 00:00:00 | 2021-01-04 00:00:00 | None | 2018-07-12 00:00:00 | 2020-09-11 00:00:00 | None | 2019-07-21 00:00:00 | 2019-01-18 00:00:00 | 2020-02-06 00:00:00 | None | 2020-10-08 00:00:00 | None | None | 2020-07-21 00:00:00 | 2020-10-05 00:00:00 | 2022-05-26 00:00:00 | None | 2022-05-06 00:00:00 | 2022-08-01 00:00:00 | None | None | 2022-01-31 00:00:00 | 2022-10-19 00:00:00 | 2022-10-27 00:00:00 | 2022-10-17 00:00:00 | None | 2022-09-29 00:00:00 | 2022-10-27 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | 22001 | None | 22001 | None | 22001 | None | None | None | None | None | 22001 | 22001 | 22001 | None | None | None | 22001 | 22001 | 22001 | None | None | None | 22001 | 22001 | 22001 | None | 22001 | None | None | None | 22001 | None | 22001 | 22001 | None | 22001 | None | 22001 | 22001 | None | None | None | 22001 | 22001 | 22006 | None | None | 22001 | None | None | None | 22001 | None | None | None | 22001 | None | None | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | None | 22001 | 22001 | None | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | None | None | 22001 | 22001 | 22001 | 22001 | 22001 | None | None | None | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | None | 22001 | None | 22001 | 22001 | 22001 | None | 22001 | None | None | 22001 | None | 22001 | 22001 | None | 22001 | 22001 | None | 22001 | 22001 | 22001 | None | 22001 | None | None | 22001 | 22001 | 22001 | None | 22001 | 22001 | None | None | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 |
filer_id | 1043948 | 1043948 | 1043948 | 1043948 | ||||
---|---|---|---|---|---|---|---|---|
filer_type | 16 | 16 | 16 | 16 | ||||
active | Y | Y | Y | Y | ||||
race | 0 | 0 | 0 | 0 | ||||
session_id | 1987 | 2017 | 2015 | 2015 | ||||
category | 0 | 0 | 0 | 0 | ||||
category_type | 40503 | 40502 | 40502 | 40503 | ||||
sub_category | 40103 | 40103 | 40103 | 40103 | ||||
effect_dt | 1990-12-01 00:00:00 | 2018-08-01 00:00:00 | 2015-01-15 00:00:00 | 2016-10-13 00:00:00 | ||||
sub_category_type | 0 | 0 | 0 | 0 | ||||
election_type | 0 | 0 | 0 | 0 | ||||
sub_category_a | None | S | S | S | ||||
nyq_dt | 1987-08-14 00:00:00 | 1987-08-14 00:00:00 | 1987-08-14 00:00:00 | 1987-08-14 00:00:00 | ||||
party_cd | None | None | None | None | ||||
county_cd | 18036 | 18036 | 18036 | 18036 | ||||
district_cd | None | None | None | None |
filer_id | 1043948 | |
---|---|---|
xref_id | 870777 | |
effect_dt | 1999-12-07 00:00:00 | |
migration_source | IDENTFIX |
xref_filer_id | 870777 | 870777 | 870777 | 870777 | 870777 | 870777 | 870777 | 870777 | 870777 | 870777 | 870777 | 870777 | 870777 | 870777 | 870777 | 870777 | 870777 | 870777 | 870777 | 870777 | 870777 | 870777 | ||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_id | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | ||||||||||||||||||||||
filer_type | RECIPIENT COMMITTEE | RECIPIENT COMMITTEE | RECIPIENT COMMITTEE | RECIPIENT COMMITTEE | RECIPIENT COMMITTEE | RECIPIENT COMMITTEE | RECIPIENT COMMITTEE | RECIPIENT COMMITTEE | RECIPIENT COMMITTEE | RECIPIENT COMMITTEE | RECIPIENT COMMITTEE | RECIPIENT COMMITTEE | RECIPIENT COMMITTEE | RECIPIENT COMMITTEE | RECIPIENT COMMITTEE | RECIPIENT COMMITTEE | RECIPIENT COMMITTEE | RECIPIENT COMMITTEE | RECIPIENT COMMITTEE | RECIPIENT COMMITTEE | RECIPIENT COMMITTEE | RECIPIENT COMMITTEE | ||||||||||||||||||||||
status | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ||||||||||||||||||||||
effect_dt | 2018-08-01 00:00:00 | 2018-08-01 00:00:00 | 2018-08-01 00:00:00 | 2018-08-01 00:00:00 | 2018-08-01 00:00:00 | 2018-08-01 00:00:00 | 2018-08-01 00:00:00 | 2018-08-01 00:00:00 | 2018-08-01 00:00:00 | 2018-08-01 00:00:00 | 2018-08-01 00:00:00 | 2018-08-01 00:00:00 | 2018-08-01 00:00:00 | 2018-08-01 00:00:00 | 2018-08-01 00:00:00 | 2018-08-01 00:00:00 | 2018-08-01 00:00:00 | 2018-08-01 00:00:00 | 2018-08-01 00:00:00 | 2018-08-01 00:00:00 | 2018-08-01 00:00:00 | 2018-08-01 00:00:00 | ||||||||||||||||||||||
naml | MOTOR CAR DEALERS ASSOCIATION OF ORANGE COUNTY POLITICAL ACTION COMMITTEE | MOTOR CAR DEALERS ASSOCIATION OF ORANGE COUNTY POLITICAL ACTION COMMITTEE | MOTOR CAR DEALERS ASSOCIATION OF ORANGE COUNTY POLITICAL ACTION COMMITTEE | MOTOR CAR DEALERS ASSOCIATION OF ORANGE COUNTY POLITICAL ACTION COMMITTEE | MOTOR CAR DEALERS ASSOCIATION OF ORANGE COUNTY POLITICAL ACTION COMMITTEE | MOTOR CAR DEALERS ASSOCIATION OF ORANGE COUNTY POLITICAL ACTION COMMITTEE | MOTOR CAR DEALERS ASSOCIATION OF ORANGE COUNTY POLITICAL ACTION COMMITTEE | MOTOR CAR DEALERS ASSOCIATION OF ORANGE COUNTY POLITICAL ACTION COMMITTEE | MOTOR CAR DEALERS ASSOCIATION OF ORANGE COUNTY POLITICAL ACTION COMMITTEE | MOTOR CAR DEALERS ASSOCIATION OF ORANGE COUNTY POLITICAL ACTION COMMITTEE | MOTOR CAR DEALERS ASSOCIATION OF ORANGE COUNTY POLITICAL ACTION COMMITTEE | ORANGE COUNTY AUTOMOBILE DEALERS ASSOCIATION PAC | ORANGE COUNTY AUTOMOBILE DEALERS ASSOCIATION PAC | ORANGE COUNTY AUTOMOBILE DEALERS ASSOCIATION PAC | ORANGE COUNTY AUTOMOBILE DEALERS ASSOCIATION PAC | ORANGE COUNTY AUTOMOBILE DEALERS ASSOCIATION PAC | ORANGE COUNTY AUTOMOBILE DEALERS ASSOCIATION PAC | ORANGE COUNTY AUTOMOBILE DEALERS ASSOCIATION PAC | ORANGE COUNTY AUTOMOBILE DEALERS ASSOCIATION PAC | ORANGE COUNTY AUTOMOBILE DEALERS ASSOCIATION PAC | ORANGE COUNTY AUTOMOBILE DEALERS ASSOCIATION PAC | ORANGE COUNTY AUTOMOBILE DEALERS ASSOCIATION PAC | ||||||||||||||||||||||
namf | 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 | ||||||||||||||||||||||
nams | 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 | ||||||||||||||||||||||
adr2 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||
city | COSTA MESA | Costa Mesa | Costa Mesa | NEWPORT BEACH | NEWPORT BEACH | SAN DIEGO | NEWPORT BEACH | NEWPORT BEACH | LOS ANGELES | NEWPORT BEACH | LOS ANGELES | COSTA MESA | Costa Mesa | Costa Mesa | NEWPORT BEACH | NEWPORT BEACH | SAN DIEGO | NEWPORT BEACH | NEWPORT BEACH | LOS ANGELES | NEWPORT BEACH | LOS ANGELES | ||||||||||||||||||||||
st | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | ||||||||||||||||||||||
zip4 | 926260000 | 92626 | 92626 | 926600000 | 92660 | 92119 | 92660 | 92660 | 90071 | 92660 | 90071 | 926260000 | 92626 | 92626 | 926600000 | 92660 | 92119 | 92660 | 92660 | 90071 | 92660 | 90071 | ||||||||||||||||||||||
phon | 7144246090 | (714) 424-6090 | 7144246090 | 7144246090 | 7144246090 | 7144246090 | 7144246090 | 7144246090 | 7144246090 | 7144246090 | 7144246090 | 7144246090 | (714) 424-6090 | 7144246090 | 7144246090 | 7144246090 | 7144246090 | 7144246090 | 7144246090 | 7144246090 | 7144246090 | 7144246090 | ||||||||||||||||||||||
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 | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] |
filer_id | 1043948 |
---|
filer_id | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | 1043948 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_file_name | 523401.cal | 523545.cal | 523716.cal | 523683.cal | 199742.cal | 1155167_0.cal | 1211518_0.cal | 1155167_2.cal | 1155167_1.cal | 1976949_0.cal | 2122397_0.cal | 2054206_0.cal | 2005799_0.cal | 2103853_0.cal | 2079366_0.cal | 2101783_0.cal | 2082920_0.cal | 2086843_0.cal | 2089109_0.cal | 2093177_0.cal | 2096428_0.cal | 2088947_0.cal | 1926519_0.cal | 2307112_0.cal | 2312325_0.cal | 2369880_0.cal | 2305300_0.cal | 2429277_0.cal | 2391882_0.cal | 2300138_0.cal | 2460799_0.cal | 2359918_0.cal | 2309866_0.cal | 2311854_0.cal | 2331677_0.cal | 2345192_0.cal | 2362841_0.cal | 2296173_1.cal | 2432505_0.cal | 2447119_0.cal | 2454290_0.cal | 2296173_0.cal | 2445271_0.cal | 2271185_0.cal | 2282165_0.cal | 2335892_0.cal | 2479623_0.cal | 2743873_0.cal | 2506078_0.cal | 2518526_0.cal | 2679840_0.cal | 2503228_0.cal | 2536432_0.cal | 2500978_0.cal | 2542283_0.cal | 2736155_0.cal | 2735182_0.cal | 2500832_0.cal | 2512099_0.cal | 2509747_0.cal | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
received_date | 2005-05-13 00:00:00 | 2005-05-13 00:00:00 | 2005-05-13 00:00:00 | 2005-05-13 00:00:00 | 2005-05-23 00:00:00 | 2006-03-13 00:00:00 | 2006-10-25 00:00:00 | 2009-04-07 00:00:00 | 2009-01-06 00:00:00 | 2015-07-24 00:00:00 | 2017-01-23 00:00:00 | 2016-07-08 00:00:00 | 2016-01-23 00:00:00 | 2016-11-02 00:00:00 | 2016-09-20 00:00:00 | 2016-10-31 00:00:00 | 2016-09-29 00:00:00 | 2016-10-09 00:00:00 | 2016-10-14 00:00:00 | 2016-10-21 00:00:00 | 2016-10-26 00:00:00 | 2016-10-14 00:00:00 | 2015-01-16 00:00:00 | 2018-10-16 00:00:00 | 2018-10-25 00:00:00 | 2019-04-02 00:00:00 | 2018-10-11 00:00:00 | 2020-01-09 00:00:00 | 2019-07-22 00:00:00 | 2018-10-02 00:00:00 | 2020-03-03 00:00:00 | 2019-02-15 00:00:00 | 2018-10-22 00:00:00 | 2018-10-24 00:00:00 | 2019-01-02 00:00:00 | 2019-01-30 00:00:00 | 2019-02-25 00:00:00 | 2018-10-24 00:00:00 | 2020-01-21 00:00:00 | 2020-02-06 00:00:00 | 2020-02-19 00:00:00 | 2018-09-26 00:00:00 | 2020-02-04 00:00:00 | 2018-07-27 00:00:00 | 2018-08-10 00:00:00 | 2019-01-18 00:00:00 | 2020-07-21 00:00:00 | 2022-10-27 00:00:00 | 2020-09-25 00:00:00 | 2020-10-20 00:00:00 | 2022-05-06 00:00:00 | 2020-09-21 00:00:00 | 2020-12-09 00:00:00 | 2020-09-12 00:00:00 | 2021-01-05 00:00:00 | 2022-10-19 00:00:00 | 2022-10-17 00:00:00 | 2020-09-11 00:00:00 | 2020-10-08 00:00:00 | 2020-10-05 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_directory | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_id | None | None | None | None | None | 1155167 | 1211518 | 1155167 | 1155167 | 1976949 | 2122397 | 2054206 | 2005799 | 2103853 | 2079366 | 2101783 | 2082920 | 2086843 | 2089109 | 2093177 | 2096428 | 2088947 | 1926519 | 2307112 | 2312325 | 2369880 | 2305300 | 2429277 | 2391882 | 2300138 | 2460799 | 2359918 | 2309866 | 2311854 | 2331677 | 2345192 | 2362841 | 2296173 | 2432505 | 2447119 | 2454290 | 2296173 | 2445271 | 2271185 | 2282165 | 2335892 | 2479623 | 2743873 | 2506078 | 2518526 | 2679840 | 2503228 | 2536432 | 2500978 | 2542283 | 2736155 | 2735182 | 2500832 | 2512099 | 2509747 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | None | None | None | None | None | F410 | F497 | F410 | F410 | F460 | F460 | F460 | F460 | F497 | F497 | F497 | F460 | F497 | F497 | F497 | F460 | F497 | F460 | F497 | F497 | F460 | F497 | F460 | F460 | F497 | F497 | F497 | F497 | F460 | F460 | F460 | F460 | F460 | F497 | F497 | F460 | F460 | F497 | F460 | F497 | F497 | F460 | F497 | F497 | F460 | F497 | F460 | F497 | F497 | F460 | F497 | F497 | F497 | F497 | F497 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
receive_comment | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted |