filer_id | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
adrid | 1025578 | 1025579 | 2089798 | 2216350 | 2215866 | 2531144 | 2531145 | 2490951 | 2490950 | 2334647 | 2438966 | |||||||||||
effect_dt | 1990-12-01 00:00:00 | 1990-12-01 00:00:00 | 2005-06-29 00:00:00 | 2011-05-16 00:00:00 | 2011-05-16 00:00:00 | 2022-02-09 00:00:00 | 2022-02-09 00:00:00 | 2019-12-03 00:00:00 | 2019-12-03 00:00:00 | 2014-10-09 00:00:00 | 2017-08-01 00:00:00 | |||||||||||
add_type | 7051 | 7051 | 7051 | 7082 | 7051 | 7051 | 7082 | 7082 | 7051 | 7051 | 7051 | |||||||||||
session_id | 1979 | 1979 | 2005 | 2011 | 2011 | 2021 | 2021 | 2019 | 2019 | 2013 | 2017 |
filer_id | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 164525 | 164526 | 164527 | 164528 | 164529 | 164530 | 164531 | 164532 | 164533 | 164534 | 164535 | 164536 | 164537 | 164538 | 164539 | 164540 | 164541 | 164542 | 164543 | 164544 | 164545 | 164546 | 164547 | 164548 | 164549 | 164550 | 217741 | 217742 | 217743 | 1095128 | 1116781 | 1110706 | 1087136 | 1110559 | 1110560 | 1110681 | 1144931 | 1135270 | 1135030 | 1140075 | 1140076 | 1152731 | 1140073 | 1135270 | 1160714 | 1182712 | 1153578 | 1158595 | 1186899 | 1174889 | 1203432 | 1210558 | 1181341 | 1203432 | 1208670 | 1221024 | 1198115 | 1232676 | 1249935 | 1283580 | 1279085 | 1780248 | 1785943 | 1982678 | 1959241 | 1948106 | 1955822 | 1956397 | 1896727 | 1898404 | 1330807 | 1327972 | 1306827 | 1311990 | 1298847 | 1298131 | 1352238 | 1364009 | 1355083 | 1362466 | 1369196 | 1373192 | 1380158 | 1379327 | 1396939 | 1400661 | 1436049 | 1462587 | 1439707 | 1467382 | 1471367 | 1471063 | 1471063 | 1507077 | 1512861 | 1512861 | 1471367 | 1507077 | 1528253 | 1530545 | 1535869 | 1521997 | 1573116 | 1575440 | 1530545 | 1535869 | 1612116 | 1608515 | 1595141 | 1633807 | 1631632 | 1646730 | 1648717 | 1648717 | 1646730 | 1676440 | 1821838 | 1813324 | 1698029 | 1681638 | 1929992 | 1693092 | 1698029 | 1710913 | 1693092 | 1702546 | 1888406 | 1888402 | 1888402 | 1745258 | 1731940 | 1987941 | 2425656 | 2422880 | 2422881 | 2422882 | 2422883 | 2423308 | 2423310 | 2423311 | 2423312 | 2017745 | 2014200 | 2073231 | 2063002 | 2126213 | 2150115 | 2174900 | 2179099 | 2180044 | 2676617 | 2670688 | 2649073 | 2697937 | 2723398 | 2648073 | 2648074 | 2648075 | 2648076 | 2648077 | 2670713 | 2649356 | 2649359 | 2649361 | 2649363 | 2649365 | 2728303 | 2753641 | 2739548 | 2735486 | 2732047 | 2739236 | 2730252 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
period_id | 80 | 79 | 81 | 101 | 103 | 101 | 105 | 108 | 107 | 108 | 109 | 107 | 109 | 111 | 111 | 113 | 115 | 116 | 116 | 115 | 113 | 116 | 120 | 125 | 129 | 129 | 83 | 103 | 129 | None | None | None | None | None | None | None | 184 | None | None | 181 | 183 | None | 181 | None | None | None | 185 | 185 | 186 | 185 | 187 | 188 | None | 187 | None | None | None | 188 | None | None | 189 | 213 | None | 222 | None | None | 222 | 221 | None | None | None | 193 | 192 | None | None | 191 | 194 | None | None | 195 | 196 | None | None | 196 | 196 | None | 197 | 199 | None | None | None | 201 | 201 | 201 | None | None | None | 201 | None | 204 | None | 203 | 204 | None | 204 | None | None | 205 | None | None | 207 | 209 | None | None | 209 | 209 | None | 215 | None | None | 219 | 211 | None | None | 211 | 212 | 217 | 219 | 219 | None | 212 | None | None | 235 | 231 | 237 | 233 | None | None | None | None | None | 223 | None | 225 | 227 | None | 229 | None | None | None | 249 | None | 250 | 251 | 239 | 241 | 243 | 245 | 247 | 250 | None | None | None | None | None | None | None | 252 | 252 | None | 251 | 252 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F410 | F420 | F420 | F420 | F420 | F405 | F420 | F420 | F420 | F420 | F405 | F405 | F420 | F420 | F405 | F420 | F420 | F420 | F420 | F405 | F405 | F405 | F405 | F420 | F405 | F405 | F420 | F405 | F405 | F460 | F460 | F460 | F460 | F460 | F460 | F410 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F497 | F460 | F460 | F410 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F497 | F497 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F410 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F410 | F410 | F460 | F460 | F460 | F410 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F410 | F460 | F460 | F410 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F497 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F497 | F497 | F460 | F460 | F497 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_sequence | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 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 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_date | 1979-10-31 00:00:00 | 1980-01-21 00:00:00 | 1980-07-30 00:00:00 | 1985-11-19 00:00:00 | 1986-01-31 00:00:00 | 1986-04-03 00:00:00 | 1986-07-11 00:00:00 | 1986-11-10 00:00:00 | 1986-11-06 00:00:00 | 1987-02-02 00:00:00 | 1987-02-02 00:00:00 | 1987-07-27 00:00:00 | 1987-07-27 00:00:00 | 1988-01-29 00:00:00 | 1988-03-11 00:00:00 | 1988-07-29 00:00:00 | 1988-10-05 00:00:00 | 1988-10-27 00:00:00 | 1989-01-26 00:00:00 | 1989-01-27 00:00:00 | 1989-01-27 00:00:00 | 1989-04-12 00:00:00 | 1989-07-13 00:00:00 | 1991-07-30 00:00:00 | 1992-01-07 00:00:00 | 1992-03-30 00:00:00 | 1981-01-16 00:00:00 | 1986-04-03 00:00:00 | 1992-02-10 00:00:00 | 2005-02-28 00:00:00 | 2005-07-28 00:00:00 | 2005-02-28 00:00:00 | 2005-01-31 00:00:00 | 2005-06-28 00:00:00 | 2005-06-28 00:00:00 | 2005-06-29 00:00:00 | 2006-01-26 00:00:00 | 2005-10-28 00:00:00 | 2005-01-31 00:00:00 | 2006-01-01 00:00:00 | 2006-01-01 00:00:00 | 2006-01-31 00:00:00 | 2005-12-30 00:00:00 | 2006-01-09 00:00:00 | 2006-03-30 00:00:00 | 2006-06-14 00:00:00 | 2006-02-28 00:00:00 | 2006-03-28 00:00:00 | 2006-07-24 00:00:00 | 2006-05-25 00:00:00 | 2006-10-02 00:00:00 | 2006-10-24 00:00:00 | 2006-05-30 00:00:00 | 2006-10-05 00:00:00 | 2006-10-06 00:00:00 | 2006-10-26 00:00:00 | 2006-07-31 00:00:00 | 2007-01-26 00:00:00 | 2007-01-29 00:00:00 | 2007-07-30 00:00:00 | 2007-07-23 00:00:00 | 2013-07-29 00:00:00 | 2013-07-31 00:00:00 | 2015-07-31 00:00:00 | 2015-04-09 00:00:00 | 2015-02-02 00:00:00 | 2015-04-02 00:00:00 | 2015-04-07 00:00:00 | 2014-10-08 00:00:00 | 2014-10-09 00:00:00 | 2008-04-30 00:00:00 | 2008-04-28 00:00:00 | 2008-01-27 00:00:00 | 2008-01-31 00:00:00 | 2007-11-01 00:00:00 | 2007-10-31 00:00:00 | 2008-07-31 00:00:00 | 2008-10-06 00:00:00 | 2008-08-02 00:00:00 | 2008-10-05 00:00:00 | 2008-10-22 00:00:00 | 2008-10-23 00:00:00 | 2008-11-04 00:00:00 | 2008-11-02 00:00:00 | 2009-02-01 00:00:00 | 2009-02-02 00:00:00 | 2009-07-29 00:00:00 | 2010-01-28 00:00:00 | 2009-07-31 00:00:00 | 2010-02-01 00:00:00 | 2010-03-04 00:00:00 | 2010-03-02 00:00:00 | 2010-03-30 00:00:00 | 2010-08-01 00:00:00 | 2010-08-02 00:00:00 | 2010-09-09 00:00:00 | 2010-04-08 00:00:00 | 2010-08-28 00:00:00 | 2010-10-05 00:00:00 | 2010-10-20 00:00:00 | 2010-10-21 00:00:00 | 2010-10-05 00:00:00 | 2011-02-01 00:00:00 | 2011-01-31 00:00:00 | 2011-06-13 00:00:00 | 2011-06-15 00:00:00 | 2011-08-05 00:00:00 | 2011-08-01 00:00:00 | 2011-05-16 00:00:00 | 2012-01-27 00:00:00 | 2012-01-25 00:00:00 | 2012-03-21 00:00:00 | 2012-03-22 00:00:00 | 2012-05-23 00:00:00 | 2012-05-21 00:00:00 | 2012-07-29 00:00:00 | 2014-01-30 00:00:00 | 2014-01-26 00:00:00 | 2012-10-05 00:00:00 | 2012-07-31 00:00:00 | 2015-01-26 00:00:00 | 2012-10-02 00:00:00 | 2012-10-24 00:00:00 | 2012-10-25 00:00:00 | 2012-10-21 00:00:00 | 2012-10-24 00:00:00 | 2014-09-25 00:00:00 | 2014-09-25 00:00:00 | 2014-09-25 00:00:00 | 2013-01-30 00:00:00 | 2013-01-24 00:00:00 | 2015-07-31 00:00:00 | 2019-12-03 00:00:00 | 2019-11-24 00:00:00 | 2019-11-24 00:00:00 | 2019-11-24 00:00:00 | 2019-11-24 00:00:00 | 2019-11-29 00:00:00 | 2019-11-29 00:00:00 | 2019-11-29 00:00:00 | 2019-11-29 00:00:00 | 2016-02-02 00:00:00 | 2016-02-04 00:00:00 | 2016-08-02 00:00:00 | 2016-08-01 00:00:00 | 2017-01-29 00:00:00 | 2017-03-31 00:00:00 | 2017-07-30 00:00:00 | 2017-07-31 00:00:00 | 2017-08-01 00:00:00 | 2022-04-28 00:00:00 | 2022-04-26 00:00:00 | 2022-02-09 00:00:00 | 2022-07-13 00:00:00 | 2022-09-24 00:00:00 | 2022-02-07 00:00:00 | 2022-02-07 00:00:00 | 2022-02-07 00:00:00 | 2022-02-07 00:00:00 | 2022-02-07 00:00:00 | 2022-04-26 00:00:00 | 2022-02-08 00:00:00 | 2022-02-08 00:00:00 | 2022-02-08 00:00:00 | 2022-02-08 00:00:00 | 2022-02-08 00:00:00 | 2022-07-18 00:00:00 | 2022-10-25 00:00:00 | 2022-10-24 00:00:00 | 2022-10-18 00:00:00 | 2022-09-29 00:00:00 | 2022-10-22 00:00:00 | 2022-10-07 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_type | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10006 | 10001 | 10005 | 10005 | 10001 | 10001 | 10005 | 10001 | 10006 | 10005 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10002 | 10005 | 10005 | 10005 | 10001 | 10005 | 10005 | 10001 | 10001 | 10005 | 10001 | 10005 | 10005 | 10001 | 10001 | 10005 | 10006 | 10005 | 10001 | 10001 | 10005 | 10005 | 10001 | 10001 | 10005 | 10005 | 10001 | 10001 | 10005 | 10005 | 10001 | 10001 | 10005 | 10001 | 10001 | 10005 | 10005 | 10005 | 10001 | 10002 | 10001 | 10005 | 10006 | 10006 | 10002 | 10005 | 10001 | 10005 | 10001 | 10001 | 10005 | 10002 | 10006 | 10005 | 10001 | 10006 | 10005 | 10001 | 10001 | 10005 | 10006 | 10002 | 10001 | 10005 | 10001 | 10005 | 10005 | 10001 | 10001 | 10006 | 10005 | 10002 | 10001 | 10001 | 10001 | 10002 | 10005 | 10001 | 10005 | 10006 | 10001 | 10001 | 10001 | 10001 | 10005 | 10005 | 10005 | 10005 | 10005 | 10001 | 10005 | 10001 | 10001 | 10005 | 10001 | 10005 | 10006 | 10005 | 10001 | 10006 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 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 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
session_id | 1979 | 1979 | 1979 | 1985 | 1985 | 1985 | 1985 | 1985 | 1985 | 1985 | 1987 | 1985 | 1987 | 1987 | 1987 | 1987 | 1987 | 1987 | 1987 | 1987 | 1987 | 1987 | 1989 | 1991 | 1991 | 1991 | 1979 | 1985 | 1991 | 2003 | 2005 | 2005 | 2003 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2007 | 2007 | 2013 | 2013 | 2015 | 2015 | 2013 | 2015 | 2015 | 2013 | 2013 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2013 | 2013 | 2011 | 2011 | 2013 | 2011 | 2011 | 2011 | 2011 | 2011 | 2013 | 2013 | 2013 | 2011 | 2011 | 2015 | 2019 | 2017 | 2017 | 2019 | 2017 | 2019 | 2019 | 2019 | 2019 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2017 | 2017 | 2017 | 2021 | 2021 | 2021 | 2021 | 2021 | 2019 | 2019 | 2019 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
user_id | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | KLARRY | GKURIMOT | KLARRY | KVOONG1 | KLARRY | KLARRY | TTHAM | * | GPEREZ | GKURIMOT | DHORRELL | DHORRELL | EMCENTEE | * | DHORRELL | CFLAGG | GPEREZ | * | * | * | * | * | * | GPEREZ | * | LHOANG | LHOANG | CFLAGG | * | CFLAGG | GPEREZ | * | MDIGRAZIA | MDIGRAZIA | SARRIAGA | MPACHECO | RGEREMIA | CAFILER | CAFILER | MDIGRAZIA | TRAMON | RGEREMIA | * | * | CFLAGG | GPEREZ | * | * | TMILLER | NWALKER | TMILLER | * | RGEREMIA | TMILLER | DHORRELL | * | JVAZQUEZ | * | CPON | SARRIAGA | CPON | CPON | CPON | * | MMORENO | MMORENO | MPACHECO | JVAZQUEZ | * | CPON | SMCCONNAN | SMCCONNAN | CPON | SMCCONNAN | SMCCONNAN | * | MPACHECO | MMORENO | MMORENO | TRAMON | CPON | CPON | SARRIAGA | SARRIAGA | MPACHECO | CAFILER | CPON | MPACHECO | MDIGRAZIA | MPACHECO | CPON | RGEREMIA | CAFILER | MPACHECO | MPACHECO | CAFILER | CAFILER | MDIGRAZIA | CAFILER | TRAMON | MPACHECO | MDIGRAZIA | SARRIAGA | LPALMER | LPHEAV | LPHEAV | LPHEAV | LPHEAV | LPHEAV | LPHEAV | LPHEAV | LPHEAV | SMCCONNAN | SMCCONNAN | SMCCONNAN | GCLARA | SARRIAGA | SARRIAGA | RPOOJA | RPOOJA | RSAGARIO | KRUSSELL | RGEREMIA | IMEDINA | CAFILER | CAFILER | LPHEAV | LPHEAV | DCODY | DCODY | DCODY | RGEREMIA | DCODY | DCODY | DCODY | DCODY | DCODY | JMAVES | RBURMEISTER | CAFILER | CAFILER | RGEREMIA | CAFILER | CAFILER | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
special_audit | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 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 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_start | None | 1979-09-25 00:00:00 | 1980-01-01 00:00:00 | 1985-01-01 00:00:00 | 1985-07-01 00:00:00 | 1985-01-01 00:00:00 | 1986-01-01 00:00:00 | 1986-10-01 00:00:00 | 1986-07-01 00:00:00 | 1986-10-19 00:00:00 | None | 1986-07-01 00:00:00 | 1987-01-01 00:00:00 | 1987-07-01 00:00:00 | 1987-07-01 00:00:00 | 1988-01-01 00:00:00 | 1988-07-01 00:00:00 | 1988-10-01 00:00:00 | 1988-10-22 00:00:00 | 1988-07-01 00:00:00 | 1988-01-01 00:00:00 | 1988-10-01 00:00:00 | 1989-10-22 00:00:00 | 1991-01-01 00:00:00 | None | None | 1980-07-01 00:00:00 | 1985-07-01 00:00:00 | None | 2005-01-01 00:00:00 | 2005-02-25 00:00:00 | 2005-01-01 00:00:00 | 2004-10-17 00:00:00 | 2004-07-01 00:00:00 | 2004-10-01 00:00:00 | None | 2005-10-31 00:00:00 | 2005-07-01 00:00:00 | 2004-10-16 00:00:00 | 2005-02-25 00:00:00 | 2005-07-01 00:00:00 | 2005-10-31 00:00:00 | 2005-01-01 00:00:00 | 2005-07-01 00:00:00 | 2006-02-26 00:00:00 | 2006-01-01 00:00:00 | 2006-01-01 00:00:00 | 2006-02-26 00:00:00 | 2006-05-26 00:00:00 | 2006-03-26 00:00:00 | 2006-07-01 00:00:00 | 2006-10-01 00:00:00 | 2006-03-26 00:00:00 | 2006-07-01 00:00:00 | 2006-07-01 00:00:00 | 2006-10-01 00:00:00 | 2006-05-26 00:00:00 | 2006-10-22 00:00:00 | 2006-10-22 00:00:00 | 2007-01-01 00:00:00 | 2007-01-01 00:00:00 | 2013-01-01 00:00:00 | 2013-01-01 00:00:00 | 2015-04-05 00:00:00 | 2015-01-01 00:00:00 | 2014-07-01 00:00:00 | 2015-04-02 00:00:00 | 2015-01-01 00:00:00 | 2014-01-01 00:00:00 | None | 2008-01-01 00:00:00 | 2008-01-01 00:00:00 | 2007-10-01 00:00:00 | 2007-10-01 00:00:00 | 2007-07-01 00:00:00 | 2007-07-01 00:00:00 | 2008-04-01 00:00:00 | 2008-07-01 00:00:00 | 2008-04-01 00:00:00 | 2008-07-01 00:00:00 | 2008-10-01 00:00:00 | 2008-10-01 00:00:00 | None | 2008-11-02 00:00:00 | 2008-10-19 00:00:00 | 2008-10-19 00:00:00 | 2009-01-01 00:00:00 | 2009-07-01 00:00:00 | 2009-01-01 00:00:00 | 2009-07-01 00:00:00 | 2010-01-01 00:00:00 | 2010-01-01 00:00:00 | 2010-01-01 00:00:00 | 2010-03-30 00:00:00 | 2010-03-30 00:00:00 | 2010-02-28 00:00:00 | 2010-01-01 00:00:00 | 2010-02-28 00:00:00 | 2010-07-01 00:00:00 | 2010-10-01 00:00:00 | 2010-10-01 00:00:00 | 2010-07-01 00:00:00 | 2010-10-17 00:00:00 | 2010-10-17 00:00:00 | 2010-10-01 00:00:00 | 2010-10-01 00:00:00 | 2011-01-01 00:00:00 | 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 | 2012-01-01 00:00:00 | 2012-01-01 00:00:00 | 2012-03-18 00:00:00 | 2013-07-01 00:00:00 | 2013-07-01 00:00:00 | 2012-07-01 00:00:00 | 2012-03-18 00:00:00 | 2014-07-01 00:00:00 | 2012-07-01 00:00:00 | 2012-07-01 00:00:00 | 2012-10-01 00:00:00 | 2012-07-01 00:00:00 | 2012-10-01 00:00:00 | 2014-01-01 00:00:00 | 2014-09-25 00:00:00 | 2014-09-25 00:00:00 | 2012-10-20 00:00:00 | 2012-10-20 00:00:00 | 2015-04-05 00:00:00 | None | 2018-07-01 00:00:00 | 2017-07-01 00:00:00 | 2019-01-01 00:00:00 | 2018-01-01 00:00:00 | 2019-01-01 00:00:00 | 2018-07-01 00:00:00 | 2018-01-01 00:00:00 | 2017-07-01 00:00:00 | 2015-07-01 00:00:00 | 2015-07-01 00:00:00 | 2016-01-01 00:00:00 | 2016-01-01 00:00:00 | 2016-07-01 00:00:00 | 2016-07-01 00:00:00 | 2017-01-01 00:00:00 | 2017-01-01 00:00:00 | None | 2022-01-01 00:00:00 | 2022-01-01 00:00:00 | None | 2022-04-24 00:00:00 | 2022-07-01 00:00:00 | 2019-07-01 00:00:00 | 2020-01-01 00:00:00 | 2020-07-01 00:00:00 | 2021-01-01 00:00:00 | 2021-07-01 00:00:00 | 2022-04-26 00:00:00 | 2019-07-01 00:00:00 | 2020-01-01 00:00:00 | 2020-07-01 00:00:00 | 2021-01-01 00:00:00 | 2021-07-01 00:00:00 | 2022-04-24 00:00:00 | 2022-09-25 00:00:00 | 2022-10-24 00:00:00 | 2022-10-18 00:00:00 | 2022-07-01 00:00:00 | 2022-09-25 00:00:00 | 2022-10-07 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_end | None | 1979-12-31 00:00:00 | 1980-06-30 00:00:00 | 1985-06-30 00:00:00 | 1985-12-30 00:00:00 | 1985-06-30 00:00:00 | 1986-06-30 00:00:00 | 1986-10-18 00:00:00 | 1986-09-30 00:00:00 | 1986-12-31 00:00:00 | None | 1986-09-30 00:00:00 | 1987-06-30 00:00:00 | 1987-12-31 00:00:00 | 1987-12-30 00:00:00 | 1988-06-30 00:00:00 | 1988-09-30 00:00:00 | 1988-10-21 00:00:00 | 1988-12-31 00:00:00 | 1988-09-30 00:00:00 | 1988-06-30 00:00:00 | 1988-10-22 00:00:00 | 1989-12-31 00:00:00 | 1991-06-30 00:00:00 | None | None | 1980-01-21 00:00:00 | 1985-12-30 00:00:00 | None | 2005-02-24 00:00:00 | 2005-06-30 00:00:00 | 2005-02-24 00:00:00 | 2004-12-31 00:00:00 | 2004-09-30 00:00:00 | 2004-10-16 00:00:00 | None | 2005-12-31 00:00:00 | 2005-10-30 00:00:00 | 2004-12-31 00:00:00 | 2005-06-30 00:00:00 | 2005-10-30 00:00:00 | 2005-12-31 00:00:00 | 2005-02-24 00:00:00 | 2005-10-30 00:00:00 | 2006-03-25 00:00:00 | 2006-02-25 00:00:00 | 2006-02-25 00:00:00 | 2006-03-25 00:00:00 | 2006-07-30 00:00:00 | 2006-05-25 00:00:00 | 2006-09-30 00:00:00 | 2006-10-21 00:00:00 | 2006-05-25 00:00:00 | 2006-09-30 00:00:00 | 2006-09-30 00:00:00 | 2006-10-21 00:00:00 | 2006-07-30 00:00:00 | 2006-12-31 00:00:00 | 2006-12-31 00:00:00 | 2007-06-30 00:00:00 | 2007-06-30 00:00:00 | 2013-06-30 00:00:00 | 2013-06-30 00:00:00 | 2015-06-30 00:00:00 | 2015-04-04 00:00:00 | 2014-12-31 00:00:00 | 2015-04-02 00:00:00 | 2015-04-04 00:00:00 | 2014-06-30 00:00:00 | None | 2008-03-31 00:00:00 | 2008-03-31 00:00:00 | 2007-12-31 00:00:00 | 2007-12-31 00:00:00 | 2007-09-30 00:00:00 | 2007-09-30 00:00:00 | 2008-06-30 00:00:00 | 2008-09-30 00:00:00 | 2008-06-30 00:00:00 | 2008-09-30 00:00:00 | 2008-10-18 00:00:00 | 2008-10-18 00:00:00 | None | 2008-11-02 00:00:00 | 2008-12-31 00:00:00 | 2008-12-31 00:00:00 | 2009-07-18 00:00:00 | 2009-12-31 00:00:00 | 2009-07-18 00:00:00 | 2009-12-31 00:00:00 | 2010-02-27 00:00:00 | 2010-02-27 00:00:00 | 2010-02-27 00:00:00 | 2010-06-30 00:00:00 | 2010-06-30 00:00:00 | 2010-06-30 00:00:00 | 2010-02-27 00:00:00 | 2010-06-30 00:00:00 | 2010-09-30 00:00:00 | 2010-10-16 00:00:00 | 2010-10-16 00:00:00 | 2010-09-30 00:00:00 | 2010-12-31 00:00:00 | 2010-12-31 00:00:00 | 2010-10-16 00:00:00 | 2010-10-16 00:00:00 | 0211-06-30 00:00:00 | 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 | 2012-03-17 00:00:00 | 2012-03-17 00:00:00 | 2012-06-30 00:00:00 | 2013-12-31 00:00:00 | 2013-12-31 00:00:00 | 2012-09-30 00:00:00 | 2012-06-30 00:00:00 | 2014-12-31 00:00:00 | 2012-09-30 00:00:00 | 2012-09-30 00:00:00 | 2012-10-20 00:00:00 | 2012-09-30 00:00:00 | 2012-10-20 00:00:00 | 2014-06-30 00:00:00 | 2014-09-25 00:00:00 | 2014-09-25 00:00:00 | 2012-12-31 00:00:00 | 2012-12-31 00:00:00 | 2015-06-30 00:00:00 | None | 2018-12-31 00:00:00 | 2017-12-31 00:00:00 | 2019-06-30 00:00:00 | 2018-06-30 00:00:00 | 2019-06-30 00:00:00 | 2018-12-31 00:00:00 | 2018-06-30 00:00:00 | 2017-12-31 00:00:00 | 2015-12-31 00:00:00 | 2015-12-31 00:00:00 | 2016-06-30 00:00:00 | 2016-06-30 00:00:00 | 2016-12-31 00:00:00 | 2016-12-31 00:00:00 | 2017-06-30 00:00:00 | 2017-06-30 00:00:00 | None | 2022-04-23 00:00:00 | 2022-04-23 00:00:00 | None | 2022-06-30 00:00:00 | 2022-09-24 00:00:00 | 2019-12-31 00:00:00 | 2020-06-30 00:00:00 | 2020-12-31 00:00:00 | 2021-06-30 00:00:00 | 2021-12-31 00:00:00 | 2022-04-26 00:00:00 | 2019-12-31 00:00:00 | 2020-06-30 00:00:00 | 2020-12-31 00:00:00 | 2021-06-30 00:00:00 | 2021-12-31 00:00:00 | 2022-06-30 00:00:00 | 2022-10-19 00:00:00 | 2022-10-24 00:00:00 | 2022-10-18 00:00:00 | 2022-09-30 00:00:00 | 2022-10-19 00:00:00 | 2022-10-07 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_date | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 2006-01-26 00:00:00 | None | None | 2006-01-01 00:00:00 | 2006-01-01 00:00:00 | None | 2005-12-30 00:00:00 | None | None | None | 2006-02-28 00:00:00 | 2006-03-28 00:00:00 | 2006-07-24 00:00:00 | 2006-05-25 00:00:00 | 2006-10-02 00:00:00 | 2006-10-24 00:00:00 | None | 2006-10-05 00:00:00 | None | None | None | 2007-01-26 00:00:00 | None | None | 2007-07-23 00:00:00 | 2013-07-29 00:00:00 | None | 2015-07-31 00:00:00 | None | None | 2015-04-02 00:00:00 | 2015-04-07 00:00:00 | None | None | None | 2008-04-28 00:00:00 | 2008-01-27 00:00:00 | None | None | 2007-10-31 00:00:00 | 2008-07-31 00:00:00 | None | None | 2008-10-05 00:00:00 | 2008-10-22 00:00:00 | None | None | 2008-11-02 00:00:00 | 2009-02-01 00:00:00 | None | 2009-07-29 00:00:00 | 2010-01-28 00:00:00 | None | None | None | 2010-03-02 00:00:00 | 2010-03-30 00:00:00 | 2010-08-01 00:00:00 | None | None | None | 2010-08-28 00:00:00 | None | 2010-10-20 00:00:00 | None | 2010-10-05 00:00:00 | 2011-02-01 00:00:00 | None | 2011-06-13 00:00:00 | None | None | 2011-08-01 00:00:00 | None | None | 2012-01-25 00:00:00 | 2012-03-21 00:00:00 | None | None | 2012-05-21 00:00:00 | 2012-07-29 00:00:00 | None | 2014-01-26 00:00:00 | None | None | 2015-01-26 00:00:00 | 2012-10-02 00:00:00 | None | None | 2012-10-21 00:00:00 | 2012-10-24 00:00:00 | 2014-09-25 00:00:00 | None | None | None | 2013-01-24 00:00:00 | None | None | 2019-11-24 00:00:00 | 2019-11-24 00:00:00 | 2019-11-24 00:00:00 | 2019-11-24 00:00:00 | None | None | None | None | None | 2016-02-04 00:00:00 | None | 2016-08-01 00:00:00 | 2017-01-29 00:00:00 | None | 2017-07-30 00:00:00 | None | None | None | 2022-04-26 00:00:00 | None | 2022-07-13 00:00:00 | 2022-09-24 00:00:00 | 2022-02-07 00:00:00 | 2022-02-07 00:00:00 | 2022-02-07 00:00:00 | 2022-02-07 00:00:00 | 2022-02-07 00:00:00 | 2022-04-26 00:00:00 | None | None | None | None | None | None | None | 2022-10-24 00:00:00 | 2022-10-18 00:00:00 | None | 2022-10-22 00:00:00 | 2022-10-07 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 | None | None | 22006 | None | None | 22006 | 22006 | None | 22006 | None | None | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | None | None | None | 22006 | None | None | 22006 | 22006 | None | 22001 | None | None | 22001 | 22001 | None | None | None | 22006 | 22006 | None | None | 22006 | 22006 | None | None | 22006 | 22006 | None | None | 22006 | 22006 | None | 22006 | 22006 | None | None | None | 22006 | 22006 | 22006 | None | None | None | 22006 | None | 22006 | None | 22006 | 22006 | None | 22006 | None | None | 22006 | None | None | 22006 | 22006 | None | None | 22006 | 22006 | None | 22006 | None | None | 22001 | 22006 | None | None | 22006 | 22006 | 22001 | 22001 | 22001 | None | 22006 | None | None | 22001 | 22001 | 22001 | 22001 | None | None | None | None | None | 22001 | None | 22001 | 22001 | None | 22001 | None | None | None | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | None | None | None | None | None | None | 22001 | 22001 | None | 22001 | 22001 |
filer_id | 1027516 | 1027516 | 1027516 | |||
---|---|---|---|---|---|---|
filer_type | 16 | 16 | 16 | |||
active | Y | Y | Y | |||
race | 0 | 0 | 0 | |||
session_id | 1979 | 1991 | 2005 | |||
category | 0 | 0 | 0 | |||
category_type | 40501 | 40503 | 40502 | |||
sub_category | 0 | 40103 | 40104 | |||
effect_dt | 1990-12-01 00:00:00 | 1992-03-30 00:00:00 | 2005-06-29 00:00:00 | |||
sub_category_type | 0 | 0 | 0 | |||
election_type | 0 | 0 | 0 | |||
sub_category_a | None | None | None | |||
nyq_dt | 1979-10-16 00:00:00 | 1979-10-16 00:00:00 | 1979-10-16 00:00:00 | |||
party_cd | None | None | 16002 | |||
county_cd | 18009 | 18017 | 18017 | |||
district_cd | None | None | None |
filer_id | 1027516 | |
---|---|---|
xref_id | 791662 | |
effect_dt | 1999-12-07 00:00:00 | |
migration_source | IDENTFIX |
xref_filer_id | 791662 | 791662 | 791662 | 791662 | 791662 | 791662 | 791662 | 791662 | 791662 | 791662 | 791662 | 791662 | 791662 | 791662 | 791662 | 791662 | 791662 | 791662 | 791662 | 791662 | 791662 | 791662 | ||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_id | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | ||||||||||||||||||||||
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 | 2005-06-29 00:00:00 | 2005-06-29 00:00:00 | 2005-06-29 00:00:00 | 2005-06-29 00:00:00 | 2005-06-29 00:00:00 | 2005-06-29 00:00:00 | 2005-06-29 00:00:00 | 2005-06-29 00:00:00 | 2005-06-29 00:00:00 | 2005-06-29 00:00:00 | 2005-06-29 00:00:00 | 2005-06-29 00:00:00 | 2005-06-29 00:00:00 | 2005-06-29 00:00:00 | 2005-06-29 00:00:00 | 2005-06-29 00:00:00 | 2005-06-29 00:00:00 | 2005-06-29 00:00:00 | 2005-06-29 00:00:00 | 2005-06-29 00:00:00 | 2005-06-29 00:00:00 | 2005-06-29 00:00:00 | ||||||||||||||||||||||
naml | EL DORADO COUNTY REPUBLICAN CENTRAL COMMITTEE (STATE) | EL DORADO COUNTY REPUBLICAN CENTRAL COMMITTEE (STATE) | EL DORADO COUNTY REPUBLICAN CENTRAL COMMITTEE (STATE) | EL DORADO COUNTY REPUBLICAN CENTRAL COMMITTEE (STATE) | EL DORADO COUNTY REPUBLICAN CENTRAL COMMITTEE (STATE) | EL DORADO COUNTY REPUBLICAN CENTRAL COMMITTEE (STATE) | EL DORADO COUNTY REPUBLICAN CENTRAL COMMITTEE (STATE) | EL DORADO COUNTY REPUBLICAN CENTRAL COMMITTEE (STATE) | EL DORADO COUNTY REPUBLICAN CENTRAL COMMITTEE (STATE) | EL DORADO COUNTY REPUBLICAN CENTRAL COMMITTEE (STATE) | EL DORADO COUNTY REPUBLICAN CENTRAL COMMITTEE (STATE) | EL DORADO COUNTY REPUBLICAN CENTRAL COMMITTEE | EL DORADO COUNTY REPUBLICAN CENTRAL COMMITTEE | EL DORADO COUNTY REPUBLICAN CENTRAL COMMITTEE | EL DORADO COUNTY REPUBLICAN CENTRAL COMMITTEE | EL DORADO COUNTY REPUBLICAN CENTRAL COMMITTEE | EL DORADO COUNTY REPUBLICAN CENTRAL COMMITTEE | EL DORADO COUNTY REPUBLICAN CENTRAL COMMITTEE | EL DORADO COUNTY REPUBLICAN CENTRAL COMMITTEE | EL DORADO COUNTY REPUBLICAN CENTRAL COMMITTEE | EL DORADO COUNTY REPUBLICAN CENTRAL COMMITTEE | EL DORADO COUNTY REPUBLICAN CENTRAL COMMITTEE | ||||||||||||||||||||||
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 | SHINGLE SPRINGS | SHINGLE SPRINGS | SHINGLE SPRINGS | RESCUE | SHINGLE SPRINGS | EL DORADO HILLS | EL DORADO HILLS | CAMERON PARK | SHINGLE SPRINGS | CAMERON PARK | SHINGLE SPRINGS | SHINGLE SPRINGS | SHINGLE SPRINGS | SHINGLE SPRINGS | RESCUE | SHINGLE SPRINGS | EL DORADO HILLS | EL DORADO HILLS | CAMERON PARK | SHINGLE SPRINGS | CAMERON PARK | SHINGLE SPRINGS | ||||||||||||||||||||||
st | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | ||||||||||||||||||||||
zip4 | 956820000 | 956820000 | 956820000 | 95672 | 95682 | 957624137 | 957624137 | 95682 | 95682 | 95682 | 95682 | 956820000 | 956820000 | 956820000 | 95672 | 95682 | 957624137 | 957624137 | 95682 | 95682 | 95682 | 95682 | ||||||||||||||||||||||
phon | 9166771453 | 9166771453 | 5306771453 | 5304170807 | 5304170807 | 5304170807 | 9166280963 | 9166737019 | 9166737019 | 9166737019 | 9166771453 | 9166771453 | 5306771453 | 5304170807 | 5304170807 | 5304170807 | 9166280963 | 9166737019 | 9166737019 | 9166737019 | ||||||||||||||||||||||||
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 | [email protected] | [email protected] | [email protected] | None | [email protected] | [email protected] | None | None | None | None | None | [email protected] | [email protected] | [email protected] | None | [email protected] | [email protected] |
filer_id | 1027516 |
---|
filer_id | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | 1027516 | ||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_file_name | 1955822_0.cal | 54626.cal | 2730252_0.cal | 411335.cal | 2735486_0.cal | 2670713_0.cal | ||||||
received_date | 2015-04-02 00:00:00 | 2017-07-30 00:00:00 | 2022-10-07 00:00:00 | 2022-02-07 00:00:00 | 2022-10-18 00:00:00 | 2022-04-26 00:00:00 | ||||||
filing_directory | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | ||||||
filing_id | 1955822 | None | 2730252 | None | 2735486 | 2670713 | ||||||
form_id | F497 | None | F497 | None | F497 | F497 | ||||||
receive_comment | Filing accepted | Filing passed validation, but failed DB constraints | Filing accepted | Filing passed validation, but failed DB constraints | Filing accepted | Filing accepted |