filer_id | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | |||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
adrid | 1077593 | 2062935 | 2085154 | 2223920 | 2541897 | 2288233 | 2312113 | |||||||
effect_dt | 1996-07-18 00:00:00 | 2004-01-14 00:00:00 | 2005-02-03 00:00:00 | 2011-12-16 00:00:00 | 2022-08-11 00:00:00 | 2013-02-13 00:00:00 | 2014-01-28 00:00:00 | |||||||
add_type | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | |||||||
session_id | 1995 | 2003 | 2005 | 2011 | 2021 | 2013 | 2013 |
filer_id | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 394215 | 394209 | 394210 | 394211 | 394213 | 394214 | 443240 | 394212 | 588948 | 650438 | 727643 | 783893 | 814766 | 863722 | 923514 | 950396 | 938783 | 983634 | 983062 | 1034918 | 1088758 | 1089479 | 1121023 | 1151616 | 1195398 | 1254247 | 1283616 | 1785889 | 1761201 | 1759420 | 1779167 | 1981350 | 1939215 | 1865609 | 1626169 | 1935846 | 1948247 | 1893872 | 1897440 | 1902866 | 1905632 | 1310321 | 1354745 | 1440865 | 1399026 | 1468854 | 1469968 | 1511157 | 1578089 | 1578089 | 1616201 | 1599246 | 1616201 | 1632215 | 1626169 | 1627002 | 1627006 | 1599246 | 1628207 | 1632911 | 1632215 | 1646712 | 1647879 | 1632911 | 1663452 | 1676696 | 1626169 | 1665825 | 1824047 | 1812991 | 1626169 | 1812991 | 1694114 | 1696833 | 1681664 | 1685619 | 1915909 | 1712667 | 1892185 | 1877068 | 1889086 | 1857946 | 1734153 | 1846609 | 1626169 | 1852779 | 1836776 | 1820340 | 1820340 | 1820340 | 1759420 | 1761201 | 1749593 | 1626169 | 1694114 | 1696833 | 1757422 | 1981350 | 1985015 | 1985015 | 2279471 | 2288542 | 2208185 | 2342334 | 2391589 | 2203309 | 2250140 | 2252555 | 2459456 | 2505880 | 2483935 | 2312035 | 2354987 | 2315879 | 2342334 | 2023789 | 2025565 | 2012442 | 2033543 | 2042089 | 2063011 | 2083014 | 2076446 | 2105572 | 2104224 | 2105572 | 2128245 | 2109022 | 2149720 | 2109022 | 2174974 | 2178370 | 2296457 | 2217214 | 2401117 | 2512206 | 2451189 | 2508841 | 2520022 | 1626169 | 2500948 | 2490504 | 2505070 | 2494823 | 2496666 | 2544725 | 2297688 | 1626169 | 2435819 | 2562466 | 2298173 | 2525546 | 2275441 | 2253835 | 2253835 | 2288542 | 2427248 | 2544729 | 2252555 | 2271404 | 2354987 | 2520028 | 2691718 | 1626169 | 2599569 | 2594098 | 2654265 | 2676744 | 2544725 | 2681283 | 2643657 | 2562466 | 1626169 | 1626169 | 2705403 | 2720497 | 2711158 | 2670980 | 2662710 | 2665393 | 2686217 | 2725537 | 2742973 | 2733876 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
period_id | 157 | 147 | 148 | 149 | 155 | 155 | 145 | 151 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 213 | 214 | 221 | None | 218 | 221 | 220 | None | None | 220 | 220 | 220 | None | None | None | None | None | None | None | None | None | 205 | None | 205 | 207 | 209 | None | None | None | None | None | 207 | 209 | None | None | 209 | 210 | 211 | None | None | 215 | 217 | 215 | 211 | None | None | None | None | 212 | 219 | None | 219 | None | 212 | 218 | 217 | 217 | None | None | None | None | 213 | None | None | 213 | 211 | None | None | 221 | None | None | None | 235 | 231 | 236 | 237 | None | 234 | 233 | 241 | 243 | 241 | 235 | None | None | 236 | None | 226 | 223 | 225 | None | 226 | 227 | None | 227 | None | 227 | 228 | None | None | None | 229 | None | 235 | None | None | 244 | None | None | 243 | 235 | 243 | 243 | 243 | None | 243 | 244 | 235 | 233 | 239 | None | None | None | None | None | None | 235 | None | 245 | 233 | 234 | None | 244 | None | 240 | None | 245 | None | None | 244 | 250 | 247 | None | 251 | 249 | 250 | 251 | None | 249 | None | 250 | 250 | 251 | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F450 | F410 | F420 | F425 | F425 | F450 | F420 | F425 | F450 | F450 | F425 | F450 | F450 | F450 | F450 | F450 | F497 | F410 | F460 | F450 | F410 | F450 | F450 | F450 | F425 | F450 | F450 | F460 | F460 | F460 | F460 | F460 | F410 | F460 | F410 | F460 | F460 | F460 | F497 | F460 | F497 | F450 | F450 | F450 | F450 | F450 | F410 | F450 | F450 | F450 | F450 | F450 | F450 | F450 | F410 | F410 | F410 | F450 | F410 | F450 | F450 | F460 | F460 | F450 | F460 | F460 | F410 | F460 | F410 | F460 | F410 | F460 | F460 | F460 | F460 | F410 | F460 | F497 | F460 | F460 | F497 | F460 | F460 | F497 | F410 | F460 | F410 | F460 | F460 | F460 | F460 | F460 | F460 | F410 | F460 | F460 | F410 | F460 | F460 | F460 | F410 | F497 | F460 | F460 | F460 | F410 | F497 | F460 | F497 | F497 | F460 | F460 | F460 | F460 | F460 | F460 | F497 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F497 | F460 | F460 | F460 | F410 | F497 | F497 | F460 | F460 | F497 | F460 | F497 | F410 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F497 | F410 | F497 | F460 | F460 | F460 | F497 | F460 | F410 | F460 | F460 | F460 | F460 | F460 | F497 | F460 | F460 | F410 | F410 | F460 | F497 | F410 | F460 | F410 | F497 | F460 | F460 | F460 | F460 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | 1 | 1 | 0 | 0 | 0 | 0 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | 0 | 1 | 2 | 0 | 0 | 0 | 0 | 2 | 1 | 1 | 0 | 1 | 1 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 8 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 10 | 9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_date | 1999-07-27 00:00:00 | 1996-07-18 00:00:00 | 1997-01-31 00:00:00 | 1997-07-31 00:00:00 | 1998-08-05 00:00:00 | 1999-02-01 00:00:00 | 1996-10-07 00:00:00 | 1997-02-05 00:00:00 | 2000-01-13 00:00:00 | 2000-07-31 00:00:00 | 2001-02-09 00:00:00 | 2001-07-31 00:00:00 | 2002-01-22 00:00:00 | 2002-07-31 00:00:00 | 2003-02-03 00:00:00 | 2003-07-31 00:00:00 | 2003-06-01 00:00:00 | 2004-01-14 00:00:00 | 2004-01-12 00:00:00 | 2004-08-02 00:00:00 | 2005-02-03 00:00:00 | 2005-01-31 00:00:00 | 2005-08-01 00:00:00 | 2006-01-31 00:00:00 | 2006-07-31 00:00:00 | 2007-01-31 00:00:00 | 2007-07-30 00:00:00 | 2013-07-29 00:00:00 | 2013-07-29 00:00:00 | 2013-07-27 00:00:00 | 2013-07-27 00:00:00 | 2015-07-30 00:00:00 | 2015-02-02 00:00:00 | 2014-07-23 00:00:00 | 2015-02-01 00:00:00 | 2015-02-01 00:00:00 | 2015-02-02 00:00:00 | 2014-10-06 00:00:00 | 2014-10-13 00:00:00 | 2014-10-22 00:00:00 | 2014-10-24 00:00:00 | 2008-01-29 00:00:00 | 2008-07-31 00:00:00 | 2009-07-31 00:00:00 | 2009-01-30 00:00:00 | 2010-01-30 00:00:00 | 2010-02-02 00:00:00 | 2010-07-29 00:00:00 | 2011-01-31 00:00:00 | 2011-04-18 00:00:00 | 2011-10-03 00:00:00 | 2011-07-07 00:00:00 | 2012-01-26 00:00:00 | 2012-01-26 00:00:00 | 2012-01-02 00:00:00 | 2011-12-21 00:00:00 | 2011-12-16 00:00:00 | 2012-01-26 00:00:00 | 2012-01-06 00:00:00 | 2012-01-26 00:00:00 | 2012-03-21 00:00:00 | 2012-03-21 00:00:00 | 2012-03-22 00:00:00 | 2012-03-22 00:00:00 | 2012-05-24 00:00:00 | 2012-07-30 00:00:00 | 2012-07-30 00:00:00 | 2012-05-24 00:00:00 | 2014-01-28 00:00:00 | 2014-03-23 00:00:00 | 2014-01-22 00:00:00 | 2014-01-24 00:00:00 | 2012-10-04 00:00:00 | 2012-10-05 00:00:00 | 2012-07-30 00:00:00 | 2012-07-30 00:00:00 | 2014-10-23 00:00:00 | 2012-11-05 00:00:00 | 2014-10-05 00:00:00 | 2014-07-30 00:00:00 | 2014-09-27 00:00:00 | 2014-05-22 00:00:00 | 2013-01-28 00:00:00 | 2014-05-01 00:00:00 | 2014-03-18 00:00:00 | 2014-05-21 00:00:00 | 2014-03-21 00:00:00 | 2014-03-24 00:00:00 | 2014-03-24 00:00:00 | 2014-01-28 00:00:00 | 2013-04-18 00:00:00 | 2013-04-22 00:00:00 | 2013-01-31 00:00:00 | 2013-02-13 00:00:00 | 2013-02-13 00:00:00 | 2013-02-13 00:00:00 | 2013-02-13 00:00:00 | 2015-11-04 00:00:00 | 2015-11-05 00:00:00 | 2015-07-31 00:00:00 | 2018-07-31 00:00:00 | 2018-09-26 00:00:00 | 2018-01-29 00:00:00 | 2019-07-21 00:00:00 | 2019-07-21 00:00:00 | 2018-01-12 00:00:00 | 2018-05-16 00:00:00 | 2018-05-23 00:00:00 | 2020-02-27 00:00:00 | 2020-09-24 00:00:00 | 2020-07-30 00:00:00 | 2018-10-24 00:00:00 | 2019-07-29 00:00:00 | 2018-10-25 00:00:00 | 2019-01-28 00:00:00 | 2016-02-01 00:00:00 | 2016-04-02 00:00:00 | 2016-02-01 00:00:00 | 2016-04-27 00:00:00 | 2016-04-28 00:00:00 | 2016-08-01 00:00:00 | 2016-09-29 00:00:00 | 2016-08-01 00:00:00 | 2016-11-05 00:00:00 | 2016-09-29 00:00:00 | 2017-01-30 00:00:00 | 2017-01-30 00:00:00 | 2016-11-07 00:00:00 | 2017-01-31 00:00:00 | 2017-01-31 00:00:00 | 2017-07-31 00:00:00 | 2017-07-31 00:00:00 | 2018-09-26 00:00:00 | 2018-01-31 00:00:00 | 2019-07-29 00:00:00 | 2020-10-08 00:00:00 | 2020-01-28 00:00:00 | 2020-09-25 00:00:00 | 2020-10-21 00:00:00 | 2018-07-28 00:00:00 | 2020-09-11 00:00:00 | 2020-08-11 00:00:00 | 2020-09-24 00:00:00 | 2020-07-31 00:00:00 | 2020-08-29 00:00:00 | 2021-01-16 00:00:00 | 2018-09-28 00:00:00 | 2018-01-11 00:00:00 | 2020-01-25 00:00:00 | 2021-01-25 00:00:00 | 2018-09-27 00:00:00 | 2020-10-22 00:00:00 | 2018-07-31 00:00:00 | 2018-07-31 00:00:00 | 2018-05-24 00:00:00 | 2018-08-31 00:00:00 | 2019-12-20 00:00:00 | 2021-01-16 00:00:00 | 2018-07-28 00:00:00 | 2018-07-28 00:00:00 | 2019-01-29 00:00:00 | 2020-10-21 00:00:00 | 2022-05-27 00:00:00 | 2019-12-19 00:00:00 | 2021-07-20 00:00:00 | 2021-07-18 00:00:00 | 2022-01-31 00:00:00 | 2022-04-28 00:00:00 | 2021-07-18 00:00:00 | 2022-05-10 00:00:00 | 2022-01-31 00:00:00 | 2021-07-20 00:00:00 | 2022-08-09 00:00:00 | 2022-03-28 00:00:00 | 2022-07-30 00:00:00 | 2022-09-15 00:00:00 | 2022-08-11 00:00:00 | 2022-04-26 00:00:00 | 2022-04-01 00:00:00 | 2022-04-12 00:00:00 | 2022-05-25 00:00:00 | 2022-09-29 00:00:00 | 2022-09-29 00:00:00 | 2022-08-02 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_type | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10002 | 10005 | 10005 | 10002 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10006 | 10002 | 10001 | 10001 | 10006 | 10001 | 10002 | 10001 | 10005 | 10005 | 10001 | 10001 | 10001 | 10005 | 10005 | 10005 | 10005 | 10005 | 10006 | 10005 | 10005 | 10006 | 10001 | 10005 | 10002 | 10001 | 10001 | 10006 | 10006 | 10006 | 10006 | 10005 | 10002 | 10001 | 10005 | 10006 | 10001 | 10001 | 10002 | 10005 | 10006 | 10002 | 10002 | 10001 | 10001 | 10005 | 10005 | 10006 | 10005 | 10001 | 10001 | 10005 | 10001 | 10005 | 10001 | 10001 | 10002 | 10001 | 10006 | 10006 | 10006 | 10005 | 10001 | 10005 | 10005 | 10002 | 10002 | 10006 | 10002 | 10002 | 10006 | 10005 | 10006 | 10002 | 10001 | 10002 | 10001 | 10006 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10006 | 10005 | 10001 | 10005 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10005 | 10001 | 10005 | 10002 | 10001 | 10005 | 10005 | 10006 | 10001 | 10005 | 10001 | 10005 | 10005 | 10001 | 10005 | 10005 | 10001 | 10002 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10002 | 10001 | 10005 | 10005 | 10005 | 10005 | 10002 | 10005 | 10001 | 10006 | 10001 | 10002 | 10001 | 10005 | 10001 | 10005 | 10002 | 10005 | 10001 | 10005 | 10005 | 10002 | 10001 | 10001 | 10006 | 10002 | 10002 | 10001 | 10001 | 10006 | 10001 | 10006 | 10001 | 10001 | 10001 | 10005 | 10005 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_status | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
session_id | 1999 | 1995 | 1995 | 1997 | 1997 | 1997 | 1995 | 1997 | 1999 | 1999 | 1999 | 2001 | 2001 | 2001 | 2001 | 2003 | 2003 | 2003 | 2003 | 2003 | 2005 | 2003 | 2005 | 2005 | 2005 | 2005 | 2007 | 2013 | 2013 | 2013 | 2013 | 2015 | 2015 | 2013 | 2015 | 2013 | 2013 | 2013 | 2013 | 2013 | 2013 | 2007 | 2007 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2013 | 2013 | 2013 | 2013 | 2011 | 2011 | 2011 | 2011 | 2013 | 2011 | 2013 | 2013 | 2013 | 2013 | 2011 | 2013 | 2013 | 2013 | 2013 | 2013 | 2013 | 2013 | 2013 | 2013 | 2011 | 2013 | 2011 | 2011 | 2013 | 2015 | 2015 | 2015 | 2017 | 2017 | 2017 | 2017 | 2019 | 2017 | 2017 | 2017 | 2019 | 2019 | 2019 | 2017 | 2017 | 2017 | 2017 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2017 | 2017 | 2017 | 2017 | 2019 | 2019 | 2019 | 2019 | 2019 | 2017 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2017 | 2017 | 2019 | 2021 | 2017 | 2019 | 2017 | 2017 | 2017 | 2017 | 2019 | 2021 | 2017 | 2017 | 2017 | 2019 | 2021 | 2019 | 2021 | 2021 | 2021 | 2021 | 2019 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
user_id | * | * | * | * | * | * | * | * | * | JLEHMAN | TWALLS | SARRIAGA | SARRIAGA | DBARRICK | DHORRELL | KVOONG1 | GGILMORE | TTHAM | KLARRY | GKURIMOT | TTHAM | GKURIMOT | GKURIMOT | KVANG | GKURIMOT | GKURIMOT | SARRIAGA | MPACHECO | MPACHECO | CAFILER | CAFILER | SARRIAGA | TRAMON | CAFILER | TRAMON | SARRIAGA | SARRIAGA | JINGRAM | CAFILER | SARRIAGA | CAFILER | SMCCABE | HTSUBOI | CPON | JVAZQUEZ | MMORENO | RGEREMIA | SMCCONNAN | CPON | MPACHECO | RGEREMIA | MMORENO | CAFILER | SARRIAGA | CAFILER | TRAMON | TRAMON | MPACHECO | TRAMON | SARRIAGA | MDIGRAZIA | MDIGRAZIA | MDIGRAZIA | MPACHECO | MDIGRAZIA | CPON | TRAMON | MDIGRAZIA | TRAMON | CAFILER | TRAMON | CAFILER | CAFILER | MPACHECO | CPON | TRAMON | SARRIAGA | CAFILER | CAFILER | MPACHECO | CAFILER | MDIGRAZIA | CAFILER | CAFILER | TRAMON | MDIGRAZIA | TRAMON | MPACHECO | MPACHECO | MPACHECO | SARRIAGA | SARRIAGA | MPACHECO | JINGRAM | CAFILER | MPACHECO | JINGRAM | CAFILER | MPACHECO | SARRIAGA | TRAMON | CAFILER | BSINGH | CAFILER | SBROWN | TRAMON | CAFILER | KKRASNAYA | RGEREMIA | CAFILER | IMEDINA | AROJAS | LPHEAV | AROJAS | VUKSTINA | SMCCONNAN | RGEREMIA | SMCCONNAN | SARRIAGA | SARRIAGA | CPON | SARRIAGA | CPON | BSINGH | SARRIAGA | CAFILER | LLEONG | BSINGH | GTAYLOR | MPACHECO | BSINGH | BSINGH | AROJAS | BSINGH | SBROWN | CAFILER | SUSHAKOV | IMEDINA | IMEDINA | TRAMON | CAFILER | CAFILER | IMEDINA | IMEDINA | CAFILER | SUSHAKOV | CAFILER | TRAMON | SUSHAKOV | SUSHAKOV | AROJAS | IMEDINA | BSINGH | HSTOVALL | KKRASNAYA | CAFILER | TRAMON | CAFILER | CAFILER | BSINGH | VUKSTINA | CAFILER | JMAVES | TRAMON | BCOLON | BCOLON | KRUSSELL | KRUSSELL | CAFILER | CAFILER | KRUSSELL | JMAVES | IMEDINA | IMEDINA | CAFILER | CAFILER | IMEDINA | KRUSSELL | IMEDINA | CAFILER | CAFILER | CAFILER | LPHEAV | RGEREMIA | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
special_audit | 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 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fine_audit | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 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 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 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 | 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_start | 1999-01-01 00:00:00 | None | 1996-10-01 00:00:00 | 1997-01-01 00:00:00 | 1998-07-07 00:00:00 | 1998-07-01 00:00:00 | 1996-01-01 00:00:00 | 1997-07-01 00:00:00 | 1999-07-01 00:00:00 | 2000-01-01 00:00:00 | 2000-07-01 00:00:00 | 2001-01-01 00:00:00 | 2001-07-01 00:00:00 | 2002-01-01 00:00:00 | 2002-07-01 00:00:00 | 2003-01-01 00:00:00 | None | None | 2003-07-01 00:00:00 | 2004-01-01 00:00:00 | None | 2004-07-01 00:00:00 | 2005-01-01 00:00:00 | 2005-07-01 00:00:00 | 2006-01-01 00:00:00 | 2006-07-01 00:00:00 | 2007-01-01 00:00:00 | 2013-04-01 00:00:00 | 2013-01-01 00:00:00 | 2013-01-01 00:00:00 | 2013-04-01 00:00:00 | 2015-01-01 00:00:00 | None | 2014-05-18 00:00:00 | 2015-02-01 00:00:00 | 2014-10-19 00:00:00 | 2014-10-19 00:00:00 | 2014-07-01 00:00:00 | 2014-10-13 00:00:00 | 2014-10-01 00:00:00 | 2014-10-24 00:00:00 | 2007-07-01 00:00:00 | 2008-01-01 00:00:00 | 2009-01-01 00:00:00 | 2008-07-01 00:00:00 | 2009-07-01 00:00:00 | None | 2010-01-10 00:00:00 | 2010-07-01 00:00:00 | None | 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-01-02 00:00:00 | None | None | 2011-01-01 00:00:00 | None | 2011-07-01 00:00:00 | 2011-07-01 00:00:00 | 2012-01-01 00:00:00 | 2012-01-01 00:00:00 | 2011-07-01 00:00:00 | 2012-03-18 00:00:00 | 2012-05-20 00:00:00 | 2012-07-30 00:00:00 | 2012-03-18 00:00:00 | None | 2013-07-01 00:00:00 | 2014-01-22 00:00:00 | 2013-07-01 00:00:00 | 2012-07-01 00:00:00 | 2012-07-01 00:00:00 | 2012-05-20 00:00:00 | None | 2014-10-01 00:00:00 | 2012-11-05 00:00:00 | 2014-07-01 00:00:00 | 2014-05-18 00:00:00 | 2014-09-27 00:00:00 | 2014-01-01 00:00:00 | 2012-10-01 00:00:00 | 2014-05-01 00:00:00 | 2014-03-18 00:00:00 | 2014-01-01 00:00:00 | None | 2013-07-01 00:00:00 | 2013-07-01 00:00:00 | 2013-07-01 00:00:00 | 2013-01-01 00:00:00 | 2013-01-01 00:00:00 | 2012-10-01 00:00:00 | 2013-02-13 00:00:00 | 2012-07-01 00:00:00 | 2012-07-01 00:00:00 | None | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | None | 2018-09-26 00:00:00 | 2017-07-01 00:00:00 | 2018-10-21 00:00:00 | 2019-01-01 00:00:00 | None | 2018-05-16 00:00:00 | 2018-01-01 00:00:00 | 2020-02-27 00:00:00 | 2020-09-24 00:00:00 | 2020-01-01 00:00:00 | 2018-09-23 00:00:00 | 2018-10-21 00:00:00 | 2018-09-23 00:00:00 | 2018-10-21 00:00:00 | 2015-07-01 00:00:00 | 2016-04-02 00:00:00 | 2015-07-01 00:00:00 | 2016-01-01 00:00:00 | 2016-01-01 00:00:00 | 2016-04-24 00:00:00 | 2016-07-01 00:00:00 | 2016-04-24 00:00:00 | 2016-09-25 00:00:00 | 2016-07-01 00:00:00 | 2016-09-25 00:00:00 | 2016-11-06 00:00:00 | 2016-09-25 00:00:00 | 2016-11-06 00:00:00 | 2016-09-25 00:00:00 | 2017-01-01 00:00:00 | 2017-01-01 00:00:00 | 2018-07-01 00:00:00 | 2017-07-01 00:00:00 | 2019-01-01 00:00:00 | 2020-10-08 00:00:00 | 2019-07-01 00:00:00 | 2020-07-01 00:00:00 | 2020-09-20 00:00:00 | 2018-07-28 00:00:00 | 2020-09-11 00:00:00 | 2020-08-11 00:00:00 | 2020-07-01 00:00:00 | 2020-01-01 00:00:00 | 2020-08-29 00:00:00 | 2020-10-18 00:00:00 | 2018-09-28 00:00:00 | 2018-01-11 00:00:00 | 2019-07-01 00:00:00 | 2020-10-18 00:00:00 | 2018-07-01 00:00:00 | 2020-09-20 00:00:00 | 2018-05-20 00:00:00 | 2018-01-01 00:00:00 | 2018-01-01 00:00:00 | 2018-08-31 00:00:00 | None | 2021-01-16 00:00:00 | 2018-01-01 00:00:00 | 2018-05-20 00:00:00 | 2018-10-21 00:00:00 | 2020-10-21 00:00:00 | 2022-04-24 00:00:00 | 2019-12-19 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-07-01 00:00:00 | 2022-01-01 00:00:00 | 2020-10-18 00:00:00 | 2022-05-10 00:00:00 | 2021-07-01 00:00:00 | 2020-10-18 00:00:00 | 2022-08-08 00:00:00 | 2022-03-25 00:00:00 | 2022-05-22 00:00:00 | 2022-09-15 00:00:00 | None | 2022-01-01 00:00:00 | None | 2022-04-12 00:00:00 | 2022-04-24 00:00:00 | 2022-07-01 00:00:00 | 2022-07-01 00:00:00 | 2022-05-22 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_end | 1999-06-30 00:00:00 | None | 1996-12-31 00:00:00 | 1997-06-30 00:00:00 | 1998-06-30 00:00:00 | 1998-12-31 00:00:00 | 1996-09-30 00:00:00 | 1997-12-31 00:00:00 | 1999-12-31 00:00:00 | 2000-06-30 00:00:00 | 2000-12-31 00:00:00 | 2001-06-30 00:00:00 | 2001-12-31 00:00:00 | 2002-06-30 00:00:00 | 2002-12-31 00:00:00 | 2003-06-30 00:00:00 | None | None | 2003-12-31 00:00:00 | 2004-06-30 00:00:00 | None | 2004-12-31 00:00:00 | 2005-06-30 00:00:00 | 2005-12-31 00:00:00 | 2006-06-30 00:00:00 | 2006-12-31 00:00:00 | 2007-06-30 00:00:00 | 2013-06-30 00:00:00 | 2013-03-31 00:00:00 | 2013-03-31 00:00:00 | 2013-06-30 00:00:00 | 2015-06-30 00:00:00 | None | 2014-06-30 00:00:00 | 2015-02-01 00:00:00 | 2014-12-31 00:00:00 | 2014-12-31 00:00:00 | 2014-09-30 00:00:00 | 2014-10-13 00:00:00 | 2014-10-18 00:00:00 | 2014-10-24 00:00:00 | 2007-12-31 00:00:00 | 2008-06-30 00:00:00 | 2009-06-30 00:00:00 | 2008-12-31 00:00:00 | 2009-12-31 00:00:00 | None | 2010-06-30 00:00:00 | 2010-12-31 00:00:00 | None | 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-01-02 00:00:00 | None | None | 2011-06-30 00:00:00 | None | 2011-12-31 00:00:00 | 2011-12-31 00:00:00 | 2012-03-17 00:00:00 | 2012-03-17 00:00:00 | 2011-12-31 00:00:00 | 2012-05-19 00:00:00 | 2012-06-30 00:00:00 | 2012-07-30 00:00:00 | 2012-05-19 00:00:00 | None | 2013-12-31 00:00:00 | 2014-01-22 00:00:00 | 2013-12-31 00:00:00 | 2012-09-30 00:00:00 | 2012-09-30 00:00:00 | 2012-06-30 00:00:00 | None | 2014-10-18 00:00:00 | 2012-11-05 00:00:00 | 2014-09-30 00:00:00 | 2014-06-30 00:00:00 | 2014-09-27 00:00:00 | 2014-05-17 00:00:00 | 2012-12-31 00:00:00 | 2014-05-01 00:00:00 | 2014-03-18 00:00:00 | 2014-05-17 00:00:00 | None | 2013-12-31 00:00:00 | 2013-12-31 00:00:00 | 2013-12-31 00:00:00 | 2013-03-31 00:00:00 | 2013-03-31 00:00:00 | 2012-12-31 00:00:00 | 2013-02-13 00:00:00 | 2012-09-30 00:00:00 | 2012-09-30 00:00:00 | None | 2015-06-30 00:00:00 | 2015-06-30 00:00:00 | 2015-06-30 00:00:00 | None | 2018-09-26 00:00:00 | 2017-12-31 00:00:00 | 2018-12-31 00:00:00 | 2019-06-30 00:00:00 | None | 2018-05-16 00:00:00 | 2018-05-19 00:00:00 | 2020-02-27 00:00:00 | 2020-09-24 00:00:00 | 2020-06-30 00:00:00 | 2018-10-20 00:00:00 | 2018-12-31 00:00:00 | 2018-10-20 00:00:00 | 2018-12-31 00:00:00 | 2015-12-31 00:00:00 | 2016-04-02 00:00:00 | 2015-12-31 00:00:00 | 2016-04-23 00:00:00 | 2016-04-23 00:00:00 | 2016-06-30 00:00:00 | 2016-09-24 00:00:00 | 2016-06-30 00:00:00 | 2016-11-05 00:00:00 | 2016-09-24 00:00:00 | 2016-11-05 00:00:00 | 2016-12-31 00:00:00 | 2016-11-05 00:00:00 | 2016-12-31 00:00:00 | 2016-11-05 00:00:00 | 2017-06-30 00:00:00 | 2017-06-30 00:00:00 | 2018-09-22 00:00:00 | 2017-12-31 00:00:00 | 2019-06-30 00:00:00 | 2020-10-08 00:00:00 | 2019-12-31 00:00:00 | 2020-09-19 00:00:00 | 2020-10-17 00:00:00 | 2018-07-28 00:00:00 | 2020-09-11 00:00:00 | 2020-08-11 00:00:00 | 2020-09-19 00:00:00 | 2020-06-30 00:00:00 | 2020-08-29 00:00:00 | 2020-12-31 00:00:00 | 2018-09-28 00:00:00 | 2018-01-11 00:00:00 | 2019-12-31 00:00:00 | 2020-12-31 00:00:00 | 2018-09-22 00:00:00 | 2020-10-17 00:00:00 | 2018-06-30 00:00:00 | 2018-05-19 00:00:00 | 2018-05-19 00:00:00 | 2018-08-31 00:00:00 | None | 2021-01-16 00:00:00 | 2018-05-19 00:00:00 | 2018-06-30 00:00:00 | 2018-12-31 00:00:00 | 2020-10-21 00:00:00 | 2022-05-21 00:00:00 | 2019-12-19 00:00:00 | 2021-06-30 00:00:00 | 2021-06-30 00:00:00 | 2021-12-31 00:00:00 | 2022-04-23 00:00:00 | 2020-12-31 00:00:00 | 2022-05-10 00:00:00 | 2021-12-31 00:00:00 | 2020-12-31 00:00:00 | 2022-08-08 00:00:00 | 2022-03-25 00:00:00 | 2022-06-30 00:00:00 | 2022-09-15 00:00:00 | None | 2022-04-23 00:00:00 | None | 2022-04-12 00:00:00 | 2022-05-21 00:00:00 | 2022-09-24 00:00:00 | 2022-09-24 00:00:00 | 2022-06-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 | 2013-07-27 00:00:00 | 2013-07-27 00:00:00 | 2015-07-30 00:00:00 | None | 2014-07-23 00:00:00 | None | 2015-02-01 00:00:00 | None | None | 2014-10-13 00:00:00 | 2014-10-22 00:00:00 | 2014-10-24 00:00:00 | None | None | None | None | None | None | None | None | None | 2011-10-03 00:00:00 | None | 2012-01-26 00:00:00 | 2012-01-25 00:00:00 | None | None | None | None | None | None | 2012-03-21 00:00:00 | 2012-03-21 00:00:00 | None | None | 2012-05-24 00:00:00 | 2012-07-30 00:00:00 | None | None | None | 2014-03-23 00:00:00 | None | 2014-01-24 00:00:00 | 2012-10-04 00:00:00 | None | None | None | None | 2012-11-05 00:00:00 | 2014-10-05 00:00:00 | None | 2014-09-27 00:00:00 | None | 2013-01-28 00:00:00 | 2014-05-01 00:00:00 | None | 2014-05-21 00:00:00 | None | None | None | None | 2013-04-18 00:00:00 | None | None | None | 2013-02-13 00:00:00 | None | None | 2015-11-04 00:00:00 | None | None | None | 2018-09-26 00:00:00 | 2018-01-29 00:00:00 | 2019-07-21 00:00:00 | 2019-07-21 00:00:00 | None | 2018-05-16 00:00:00 | 2018-05-23 00:00:00 | 2020-02-27 00:00:00 | 2020-09-24 00:00:00 | 2020-07-30 00:00:00 | 2018-10-24 00:00:00 | None | None | 2019-01-28 00:00:00 | None | 2016-04-02 00:00:00 | 2016-02-01 00:00:00 | 2016-04-27 00:00:00 | None | 2016-08-01 00:00:00 | 2016-09-29 00:00:00 | None | 2016-11-05 00:00:00 | None | 2017-01-30 00:00:00 | 2017-01-30 00:00:00 | None | None | None | 2017-07-30 00:00:00 | None | 2018-09-26 00:00:00 | None | None | 2020-10-08 00:00:00 | None | None | 2020-10-21 00:00:00 | None | 2020-09-11 00:00:00 | 2020-08-11 00:00:00 | 2020-09-24 00:00:00 | None | 2020-08-29 00:00:00 | 2021-01-16 00:00:00 | 2018-09-28 00:00:00 | None | 2020-01-25 00:00:00 | None | None | None | None | None | None | 2018-08-31 00:00:00 | None | 2021-01-16 00:00:00 | 2018-07-28 00:00:00 | 2018-07-28 00:00:00 | None | 2020-10-21 00:00:00 | None | None | None | 2021-07-18 00:00:00 | None | None | 2021-07-18 00:00:00 | 2022-05-10 00:00:00 | 2022-01-31 00:00:00 | None | None | None | 2022-07-30 00:00:00 | 2022-09-15 00:00:00 | None | 2022-04-26 00:00:00 | None | 2022-04-12 00:00:00 | 2022-05-25 00:00:00 | 2022-09-27 00:00:00 | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_type | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | None | None | 22001 | 22001 | 22001 | None | None | None | None | None | None | None | None | None | 22006 | None | 22001 | 22001 | 22001 | None | None | None | None | None | 22001 | 22001 | None | None | 22001 | 22001 | 22001 | None | None | 22001 | 22001 | 22001 | 22001 | None | None | None | None | 22001 | 22001 | None | 22001 | None | 22001 | 22001 | 22001 | 22001 | None | None | None | None | 22001 | None | None | 22001 | 22001 | None | None | 22001 | None | None | None | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | None | 22001 | None | 22001 | 22001 | 22001 | None | 22001 | 22001 | None | 22001 | None | 22001 | 22001 | None | None | None | 22001 | None | 22001 | None | None | 22001 | None | None | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | None | None | None | None | None | None | 22001 | None | 22001 | 22001 | 22001 | None | 22001 | None | 22001 | None | 22001 | None | None | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | None | 22001 | None | 22001 | 22001 | 22001 | None | None |
filer_id | 1067843 | 1067843 | 1067843 | 1067843 | ||||
---|---|---|---|---|---|---|---|---|
filer_type | 16 | 16 | 16 | 16 | ||||
active | Y | Y | Y | Y | ||||
race | 0 | 0 | 0 | 0 | ||||
session_id | 1995 | 2011 | 2011 | 2015 | ||||
category | 0 | 0 | 0 | 0 | ||||
category_type | 40502 | 40502 | 40502 | 40502 | ||||
sub_category | 40103 | 40103 | 40103 | 40103 | ||||
effect_dt | 1996-07-18 00:00:00 | 2011-12-16 00:00:00 | 2011-12-21 00:00:00 | 2015-02-02 00:00:00 | ||||
sub_category_type | 0 | 0 | 40203 | 0 | ||||
election_type | 0 | 0 | 0 | 0 | ||||
sub_category_a | S | S | S | S | ||||
nyq_dt | 1996-07-15 00:00:00 | 1996-07-15 00:00:00 | 1996-07-15 00:00:00 | 1996-07-15 00:00:00 | ||||
party_cd | None | None | None | None | ||||
county_cd | 18052 | 18004 | 18004 | 18004 | ||||
district_cd | None | None | None | None |
filer_id | 1067843 | |
---|---|---|
xref_id | 961083 | |
effect_dt | 1999-12-07 00:00:00 | |
migration_source | IDENTFIX |
xref_filer_id | 961083 | 961083 | 961083 | 961083 | 961083 | 961083 | 961083 | 961083 | 961083 | 961083 | 961083 | 961083 | 961083 | 961083 | 961083 | 961083 | 961083 | 961083 | 961083 | 961083 | 961083 | 961083 | 961083 | 961083 | 961083 | 961083 | 961083 | 961083 | 961083 | 961083 | 961083 | 961083 | 961083 | 961083 | 961083 | 961083 | ||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_id | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | ||||||||||||||||||||||||||||||||||||
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 | 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 | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ||||||||||||||||||||||||||||||||||||
effect_dt | 2015-02-02 00:00:00 | 2015-02-02 00:00:00 | 2015-02-02 00:00:00 | 2015-02-02 00:00:00 | 2015-02-02 00:00:00 | 2015-02-02 00:00:00 | 2015-02-02 00:00:00 | 2015-02-02 00:00:00 | 2015-02-02 00:00:00 | 2015-02-02 00:00:00 | 2015-02-02 00:00:00 | 2015-02-02 00:00:00 | 2015-02-02 00:00:00 | 2015-02-02 00:00:00 | 2015-02-02 00:00:00 | 2015-02-02 00:00:00 | 2015-02-02 00:00:00 | 2015-02-02 00:00:00 | 2015-02-02 00:00:00 | 2015-02-02 00:00:00 | 2015-02-02 00:00:00 | 2015-02-02 00:00:00 | 2015-02-02 00:00:00 | 2015-02-02 00:00:00 | 2015-02-02 00:00:00 | 2015-02-02 00:00:00 | 2015-02-02 00:00:00 | 2015-02-02 00:00:00 | 2015-02-02 00:00:00 | 2015-02-02 00:00:00 | 2015-02-02 00:00:00 | 2015-02-02 00:00:00 | 2015-02-02 00:00:00 | 2015-02-02 00:00:00 | 2015-02-02 00:00:00 | 2015-02-02 00:00:00 | ||||||||||||||||||||||||||||||||||||
naml | SUN PAC | SUN PAC | SUN PAC | SUN PAC | SUN PAC | SUN PAC | SUN PAC - CALIFORNIA SOLAR ENERGY INDUSTRIES ASSOCIATION | SUN PAC - CALIFORNIA SOLAR ENERGY INDUSTRIES ASSOCIATION | SUN PAC - CALIFORNIA SOLAR ENERGY INDUSTRIES ASSOCIATION | SUN PAC - CALIFORNIA SOLAR ENERGY INDUSTRIES ASSOCIATION | SUN PAC - CALIFORNIA SOLAR ENERGY INDUSTRIES ASSOCIATION | SUN PAC - CALIFORNIA SOLAR ENERGY INDUSTRIES ASSOCIATION | CALIFORNIA SOLAR ENERGY INDUSTRIES ASSOCIATION | CALIFORNIA SOLAR ENERGY INDUSTRIES ASSOCIATION | CALIFORNIA SOLAR ENERGY INDUSTRIES ASSOCIATION | CALIFORNIA SOLAR ENERGY INDUSTRIES ASSOCIATION | CALIFORNIA SOLAR ENERGY INDUSTRIES ASSOCIATION | CALIFORNIA SOLAR ENERGY INDUSTRIES ASSOCIATION | CALIFORNIA SOLAR ENERGY INDUSTRIES ASSOCIATION - SUN PAC | CALIFORNIA SOLAR ENERGY INDUSTRIES ASSOCIATION - SUN PAC | CALIFORNIA SOLAR ENERGY INDUSTRIES ASSOCIATION - SUN PAC | CALIFORNIA SOLAR ENERGY INDUSTRIES ASSOCIATION - SUN PAC | CALIFORNIA SOLAR ENERGY INDUSTRIES ASSOCIATION - SUN PAC | CALIFORNIA SOLAR ENERGY INDUSTRIES ASSOCIATION - SUN PAC | SUN PAC - CALIFORNIA SOLAR ENERGY INDUSTRIES ASSOCIATION | SUN PAC - CALIFORNIA SOLAR ENERGY INDUSTRIES ASSOCIATION | SUN PAC - CALIFORNIA SOLAR ENERGY INDUSTRIES ASSOCIATION | SUN PAC - CALIFORNIA SOLAR ENERGY INDUSTRIES ASSOCIATION | SUN PAC - CALIFORNIA SOLAR ENERGY INDUSTRIES ASSOCIATION | SUN PAC - CALIFORNIA SOLAR ENERGY INDUSTRIES ASSOCIATION | SUNPAC SPONSORED BY CALIFORNIA SOLAR & STORAGE ASSOCIATION (FORMERLY CALSEIA) | SUNPAC SPONSORED BY CALIFORNIA SOLAR & STORAGE ASSOCIATION (FORMERLY CALSEIA) | SUNPAC SPONSORED BY CALIFORNIA SOLAR & STORAGE ASSOCIATION (FORMERLY CALSEIA) | SUNPAC SPONSORED BY CALIFORNIA SOLAR & STORAGE ASSOCIATION (FORMERLY CALSEIA) | SUNPAC SPONSORED BY CALIFORNIA SOLAR & STORAGE ASSOCIATION (FORMERLY CALSEIA) | SUNPAC SPONSORED BY CALIFORNIA SOLAR & STORAGE ASSOCIATION (FORMERLY CALSEIA) | ||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||
city | SACRAMENTO | RIO VISTA | RANCHO CORDOVA | RANCHO CORDOVA | SACRAMENTO | SACRAMENTO | SACRAMENTO | RIO VISTA | RANCHO CORDOVA | RANCHO CORDOVA | SACRAMENTO | SACRAMENTO | SACRAMENTO | RIO VISTA | RANCHO CORDOVA | RANCHO CORDOVA | SACRAMENTO | SACRAMENTO | SACRAMENTO | RIO VISTA | RANCHO CORDOVA | RANCHO CORDOVA | SACRAMENTO | SACRAMENTO | SACRAMENTO | RIO VISTA | RANCHO CORDOVA | RANCHO CORDOVA | SACRAMENTO | SACRAMENTO | SACRAMENTO | RIO VISTA | RANCHO CORDOVA | RANCHO CORDOVA | 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 | ||||||||||||||||||||||||||||||||||||
zip4 | 95814 | 94571 | 95742 | 95742 | 95814 | 95814 | 95814 | 94571 | 95742 | 95742 | 95814 | 95814 | 95814 | 94571 | 95742 | 95742 | 95814 | 95814 | 95814 | 94571 | 95742 | 95742 | 95814 | 95814 | 95814 | 94571 | 95742 | 95742 | 95814 | 95814 | 95814 | 94571 | 95742 | 95742 | 95814 | 95814 | ||||||||||||||||||||||||||||||||||||
phon | 9163402605 | 9167476987 | 9167476987 | 9167476987 | 9167476987 | 9164427757 | 9163402605 | 9167476987 | 9167476987 | 9167476987 | 9167476987 | 9164427757 | 9163402605 | 9167476987 | 9167476987 | 9167476987 | 9167476987 | 9164427757 | 9163402605 | 9167476987 | 9167476987 | 9167476987 | 9167476987 | 9164427757 | 9163402605 | 9167476987 | 9167476987 | 9167476987 | 9167476987 | 9164427757 | 9163402605 | 9167476987 | 9167476987 | 9167476987 | 9167476987 | 9164427757 | ||||||||||||||||||||||||||||||||||||
fax | 9164423177 | 9066600218 | 9164423177 | 9066600218 | 9164423177 | 9066600218 | 9164423177 | 9066600218 | 9164423177 | 9066600218 | 9164423177 | 9066600218 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
None | None | None | [email protected] | [email protected] | [email protected] | None | None | None | [email protected] | [email protected] | [email protected] | None | None | None | [email protected] | [email protected] | [email protected] | None | None | None | [email protected] | [email protected] | [email protected] | None | None | None | [email protected] | [email protected] | [email protected] | None | None | None | [email protected] | [email protected] | [email protected] |
filer_id | 1067843 |
---|
filer_id | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | 1067843 | ||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_file_name | 1846609_0.cal | 1712667_0.cal | 520190.cal | 53328.cal | 2025565_0.cal | 1897440_0.cal | 1889086_0.cal | 1905632_0.cal | 2288542_1.cal | 2250140_0.cal | 2490504_0.cal | 2297688_0.cal | 2496666_0.cal | 2288542_0.cal | 2459456_0.cal | 2681283_0.cal | 2512206_0.cal | 2500948_0.cal | 2544729_0.cal | 2665393_0.cal | 118893.cal | 2520028_0.cal | 2720497_0.cal | 235486.cal | ||||||||||||||||||||||||
received_date | 2014-05-01 00:00:00 | 2012-11-05 00:00:00 | 2012-05-24 00:00:00 | 2017-01-30 00:00:00 | 2016-04-02 00:00:00 | 2014-10-13 00:00:00 | 2014-09-27 00:00:00 | 2014-10-24 00:00:00 | 2018-09-26 00:00:00 | 2018-05-16 00:00:00 | 2020-08-11 00:00:00 | 2018-09-28 00:00:00 | 2020-08-29 00:00:00 | 2018-08-31 00:00:00 | 2020-02-27 00:00:00 | 2022-05-10 00:00:00 | 2020-10-08 00:00:00 | 2020-09-11 00:00:00 | 2021-01-16 00:00:00 | 2022-04-12 00:00:00 | 2022-04-12 00:00:00 | 2020-10-21 00:00:00 | 2022-09-15 00:00:00 | 2022-03-28 00:00:00 | ||||||||||||||||||||||||
filing_directory | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | ||||||||||||||||||||||||
filing_id | 1846609 | 1712667 | None | None | 2025565 | 1897440 | 1889086 | 1905632 | 2288542 | 2250140 | 2490504 | 2297688 | 2496666 | 2288542 | 2459456 | 2681283 | 2512206 | 2500948 | 2544729 | 2665393 | None | 2520028 | 2720497 | None | ||||||||||||||||||||||||
form_id | F497 | F497 | None | None | F497 | F497 | F497 | F497 | F497 | F497 | F497 | F497 | F497 | F497 | F497 | F497 | F497 | F497 | F497 | F497 | None | F497 | F497 | None | ||||||||||||||||||||||||
receive_comment | Filing accepted | Filing accepted | Filing did not pass validation | 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 passed validation, but failed DB constraints | Filing accepted | Filing accepted | Filing passed validation, but failed DB constraints |