filer_id | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
adrid | 2012669 | 1108690 | 2041023 | 2080333 | 2119570 | 2164842 | 2207011 | 2417544 | 2509592 | 2278763 | 2338389 | 2468210 | 2550991 | |||||||||||||
effect_dt | 2001-01-01 00:00:00 | 1999-01-01 00:00:00 | 2003-01-01 00:00:00 | 2005-01-01 00:00:00 | 2007-01-01 00:00:00 | 2009-01-01 00:00:00 | 2011-01-01 00:00:00 | 2017-01-01 00:00:00 | 2021-01-01 00:00:00 | 2013-01-01 00:00:00 | 2015-01-01 00:00:00 | 2019-01-01 00:00:00 | 2023-01-01 00:00:00 | |||||||||||||
add_type | 7051 | 7050 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | |||||||||||||
session_id | 2001 | 1999 | 2003 | 2005 | 2007 | 2009 | 2011 | 2017 | 2021 | 2013 | 2015 | 2019 | 2023 |
filer_id | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 467999 | 471411 | 482518 | 473498 | 484970 | 466155 | 488585 | 489793 | 492284 | 493501 | 481430 | 497122 | 486106 | 479049 | 475871 | 465148 | 540704 | 470362 | 492284 | 541475 | 630316 | 618551 | 664918 | 676002 | 711305 | 692830 | 702328 | 742149 | 755803 | 738635 | 768690 | 788865 | 778822 | 809305 | 795768 | 836813 | 824324 | 849567 | 842432 | 863489 | 879588 | 876487 | 912709 | 905881 | 934712 | 895883 | 928124 | 942142 | 937315 | 937239 | 937241 | 965468 | 956234 | 986731 | 976370 | 1002405 | 1030151 | 1014024 | 1033829 | 1018098 | 1058869 | 1064084 | 1094848 | 1080935 | 1116433 | 1104810 | 1105767 | 1088027 | 1133845 | 1164618 | 1145148 | 1191388 | 1224137 | 1216563 | 1255586 | 1259616 | 1248620 | 1236247 | 1250410 | 1278588 | 1295584 | 1259616 | 1295584 | 1784250 | 1975832 | 1798193 | 1959788 | 1949655 | 1908648 | 1325218 | 1305050 | 1343971 | 1366563 | 1384974 | 1414657 | 1402005 | 1437764 | 1408436 | 1448486 | 1459994 | 1480854 | 1512211 | 1530801 | 1552822 | 1552835 | 1561490 | 1530801 | 1530801 | 1561490 | 1591961 | 1591961 | 1613671 | 1628881 | 1617599 | 1653307 | 1672793 | 1784250 | 1825252 | 1672793 | 1720714 | 1718798 | 1873407 | 1727965 | 1728535 | 1845661 | 1763587 | 1993565 | 1999637 | 2269701 | 2432119 | 2188729 | 2234298 | 2480939 | 2203670 | 2006600 | 2030065 | 2042524 | 2056311 | 2100178 | 2124907 | 2136634 | 2152435 | 2170649 | 2375286 | 2344613 | 2466281 | 2513194 | 2336474 | 2391496 | 2414442 | 2309517 | 2574295 | 2634780 | 2698928 | 2666738 | 2616005 | 2593236 | 2568173 | 2544798 | 2734176 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
period_id | 157 | 150 | 152 | 158 | 145 | 149 | 146 | 154 | 147 | 155 | 144 | 156 | 153 | 159 | 143 | 141 | 151 | 142 | 147 | 148 | None | 160 | 162 | 163 | 164 | 163 | None | 165 | 165 | 164 | 166 | 167 | None | 168 | None | 169 | None | 170 | None | None | 171 | 171 | None | 172 | None | None | 173 | 174 | None | None | None | 175 | None | 176 | None | None | 178 | 177 | None | None | 179 | None | None | 180 | 182 | 181 | 182 | None | 183 | 185 | 184 | 186 | 188 | 187 | None | 189 | None | 188 | 189 | 190 | 191 | 189 | 191 | 214 | 222 | 215 | 221 | None | 219 | 193 | 192 | 194 | 195 | 196 | 197 | 196 | 198 | None | 199 | 200 | 201 | 202 | 203 | 204 | None | 204 | 203 | 203 | 204 | 205 | 205 | 206 | 208 | 207 | 209 | 210 | 214 | 216 | 210 | 211 | 213 | 218 | None | 212 | 217 | 213 | 223 | 220 | 234 | 240 | 231 | 233 | 242 | 232 | 224 | 225 | None | 226 | 227 | 228 | None | 229 | 230 | 237 | None | 241 | 243 | 236 | 238 | 239 | 235 | 245 | 248 | 250 | 249 | 247 | 246 | None | 244 | 251 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F690 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F690 | F605 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F602 | F635 | F635 | F635 | F635 | F602 | F635 | F602 | F635 | F602 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F602 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F888 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_sequence | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 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 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 2 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_date | 1999-04-30 00:00:00 | 1997-07-22 00:00:00 | 1998-01-30 00:00:00 | 1999-07-30 00:00:00 | 1996-04-26 00:00:00 | 1997-04-30 00:00:00 | 1996-07-30 00:00:00 | 1998-07-30 00:00:00 | 1996-10-30 00:00:00 | 1998-10-28 00:00:00 | 1996-01-30 00:00:00 | 1999-02-01 00:00:00 | 1998-04-30 00:00:00 | 1999-10-28 00:00:00 | 1995-10-25 00:00:00 | 1995-04-24 00:00:00 | 1997-10-31 00:00:00 | 1995-07-25 00:00:00 | 1997-09-15 00:00:00 | 1997-01-29 00:00:00 | 2000-04-26 00:00:00 | 2000-01-26 00:00:00 | 2000-07-27 00:00:00 | 2000-10-25 00:00:00 | 2001-01-18 00:00:00 | 2000-10-31 00:00:00 | 2000-12-11 00:00:00 | 2001-04-19 00:00:00 | 2001-04-25 00:00:00 | 2001-01-25 00:00:00 | 2001-07-23 00:00:00 | 2001-10-24 00:00:00 | 2001-07-25 00:00:00 | 2002-01-23 00:00:00 | 2001-10-31 00:00:00 | 2002-04-24 00:00:00 | 2002-01-24 00:00:00 | 2002-07-15 00:00:00 | 2002-04-25 00:00:00 | 2002-07-30 00:00:00 | 2002-10-24 00:00:00 | 2002-10-22 00:00:00 | 2003-01-29 00:00:00 | 2003-01-24 00:00:00 | 2003-04-30 00:00:00 | 2002-12-03 00:00:00 | 2003-04-21 00:00:00 | 2003-07-16 00:00:00 | 2003-05-21 00:00:00 | 2003-05-21 00:00:00 | 2003-05-21 00:00:00 | 2003-10-20 00:00:00 | 2003-07-30 00:00:00 | 2004-01-27 00:00:00 | 2003-10-29 00:00:00 | 2004-01-29 00:00:00 | 2004-07-30 00:00:00 | 2004-04-30 00:00:00 | 2004-07-30 00:00:00 | 2004-04-30 00:00:00 | 2004-11-01 00:00:00 | 2004-10-29 00:00:00 | 2005-01-31 00:00:00 | 2005-01-31 00:00:00 | 2005-07-28 00:00:00 | 2005-04-29 00:00:00 | 2005-05-02 00:00:00 | 2004-12-29 00:00:00 | 2005-10-31 00:00:00 | 2006-04-25 00:00:00 | 2006-01-27 00:00:00 | 2006-07-31 00:00:00 | 2006-12-20 00:00:00 | 2006-10-31 00:00:00 | 2007-02-27 00:00:00 | 2007-04-25 00:00:00 | 2007-01-02 00:00:00 | 2007-01-30 00:00:00 | 2007-03-05 00:00:00 | 2007-07-20 00:00:00 | 2007-10-29 00:00:00 | 2007-11-20 00:00:00 | 2007-12-28 00:00:00 | 2013-08-01 00:00:00 | 2015-07-21 00:00:00 | 2013-10-28 00:00:00 | 2015-04-20 00:00:00 | 2014-12-26 00:00:00 | 2014-10-29 00:00:00 | 2008-04-17 00:00:00 | 2008-01-22 00:00:00 | 2008-07-17 00:00:00 | 2008-10-16 00:00:00 | 2008-12-22 00:00:00 | 2009-04-01 00:00:00 | 2009-02-11 00:00:00 | 2009-07-31 00:00:00 | 2008-12-19 00:00:00 | 2009-10-20 00:00:00 | 2010-01-25 00:00:00 | 2010-04-20 00:00:00 | 2010-08-12 00:00:00 | 2010-10-21 00:00:00 | 2010-12-21 00:00:00 | 2010-12-20 00:00:00 | 2011-01-19 00:00:00 | 2011-01-19 00:00:00 | 2011-03-21 00:00:00 | 2011-03-21 00:00:00 | 2011-05-02 00:00:00 | 2011-08-29 00:00:00 | 2011-08-29 00:00:00 | 2012-01-17 00:00:00 | 2011-10-14 00:00:00 | 2012-04-20 00:00:00 | 2012-07-19 00:00:00 | 2014-02-28 00:00:00 | 2014-02-28 00:00:00 | 2012-07-19 00:00:00 | 2012-12-27 00:00:00 | 2012-12-19 00:00:00 | 2014-08-01 00:00:00 | 2012-12-19 00:00:00 | 2013-01-17 00:00:00 | 2014-04-30 00:00:00 | 2013-04-29 00:00:00 | 2015-10-22 00:00:00 | 2015-11-13 00:00:00 | 2018-07-25 00:00:00 | 2020-01-18 00:00:00 | 2017-10-18 00:00:00 | 2018-04-23 00:00:00 | 2020-07-25 00:00:00 | 2018-01-21 00:00:00 | 2016-01-25 00:00:00 | 2016-04-20 00:00:00 | 2016-04-23 00:00:00 | 2016-07-19 00:00:00 | 2016-10-29 00:00:00 | 2017-01-26 00:00:00 | 2016-12-19 00:00:00 | 2017-04-23 00:00:00 | 2017-07-24 00:00:00 | 2019-04-19 00:00:00 | 2018-12-24 00:00:00 | 2020-04-19 00:00:00 | 2020-10-12 00:00:00 | 2019-01-18 00:00:00 | 2019-07-20 00:00:00 | 2019-10-22 00:00:00 | 2018-10-20 00:00:00 | 2021-04-14 00:00:00 | 2022-01-17 00:00:00 | 2022-07-18 00:00:00 | 2022-04-15 00:00:00 | 2021-10-14 00:00:00 | 2021-07-14 00:00:00 | 2020-12-18 00:00:00 | 2021-01-17 00:00:00 | 2022-10-14 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 | 10005 | 10005 | 10001 | 10001 | 10005 | 10005 | 10001 | 10005 | 10005 | 10001 | 10001 | 10005 | 10001 | 10005 | 10001 | 10005 | 10001 | 10005 | 10005 | 10005 | 10001 | 10005 | 10001 | 10005 | 10005 | 10001 | 10001 | 10006 | 10005 | 10005 | 10001 | 10005 | 10001 | 10005 | 10005 | 10001 | 10001 | 10005 | 10005 | 10001 | 10005 | 10005 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10002 | 10002 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10002 | 10002 | 10002 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10002 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_status | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 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 | 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 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
session_id | 1999 | 1997 | 1997 | 1999 | 1995 | 1997 | 1995 | 1997 | 1995 | 1997 | 1995 | 1997 | 1997 | 1999 | 1995 | 1995 | 1997 | 1995 | 1995 | 1995 | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 2001 | 2001 | 2001 | 1999 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2007 | 2005 | 2007 | 2007 | 2007 | 2005 | 2007 | 2007 | 2007 | 2007 | 2007 | 2013 | 2015 | 2013 | 2015 | 2015 | 2013 | 2007 | 2007 | 2007 | 2007 | 2009 | 2009 | 2007 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2011 | 2011 | 2009 | 2009 | 2009 | 2009 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2013 | 2013 | 2011 | 2011 | 2013 | 2013 | 2013 | 2011 | 2013 | 2013 | 2015 | 2013 | 2017 | 2019 | 2017 | 2017 | 2019 | 2017 | 2015 | 2015 | 2013 | 2015 | 2015 | 2015 | 2017 | 2017 | 2017 | 2019 | 2019 | 2019 | 2019 | 2017 | 2019 | 2019 | 2017 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2019 | 2021 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
user_id | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | KCHAN | * | LTHIBAUL | * | * | LTHIBAUL | GGILMORE | * | JBRANNAN | YBONILLA | * | * | LTHIBAUL | * | LTHIBAUL | * | LTHIBAUL | * | LTHIBAUL | LTHIBAUL | LTHIBAUL | * | LTHIBAUL | COMPLETED | LTHIBAUL | PBANFORD | COMPLETED | COMPLETED | LTHIBAUL | SARRIAGA | SARRIAGA | COMPLETED | LTHIBAUL | COMPLETED | LTHIBAUL | LTHIBAUL | COMPLETED | COMPLETED | LTHIBAUL | LTHIBAUL | COMPLETED | LTHIBAUL | LTHIBAUL | COMPLETED | * | * | * | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | * | LTHIBAUL | GPEREZ | LTHIBAUL | PBANFORD | LTHIBAUL | * | YRODRIGU | YRODRIGU | YRODRIGU | LTHIBAUL | ASAETERN | AGLADNEY | AGLADNEY | AGLADNEY | PBANFORD | AGLADNEY | LTHIBAUL | LTHIBAUL | LTHIBAUL | JINGRAM | * | MGUERRA | JINGRAM | MGUERRA | SARRIAGA | MGUERRA | JINGRAM | ASAETERN | TBOWMAN | ASAETERN | * | SARRIAGA | AGLADNEY | ASAETERN | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | TBOWMAN | AGLADNEY | AGLADNEY | AGLADNEY | ASAETERN | AGLADNEY | RGEREMIA | ASAETERN | RGEREMIA | SARRIAGA | RGEREMIA | SARRIAGA | ASAETERN | ASAETERN | AGLADNEY | AGLADNEY | GCLARA | AGLADNEY | GTAYLOR | AGLADNEY | AGLADNEY | GTAYLOR | AGLADNEY | AGLADNEY | AGLADNEY | SBROWN | AGLADNEY | AGLADNEY | AGLADNEY | DMCCASTL | AGLADNEY | AGLADNEY | VUKSTINA | SARRIAGA | GTAYLOR | GTAYLOR | AGLADNEY | VUKSTINA | VUKSTINA | AGLADNEY | GTAYLOR | GTAYLOR | CAFILER | CAFILER | CHATRIDGE | GTAYLOR | AROJAS | GTAYLOR | 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 | 11002 | 11003 | 11002 | 11002 | 11002 | 11003 | 11002 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 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 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 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 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_start | 1999-01-01 00:00:00 | 1997-04-01 00:00:00 | 1997-10-01 00:00:00 | 1999-04-01 00:00:00 | 1996-01-01 00:00:00 | 1997-01-01 00:00:00 | 1996-04-01 00:00:00 | 1998-04-01 00:00:00 | 1996-07-01 00:00:00 | 1998-07-01 00:00:00 | 1995-10-01 00:00:00 | 1998-10-01 00:00:00 | 1998-01-01 00:00:00 | 1999-07-01 00:00:00 | 1995-07-01 00:00:00 | 1995-01-01 00:00:00 | 1997-07-01 00:00:00 | 1995-04-01 00:00:00 | 1996-07-01 00:00:00 | 1996-10-01 00:00:00 | 2000-01-01 00:00:00 | 1999-10-01 00:00:00 | 2000-04-01 00:00:00 | 2000-07-01 00:00:00 | 2000-10-01 00:00:00 | 2000-07-01 00:00:00 | 1900-01-01 00:00:00 | 2001-01-01 00:00:00 | 2001-01-01 00:00:00 | 2000-10-01 00:00:00 | 2001-04-01 00:00:00 | 2001-07-01 00:00:00 | 2001-04-01 00:00:00 | 2001-10-01 00:00:00 | 2001-07-01 00:00:00 | 2002-01-01 00:00:00 | 2001-10-01 00:00:00 | 2002-04-01 00:00:00 | 2002-01-01 00:00:00 | 2002-04-01 00:00:00 | 2002-07-01 00:00:00 | 2002-07-01 00:00:00 | 2002-10-01 00:00:00 | 2002-10-01 00:00:00 | 2003-01-01 00:00:00 | 1900-01-01 00:00:00 | 2003-01-01 00:00:00 | 2003-04-01 00:00:00 | 2003-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2003-07-01 00:00:00 | 2003-04-01 00:00:00 | 2003-10-01 00:00:00 | 2003-07-01 00:00:00 | 2003-10-01 00:00:00 | 2004-04-01 00:00:00 | 2004-01-01 00:00:00 | 2004-04-01 00:00:00 | 2004-01-01 00:00:00 | 2004-07-01 00:00:00 | 2004-07-01 00:00:00 | 2004-10-01 00:00:00 | 2004-10-01 00:00:00 | 2005-04-01 00:00:00 | 2005-01-01 00:00:00 | 2005-05-02 00:00:00 | 1900-01-01 00:00:00 | 2005-07-01 00:00:00 | 2006-01-01 00:00:00 | 2005-10-01 00:00:00 | 2006-04-01 00:00:00 | 2006-12-13 00:00:00 | 2006-07-01 00:00:00 | 1900-01-01 00:00:00 | 2007-01-01 00:00:00 | 1900-01-01 00:00:00 | 2006-10-01 00:00:00 | 2007-03-05 00:00:00 | 2007-04-01 00:00:00 | 2007-07-01 00:00:00 | 2007-01-01 00:00:00 | 2007-07-01 00:00:00 | 2013-04-01 00:00:00 | 2015-04-01 00:00:00 | 2013-07-01 00:00:00 | 2015-01-01 00:00:00 | 1900-01-01 00:00:00 | 2014-07-01 00:00:00 | 2008-01-01 00:00:00 | 2007-10-01 00:00:00 | 2008-04-01 00:00:00 | 2008-07-01 00:00:00 | 2008-12-22 00:00:00 | 2009-01-01 00:00:00 | 2008-10-01 00:00:00 | 2009-05-01 00:00:00 | 1900-01-01 00:00:00 | 2009-07-01 00:00:00 | 2009-10-01 00:00:00 | 2010-01-01 00:00:00 | 2010-04-01 00:00:00 | 2010-07-01 00:00:00 | 2010-12-21 00:00:00 | 1900-01-01 00:00:00 | 2010-10-01 00:00:00 | 2010-07-01 00:00:00 | 2010-07-01 00:00:00 | 2010-10-01 00:00:00 | 2011-01-01 00:00:00 | 2011-01-01 00:00:00 | 2011-04-01 00:00:00 | 2011-10-01 00:00:00 | 2011-07-01 00:00:00 | 2012-01-01 00:00:00 | 2012-04-01 00:00:00 | 2013-04-01 00:00:00 | 2013-10-01 00:00:00 | 2012-04-01 00:00:00 | 2012-07-01 00:00:00 | 2013-01-01 00:00:00 | 2014-04-01 00:00:00 | 1900-01-01 00:00:00 | 2012-10-01 00:00:00 | 2014-01-01 00:00:00 | 2013-01-01 00:00:00 | 2015-07-01 00:00:00 | 2014-10-01 00:00:00 | 2018-04-01 00:00:00 | 2019-10-01 00:00:00 | 2017-07-01 00:00:00 | 2018-01-01 00:00:00 | 2020-04-01 00:00:00 | 2017-10-01 00:00:00 | 2015-10-01 00:00:00 | 2016-01-01 00:00:00 | 2014-10-01 00:00:00 | 2016-04-01 00:00:00 | 2016-07-01 00:00:00 | 2016-10-01 00:00:00 | 1900-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017-04-01 00:00:00 | 2019-01-01 00:00:00 | 1900-01-01 00:00:00 | 2020-01-01 00:00:00 | 2020-07-01 00:00:00 | 2018-10-01 00:00:00 | 2019-04-01 00:00:00 | 2019-07-01 00:00:00 | 2018-07-01 00:00:00 | 2021-01-01 00:00:00 | 2021-10-01 00:00:00 | 2022-04-01 00:00:00 | 2022-01-01 00:00:00 | 2021-07-01 00:00:00 | 2021-04-01 00:00:00 | 1900-01-01 00:00:00 | 2020-10-01 00:00:00 | 2022-07-01 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_end | 1999-03-31 00:00:00 | 1997-06-30 00:00:00 | 1997-12-31 00:00:00 | 1999-06-30 00:00:00 | 1996-03-31 00:00:00 | 1997-03-31 00:00:00 | 1996-06-30 00:00:00 | 1998-06-30 00:00:00 | 1996-09-30 00:00:00 | 1998-09-30 00:00:00 | 1995-12-31 00:00:00 | 1998-12-31 00:00:00 | 1998-03-31 00:00:00 | 1999-09-30 00:00:00 | 1995-09-30 00:00:00 | 1995-03-31 00:00:00 | 1997-09-30 00:00:00 | 1995-06-30 00:00:00 | 1996-09-30 00:00:00 | 1996-12-31 00:00:00 | 2000-03-31 00:00:00 | 1999-12-31 00:00:00 | 2000-06-30 00:00:00 | 2000-09-30 00:00:00 | 2000-12-31 00:00:00 | 2000-09-30 00:00:00 | 1900-01-01 00:00:00 | 2001-03-31 00:00:00 | 2001-03-31 00:00:00 | 2000-12-31 00:00:00 | 2001-06-30 00:00:00 | 2001-09-30 00:00:00 | 2001-06-30 00:00:00 | 2001-12-31 00:00:00 | 2001-09-30 00:00:00 | 2002-03-31 00:00:00 | 2001-12-31 00:00:00 | 2002-06-30 00:00:00 | 2002-03-31 00:00:00 | 2002-06-30 00:00:00 | 2002-09-30 00:00:00 | 2002-09-30 00:00:00 | 2002-12-31 00:00:00 | 2002-12-31 00:00:00 | 2003-03-31 00:00:00 | 1900-01-01 00:00:00 | 2003-03-31 00:00:00 | 2003-06-30 00:00:00 | 2003-03-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2003-09-30 00:00:00 | 2003-06-30 00:00:00 | 2003-12-30 00:00:00 | 2003-09-30 00:00:00 | 2003-12-30 00:00:00 | 2004-06-30 00:00:00 | 2004-03-31 00:00:00 | 2004-06-30 00:00:00 | 2004-03-31 00:00:00 | 2004-09-30 00:00:00 | 2004-09-30 00:00:00 | 2004-12-31 00:00:00 | 2004-12-31 00:00:00 | 2005-06-30 00:00:00 | 2005-03-31 00:00:00 | 2005-05-02 00:00:00 | 1900-01-01 00:00:00 | 2005-09-30 00:00:00 | 2006-03-31 00:00:00 | 2005-12-31 00:00:00 | 2006-06-30 00:00:00 | 2006-12-13 00:00:00 | 2006-09-30 00:00:00 | 1900-01-01 00:00:00 | 2007-03-31 00:00:00 | 1900-01-01 00:00:00 | 2006-12-31 00:00:00 | 2007-03-05 00:00:00 | 2007-06-30 00:00:00 | 2007-09-30 00:00:00 | 2007-03-31 00:00:00 | 2007-09-30 00:00:00 | 2013-06-30 00:00:00 | 2015-06-30 00:00:00 | 2013-09-30 00:00:00 | 2015-03-31 00:00:00 | 1900-01-01 00:00:00 | 2014-09-30 00:00:00 | 2008-03-31 00:00:00 | 2007-12-31 00:00:00 | 2008-06-30 00:00:00 | 2008-09-30 00:00:00 | 2008-12-22 00:00:00 | 2009-03-31 00:00:00 | 2008-12-31 00:00:00 | 2009-07-31 00:00:00 | 1900-01-01 00:00:00 | 2009-09-30 00:00:00 | 2009-12-31 00:00:00 | 2010-03-31 00:00:00 | 2010-06-30 00:00:00 | 2010-09-30 00:00:00 | 2010-12-21 00:00:00 | 1900-01-01 00:00:00 | 2010-12-31 00:00:00 | 2010-09-30 00:00:00 | 2010-09-30 00:00:00 | 2010-12-31 00:00:00 | 2011-03-31 00:00:00 | 2011-03-31 00:00:00 | 2011-06-30 00:00:00 | 2011-12-31 00:00:00 | 2011-09-30 00:00:00 | 2012-03-31 00:00:00 | 2012-06-30 00:00:00 | 2013-06-30 00:00:00 | 2013-12-31 00:00:00 | 2012-06-30 00:00:00 | 2012-09-30 00:00:00 | 2013-01-01 00:00:00 | 2014-06-30 00:00:00 | 1900-01-01 00:00:00 | 2012-12-31 00:00:00 | 2014-03-31 00:00:00 | 2013-03-31 00:00:00 | 2015-09-30 00:00:00 | 2014-12-31 00:00:00 | 2018-06-30 00:00:00 | 2019-12-31 00:00:00 | 2017-09-30 00:00:00 | 2018-03-31 00:00:00 | 2020-06-30 00:00:00 | 2017-12-31 00:00:00 | 2015-12-31 00:00:00 | 2016-03-31 00:00:00 | 2014-12-31 00:00:00 | 2016-06-30 00:00:00 | 2016-09-30 00:00:00 | 2016-12-31 00:00:00 | 1900-01-01 00:00:00 | 2017-03-31 00:00:00 | 2017-06-30 00:00:00 | 2019-03-31 00:00:00 | 1900-01-01 00:00:00 | 2020-03-31 00:00:00 | 2020-09-30 00:00:00 | 2018-12-31 00:00:00 | 2019-06-30 00:00:00 | 2019-09-30 00:00:00 | 2018-09-30 00:00:00 | 2021-03-31 00:00:00 | 2021-12-31 00:00:00 | 2022-06-30 00:00:00 | 2022-03-31 00:00:00 | 2021-09-30 00:00:00 | 2021-06-30 00:00:00 | 1900-01-01 00:00:00 | 2020-12-31 00:00:00 | 2022-09-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 | 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 | 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 | 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | None | None | None | None | None | None | None | 22001 | None | None | 22001 | 22006 | None | None | None | 22001 | None | 22001 | None | None | 22001 | 22001 | None | None | 22001 | None | None | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22006 | None | 22001 | 22001 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22001 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22001 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22001 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 |
filer_id | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
session_id | 2001 | 2003 | 1999 | 1995 | 1997 | 2009 | 2007 | 2011 | 2005 | 2013 | 2021 | 2019 | 2017 | 2015 | 2023 | |||||||||||||||
interest_cd | 40305 | 40305 | 40305 | 40305 | 40305 | 40305 | 40305 | 40305 | 40305 | 40305 | 40305 | 40305 | 40305 | 40305 | 40305 | |||||||||||||||
effect_date | 2001-01-01 00:00:00 | 2003-01-01 00:00:00 | 1999-01-01 00:00:00 | 1994-12-05 00:00:00 | 1997-01-01 00:00:00 | 2009-01-01 00:00:00 | 2007-01-01 00:00:00 | 2011-01-01 00:00:00 | 2005-01-01 00:00:00 | 2013-01-01 00:00:00 | 2021-01-01 00:00:00 | 2019-01-01 00:00:00 | 2017-01-01 00:00:00 | 2015-01-01 00:00:00 | 2023-01-01 00:00:00 |
filer_id | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_type | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | |||||||||||||||
active | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | N | |||||||||||||||
race | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
session_id | 1997 | 1995 | 1999 | 2001 | 2003 | 2005 | 2007 | 2013 | 2011 | 2009 | 2017 | 2019 | 2015 | 2021 | 2023 | |||||||||||||||
category | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
category_type | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
sub_category | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
effect_dt | 1997-01-01 00:00:00 | 1994-12-05 00:00:00 | 1999-01-01 00:00:00 | 2001-01-01 00:00:00 | 2003-01-01 00:00:00 | 2005-01-01 00:00:00 | 2007-01-01 00:00:00 | 2013-01-01 00:00:00 | 2011-01-01 00:00:00 | 2009-01-01 00:00:00 | 2017-01-01 00:00:00 | 2019-01-01 00:00:00 | 2015-01-01 00:00:00 | 2021-01-01 00:00:00 | 2023-01-01 00:00:00 | |||||||||||||||
sub_category_type | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
election_type | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
sub_category_a | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
nyq_dt | None | None | None | None | None | 2000-07-01 00:00:00 | 2000-07-01 00:00:00 | None | None | None | None | None | None | None | None | |||||||||||||||
party_cd | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
county_cd | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
district_cd | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None |
filer_id | 1143924 | |
---|---|---|
xref_id | C24907 | |
effect_dt | 1999-12-08 00:00:00 | |
migration_source | MASTER |
xref_filer_id | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | C24907 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_id | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filer_type | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
status | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
effect_dt | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
naml | MADERA, COUNTY OF | MADERA, COUNTY OF | MADERA, COUNTY OF | MADERA, COUNTY OF | MADERA, COUNTY OF | MADERA, COUNTY OF | MADERA, COUNTY OF | MADERA, COUNTY OF | MADERA, COUNTY OF | MADERA, COUNTY OF | MADERA, COUNTY OF | MADERA, COUNTY OF | MADERA, COUNTY OF | MADERA, COUNTY OF | MADERA, COUNTY OF | MADERA, COUNTY OF | MADERA, COUNTY OF | MADERA, COUNTY OF | MADERA, COUNTY OF | MADERA, COUNTY OF | MADERA, COUNTY OF | MADERA, COUNTY OF | MADERA, COUNTY OF | MADERA, COUNTY OF | MADERA, COUNTY OF | MADERA, COUNTY OF | MADERA, COUNTY OF | MADERA, COUNTY OF | MADERA, COUNTY OF | MADERA, COUNTY OF | MADERA, COUNTY OF | MADERA, COUNTY OF | MADERA, COUNTY OF | MADERA, COUNTY OF | MADERA, COUNTY OF | MADERA, COUNTY OF | MADERA, COUNTY OF | MADERA, COUNTY OF | MADERA, COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | MADERA | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | 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 | 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 | 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 | 93637 | 93637 | 93637 | 93637 | 93637 | 936373548 | 936373548 | 936373548 | 93637 | 93637 | 93637 | 93637 | 93637 | 93637 | 93637 | 93637 | 93637 | 93637 | 936373548 | 936373548 | 936373548 | 93637 | 93637 | 93637 | 93637 | 93637 | 93637 | 93637 | 93637 | 93637 | 93637 | 936373548 | 936373548 | 936373548 | 93637 | 93637 | 93637 | 93637 | 93637 | 93637 | 93637 | 93637 | 93637 | 93637 | 936373548 | 936373548 | 936373548 | 93637 | 93637 | 93637 | 93637 | 93637 | 93637 | 93637 | 93637 | 93637 | 93637 | 936373548 | 936373548 | 936373548 | 93637 | 93637 | 93637 | 93637 | 93637 | 93637 | 93637 | 93637 | 93637 | 93637 | 936373548 | 936373548 | 936373548 | 93637 | 93637 | 93637 | 93637 | 93637 | 93637 | 93637 | 93637 | 93637 | 93637 | 936373548 | 936373548 | 936373548 | 93637 | 93637 | 93637 | 93637 | 93637 | 93637 | 93637 | 93637 | 93637 | 93637 | 936373548 | 936373548 | 936373548 | 93637 | 93637 | 93637 | 93637 | 93637 | 93637 | 93637 | 93637 | 93637 | 93637 | 936373548 | 936373548 | 936373548 | 93637 | 93637 | 93637 | 93637 | 93637 | 93637 | 93637 | 93637 | 93637 | 93637 | 936373548 | 936373548 | 936373548 | 93637 | 93637 | 93637 | 93637 | 93637 | 93637 | 93637 | 93637 | 93637 | 93637 | 936373548 | 936373548 | 936373548 | 93637 | 93637 | 93637 | 93637 | 93637 | 93637 | 93637 | 93637 | 93637 | 93637 | 936373548 | 936373548 | 936373548 | 93637 | 93637 | 93637 | 93637 | 93637 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
phon | 2096757703 | 5596757703 | 5596757703 | 5596757703 | 5596757700 | 5596757700 | 5596757700 | 5596757700 | 5596757703 | 5596757703 | 5596757703 | 5596757703 | 5596757703 | 2096757703 | 5596757703 | 5596757703 | 5596757703 | 5596757700 | 5596757700 | 5596757700 | 5596757700 | 5596757703 | 5596757703 | 5596757703 | 5596757703 | 5596757703 | 2096757703 | 5596757703 | 5596757703 | 5596757703 | 5596757700 | 5596757700 | 5596757700 | 5596757700 | 5596757703 | 5596757703 | 5596757703 | 5596757703 | 5596757703 | 2096757703 | 5596757703 | 5596757703 | 5596757703 | 5596757700 | 5596757700 | 5596757700 | 5596757700 | 5596757703 | 5596757703 | 5596757703 | 5596757703 | 5596757703 | 2096757703 | 5596757703 | 5596757703 | 5596757703 | 5596757700 | 5596757700 | 5596757700 | 5596757700 | 5596757703 | 5596757703 | 5596757703 | 5596757703 | 5596757703 | 2096757703 | 5596757703 | 5596757703 | 5596757703 | 5596757700 | 5596757700 | 5596757700 | 5596757700 | 5596757703 | 5596757703 | 5596757703 | 5596757703 | 5596757703 | 2096757703 | 5596757703 | 5596757703 | 5596757703 | 5596757700 | 5596757700 | 5596757700 | 5596757700 | 5596757703 | 5596757703 | 5596757703 | 5596757703 | 5596757703 | 2096757703 | 5596757703 | 5596757703 | 5596757703 | 5596757700 | 5596757700 | 5596757700 | 5596757700 | 5596757703 | 5596757703 | 5596757703 | 5596757703 | 5596757703 | 2096757703 | 5596757703 | 5596757703 | 5596757703 | 5596757700 | 5596757700 | 5596757700 | 5596757700 | 5596757703 | 5596757703 | 5596757703 | 5596757703 | 5596757703 | 2096757703 | 5596757703 | 5596757703 | 5596757703 | 5596757700 | 5596757700 | 5596757700 | 5596757700 | 5596757703 | 5596757703 | 5596757703 | 5596757703 | 5596757703 | 2096757703 | 5596757703 | 5596757703 | 5596757703 | 5596757700 | 5596757700 | 5596757700 | 5596757700 | 5596757703 | 5596757703 | 5596757703 | 5596757703 | 5596757703 | 2096757703 | 5596757703 | 5596757703 | 5596757703 | 5596757700 | 5596757700 | 5596757700 | 5596757700 | 5596757703 | 5596757703 | 5596757703 | 5596757703 | 5596757703 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fax | None | 5596757950 | 5596757950 | None | 5596757950 | 5596757950 | None | 5596757950 | 5596757950 | None | 5596757950 | 5596757950 | None | 5596757950 | 5596757950 | None | 5596757950 | 5596757950 | None | 5596757950 | 5596757950 | None | 5596757950 | 5596757950 | None | 5596757950 | 5596757950 | None | 5596757950 | 5596757950 | None | 5596757950 | 5596757950 | None | 5596757950 | 5596757950 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
None | [email protected] | None | None | None | None | None | None | None | None | None | None | None | None | [email protected] | None | None | None | None | None | None | None | None | None | None | None | None | [email protected] | None | None | None | None | None | None | None | None | None | None | None | None | [email protected] | None | None | None | None | None | None | None | None | None | None | None | None | [email protected] | None | None | None | None | None | None | None | None | None | None | None | None | [email protected] | None | None | None | None | None | None | None | None | None | None | None | None | [email protected] | None | None | None | None | None | None | None | None | None | None | None | None | [email protected] | None | None | None | None | None | None | None | None | None | None | None | None | [email protected] | None | None | None | None | None | None | None | None | None | None | None | None | [email protected] | None | None | None | None | None | None | None | None | None | None | None | None | [email protected] | None | None | None | None | None | None | None | None | None | None | None | None | [email protected] | None | None | None | None | None | None | None | None | None | None | None |
filer_id | 1143924 |
---|
filer_id | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | |||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
change_no | 1 | 2 | 3 | 0 | 4 | 5 | 6 | |||||||
session_id | 2001 | 2001 | 2003 | 2003 | 2005 | 2007 | 2007 | |||||||
log_dt | 2001-04-09 00:00:00 | 2001-04-09 00:00:00 | 2004-06-07 00:00:00 | 2003-05-21 00:00:00 | 2004-12-29 00:00:00 | 2007-02-27 00:00:00 | 2007-08-28 00:00:00 | |||||||
filer_type | 1 | 1 | 1 | 1 | 1 | 1 | 1 | |||||||
correction_flg | None | None | None | Y | None | Y | Y | |||||||
action | IN SUSPENSE | IN SUSPENSE | DELETED | ADDED | SET ACTIVE | ADDED | DELETED | |||||||
attribute_changed | LOBBYIST | LOBBYIST | FIRM | None | FIRM | None | ||||||||
ethics_dt | None | None | None | None | None | None | None | |||||||
interests | None | None | None | None | None | None | None | |||||||
filer_full_name | MADERA, COUNTY OF | MADERA, COUNTY OF | MADERA, COUNTY OF | MADERA, COUNTY OF | MADERA, COUNTY OF | MADERA; COUNTY OF | MADERA; COUNTY OF | |||||||
filer_city | SACRAMENTO | None | None | None | None | MADERA | MADERA | |||||||
filer_st | CA | None | None | None | None | CA | CA | |||||||
filer_zip | 95814 | None | None | None | None | 93637 | 93637 | |||||||
filer_phone | 9164411850 | None | None | None | None | 2096757703 | 2096757703 | |||||||
entity_type | 3 | 3 | 3 | 3 | 1 | 3 | 3 | |||||||
entity_name | WAGERMAN ASSOCIATES, INC. | WAGERMAN ASSOCIATES, INC. | WAGERMAN ASSOCIATES, INC. | STRATEGIC LOCAL GOVERNMENT SERVICES, LLC | None | ADVOCATION, INC. | STRATEGIC LOCAL GOVERNMENT SERVICES LLC | |||||||
entity_city | None | None | None | None | None | None | None | |||||||
entity_st | None | None | None | None | None | None | None | |||||||
entity_zip | None | None | None | None | None | None | None | |||||||
entity_phone | None | None | None | None | None | None | None | |||||||
entity_id | 1147322 | 1147322 | 1147322 | 1246828 | 0 | None | None | |||||||
responsible_officer | None | None | None | None | None | None | None | |||||||
effect_dt | None | None | 2004-01-01 00:00:00 | 2003-01-01 00:00:00 | 2005-01-01 00:00:00 | 2007-03-01 00:00:00 | 2007-04-01 00:00:00 |
filer_id | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | 1143924 | ||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_file_name | 711305_0.cal | 676002_0.cal | 742149_0.cal | 768690_0.cal | 788865_0.cal | 809305_0.cal | 836813_0.cal | 849567_0.cal | 876487_0.cal | 905881_0.cal | 928124_0.cal | 942142_0.cal | 965468_0.cal | 986731_0.cal | 1105767_0.cal | 273753.cal | 273194.cal | 273447.cal | 274469.cal | 1216563_0.cal | ||||||||||||||||||||
received_date | 2001-01-18 00:00:00 | 2000-10-25 00:00:00 | 2001-04-19 00:00:00 | 2001-07-23 00:00:00 | 2001-10-24 00:00:00 | 2002-01-23 00:00:00 | 2002-04-24 00:00:00 | 2002-07-15 00:00:00 | 2002-10-22 00:00:00 | 2003-01-24 00:00:00 | 2003-04-21 00:00:00 | 2003-07-16 00:00:00 | 2003-10-20 00:00:00 | 2004-01-27 00:00:00 | 2005-05-02 00:00:00 | 2005-08-02 00:00:00 | 2005-08-02 00:00:00 | 2005-08-02 00:00:00 | 2005-08-02 00:00:00 | 2006-10-31 00:00:00 | ||||||||||||||||||||
filing_directory | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /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/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | ||||||||||||||||||||
filing_id | 711305 | 676002 | 742149 | 768690 | 788865 | 809305 | 836813 | 849567 | 876487 | 905881 | 928124 | 942142 | 965468 | 986731 | 1105767 | None | None | None | None | 1216563 | ||||||||||||||||||||
form_id | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | None | None | None | None | F635 | ||||||||||||||||||||
receive_comment | Filing accepted, but with warnings | Filing accepted, but but with warnings | Filing accepted, but with warnings | Filing accepted, but with warnings | Filing accepted, but with warnings | Filing accepted | Filing accepted | Filing accepted | Filing accepted, but with warnings | Filing accepted | Filing accepted | Filing accepted, but with warnings | Filing accepted | Filing accepted | Filing accepted | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing accepted |