acronym | TDIC | |
---|---|---|
filer_id | 1010544 |
filer_id | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
adrid | 1009850 | 2079404 | 2097054 | 2103331 | 2117344 | 2132558 | 2130186 | 2159364 | 2142860 | 2169077 | 2202321 | |||||||||||
effect_dt | 1990-12-01 00:00:00 | 2005-01-06 00:00:00 | 2006-01-17 00:00:00 | 2006-04-14 00:00:00 | 2007-01-31 00:00:00 | 2008-03-25 00:00:00 | 2007-10-30 00:00:00 | 2009-02-02 00:00:00 | 2008-07-28 00:00:00 | 2009-06-02 00:00:00 | 2010-10-21 00:00:00 | |||||||||||
add_type | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | |||||||||||
session_id | 1989 | 2005 | 2005 | 2005 | 2005 | 2007 | 2007 | 2009 | 2007 | 2009 | 2009 |
filer_id | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 66156 | 66157 | 66158 | 66159 | 66160 | 66143 | 66144 | 66145 | 66146 | 66147 | 66148 | 66149 | 66150 | 66151 | 66152 | 66153 | 66154 | 66155 | 203689 | 203690 | 578842 | 717786 | 747760 | 804607 | 829929 | 858185 | 855123 | 917314 | 911146 | 965784 | 1006705 | 1020975 | 1027508 | 1038528 | 1053510 | 1056466 | 1070458 | 1099985 | 1115427 | 1121166 | 1142629 | 1173656 | 1187282 | 1173456 | 1187142 | 1201220 | 1179866 | 1211514 | 1253483 | 1234253 | 1272639 | 1308501 | 1781911 | 1787254 | 1980085 | 1870967 | 1855714 | 1943241 | 1907784 | 1878385 | 1905566 | 1296502 | 1320128 | 1300499 | 1322560 | 1315653 | 1347382 | 1355073 | 1397119 | 1402358 | 1423744 | 1425384 | 1423798 | 1425324 | 1425324 | 1437178 | 1425384 | 1463439 | 1443602 | 1469664 | 1474218 | 1491006 | 1495453 | 1503276 | 1511665 | 1530331 | 1544144 | 1543770 | 1538956 | 1546370 | 1539083 | 1546232 | 1537133 | 1571142 | 1576069 | 1609893 | 1606266 | 1639095 | 1634791 | 1678857 | 1829395 | 1831382 | 1816139 | 1822443 | 1682471 | 1934801 | 1885056 | 1887804 | 1745042 | 1738100 | 1843767 | 1837640 | 1838319 | 1984335 | 2209041 | 2247778 | 2439442 | 2228927 | 2461296 | 2455176 | 2288314 | 2289180 | 2293704 | 2281683 | 2387076 | 2393767 | 2367477 | 2009934 | 2017148 | 2030337 | 2027032 | 2026683 | 2060973 | 2071446 | 2074335 | 2070583 | 2091754 | 2082470 | 2128474 | 2134222 | 2172494 | 2179439 | 2505300 | 2225169 | 2394001 | 2426007 | 2345699 | 2534812 | 2568399 | 2273754 | 2599762 | 2455879 | 2269424 | 2311888 | 2464269 | 2226094 | 2262415 | 2300736 | 2548757 | 2666673 | 2484449 | 2667968 | 2703107 | 2640448 | 2609421 | 2687958 | 2714367 | 2722579 | 2729394 | 2735637 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
period_id | 147 | 153 | 155 | 158 | 159 | 103 | 103 | 106 | 105 | 107 | 116 | 113 | 129 | 131 | 131 | 133 | 137 | 141 | 145 | 157 | None | 163 | None | 165 | None | None | 169 | None | 171 | None | None | None | 177 | None | 180 | None | 179 | None | 181 | None | 183 | 186 | None | 185 | 186 | None | None | 188 | None | 187 | None | 192 | 213 | None | 221 | 217 | 218 | None | 220 | None | 220 | 189 | 193 | None | None | None | 193 | None | 195 | None | 198 | None | None | 197 | 197 | 198 | None | 199 | None | None | 201 | 201 | None | 202 | None | 204 | None | None | 204 | None | 204 | None | 204 | 203 | None | None | 205 | None | 207 | 209 | 217 | 217 | 215 | None | None | 219 | 219 | 219 | None | 211 | 218 | 218 | 218 | None | 231 | 234 | 239 | 234 | 241 | 241 | None | 235 | 235 | 235 | 238 | 237 | None | 223 | None | 226 | 226 | 226 | 225 | 227 | 227 | None | 228 | 227 | 227 | None | 229 | None | 243 | None | None | 240 | 235 | None | None | 233 | 245 | 241 | 235 | 236 | None | 233 | 235 | 236 | 243 | 250 | 241 | None | 249 | 247 | None | 250 | None | 251 | 252 | 252 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F461 | F461 | F461 | F461 | F461 | F461 | F405 | F777 | F461 | F461 | F777 | F461 | F461 | F461 | F461 | F461 | F461 | F461 | F461 | F461 | F461 | F461 | F461 | F461 | F461 | F461 | F461 | F461 | F461 | F461 | F461 | F461 | F461 | F461 | F497 | F497 | F461 | F461 | F461 | F461 | F461 | F497 | F461 | F461 | F461 | F461 | F461 | F497 | F461 | F461 | F497 | F461 | F461 | F461 | F461 | F461 | F497 | F461 | F497 | F461 | F497 | F461 | F461 | F461 | F461 | F461 | F461 | F461 | F461 | F461 | F497 | F461 | F497 | F461 | F461 | F461 | F461 | F461 | F461 | F461 | F461 | F461 | F461 | F461 | F461 | F497 | F497 | F497 | F497 | F497 | F497 | F497 | F497 | F461 | F461 | F461 | F461 | F461 | F461 | F461 | F497 | F497 | F461 | F461 | F461 | F461 | F497 | F497 | F461 | F461 | F497 | F497 | F497 | F461 | F461 | F497 | F461 | F497 | F497 | F497 | F461 | F497 | F497 | F497 | F497 | F461 | F461 | F461 | F461 | F497 | F497 | F497 | F461 | F497 | F497 | F461 | F497 | F497 | F461 | F461 | F461 | F461 | F497 | F461 | F461 | F497 | F461 | F461 | F461 | F461 | F461 | F497 | F497 | F497 | F461 | F497 | F497 | F497 | F461 | F497 | F461 | F461 | F461 | F461 | F461 | F497 | F461 | F497 | F497 | 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 | 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 | 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 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_date | 1997-01-31 00:00:00 | 1998-10-14 00:00:00 | 1999-02-01 00:00:00 | 1999-07-28 00:00:00 | 1999-10-07 00:00:00 | 1986-01-31 00:00:00 | 1986-04-21 00:00:00 | 1986-05-27 00:00:00 | 1986-07-03 00:00:00 | 1987-02-02 00:00:00 | 1988-10-31 00:00:00 | 1989-01-30 00:00:00 | 1992-07-06 00:00:00 | 1992-10-01 00:00:00 | 1993-02-01 00:00:00 | 1993-07-20 00:00:00 | 1994-07-08 00:00:00 | 1995-07-28 00:00:00 | 1996-07-31 00:00:00 | 1999-04-29 00:00:00 | 2000-01-07 00:00:00 | 2001-01-30 00:00:00 | 2001-01-31 00:00:00 | 2002-01-10 00:00:00 | 2002-01-10 00:00:00 | 2002-07-31 00:00:00 | 2002-07-30 00:00:00 | 2003-01-31 00:00:00 | 2003-01-30 00:00:00 | 2003-10-10 00:00:00 | 2004-01-12 00:00:00 | 2000-07-20 00:00:00 | 2004-07-28 00:00:00 | 2004-08-02 00:00:00 | 2004-10-25 00:00:00 | 2004-10-25 00:00:00 | 2005-01-07 00:00:00 | 2005-01-31 00:00:00 | 2005-07-27 00:00:00 | 2005-08-01 00:00:00 | 2006-01-19 00:00:00 | 2006-05-24 00:00:00 | 2006-05-25 00:00:00 | 2006-05-24 00:00:00 | 2006-07-25 00:00:00 | 2006-07-31 00:00:00 | 2006-01-31 00:00:00 | 2006-10-25 00:00:00 | 2007-01-31 00:00:00 | 2007-01-29 00:00:00 | 2006-10-25 00:00:00 | 2008-01-29 00:00:00 | 2013-07-31 00:00:00 | 2013-07-31 00:00:00 | 2015-07-30 00:00:00 | 2014-07-31 00:00:00 | 2014-05-28 00:00:00 | 2015-01-30 00:00:00 | 2014-10-28 00:00:00 | 2014-07-31 00:00:00 | 2014-10-24 00:00:00 | 2007-10-30 00:00:00 | 2008-03-24 00:00:00 | 2007-10-31 00:00:00 | 2008-03-25 00:00:00 | 2008-02-01 00:00:00 | 2008-07-28 00:00:00 | 2008-07-31 00:00:00 | 2009-02-02 00:00:00 | 2009-02-02 00:00:00 | 2009-05-12 00:00:00 | 2009-06-02 00:00:00 | 2009-05-12 00:00:00 | 2009-06-02 00:00:00 | 2009-07-30 00:00:00 | 2009-07-30 00:00:00 | 2009-08-03 00:00:00 | 2010-01-29 00:00:00 | 2009-07-31 00:00:00 | 2010-02-01 00:00:00 | 2010-03-22 00:00:00 | 2010-05-27 00:00:00 | 2010-05-27 00:00:00 | 2010-07-26 00:00:00 | 2010-08-02 00:00:00 | 2010-10-20 00:00:00 | 2010-10-29 00:00:00 | 2010-10-20 00:00:00 | 2010-10-29 00:00:00 | 2010-10-29 00:00:00 | 2010-10-29 00:00:00 | 2010-10-27 00:00:00 | 2010-10-27 00:00:00 | 2011-01-31 00:00:00 | 2011-01-31 00:00:00 | 2011-07-29 00:00:00 | 2011-07-29 00:00:00 | 2012-01-31 00:00:00 | 2012-01-30 00:00:00 | 2012-07-31 00:00:00 | 2014-03-17 00:00:00 | 2014-03-21 00:00:00 | 2014-01-30 00:00:00 | 2014-01-31 00:00:00 | 2012-07-31 00:00:00 | 2015-01-30 00:00:00 | 2014-09-12 00:00:00 | 2014-09-23 00:00:00 | 2013-01-31 00:00:00 | 2013-01-31 00:00:00 | 2014-04-29 00:00:00 | 2014-04-10 00:00:00 | 2014-04-14 00:00:00 | 2015-07-31 00:00:00 | 2018-01-30 00:00:00 | 2018-05-09 00:00:00 | 2020-01-30 00:00:00 | 2018-04-06 00:00:00 | 2020-03-04 00:00:00 | 2020-02-20 00:00:00 | 2018-07-31 00:00:00 | 2018-09-05 00:00:00 | 2018-09-20 00:00:00 | 2018-08-09 00:00:00 | 2019-06-20 00:00:00 | 2019-07-26 00:00:00 | 2019-01-31 00:00:00 | 2016-01-29 00:00:00 | 2016-01-29 00:00:00 | 2016-04-20 00:00:00 | 2016-04-08 00:00:00 | 2016-04-07 00:00:00 | 2016-07-29 00:00:00 | 2016-08-24 00:00:00 | 2016-09-06 00:00:00 | 2016-07-29 00:00:00 | 2016-10-19 00:00:00 | 2016-09-28 00:00:00 | 2017-01-31 00:00:00 | 2017-01-31 00:00:00 | 2017-07-27 00:00:00 | 2017-07-28 00:00:00 | 2020-09-24 00:00:00 | 2018-01-31 00:00:00 | 2019-07-26 00:00:00 | 2019-12-20 00:00:00 | 2019-01-30 00:00:00 | 2020-07-31 00:00:00 | 2021-01-29 00:00:00 | 2018-07-31 00:00:00 | 2021-07-29 00:00:00 | 2020-02-21 00:00:00 | 2018-07-25 00:00:00 | 2018-10-24 00:00:00 | 2020-01-30 00:00:00 | 2018-03-28 00:00:00 | 2018-07-03 00:00:00 | 2018-10-03 00:00:00 | 2021-01-28 00:00:00 | 2022-04-15 00:00:00 | 2020-07-30 00:00:00 | 2022-01-28 00:00:00 | 2022-07-28 00:00:00 | 2022-01-28 00:00:00 | 2021-07-30 00:00:00 | 2022-05-27 00:00:00 | 2022-07-29 00:00:00 | 2022-09-22 00:00:00 | 2022-10-06 00:00:00 | 2022-10-18 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 | 10005 | 10001 | 10005 | 10001 | 10005 | 10005 | 10001 | 10005 | 10001 | 10005 | 10005 | 10005 | 10001 | 10005 | 10001 | 10005 | 10001 | 10005 | 10001 | 10005 | 10001 | 10001 | 10005 | 10001 | 10001 | 10005 | 10005 | 10001 | 10005 | 10001 | 10005 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10005 | 10001 | 10005 | 10001 | 10001 | 10001 | 10005 | 10001 | 10005 | 10001 | 10001 | 10001 | 10005 | 10001 | 10005 | 10005 | 10001 | 10002 | 10001 | 10006 | 10001 | 10005 | 10005 | 10001 | 10001 | 10005 | 10001 | 10005 | 10001 | 10005 | 10005 | 10001 | 10005 | 10001 | 10005 | 10001 | 10001 | 10005 | 10005 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10005 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10005 | 10001 | 10005 | 10001 | 10005 | 10005 | 10001 | 10001 | 10005 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10005 | 10001 | 10005 | 10001 | 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 | 11003 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
session_id | 1995 | 1997 | 1997 | 1999 | 1999 | 1985 | 1985 | 1985 | 1985 | 1985 | 1987 | 1987 | 1991 | 1991 | 1991 | 1993 | 1993 | 1995 | 1995 | 1999 | 1999 | 1999 | 1999 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2007 | 2013 | 2013 | 2015 | 2013 | 2013 | 2013 | 2013 | 2013 | 2013 | 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 | 2009 | 2009 | 2009 | 2009 | 2009 | 2011 | 2011 | 2011 | 2011 | 2011 | 2013 | 2013 | 2013 | 2013 | 2011 | 2013 | 2013 | 2013 | 2011 | 2011 | 2013 | 2013 | 2013 | 2015 | 2017 | 2017 | 2019 | 2017 | 2019 | 2019 | 2017 | 2017 | 2017 | 2017 | 2019 | 2019 | 2019 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2017 | 2017 | 2019 | 2017 | 2019 | 2019 | 2017 | 2019 | 2021 | 2017 | 2021 | 2019 | 2017 | 2017 | 2019 | 2017 | 2017 | 2017 | 2019 | 2021 | 2019 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
user_id | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | BSMITH | * | MKIENG | * | YBONILLA | LTHIBAUL | * | LTHIBAUL | COMPLETED | DHORRELL | DHORRELL | KVANG | COMPLETED | DHORRELL | GKURIMOT | GPEREZ | COMPLETED | DHORRELL | * | DHORRELL | * | * | JMARTIN | * | * | JMARTIN | JINGRAM | DHORRELL | JMARTIN | * | RGEREMIA | SMCCABE | JINGRAM | JINGRAM | JINGRAM | JINGRAM | WBROWN | JINGRAM | WBROWN | JINGRAM | WBROWN | * | SMCCABE | SMCCABE | SMCCABE | SMCCABE | SMCCABE | SMCCABE | JINGRAM | JINGRAM | DHORRELL | JVAZQUEZ | GKURIMOT | * | * | JINGRAM | JVAZQUEZ | JINGRAM | JINGRAM | JINGRAM | * | JINGRAM | JINGRAM | JINGRAM | JINGRAM | CREYNOLDS | MPACHECO | MPACHECO | WBROWN | MPACHECO | WBROWN | MPACHECO | CREYNOLDS | JINGRAM | JINGRAM | JINGRAM | JINGRAM | JINGRAM | JINGRAM | JINGRAM | WBROWN | WBROWN | JINGRAM | JINGRAM | JINGRAM | JINGRAM | WBROWN | WBROWN | JINGRAM | JINGRAM | WBROWN | WBROWN | WBROWN | JINGRAM | LPALMER | GTAYLOR | GTAYLOR | GTAYLOR | CAFILER | CAFILER | GTAYLOR | CAFILER | CAFILER | CAFILER | CAFILER | GTAYLOR | GTAYLOR | JINGRAM | JINGRAM | KBANH | KBANH | KBANH | JINGRAM | GCLARA | RGEREMIA | JINGRAM | PDEO | PDEO | JINGRAM | JINGRAM | RGEREMIA | RGEREMIA | CAFILER | LPALMER | GTAYLOR | CAFILER | GTAYLOR | GTAYLOR | GTAYLOR | GTAYLOR | GTAYLOR | CAFILER | RGEREMIA | CAFILER | GTAYLOR | GTAYLOR | KBANH | CAFILER | GTAYLOR | CAFILER | GTAYLOR | GTAYLOR | GTAYLOR | GTAYLOR | GTAYLOR | CAFILER | GTAYLOR | CAFILER | CAFILER | CAFILER | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
special_audit | 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 | 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 | 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 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_start | 1996-07-01 00:00:00 | 1998-01-01 00:00:00 | 1998-07-01 00:00:00 | 1999-04-01 00:00:00 | 1999-07-01 00:00:00 | 1985-07-01 00:00:00 | 1985-07-01 00:00:00 | None | 1986-01-01 00:00:00 | 1986-07-01 00:00:00 | None | 1988-01-01 00:00:00 | 1992-01-01 00:00:00 | 1992-07-01 00:00:00 | 1992-07-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 | 1999-01-01 00:00:00 | 1999-10-01 00:00:00 | 2000-07-01 00:00:00 | 2000-07-01 00:00:00 | 2001-01-01 00:00:00 | 2001-01-01 00:00:00 | 2002-01-01 00:00:00 | 2002-01-01 00:00:00 | 2002-07-01 00:00:00 | 2002-07-01 00:00:00 | 2003-01-01 00:00:00 | 2003-10-01 00:00:00 | 2000-01-01 00:00:00 | 2004-01-01 00:00:00 | 2004-01-01 00:00:00 | 2004-10-25 00:00:00 | None | 2004-07-01 00:00:00 | 2004-07-01 00:00:00 | 2005-01-01 00:00:00 | 2005-01-01 00:00:00 | 2005-07-01 00:00:00 | 2006-05-24 00:00:00 | 2006-01-01 00:00:00 | 2006-01-01 00:00:00 | 2006-05-21 00:00:00 | 2006-05-21 00:00:00 | 2005-07-01 00:00:00 | 2006-10-25 00:00:00 | 2006-07-01 00:00:00 | 2006-07-01 00:00:00 | None | 2007-10-01 00:00:00 | 2013-01-01 00:00:00 | 2013-01-01 00:00:00 | 2015-01-01 00:00:00 | 2014-01-01 00:00:00 | 2014-05-28 00:00:00 | 2014-07-01 00:00:00 | 2014-10-28 00:00:00 | 2014-01-01 00:00:00 | 2014-10-24 00:00:00 | 2007-01-01 00:00:00 | 2008-01-01 00:00:00 | 2007-01-01 00:00:00 | 2008-01-01 00:00:00 | 2007-10-01 00:00:00 | 2008-03-18 00:00:00 | 2008-03-18 00:00:00 | 2008-07-01 00:00:00 | 2008-07-01 00:00:00 | 2009-05-12 00:00:00 | 2009-01-01 00:00:00 | None | 2009-01-01 00:00:00 | 2009-01-01 00:00:00 | 2009-05-22 00:00:00 | 2009-01-01 00:00:00 | 2009-07-01 00:00:00 | 2009-05-22 00:00:00 | 2009-07-01 00:00:00 | 2010-01-01 00:00:00 | 2010-03-18 00:00:00 | 2010-03-18 00:00:00 | 2010-05-23 00:00:00 | 2010-05-23 00:00:00 | 2010-10-20 00:00:00 | None | None | 2010-10-29 00:00:00 | 2010-10-29 00:00:00 | 2010-10-29 00:00:00 | 2010-10-26 00:00:00 | 2010-10-27 00:00:00 | 2010-07-01 00:00:00 | 2010-07-01 00:00:00 | 2011-01-01 00:00:00 | 2011-01-01 00:00:00 | 2011-07-01 00:00:00 | 2011-07-01 00:00:00 | 2012-01-01 00:00:00 | 2014-03-17 00:00:00 | 2014-03-21 00:00:00 | 2013-07-01 00:00:00 | 2013-07-01 00:00:00 | 2012-01-01 00:00:00 | 2014-07-01 00:00:00 | 2014-09-12 00:00:00 | 2014-09-23 00:00:00 | 2012-07-01 00:00:00 | 2012-07-01 00:00:00 | 2014-04-29 00:00:00 | 2014-04-10 00:00:00 | 2014-04-14 00:00:00 | 2015-01-01 00:00:00 | 2017-07-01 00:00:00 | 2018-05-09 00:00:00 | 2019-07-01 00:00:00 | 2018-04-06 00:00:00 | 2020-03-04 00:00:00 | 2020-02-20 00:00:00 | 2018-01-01 00:00:00 | 2018-09-05 00:00:00 | 2018-09-20 00:00:00 | 2018-08-09 00:00:00 | 2019-06-20 00:00:00 | 2019-01-01 00:00:00 | 2018-07-01 00:00:00 | 2015-07-01 00:00:00 | 2015-07-01 00:00:00 | 2016-04-20 00:00:00 | 2016-04-08 00:00:00 | 2016-04-07 00:00:00 | 2016-01-01 00:00:00 | 2016-08-24 00:00:00 | 2016-09-06 00:00:00 | 2016-01-01 00:00:00 | 2016-10-19 00:00:00 | 2016-09-28 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 | 2020-09-24 00:00:00 | 2017-07-01 00:00:00 | 2019-01-01 00:00:00 | 2019-12-20 00:00:00 | 2018-07-01 00:00:00 | 2020-01-01 00:00:00 | 2020-07-01 00:00:00 | 2018-01-01 00:00:00 | 2021-01-01 00:00:00 | 2020-02-21 00:00:00 | 2018-07-25 00:00:00 | 2018-10-24 00:00:00 | 2019-07-01 00:00:00 | 2018-03-28 00:00:00 | 2018-07-03 00:00:00 | 2018-10-03 00:00:00 | 2020-07-01 00:00:00 | 2022-04-15 00:00:00 | 2020-01-01 00:00:00 | 2021-07-01 00:00:00 | 2022-01-01 00:00:00 | 2021-07-01 00:00:00 | 2021-01-01 00:00:00 | 2022-05-27 00:00:00 | 2022-01-01 00:00:00 | 2022-09-22 00:00:00 | 2022-10-06 00:00:00 | 2022-10-18 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_end | 1996-12-31 00:00:00 | 1998-06-30 00:00:00 | 1998-12-31 00:00:00 | 1999-06-30 00:00:00 | 1999-09-30 00:00:00 | 1985-12-31 00:00:00 | 1985-12-31 00:00:00 | None | 1986-06-30 00:00:00 | 1986-12-31 00:00:00 | None | 1988-12-31 00:00:00 | 1992-06-30 00:00:00 | 1992-09-30 00:00:00 | 1992-12-31 00:00:00 | 1993-06-30 00:00:00 | 1994-06-30 00:00:00 | 1995-06-30 00:00:00 | 1996-06-30 00:00:00 | 1999-03-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 | 2001-12-31 00:00:00 | 2002-06-30 00:00:00 | 2002-06-30 00:00:00 | 2002-12-31 00:00:00 | 2002-12-31 00:00:00 | 2003-09-30 00:00:00 | 2003-12-31 00:00:00 | 2000-06-30 00:00:00 | 2004-06-30 00:00:00 | 2004-06-30 00:00:00 | 2004-10-25 00:00:00 | None | 2004-12-31 00:00:00 | 2004-12-31 00:00:00 | 2005-06-30 00:00:00 | 2005-06-30 00:00:00 | 2005-12-31 00:00:00 | 2006-05-24 00:00:00 | 2006-05-20 00:00:00 | 2006-05-20 00:00:00 | 2006-06-30 00:00:00 | 2006-06-30 00:00:00 | 2005-12-31 00:00:00 | 2006-10-25 00:00:00 | 2006-12-31 00:00:00 | 2006-12-31 00:00:00 | None | 2007-12-31 00:00:00 | 2013-06-30 00:00:00 | 2013-06-30 00:00:00 | 2015-06-30 00:00:00 | 2014-06-30 00:00:00 | 2014-05-28 00:00:00 | 2014-12-31 00:00:00 | 2014-10-28 00:00:00 | 2014-06-30 00:00:00 | 2014-10-24 00:00:00 | 2007-09-30 00:00:00 | 2008-03-17 00:00:00 | 2007-09-30 00:00:00 | 2008-03-17 00:00:00 | 2007-12-31 00:00:00 | 2008-06-30 00:00:00 | 2008-06-30 00:00:00 | 2008-12-31 00:00:00 | 2008-12-31 00:00:00 | 2009-05-12 00:00:00 | 2009-05-21 00:00:00 | None | 2009-05-21 00:00:00 | 2009-05-21 00:00:00 | 2009-06-30 00:00:00 | 2009-05-21 00:00:00 | 2009-12-31 00:00:00 | 2009-06-30 00:00:00 | 2009-12-31 00:00:00 | 2010-03-17 00:00:00 | 2010-05-22 00:00:00 | 2010-05-22 00:00:00 | 2010-06-30 00:00:00 | 2010-06-30 00:00:00 | 2010-10-20 00:00:00 | None | None | 2010-10-29 00:00:00 | 2010-10-29 00:00:00 | 2010-10-29 00:00:00 | 2010-10-26 00:00:00 | 2010-10-27 00:00:00 | 2010-12-31 00:00:00 | 2010-12-31 00:00:00 | 2011-06-30 00:00:00 | 2011-06-30 00:00:00 | 2011-12-31 00:00:00 | 2011-12-31 00:00:00 | 2012-06-30 00:00:00 | 2014-03-17 00:00:00 | 2014-03-21 00:00:00 | 2013-12-31 00:00:00 | 2013-12-31 00:00:00 | 2012-06-30 00:00:00 | 2014-12-31 00:00:00 | 2014-09-12 00:00:00 | 2014-09-23 00:00:00 | 2012-12-31 00:00:00 | 2012-12-31 00:00:00 | 2014-04-29 00:00:00 | 2014-04-10 00:00:00 | 2014-04-14 00:00:00 | 2015-06-30 00:00:00 | 2017-12-31 00:00:00 | 2018-05-09 00:00:00 | 2019-12-31 00:00:00 | 2018-04-06 00:00:00 | 2020-03-04 00:00:00 | 2020-02-20 00:00:00 | 2018-06-30 00:00:00 | 2018-09-05 00:00:00 | 2018-09-20 00:00:00 | 2018-08-09 00:00:00 | 2019-06-20 00:00:00 | 2019-06-30 00:00:00 | 2018-12-31 00:00:00 | 2015-12-31 00:00:00 | 2015-12-31 00:00:00 | 2016-04-20 00:00:00 | 2016-04-08 00:00:00 | 2016-04-07 00:00:00 | 2016-06-30 00:00:00 | 2016-08-24 00:00:00 | 2016-09-06 00:00:00 | 2016-06-30 00:00:00 | 2016-10-19 00:00:00 | 2016-09-28 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 | 2020-09-24 00:00:00 | 2017-12-31 00:00:00 | 2019-06-30 00:00:00 | 2019-12-20 00:00:00 | 2018-12-31 00:00:00 | 2020-06-30 00:00:00 | 2020-12-31 00:00:00 | 2018-06-30 00:00:00 | 2021-06-30 00:00:00 | 2020-02-21 00:00:00 | 2018-07-25 00:00:00 | 2018-10-24 00:00:00 | 2019-12-31 00:00:00 | 2018-03-28 00:00:00 | 2018-07-03 00:00:00 | 2018-10-03 00:00:00 | 2020-12-31 00:00:00 | 2022-04-15 00:00:00 | 2020-06-30 00:00:00 | 2021-12-31 00:00:00 | 2022-06-30 00:00:00 | 2021-12-31 00:00:00 | 2021-06-30 00:00:00 | 2022-05-27 00:00:00 | 2022-06-30 00:00:00 | 2022-09-22 00:00:00 | 2022-10-06 00:00:00 | 2022-10-18 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 | 2001-01-26 00:00:00 | None | 2002-01-10 00:00:00 | None | None | 2002-07-24 00:00:00 | None | 2003-01-10 00:00:00 | None | None | None | 2004-07-28 00:00:00 | None | 2004-10-25 00:00:00 | None | 2005-01-07 00:00:00 | None | 2005-07-27 00:00:00 | None | 2006-01-19 00:00:00 | 2006-05-24 00:00:00 | None | 2006-05-24 00:00:00 | 2006-07-25 00:00:00 | None | None | 2006-10-25 00:00:00 | None | 2007-01-29 00:00:00 | None | 2008-01-29 00:00:00 | 2013-07-25 00:00:00 | None | 2015-07-06 00:00:00 | 2014-07-22 00:00:00 | 2014-05-28 00:00:00 | None | 2014-10-28 00:00:00 | None | 2014-10-24 00:00:00 | 2007-10-30 00:00:00 | 2008-03-24 00:00:00 | None | None | None | 2008-07-28 00:00:00 | None | 2009-02-02 00:00:00 | None | 2009-05-12 00:00:00 | None | None | 2009-06-02 00:00:00 | 2009-07-30 00:00:00 | 2009-07-30 00:00:00 | None | 2010-01-29 00:00:00 | None | None | 2010-03-22 00:00:00 | 2010-05-27 00:00:00 | None | 2010-07-26 00:00:00 | None | 2010-10-20 00:00:00 | None | None | 2010-10-29 00:00:00 | None | 2010-10-29 00:00:00 | None | 2010-10-27 00:00:00 | 2011-01-28 00:00:00 | None | None | 2011-07-21 00:00:00 | None | 2012-01-10 00:00:00 | 2012-07-19 00:00:00 | 2014-03-17 00:00:00 | 2014-03-21 00:00:00 | 2014-01-20 00:00:00 | None | None | 2015-01-21 00:00:00 | 2014-09-12 00:00:00 | 2014-09-23 00:00:00 | None | 2013-01-24 00:00:00 | 2014-04-29 00:00:00 | 2014-04-10 00:00:00 | 2014-04-14 00:00:00 | None | 2018-01-15 00:00:00 | 2018-05-09 00:00:00 | 2020-01-15 00:00:00 | 2018-04-06 00:00:00 | 2020-03-04 00:00:00 | 2020-02-20 00:00:00 | None | 2018-09-05 00:00:00 | 2018-09-20 00:00:00 | 2018-08-09 00:00:00 | 2019-06-20 00:00:00 | 2019-07-15 00:00:00 | None | 2016-01-08 00:00:00 | None | 2016-04-20 00:00:00 | 2016-04-08 00:00:00 | 2016-04-07 00:00:00 | 2016-07-07 00:00:00 | 2016-08-24 00:00:00 | 2016-09-06 00:00:00 | None | 2016-10-19 00:00:00 | 2016-09-28 00:00:00 | 2017-01-17 00:00:00 | None | 2017-07-18 00:00:00 | None | 2020-09-24 00:00:00 | None | None | 2019-12-20 00:00:00 | 2019-01-09 00:00:00 | None | None | 2018-07-03 00:00:00 | 2021-07-16 00:00:00 | 2020-02-21 00:00:00 | 2018-07-25 00:00:00 | 2018-10-24 00:00:00 | None | 2018-03-28 00:00:00 | 2018-07-03 00:00:00 | 2018-10-03 00:00:00 | 2021-01-19 00:00:00 | 2022-04-15 00:00:00 | 2020-07-13 00:00:00 | None | 2022-07-18 00:00:00 | 2022-01-12 00:00:00 | None | 2022-05-27 00:00:00 | None | 2022-09-22 00:00:00 | 2022-10-06 00:00:00 | 2022-10-18 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 | 22001 | None | None | None | 22006 | None | 22006 | None | 22006 | None | 22006 | None | 22006 | 22006 | None | 22006 | 22006 | None | None | 22006 | None | 22006 | None | 22006 | 22001 | None | 22001 | 22001 | 22001 | None | 22001 | None | 22001 | 22006 | 22006 | None | None | None | 22006 | None | 22006 | None | 22006 | None | None | 22006 | 22006 | 22006 | None | 22006 | None | None | 22006 | 22006 | None | 22006 | None | 22001 | None | None | 22001 | None | 22001 | None | 22001 | 22001 | None | None | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | None | None | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | None | 22001 | None | 22001 | None | None | 22001 | 22001 | None | None | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | None | 22001 | None | 22001 | 22001 | 22001 |
filer_id | 1010544 | |
---|---|---|
filer_type | 10 | |
active | Y | |
race | 0 | |
session_id | 2007 | |
category | 0 | |
category_type | 40502 | |
sub_category | 0 | |
effect_dt | 1990-12-01 00:00:00 | |
sub_category_type | 0 | |
election_type | 0 | |
sub_category_a | None | |
nyq_dt | None | |
party_cd | 0 | |
county_cd | 18004 | |
district_cd | 0 |
filer_id | 1010544 | |
---|---|---|
xref_id | 486004 | |
effect_dt | 1999-12-07 00:00:00 | |
migration_source | IDENTFIX |
xref_filer_id | 486004 | 486004 | 486004 | 486004 | 486004 | 486004 | 486004 | 486004 | 486004 | 486004 | 486004 | 486004 | 486004 | 486004 | 486004 | 486004 | 486004 | 486004 | 486004 | 486004 | 486004 | 486004 | 486004 | 486004 | 486004 | 486004 | 486004 | 486004 | 486004 | 486004 | 486004 | 486004 | 486004 | 486004 | 486004 | 486004 | 486004 | 486004 | 486004 | 486004 | 486004 | 486004 | 486004 | 486004 | ||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_id | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | ||||||||||||||||||||||||||||||||||||||||||||
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 | 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 | 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 | 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 | 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 | 1990-12-01 00:00:00 | 1990-12-01 00:00:00 | 1990-12-01 00:00:00 | 1990-12-01 00:00:00 | 1990-12-01 00:00:00 | 1990-12-01 00:00:00 | 1990-12-01 00:00:00 | 1990-12-01 00:00:00 | 1990-12-01 00:00:00 | 1990-12-01 00:00:00 | 1990-12-01 00:00:00 | 1990-12-01 00:00:00 | 1990-12-01 00:00:00 | 1990-12-01 00:00:00 | 1990-12-01 00:00:00 | 1990-12-01 00:00:00 | 1990-12-01 00:00:00 | 1990-12-01 00:00:00 | 1990-12-01 00:00:00 | 1990-12-01 00:00:00 | 1990-12-01 00:00:00 | 1990-12-01 00:00:00 | 1990-12-01 00:00:00 | 1990-12-01 00:00:00 | 1990-12-01 00:00:00 | 1990-12-01 00:00:00 | 1990-12-01 00:00:00 | 1990-12-01 00:00:00 | 1990-12-01 00:00:00 | 1990-12-01 00:00:00 | 1990-12-01 00:00:00 | 1990-12-01 00:00:00 | 1990-12-01 00:00:00 | 1990-12-01 00:00:00 | 1990-12-01 00:00:00 | 1990-12-01 00:00:00 | 1990-12-01 00:00:00 | 1990-12-01 00:00:00 | 1990-12-01 00:00:00 | 1990-12-01 00:00:00 | 1990-12-01 00:00:00 | 1990-12-01 00:00:00 | 1990-12-01 00:00:00 | 1990-12-01 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||
naml | DENTISTS INSURANCE COMPANY, THE | DENTISTS INSURANCE COMPANY, THE | DENTISTS INSURANCE COMPANY, THE | DENTISTS INSURANCE COMPANY, THE | DENTISTS INSURANCE COMPANY, THE | DENTISTS INSURANCE COMPANY, THE | DENTISTS INSURANCE COMPANY, THE | DENTISTS INSURANCE COMPANY, THE | DENTISTS INSURANCE COMPANY, THE | DENTISTS INSURANCE COMPANY, THE | DENTISTS INSURANCE COMPANY, THE | DENTISTS INSURANCE COMPANY, THE (TDIC) | DENTISTS INSURANCE COMPANY, THE (TDIC) | DENTISTS INSURANCE COMPANY, THE (TDIC) | DENTISTS INSURANCE COMPANY, THE (TDIC) | DENTISTS INSURANCE COMPANY, THE (TDIC) | DENTISTS INSURANCE COMPANY, THE (TDIC) | DENTISTS INSURANCE COMPANY, THE (TDIC) | DENTISTS INSURANCE COMPANY, THE (TDIC) | DENTISTS INSURANCE COMPANY, THE (TDIC) | DENTISTS INSURANCE COMPANY, THE (TDIC) | DENTISTS INSURANCE COMPANY, THE (TDIC) | DENTISTS INSURANCE COMPANY | DENTISTS INSURANCE COMPANY | DENTISTS INSURANCE COMPANY | DENTISTS INSURANCE COMPANY | DENTISTS INSURANCE COMPANY | DENTISTS INSURANCE COMPANY | DENTISTS INSURANCE COMPANY | DENTISTS INSURANCE COMPANY | DENTISTS INSURANCE COMPANY | DENTISTS INSURANCE COMPANY | DENTISTS INSURANCE COMPANY | DENTISTS INSURANCE COMPANY (TDIC), THE | DENTISTS INSURANCE COMPANY (TDIC), THE | DENTISTS INSURANCE COMPANY (TDIC), THE | DENTISTS INSURANCE COMPANY (TDIC), THE | DENTISTS INSURANCE COMPANY (TDIC), THE | DENTISTS INSURANCE COMPANY (TDIC), THE | DENTISTS INSURANCE COMPANY (TDIC), THE | DENTISTS INSURANCE COMPANY (TDIC), THE | DENTISTS INSURANCE COMPANY (TDIC), THE | DENTISTS INSURANCE COMPANY (TDIC), THE | DENTISTS INSURANCE COMPANY (TDIC), THE | ||||||||||||||||||||||||||||||||||||||||||||
namf | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||
namt | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||
nams | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||
adr1 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||
adr2 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||
city | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | ||||||||||||||||||||||||||||||||||||||||||||
st | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | ||||||||||||||||||||||||||||||||||||||||||||
zip4 | 958140000 | 95814-0000 | 95814-0000 | 95814-0000 | 95814-0000 | 95814-0000 | 95814-0000 | 95814-0000 | 95814-0000 | 95814-0000 | 95814 | 958140000 | 95814-0000 | 95814-0000 | 95814-0000 | 95814-0000 | 95814-0000 | 95814-0000 | 95814-0000 | 95814-0000 | 95814-0000 | 95814 | 958140000 | 95814-0000 | 95814-0000 | 95814-0000 | 95814-0000 | 95814-0000 | 95814-0000 | 95814-0000 | 95814-0000 | 95814-0000 | 95814 | 958140000 | 95814-0000 | 95814-0000 | 95814-0000 | 95814-0000 | 95814-0000 | 95814-0000 | 95814-0000 | 95814-0000 | 95814-0000 | 95814 | ||||||||||||||||||||||||||||||||||||||||||||
phon | 9164434567 | 9164434567 | (916) 443-4567 | (916) 443-4567 | 9164434567 | 9165545337 | 9165545337 | 9165545337 | 9165545337 | 9165545307 | 9164427757 | 9164434567 | 9164434567 | (916) 443-4567 | (916) 443-4567 | 9164434567 | 9165545337 | 9165545337 | 9165545337 | 9165545337 | 9165545307 | 9164427757 | 9164434567 | 9164434567 | (916) 443-4567 | (916) 443-4567 | 9164434567 | 9165545337 | 9165545337 | 9165545337 | 9165545337 | 9165545307 | 9164427757 | 9164434567 | 9164434567 | (916) 443-4567 | (916) 443-4567 | 9164434567 | 9165545337 | 9165545337 | 9165545337 | 9165545337 | 9165545307 | 9164427757 | ||||||||||||||||||||||||||||||||||||||||||||
fax | None | None | None | None | None | None | None | None | 9164986145 | 9165545985 | 9164427759 | None | None | None | None | None | None | None | None | 9164986145 | 9165545985 | 9164427759 | None | None | None | None | None | None | None | None | 9164986145 | 9165545985 | 9164427759 | None | None | None | None | None | None | None | None | 9164986145 | 9165545985 | 9164427759 | ||||||||||||||||||||||||||||||||||||||||||||
None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None |
filer_id | 1010544 |
---|
filer_id | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | 1010544 | |||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_file_name | 717786_0.cal | 804607_0.cal | 855123_0.cal | 911146_0.cal | 1738100_0.cal | 1678857_0.cal | 1571142_0.cal | 1606266_0.cal | 1634791_0.cal | 2082470_0.cal | 2026683_0.cal | 2091754_0.cal | 2074335_0.cal | 2071446_0.cal | 2247778_0.cal | 2228927_0.cal | 2293704_0.cal | 2281683_0.cal | 2426007_0.cal | 2455879_0.cal | 2311888_0.cal | 2262415_0.cal | 2300736_0.cal | 2226094_0.cal | 2455176_0.cal | 2729394_0.cal | 2687958_0.cal | 2722579_0.cal | 2735637_0.cal | |||||||||||||||||||||||||||||
received_date | 2001-01-30 00:00:00 | 2002-01-10 00:00:00 | 2002-07-30 00:00:00 | 2003-01-30 00:00:00 | 2013-01-31 00:00:00 | 2012-07-31 00:00:00 | 2011-01-31 00:00:00 | 2011-07-29 00:00:00 | 2012-01-30 00:00:00 | 2016-09-28 00:00:00 | 2016-04-07 00:00:00 | 2016-10-19 00:00:00 | 2016-09-06 00:00:00 | 2016-08-24 00:00:00 | 2018-05-09 00:00:00 | 2018-04-06 00:00:00 | 2018-09-20 00:00:00 | 2018-08-09 00:00:00 | 2019-12-20 00:00:00 | 2020-02-21 00:00:00 | 2018-10-24 00:00:00 | 2018-07-03 00:00:00 | 2018-10-03 00:00:00 | 2018-03-28 00:00:00 | 2020-02-20 00:00:00 | 2022-10-06 00:00:00 | 2022-05-27 00:00:00 | 2022-09-22 00:00:00 | 2022-10-18 00:00:00 | |||||||||||||||||||||||||||||
filing_directory | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | |||||||||||||||||||||||||||||
filing_id | 717786 | 804607 | 855123 | 911146 | 1738100 | 1678857 | 1571142 | 1606266 | 1634791 | 2082470 | 2026683 | 2091754 | 2074335 | 2071446 | 2247778 | 2228927 | 2293704 | 2281683 | 2426007 | 2455879 | 2311888 | 2262415 | 2300736 | 2226094 | 2455176 | 2729394 | 2687958 | 2722579 | 2735637 | |||||||||||||||||||||||||||||
form_id | F461 | F461 | F461 | F461 | F461 | F461 | F461 | F461 | F461 | F497 | F497 | F497 | F497 | F497 | F497 | F497 | F497 | F497 | F497 | F497 | F497 | F497 | F497 | F497 | F497 | F497 | F497 | F497 | F497 | |||||||||||||||||||||||||||||
receive_comment | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted |