filer_id | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
adrid | 1011885 | 2097063 | 2105628 | 2117597 | 2202334 | 2224810 | 2235226 | 2455221 | 2281778 | 2374848 | 2322327 | 2379370 | 2349346 | |||||||||||||
effect_dt | 1998-06-25 00:00:00 | 2006-01-20 00:00:00 | 2006-07-27 00:00:00 | 2008-01-25 00:00:00 | 2010-10-21 00:00:00 | 2012-01-26 00:00:00 | 2012-07-11 00:00:00 | 2018-07-13 00:00:00 | 2013-01-18 00:00:00 | 2015-10-21 00:00:00 | 2014-07-16 00:00:00 | 2016-01-11 00:00:00 | 2015-01-20 00:00:00 | |||||||||||||
add_type | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | |||||||||||||
session_id | 1997 | 2005 | 2005 | 2007 | 2009 | 2011 | 2011 | 2017 | 2013 | 2015 | 2013 | 2015 | 2015 |
filer_id | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 73037 | 73038 | 73039 | 73040 | 73041 | 73042 | 73043 | 73044 | 73045 | 204673 | 585102 | 715877 | 747517 | 811561 | 831811 | 828939 | 835921 | 852140 | 850243 | 850243 | 907196 | 852140 | 916000 | 981039 | 955893 | 979889 | 986431 | 1056580 | 1035480 | 1095521 | 1112141 | 1135013 | 1135014 | 1135017 | 1135019 | 1135022 | 1135025 | 1135016 | 1135023 | 1142782 | 1188306 | 1178510 | 1179902 | 1177972 | 1219523 | 1252054 | 1236944 | 1219203 | 1273430 | 1308147 | 1272762 | 1272790 | 1856348 | 1866354 | 1931751 | 1338934 | 1339022 | 1353730 | 1369465 | 1392956 | 1401741 | 1377133 | 1433287 | 1469024 | 1511611 | 1530809 | 1530811 | 1536033 | 1533805 | 1533815 | 1533817 | 1533824 | 1530810 | 1530812 | 1544051 | 1536104 | 1544596 | 1569528 | 1606836 | 1577728 | 1632499 | 1612054 | 1612056 | 1606834 | 1638667 | 1667219 | 1672149 | 1830511 | 1674752 | 1927215 | 1910483 | 1703062 | 1887357 | 1863552 | 1884362 | 1885557 | 1731141 | 1729139 | 1843532 | 1851820 | 1851500 | 1839441 | 2004525 | 1997740 | 2249062 | 2223987 | 2186578 | 2186578 | 2184988 | 2408778 | 2306045 | 2306683 | 2412063 | 2499750 | 2547064 | 2228131 | 2428382 | 2264699 | 2285387 | 2304661 | 2483817 | 2293636 | 2296280 | 2187701 | 2413457 | 2246273 | 2463871 | 1993119 | 2003189 | 2082897 | 2089143 | 2099373 | 2103720 | 2118959 | 2122092 | 2118959 | 2154258 | 2152970 | 2172517 | 2408431 | 2225872 | 2301938 | 2483817 | 2333979 | 2258458 | 2264699 | 2415538 | 2510186 | 2187701 | 2565055 | 2316792 | 2203821 | 2535285 | 2266770 | 2226968 | 2427056 | 2266770 | 2309224 | 2223336 | 2444789 | 2524049 | 2311001 | 2294495 | 2438539 | 2641137 | 2491004 | 2666388 | 2635325 | 2704540 | 2689480 | 2691582 | 2661177 | 2716770 | 2720484 | 2662221 | 2662221 | 2719300 | 2730985 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
period_id | 121 | 121 | 129 | 133 | 137 | 141 | 145 | 153 | 155 | 147 | None | 161 | None | 165 | None | None | None | None | 169 | 169 | 171 | None | None | None | None | 175 | None | None | None | None | None | 184 | 184 | 184 | 184 | 184 | 184 | 184 | 184 | 183 | 185 | 186 | None | 186 | 188 | None | 187 | None | None | None | None | None | 218 | None | None | None | None | None | None | 195 | None | None | None | None | None | 204 | 204 | 204 | None | None | None | None | 204 | 204 | None | 204 | None | 203 | 205 | None | 207 | None | None | 205 | None | 210 | 209 | None | None | 219 | 220 | 212 | 219 | 217 | 219 | 219 | None | 211 | 218 | 218 | 218 | 218 | None | None | 234 | 233 | 231 | 229 | None | 239 | 236 | 236 | 240 | 243 | 241 | 234 | 241 | 233 | 235 | 236 | 241 | 235 | 235 | None | 237 | 234 | None | 221 | 221 | 227 | 228 | 228 | 228 | 225 | None | 227 | None | 229 | 229 | 239 | 233 | 236 | 241 | 233 | 234 | 233 | None | 244 | None | None | 236 | 229 | None | None | None | 240 | None | 236 | 233 | 241 | 244 | 236 | 235 | 237 | None | 243 | 250 | 245 | 249 | 250 | 250 | 249 | None | 251 | 250 | 250 | 251 | 252 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F461 | F405 | F461 | F461 | F461 | F461 | F461 | F461 | F461 | F461 | F461 | F461 | F461 | F461 | F497 | F461 | F497 | F461 | F461 | F461 | F461 | F461 | F461 | F461 | F461 | F461 | F497 | F497 | F461 | F461 | F461 | F496 | F496 | F496 | F496 | F496 | F496 | F496 | F496 | F461 | F461 | F497 | F461 | F497 | F497 | F461 | F461 | F461 | F497 | F461 | F497 | F497 | F497 | F461 | F461 | F497 | F497 | F461 | F497 | F461 | F461 | F497 | F461 | F461 | F461 | F465 | F465 | F497 | F465 | F465 | F465 | F465 | F465 | F465 | F497 | F497 | F497 | F461 | F465 | F461 | F461 | F465 | F461 | F461 | F461 | F497 | F461 | F461 | F461 | F461 | F497 | F497 | F497 | F461 | F497 | F497 | F461 | F461 | F497 | F497 | F497 | F497 | F461 | F461 | F497 | F497 | F461 | F461 | F461 | F497 | F497 | F497 | F497 | F497 | F461 | F497 | F497 | F461 | F497 | F497 | F461 | F497 | F497 | F461 | F461 | F497 | F461 | F461 | F461 | F497 | F497 | F497 | F497 | F461 | F461 | F461 | F461 | F461 | F461 | F497 | F497 | F497 | F461 | F461 | F497 | F461 | F461 | F497 | F461 | F461 | F497 | F461 | F461 | F461 | F461 | F497 | F461 | F497 | F497 | F497 | F497 | F497 | F497 | F461 | F461 | F497 | F497 | F461 | F461 | F497 | F497 | F497 | F461 | F497 | F497 | F497 | F497 | F497 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_sequence | 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 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 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 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_date | 1992-01-01 00:00:00 | 1992-07-20 00:00:00 | 1993-02-01 00:00:00 | 1994-01-31 00:00:00 | 1995-01-31 00:00:00 | 1996-01-31 00:00:00 | 1996-07-31 00:00:00 | 1998-07-29 00:00:00 | 1999-02-01 00:00:00 | 1997-01-31 00:00:00 | 2000-01-27 00:00:00 | 2001-01-29 00:00:00 | 2001-01-30 00:00:00 | 2002-01-28 00:00:00 | 2002-02-27 00:00:00 | 2002-01-23 00:00:00 | 2002-03-01 00:00:00 | 2002-07-22 00:00:00 | 2002-07-24 00:00:00 | 2002-07-18 00:00:00 | 2003-01-28 00:00:00 | 2002-07-26 00:00:00 | 2003-01-30 00:00:00 | 2004-01-13 00:00:00 | 2003-07-16 00:00:00 | 2004-01-12 00:00:00 | 2003-11-03 00:00:00 | 2004-10-26 00:00:00 | 2004-07-28 00:00:00 | 2005-01-27 00:00:00 | 2005-07-14 00:00:00 | 2005-11-02 00:00:00 | 2005-11-02 00:00:00 | 2005-11-02 00:00:00 | 2005-11-02 00:00:00 | 2005-11-02 00:00:00 | 2005-11-02 00:00:00 | 2005-11-02 00:00:00 | 2005-11-02 00:00:00 | 2006-01-20 00:00:00 | 2006-07-27 00:00:00 | 2006-06-02 00:00:00 | 2006-01-30 00:00:00 | 2006-06-01 00:00:00 | 2006-11-03 00:00:00 | 2007-02-01 00:00:00 | 2007-01-31 00:00:00 | 2006-07-27 00:00:00 | 2006-11-03 00:00:00 | 2008-01-25 00:00:00 | 2006-06-01 00:00:00 | 2006-06-02 00:00:00 | 2014-05-29 00:00:00 | 2014-07-18 00:00:00 | 2015-01-23 00:00:00 | 2008-05-23 00:00:00 | 2008-05-29 00:00:00 | 2008-07-31 00:00:00 | 2008-10-22 00:00:00 | 2009-01-27 00:00:00 | 2009-01-29 00:00:00 | 2008-10-30 00:00:00 | 2009-07-23 00:00:00 | 2010-02-01 00:00:00 | 2010-08-02 00:00:00 | 2010-10-21 00:00:00 | 2010-10-21 00:00:00 | 2010-10-26 00:00:00 | 2010-10-21 00:00:00 | 2010-10-21 00:00:00 | 2010-10-21 00:00:00 | 2010-10-21 00:00:00 | 2010-10-21 00:00:00 | 2010-10-21 00:00:00 | 2010-10-27 00:00:00 | 2010-10-26 00:00:00 | 2010-10-26 00:00:00 | 2011-01-29 00:00:00 | 2011-07-29 00:00:00 | 2011-01-28 00:00:00 | 2012-01-26 00:00:00 | 2011-08-01 00:00:00 | 2011-08-01 00:00:00 | 2011-07-29 00:00:00 | 2012-01-30 00:00:00 | 2012-06-01 00:00:00 | 2012-07-17 00:00:00 | 2014-01-22 00:00:00 | 2012-07-23 00:00:00 | 2015-01-20 00:00:00 | 2014-10-30 00:00:00 | 2012-10-25 00:00:00 | 2014-09-22 00:00:00 | 2014-07-16 00:00:00 | 2014-09-10 00:00:00 | 2014-09-16 00:00:00 | 2013-01-23 00:00:00 | 2013-01-18 00:00:00 | 2014-04-29 00:00:00 | 2014-05-20 00:00:00 | 2014-05-19 00:00:00 | 2014-04-18 00:00:00 | 2016-01-13 00:00:00 | 2015-10-27 00:00:00 | 2018-05-14 00:00:00 | 2018-03-21 00:00:00 | 2017-10-19 00:00:00 | 2017-10-05 00:00:00 | 2017-07-31 00:00:00 | 2019-09-04 00:00:00 | 2018-10-12 00:00:00 | 2018-10-15 00:00:00 | 2019-10-08 00:00:00 | 2020-09-09 00:00:00 | 2021-01-25 00:00:00 | 2018-04-04 00:00:00 | 2020-01-06 00:00:00 | 2018-07-13 00:00:00 | 2018-08-22 00:00:00 | 2018-10-10 00:00:00 | 2020-07-31 00:00:00 | 2018-09-19 00:00:00 | 2018-09-26 00:00:00 | 2017-10-23 00:00:00 | 2019-10-17 00:00:00 | 2018-05-04 00:00:00 | 2020-01-31 00:00:00 | 2015-10-21 00:00:00 | 2016-01-11 00:00:00 | 2016-09-29 00:00:00 | 2016-10-14 00:00:00 | 2016-10-28 00:00:00 | 2016-11-02 00:00:00 | 2017-01-11 00:00:00 | 2017-01-17 00:00:00 | 2017-01-11 00:00:00 | 2017-04-26 00:00:00 | 2017-04-24 00:00:00 | 2017-07-27 00:00:00 | 2019-08-29 00:00:00 | 2018-03-28 00:00:00 | 2018-10-04 00:00:00 | 2020-07-30 00:00:00 | 2019-01-11 00:00:00 | 2018-06-01 00:00:00 | 2018-07-16 00:00:00 | 2019-10-21 00:00:00 | 2020-10-05 00:00:00 | 2017-10-10 00:00:00 | 2021-01-29 00:00:00 | 2018-10-30 00:00:00 | 2018-01-22 00:00:00 | 2020-07-31 00:00:00 | 2018-07-18 00:00:00 | 2018-01-25 00:00:00 | 2019-12-27 00:00:00 | 2019-01-14 00:00:00 | 2018-10-19 00:00:00 | 2018-03-19 00:00:00 | 2020-02-03 00:00:00 | 2020-10-27 00:00:00 | 2018-10-23 00:00:00 | 2018-09-21 00:00:00 | 2020-01-29 00:00:00 | 2022-01-19 00:00:00 | 2020-08-13 00:00:00 | 2022-04-14 00:00:00 | 2022-01-19 00:00:00 | 2022-07-29 00:00:00 | 2022-06-01 00:00:00 | 2022-06-06 00:00:00 | 2022-03-29 00:00:00 | 2022-08-01 00:00:00 | 2022-09-15 00:00:00 | 2022-04-01 00:00:00 | 2022-04-04 00:00:00 | 2022-09-12 00:00:00 | 2022-10-11 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_type | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10005 | 10001 | 10005 | 10005 | 10005 | 10005 | 10002 | 10001 | 10001 | 10006 | 10005 | 10005 | 10005 | 10001 | 10001 | 10005 | 10005 | 10005 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10005 | 10001 | 10005 | 10005 | 10005 | 10005 | 10005 | 10001 | 10005 | 10005 | 10005 | 10005 | 10001 | 10005 | 10001 | 10005 | 10005 | 10005 | 10005 | 10005 | 10001 | 10001 | 10001 | 10005 | 10005 | 10005 | 10005 | 10001 | 10001 | 10005 | 10001 | 10005 | 10001 | 10001 | 10005 | 10001 | 10005 | 10005 | 10001 | 10005 | 10001 | 10001 | 10005 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10005 | 10001 | 10001 | 10002 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | 10001 | 10006 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10006 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10006 | 10001 | 10002 | 10005 | 10001 | 10005 | 10005 | 10001 | 10001 | 10005 | 10005 | 10005 | 10001 | 10006 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10002 | 10001 | 10001 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_status | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
session_id | 1989 | 1989 | 1991 | 1993 | 1993 | 1995 | 1995 | 1997 | 1997 | 1995 | 1999 | 1999 | 1999 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2007 | 2007 | 2005 | 2013 | 2013 | 2013 | 2007 | 2007 | 2007 | 2007 | 2007 | 2009 | 2007 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2011 | 2009 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2013 | 2011 | 2013 | 2013 | 2011 | 2013 | 2013 | 2013 | 2013 | 2011 | 2011 | 2013 | 2013 | 2013 | 2013 | 2015 | 2015 | 2017 | 2017 | 2017 | 2017 | 2017 | 2019 | 2017 | 2017 | 2019 | 2019 | 2019 | 2017 | 2019 | 2017 | 2017 | 2017 | 2019 | 2017 | 2017 | 2017 | 2019 | 2017 | 2019 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2017 | 2017 | 2017 | 2019 | 2017 | 2017 | 2019 | 2017 | 2017 | 2017 | 2019 | 2019 | 2017 | 2021 | 2017 | 2017 | 2019 | 2017 | 2017 | 2019 | 2017 | 2017 | 2017 | 2019 | 2019 | 2017 | 2017 | 2019 | 2021 | 2019 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
user_id | * | * | * | * | * | * | * | * | * | * | BSMITH | * | MKIENG | * | RALLMOND | YBONILLA | EMCENTEE | LTHIBAUL | * | * | COMPLETED | LTHIBAUL | LTHIBAUL | CFLAGG | GGILMORE | COMPLETED | PBANFORD | GPEREZ | DHORRELL | DHORRELL | DHORRELL | * | * | * | * | * | * | * | * | * | * | DHORRELL | RFARAIMO | DHORRELL | RGEREMIA | JMARTIN | * | JMARTIN | RGEREMIA | SMCCABE | CFLAGG | LHOANG | WBROWN | JINGRAM | JINGRAM | LHOANG | LHOANG | SMCCABE | YRODRIGU | JINGRAM | JINGRAM | EMCENTEE | JINGRAM | JINGRAM | JINGRAM | * | * | CREYNOLDS | MPACHECO | MPACHECO | MPACHECO | MPACHECO | * | * | MPACHECO | CFLAGG | MPACHECO | JINGRAM | CAFILER | JINGRAM | JINGRAM | JINGRAM | JINGRAM | JINGRAM | JINGRAM | PBANFORD | JINGRAM | JINGRAM | JINGRAM | JINGRAM | CAFILER | CAFILER | CAFILER | JINGRAM | CAFILER | CAFILER | JINGRAM | JINGRAM | WBROWN | WBROWN | WBROWN | WBROWN | JINGRAM | JINGRAM | CAFILER | CAFILER | RGEREMIA | LPALMER | LPALMER | CAFILER | CAFILER | CAFILER | CAFILER | CAFILER | GTAYLOR | CAFILER | CAFILER | GTAYLOR | CAFILER | CAFILER | GTAYLOR | CAFILER | CAFILER | LPALMER | GTAYLOR | CAFILER | GTAYLOR | JINGRAM | JINGRAM | PDEO | PDEO | PDEO | PDEO | JINGRAM | JINGRAM | LPALMER | JINGRAM | JINGRAM | LPALMER | CAFILER | CAFILER | CAFILER | GTAYLOR | GTAYLOR | CAFILER | GTAYLOR | GTAYLOR | CAFILER | LPALMER | GTAYLOR | CAFILER | DMCCASTL | GTAYLOR | GTAYLOR | DMCCASTL | CAFILER | GTAYLOR | CAFILER | RGEREMIA | CAFILER | CAFILER | CAFILER | CAFILER | GTAYLOR | GTAYLOR | CAFILER | CAFILER | GTAYLOR | GTAYLOR | CAFILER | CAFILER | CAFILER | GTAYLOR | CAFILER | CAFILER | CAFILER | CAFILER | CAFILER | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
special_audit | 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 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fine_audit | 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 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_start | 1990-01-01 00:00:00 | 1990-01-01 00:00:00 | 1992-01-01 00:00:00 | 1993-01-01 00:00:00 | 1994-01-01 00:00:00 | 1995-01-01 00:00:00 | 1996-01-01 00:00:00 | 1998-01-01 00:00:00 | 1998-07-01 00:00:00 | 1996-07-01 00:00:00 | 1999-01-01 00:00:00 | 2000-01-01 00:00:00 | 2000-01-01 00:00:00 | 2001-01-01 00:00:00 | None | 2001-01-01 00:00:00 | None | 2002-01-01 00:00:00 | 2002-01-01 00:00:00 | 2002-01-01 00:00:00 | 2002-07-01 00:00:00 | 2002-01-01 00:00:00 | 2002-07-01 00:00:00 | 2003-07-01 00:00:00 | 2003-01-01 00:00:00 | 2003-07-01 00:00:00 | None | None | 2004-01-01 00:00:00 | 2004-07-01 00:00:00 | 2005-01-01 00:00:00 | 2005-11-02 00:00:00 | 2005-11-02 00:00:00 | 2005-11-02 00:00:00 | 2005-11-02 00:00:00 | 2005-11-02 00:00:00 | 2005-11-02 00:00:00 | 2005-11-02 00:00:00 | 2005-11-02 00:00:00 | 2005-07-01 00:00:00 | 2006-01-01 00:00:00 | 2006-06-02 00:00:00 | 2005-07-01 00:00:00 | 2006-06-01 00:00:00 | 2006-11-03 00:00:00 | 2006-07-01 00:00:00 | 2006-07-01 00:00:00 | 2006-01-01 00:00:00 | None | 2007-01-01 00:00:00 | None | None | 2014-05-29 00:00:00 | 2014-01-01 00:00:00 | 2014-07-01 00:00:00 | None | None | 2008-01-01 00:00:00 | None | 2008-07-01 00:00:00 | 2008-07-01 00:00:00 | None | 2009-01-01 00:00:00 | 2009-07-01 00:00:00 | 2010-01-01 00:00:00 | 2010-10-01 00:00:00 | 2010-10-01 00:00:00 | 2010-10-26 00:00:00 | 2010-10-01 00:00:00 | 2010-10-01 00:00:00 | 2010-10-01 00:00:00 | 2010-10-01 00:00:00 | 2010-10-01 00:00:00 | 2010-10-01 00:00:00 | None | 2010-10-26 00:00:00 | 2010-10-25 00:00:00 | 2010-07-01 00:00:00 | 2011-01-01 00:00:00 | 2010-07-01 00:00:00 | 2011-07-01 00:00:00 | 2011-01-01 00:00:00 | 2011-01-01 00:00:00 | 2011-01-01 00:00:00 | 2011-07-01 00:00:00 | 2012-06-01 00:00:00 | 2012-01-01 00:00:00 | 2013-01-01 00:00:00 | 2012-01-01 00:00:00 | 2014-07-01 00:00:00 | 2014-10-30 00:00:00 | 2012-10-25 00:00:00 | 2014-09-22 00:00:00 | 2014-01-01 00:00:00 | 2014-09-10 00:00:00 | 2014-09-16 00:00:00 | 2012-07-01 00:00:00 | 2012-07-01 00:00:00 | 2014-04-29 00:00:00 | 2014-05-20 00:00:00 | 2014-05-19 00:00:00 | 2014-04-18 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2018-05-14 00:00:00 | 2018-03-21 00:00:00 | 2017-07-01 00:00:00 | 2017-01-01 00:00:00 | 2017-01-01 00:00:00 | 2019-09-04 00:00:00 | 2018-10-12 00:00:00 | 2018-10-15 00:00:00 | 2019-10-08 00:00:00 | 2020-09-09 00:00:00 | 2020-01-01 00:00:00 | 2018-04-04 00:00:00 | 2020-01-06 00:00:00 | 2018-01-01 00:00:00 | 2018-08-22 00:00:00 | 2018-10-10 00:00:00 | 2020-01-01 00:00:00 | 2018-09-19 00:00:00 | 2018-09-26 00:00:00 | 2017-07-01 00:00:00 | 2019-01-01 00:00:00 | 2018-05-04 00:00:00 | 2019-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2016-09-29 00:00:00 | 2016-10-14 00:00:00 | 2016-10-28 00:00:00 | 2016-11-02 00:00:00 | 2016-01-01 00:00:00 | 2016-01-01 00:00:00 | 2016-07-01 00:00:00 | 2017-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017-01-01 00:00:00 | 2019-08-29 00:00:00 | 2018-03-28 00:00:00 | 2018-10-04 00:00:00 | 2020-01-01 00:00:00 | 2018-01-01 00:00:00 | 2018-06-01 00:00:00 | 2018-01-01 00:00:00 | 2019-01-01 00:00:00 | 2020-10-05 00:00:00 | 2017-01-01 00:00:00 | 2020-01-01 00:00:00 | 2018-10-30 00:00:00 | 2017-01-01 00:00:00 | 2020-01-01 00:00:00 | 2018-01-01 00:00:00 | 2017-01-01 00:00:00 | 2019-12-27 00:00:00 | 2018-01-01 00:00:00 | 2018-10-19 00:00:00 | 2018-03-19 00:00:00 | 2020-02-03 00:00:00 | 2020-10-27 00:00:00 | 2018-10-23 00:00:00 | 2018-09-21 00:00:00 | 2019-01-01 00:00:00 | 2021-01-01 00:00:00 | 2020-08-13 00:00:00 | 2022-04-14 00:00:00 | 2021-01-01 00:00:00 | 2022-01-01 00:00:00 | 2022-06-01 00:00:00 | 2022-06-06 00:00:00 | 2022-03-29 00:00:00 | 2022-01-01 00:00:00 | 2022-09-15 00:00:00 | 2022-04-01 00:00:00 | 2022-04-04 00:00:00 | 2022-09-12 00:00:00 | 2022-10-11 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_end | 1990-12-31 00:00:00 | 1990-12-31 00:00:00 | 1992-12-31 00:00:00 | 1993-12-31 00:00:00 | 1994-12-31 00:00:00 | 1995-12-31 00:00:00 | 1996-06-30 00:00:00 | 1998-06-30 00:00:00 | 1998-12-31 00:00:00 | 1996-12-31 00:00:00 | 1999-12-31 00:00:00 | 2000-12-31 00:00:00 | 2000-12-31 00:00:00 | 2001-12-31 00:00:00 | None | 2001-12-31 00:00:00 | None | 2002-06-30 00:00:00 | 2002-06-30 00:00:00 | 2002-06-30 00:00:00 | 2002-12-31 00:00:00 | 2002-06-30 00:00:00 | 2002-12-31 00:00:00 | 2003-12-31 00:00:00 | 2003-06-30 00:00:00 | 2003-12-31 00:00:00 | None | None | 2004-06-30 00:00:00 | 2004-12-31 00:00:00 | 2005-06-30 00:00:00 | 2005-11-02 00:00:00 | 2005-11-02 00:00:00 | 2005-11-02 00:00:00 | 2005-11-02 00:00:00 | 2005-11-02 00:00:00 | 2005-11-02 00:00:00 | 2005-11-02 00:00:00 | 2005-11-02 00:00:00 | 2005-12-31 00:00:00 | 2006-06-30 00:00:00 | 2006-06-02 00:00:00 | 2005-12-31 00:00:00 | 2006-06-01 00:00:00 | 2006-11-03 00:00:00 | 2006-12-31 00:00:00 | 2006-12-31 00:00:00 | 2006-06-30 00:00:00 | None | 2007-12-31 00:00:00 | None | None | 2014-05-29 00:00:00 | 2014-06-30 00:00:00 | 2014-12-31 00:00:00 | None | None | 2008-06-30 00:00:00 | None | 2008-12-31 00:00:00 | 2008-12-31 00:00:00 | None | 2009-06-30 00:00:00 | 2009-12-31 00:00:00 | 2010-06-30 00:00:00 | 2010-10-16 00:00:00 | 2010-10-16 00:00:00 | 2010-10-26 00:00:00 | 2010-10-16 00:00:00 | 2010-10-16 00:00:00 | 2010-10-16 00:00:00 | 2010-10-16 00:00:00 | 2010-10-16 00:00:00 | 2010-10-16 00:00:00 | None | 2010-10-26 00:00:00 | 2010-10-25 00:00:00 | 2010-12-31 00:00:00 | 2011-06-30 00:00:00 | 2010-12-31 00:00:00 | 2011-12-31 00:00:00 | 2011-06-30 00:00:00 | 2011-06-30 00:00:00 | 2011-06-30 00:00:00 | 2011-12-31 00:00:00 | 2012-06-01 00:00:00 | 2012-06-30 00:00:00 | 2013-12-31 00:00:00 | 2012-06-30 00:00:00 | 2014-12-31 00:00:00 | 2014-10-30 00:00:00 | 2012-10-25 00:00:00 | 2014-09-22 00:00:00 | 2014-06-30 00:00:00 | 2014-09-10 00:00:00 | 2014-09-16 00:00:00 | 2012-12-31 00:00:00 | 2012-12-31 00:00:00 | 2014-04-29 00:00:00 | 2014-05-20 00:00:00 | 2014-05-19 00:00:00 | 2014-04-18 00:00:00 | 2015-12-31 00:00:00 | 2015-09-30 00:00:00 | 2018-05-14 00:00:00 | 2018-03-21 00:00:00 | 2017-09-30 00:00:00 | 2017-09-30 00:00:00 | 2017-06-30 00:00:00 | 2019-09-04 00:00:00 | 2018-10-12 00:00:00 | 2018-10-15 00:00:00 | 2019-10-08 00:00:00 | 2020-09-09 00:00:00 | 2020-12-31 00:00:00 | 2018-04-04 00:00:00 | 2020-01-06 00:00:00 | 2018-06-30 00:00:00 | 2018-08-22 00:00:00 | 2018-10-10 00:00:00 | 2020-06-30 00:00:00 | 2018-09-19 00:00:00 | 2018-09-26 00:00:00 | 2017-09-30 00:00:00 | 2019-09-30 00:00:00 | 2018-05-04 00:00:00 | 2019-12-31 00:00:00 | 2015-09-30 00:00:00 | 2015-12-31 00:00:00 | 2016-09-29 00:00:00 | 2016-10-14 00:00:00 | 2016-10-28 00:00:00 | 2016-11-02 00:00:00 | 2016-12-31 00:00:00 | 2016-12-31 00:00:00 | 2016-12-31 00:00:00 | 2017-03-31 00:00:00 | 2017-03-31 00:00:00 | 2017-06-30 00:00:00 | 2019-08-29 00:00:00 | 2018-03-28 00:00:00 | 2018-10-04 00:00:00 | 2020-06-30 00:00:00 | 2018-12-31 00:00:00 | 2018-06-01 00:00:00 | 2018-06-30 00:00:00 | 2019-09-30 00:00:00 | 2020-10-05 00:00:00 | 2017-09-30 00:00:00 | 2020-12-31 00:00:00 | 2018-10-30 00:00:00 | 2017-12-31 00:00:00 | 2020-06-30 00:00:00 | 2018-06-30 00:00:00 | 2017-12-31 00:00:00 | 2019-12-27 00:00:00 | 2018-12-31 00:00:00 | 2018-10-19 00:00:00 | 2018-03-19 00:00:00 | 2020-02-03 00:00:00 | 2020-10-27 00:00:00 | 2018-10-23 00:00:00 | 2018-09-21 00:00:00 | 2019-12-31 00:00:00 | 2021-12-31 00:00:00 | 2020-08-13 00:00:00 | 2022-04-14 00:00:00 | 2021-12-31 00:00:00 | 2022-06-30 00:00:00 | 2022-06-01 00:00:00 | 2022-06-06 00:00:00 | 2022-03-29 00:00:00 | 2022-06-30 00:00:00 | 2022-09-15 00:00:00 | 2022-04-01 00:00:00 | 2022-04-04 00:00:00 | 2022-09-12 00:00:00 | 2022-10-11 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_date | None | None | None | None | None | None | None | None | None | None | None | 2001-01-29 00:00:00 | None | 2002-01-28 00:00:00 | None | None | None | None | 2002-07-24 00:00:00 | 2002-07-18 00:00:00 | 2003-01-28 00:00:00 | None | None | None | None | 2004-01-12 00:00:00 | None | None | None | None | None | 2005-11-02 00:00:00 | 2005-11-02 00:00:00 | 2005-11-02 00:00:00 | 2005-11-02 00:00:00 | 2005-11-02 00:00:00 | 2005-11-02 00:00:00 | 2005-11-02 00:00:00 | 2005-11-02 00:00:00 | 2006-01-20 00:00:00 | 2006-07-27 00:00:00 | 2006-06-02 00:00:00 | None | 2006-06-01 00:00:00 | 2006-11-03 00:00:00 | None | 2007-01-31 00:00:00 | None | None | None | None | None | 2014-05-29 00:00:00 | None | None | None | None | None | None | 2009-01-27 00:00:00 | None | None | None | None | None | 2010-10-20 00:00:00 | 2010-10-20 00:00:00 | 2010-10-26 00:00:00 | None | None | None | None | 2010-10-20 00:00:00 | 2010-10-20 00:00:00 | None | 2010-10-26 00:00:00 | None | 2011-01-31 00:00:00 | 2011-07-25 00:00:00 | None | 2012-01-26 00:00:00 | None | None | 2011-07-31 00:00:00 | None | 2012-06-01 00:00:00 | 2012-07-17 00:00:00 | None | None | 2015-01-20 00:00:00 | 2014-10-30 00:00:00 | 2012-10-25 00:00:00 | 2014-09-22 00:00:00 | 2014-07-16 00:00:00 | 2014-09-10 00:00:00 | 2014-09-16 00:00:00 | None | 2013-01-18 00:00:00 | 2014-04-29 00:00:00 | 2014-05-20 00:00:00 | 2014-05-19 00:00:00 | 2014-04-18 00:00:00 | None | None | 2018-05-14 00:00:00 | 2018-03-21 00:00:00 | 2017-10-19 00:00:00 | 2017-10-05 00:00:00 | None | 2019-09-04 00:00:00 | 2018-10-12 00:00:00 | 2018-10-15 00:00:00 | 2019-10-08 00:00:00 | 2020-09-09 00:00:00 | 2021-01-25 00:00:00 | 2018-04-04 00:00:00 | 2020-01-06 00:00:00 | 2018-07-13 00:00:00 | 2018-08-22 00:00:00 | 2018-10-10 00:00:00 | 2020-07-31 00:00:00 | 2018-09-19 00:00:00 | 2018-09-26 00:00:00 | None | 2019-10-17 00:00:00 | 2018-05-04 00:00:00 | None | 2015-10-21 00:00:00 | 2016-01-11 00:00:00 | 2016-09-29 00:00:00 | 2016-10-14 00:00:00 | 2016-10-28 00:00:00 | 2016-11-02 00:00:00 | 2017-01-11 00:00:00 | None | 2017-01-11 00:00:00 | None | 2017-04-24 00:00:00 | 2017-07-27 00:00:00 | 2019-08-29 00:00:00 | 2018-03-28 00:00:00 | 2018-10-04 00:00:00 | 2020-07-30 00:00:00 | 2019-01-11 00:00:00 | 2018-06-01 00:00:00 | 2018-07-16 00:00:00 | None | 2020-10-05 00:00:00 | None | None | 2018-10-30 00:00:00 | 2018-01-22 00:00:00 | None | None | None | 2019-12-27 00:00:00 | None | 2018-10-19 00:00:00 | 2018-03-19 00:00:00 | 2020-02-03 00:00:00 | 2020-10-27 00:00:00 | 2018-10-23 00:00:00 | 2018-09-21 00:00:00 | 2020-01-29 00:00:00 | None | 2020-08-13 00:00:00 | 2022-04-14 00:00:00 | 2022-01-19 00:00:00 | 2022-07-29 00:00:00 | 2022-06-01 00:00:00 | 2022-06-06 00:00:00 | 2022-03-29 00:00:00 | None | 2022-09-15 00:00:00 | 2022-04-01 00:00:00 | 2022-04-04 00:00:00 | 2022-09-12 00:00:00 | 2022-10-11 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 | 22001 | None | None | None | None | 22006 | None | None | None | None | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | None | 22006 | None | None | None | None | None | 22006 | None | None | None | None | None | None | 22006 | None | None | None | None | None | 22001 | 22001 | 22001 | None | None | None | None | 22001 | 22001 | None | 22001 | None | 22001 | 22001 | None | 22006 | None | None | 22001 | None | 22006 | 22006 | None | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | None | None | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | None | None | 22006 | 22006 | None | None | None | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 |
filer_id | 1012410 | |
---|---|---|
filer_type | 10 | |
active | Y | |
race | 0 | |
session_id | 1989 | |
category | 0 | |
category_type | 40502 | |
sub_category | 0 | |
effect_dt | 1998-06-25 00:00:00 | |
sub_category_type | 0 | |
election_type | 0 | |
sub_category_a | None | |
nyq_dt | None | |
party_cd | 0 | |
county_cd | 18046 | |
district_cd | 0 |
filer_id | 1012410 | |
---|---|---|
xref_id | 492005 | |
effect_dt | 1999-12-07 00:00:00 | |
migration_source | IDENTFIX |
xref_filer_id | 492005 | 492005 | 492005 | 492005 | 492005 | 492005 | 492005 | 492005 | 492005 | 492005 | 492005 | 492005 | 492005 | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_id | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | |||||||||||||
filer_type | MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE | MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE | MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE | MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE | MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE | MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE | MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE | MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE | MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE | MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE | MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE | MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE | MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE | |||||||||||||
status | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | |||||||||||||
effect_dt | 1998-06-25 00:00:00 | 1998-06-25 00:00:00 | 1998-06-25 00:00:00 | 1998-06-25 00:00:00 | 1998-06-25 00:00:00 | 1998-06-25 00:00:00 | 1998-06-25 00:00:00 | 1998-06-25 00:00:00 | 1998-06-25 00:00:00 | 1998-06-25 00:00:00 | 1998-06-25 00:00:00 | 1998-06-25 00:00:00 | 1998-06-25 00:00:00 | |||||||||||||
naml | COTCHETT, JOSEPH W. | COTCHETT, JOSEPH W. | COTCHETT, JOSEPH W. | COTCHETT, JOSEPH W. | COTCHETT, JOSEPH W. | COTCHETT, JOSEPH W. | COTCHETT, JOSEPH W. | COTCHETT, JOSEPH W. | COTCHETT, JOSEPH W. | COTCHETT, JOSEPH W. | COTCHETT, JOSEPH W. | COTCHETT, JOSEPH W. | COTCHETT, JOSEPH W. | |||||||||||||
namf | 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 | |||||||||||||
nams | 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 | |||||||||||||
adr2 | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||
city | BURLINGAME | BURLINGAME | BURLINGAME | BURLINGAME | BURLINGAME | BURLINGAME | BURLINGAME | BURLINGAME | BURLINGAME | BURLINGAME | BURLINGAME | BURLINGAME | BURLINGAME | |||||||||||||
st | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | |||||||||||||
zip4 | 940100000 | 94010-0000 | 94010-0000 | 94010-0000 | 940101413 | 94010-1413 | 94010 | 94010 | 94010 | 94010 | 94010 | 94010 | 94010 | |||||||||||||
phon | 6506976000 | (650) 697-6000 | (650) 697-6000 | 6506976000 | 6506976000 | 6506976000 | 6506976000 | 6506976000 | 6506976000 | 6506976000 | 6506976000 | 6506976000 | 6506976000 | |||||||||||||
fax | None | None | None | None | None | None | None | 6506921112 | 6506921112 | 6506921112 | 6506921112 | 6506921112 | 6506921112 | |||||||||||||
None | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] |
filer_id | 1012410 |
---|
filer_id | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | 1012410 | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_file_name | 16095.cal | 22864.cal | 715877_0.cal | 811561_0.cal | 850243_0.cal | 129126.cal | 850243_1.cal | 907196_0.cal | 979889_0.cal | 1536033_0.cal | 1536104_0.cal | 1606834_0.cal | ||||||||||||
received_date | 2001-01-26 00:00:00 | 2001-01-29 00:00:00 | 2001-01-29 00:00:00 | 2002-01-28 00:00:00 | 2002-07-18 00:00:00 | 2002-07-24 00:00:00 | 2002-07-24 00:00:00 | 2003-01-28 00:00:00 | 2004-01-12 00:00:00 | 2010-10-26 00:00:00 | 2010-10-26 00:00:00 | 2011-07-29 00:00:00 | ||||||||||||
filing_directory | /usr/users/cafiler/disclose/ca99/temp | /usr/users/cafiler/disclose/ca99/temp | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | ||||||||||||
filing_id | None | None | 715877 | 811561 | 850243 | None | 850243 | 907196 | 979889 | 1536033 | 1536104 | 1606834 | ||||||||||||
form_id | None | None | F461 | F461 | F461 | None | F461 | F461 | F461 | F497 | F497 | F461 | ||||||||||||
receive_comment | Filing did not pass validation | Filing did not pass validation | Filing accepted | Filing accepted | Filing accepted | Filing did not pass validation | Filing accepted | Filing accepted | Filing accepted, but with warnings | Filing accepted | Filing accepted | Filing accepted |