filer_id | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
adrid | 1101016 | 2042445 | 2079874 | 2113865 | 2130065 | 2160241 | 2203751 | 2520179 | 2441452 | 2410578 | 2469910 | 2546911 | 2481035 | 2278636 | 2341937 | |||||||||||||||
effect_dt | 1999-04-26 00:00:00 | 2003-01-01 00:00:00 | 2006-01-17 00:00:00 | 2007-01-01 00:00:00 | 2007-10-26 00:00:00 | 2009-01-01 00:00:00 | 2011-01-01 00:00:00 | 2021-01-01 00:00:00 | 2017-11-01 00:00:00 | 2017-01-01 00:00:00 | 2019-01-01 00:00:00 | 2023-01-01 00:00:00 | 2019-01-15 00:00:00 | 2013-01-01 00:00:00 | 2015-01-01 00:00:00 | |||||||||||||||
add_type | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | |||||||||||||||
session_id | 1999 | 2003 | 2005 | 2007 | 2007 | 2009 | 2011 | 2021 | 2017 | 2017 | 2019 | 2023 | 2019 | 2013 | 2015 |
filer_id | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
session_id | 1999 | 2001 | 2003 | 2007 | 2005 | 2009 | 2011 | 2013 | 2015 | 2017 | 2019 | 2021 | ||||||||||||
ethics_date | 1999-11-17 00:00:00 | 2001-04-20 00:00:00 | 2002-11-13 00:00:00 | 2006-11-16 00:00:00 | 2006-02-16 00:00:00 | 2009-02-19 00:00:00 | 2011-01-13 00:00:00 | 2013-01-24 00:00:00 | 2015-06-16 00:00:00 | 2017-02-02 00:00:00 | 2019-05-23 00:00:00 | 2021-08-12 00:00:00 |
filer_id | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 515847 | 518988 | 626490 | 611282 | 638514 | 659365 | 646233 | 684080 | 719330 | 711702 | 683009 | 689978 | 746550 | 749944 | 727056 | 791690 | 770784 | 793317 | 776420 | 816291 | 813572 | 837422 | 858121 | 855975 | 842265 | 879346 | 899364 | 883457 | 909452 | 942895 | 929301 | 911754 | 929963 | 945222 | 951218 | 969481 | 971440 | 1027310 | 990481 | 1016044 | 1014163 | 993406 | 1030605 | 1076690 | 1059285 | 1079704 | 1061165 | 1166454 | 1150131 | 1152660 | 1155785 | 1189267 | 1225243 | 1215711 | 1260045 | 1240548 | 1236382 | 1282980 | 1782371 | 1965459 | 1922058 | 1979108 | 1872429 | 1949072 | 1935103 | 1911503 | 1329113 | 1294314 | 1311706 | 1350744 | 1392912 | 1386442 | 1415495 | 1377279 | 1421395 | 1414362 | 1464204 | 1451277 | 1436554 | 1484419 | 1507792 | 1554235 | 1560579 | 1560579 | 1554235 | 1538321 | 1571075 | 1607794 | 1590629 | 1637128 | 1620455 | 1657242 | 1678926 | 1804297 | 1800296 | 1817118 | 1922058 | 1720587 | 1707963 | 1720587 | 1742938 | 1734139 | 1845809 | 1765119 | 1971472 | 1996606 | 2319673 | 2211663 | 2208001 | 2362931 | 2442973 | 2191714 | 2194509 | 2397200 | 2242557 | 2275371 | 2009343 | 2037807 | 2059464 | 2102121 | 2127840 | 2113676 | 2154935 | 2134690 | 2149470 | 2139828 | 2113676 | 2175815 | 2330528 | 2381561 | 2195925 | 2415971 | 2469768 | 2531261 | 2349899 | 2562825 | 2385499 | 2381561 | 2330528 | 2621774 | 2487303 | 2674021 | 2590257 | 2602663 | 2581021 | 2703268 | 2617296 | 2644795 | 2554221 | 2746061 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
period_id | 158 | 159 | 161 | 160 | 161 | None | 162 | 163 | 164 | None | 163 | None | 165 | 165 | 164 | 167 | 166 | None | None | None | 168 | 169 | None | 170 | None | 171 | None | None | 172 | 175 | 173 | None | None | 174 | None | 175 | None | 178 | 176 | None | 177 | None | None | 180 | 179 | None | None | 185 | None | 185 | None | 186 | 188 | 187 | 189 | None | 188 | 190 | 214 | 221 | 222 | 222 | 218 | None | 220 | 219 | 193 | 191 | 192 | 194 | 196 | 196 | None | 195 | 197 | None | 200 | 199 | 198 | 201 | 202 | 204 | None | None | 205 | 203 | 204 | 206 | 205 | 208 | 207 | 209 | 210 | None | 215 | 216 | 220 | 212 | 211 | 213 | None | 212 | 217 | 213 | None | 223 | 235 | 232 | 232 | None | 240 | 231 | None | 238 | 233 | 234 | 224 | 225 | 226 | 227 | 228 | 228 | 229 | None | None | None | 229 | 230 | 238 | 237 | 232 | 239 | 241 | 243 | 236 | 244 | None | 237 | 236 | 247 | 242 | 249 | None | 246 | 245 | 250 | None | 248 | 244 | 251 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F604 | F604 | F615 | F604 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F604 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F604 | F604 | F604 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F604 | F604 | F615 | F604 | F604 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F604 | F604 | F604 | F604 | F615 | F604 | F615 | F604 | F615 | F615 | F615 | F615 | F604 | F604 | F615 | F604 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | 1 | 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 | 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 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_date | 1999-08-02 00:00:00 | 1999-11-01 00:00:00 | 2000-05-01 00:00:00 | 2000-01-31 00:00:00 | 2000-07-10 00:00:00 | 2000-08-02 00:00:00 | 2000-08-01 00:00:00 | 2000-11-01 00:00:00 | 2001-01-31 00:00:00 | 2000-12-29 00:00:00 | 2000-10-31 00:00:00 | 2000-05-04 00:00:00 | 2001-04-30 00:00:00 | 2001-04-30 00:00:00 | 2001-01-31 00:00:00 | 2001-10-31 00:00:00 | 2001-07-27 00:00:00 | 2001-10-31 00:00:00 | 2001-07-31 00:00:00 | 2002-01-31 00:00:00 | 2002-01-31 00:00:00 | 2002-04-25 00:00:00 | 2002-07-31 00:00:00 | 2002-07-31 00:00:00 | 2002-04-29 00:00:00 | 2002-10-25 00:00:00 | 2002-12-26 00:00:00 | 2002-10-28 00:00:00 | 2003-01-30 00:00:00 | 2003-07-20 00:00:00 | 2003-04-28 00:00:00 | 2003-01-30 00:00:00 | 2003-04-28 00:00:00 | 2003-07-28 00:00:00 | 2003-07-29 00:00:00 | 2003-10-31 00:00:00 | 2003-10-30 00:00:00 | 2004-07-28 00:00:00 | 2004-02-02 00:00:00 | 2004-04-30 00:00:00 | 2004-04-30 00:00:00 | 2004-02-02 00:00:00 | 2004-07-28 00:00:00 | 2005-01-27 00:00:00 | 2004-11-01 00:00:00 | 2005-01-26 00:00:00 | 2004-11-01 00:00:00 | 2006-04-28 00:00:00 | 2006-02-01 00:00:00 | 2006-02-23 00:00:00 | 2006-02-22 00:00:00 | 2006-07-28 00:00:00 | 2006-12-29 00:00:00 | 2006-10-30 00:00:00 | 2007-04-26 00:00:00 | 2006-12-29 00:00:00 | 2007-01-30 00:00:00 | 2007-07-30 00:00:00 | 2013-07-31 00:00:00 | 2015-04-30 00:00:00 | 2015-06-23 00:00:00 | 2015-07-29 00:00:00 | 2014-07-31 00:00:00 | 2014-12-30 00:00:00 | 2015-01-30 00:00:00 | 2014-10-31 00:00:00 | 2008-04-30 00:00:00 | 2007-10-23 00:00:00 | 2008-01-31 00:00:00 | 2008-07-31 00:00:00 | 2009-01-27 00:00:00 | 2008-12-30 00:00:00 | 2009-02-19 00:00:00 | 2008-10-30 00:00:00 | 2009-04-30 00:00:00 | 2008-12-30 00:00:00 | 2010-01-31 00:00:00 | 2009-10-29 00:00:00 | 2009-07-30 00:00:00 | 2010-04-29 00:00:00 | 2010-08-02 00:00:00 | 2010-12-28 00:00:00 | 2010-12-28 00:00:00 | 2011-01-21 00:00:00 | 2011-01-20 00:00:00 | 2010-10-28 00:00:00 | 2011-01-31 00:00:00 | 2011-08-01 00:00:00 | 2011-04-29 00:00:00 | 2012-01-31 00:00:00 | 2011-10-27 00:00:00 | 2012-04-30 00:00:00 | 2012-07-31 00:00:00 | 2013-01-31 00:00:00 | 2013-10-31 00:00:00 | 2014-01-30 00:00:00 | 2014-12-30 00:00:00 | 2012-12-27 00:00:00 | 2012-10-30 00:00:00 | 2013-01-30 00:00:00 | 2012-12-27 00:00:00 | 2013-01-28 00:00:00 | 2014-04-30 00:00:00 | 2013-04-30 00:00:00 | 2015-06-16 00:00:00 | 2015-10-30 00:00:00 | 2018-10-31 00:00:00 | 2018-01-31 00:00:00 | 2018-01-29 00:00:00 | 2018-12-28 00:00:00 | 2020-01-31 00:00:00 | 2017-10-30 00:00:00 | 2017-10-31 00:00:00 | 2019-07-30 00:00:00 | 2018-04-30 00:00:00 | 2018-07-31 00:00:00 | 2016-01-28 00:00:00 | 2016-05-02 00:00:00 | 2016-07-27 00:00:00 | 2016-10-31 00:00:00 | 2017-01-30 00:00:00 | 2016-12-22 00:00:00 | 2017-04-27 00:00:00 | 2017-02-02 00:00:00 | 2017-04-04 00:00:00 | 2016-12-27 00:00:00 | 2017-02-24 00:00:00 | 2017-07-31 00:00:00 | 2019-05-29 00:00:00 | 2019-07-30 00:00:00 | 2017-11-13 00:00:00 | 2019-10-27 00:00:00 | 2020-04-29 00:00:00 | 2020-11-02 00:00:00 | 2019-01-31 00:00:00 | 2021-03-04 00:00:00 | 2019-05-29 00:00:00 | 2019-04-30 00:00:00 | 2018-12-28 00:00:00 | 2021-10-28 00:00:00 | 2020-07-31 00:00:00 | 2022-04-28 00:00:00 | 2021-03-05 00:00:00 | 2021-08-02 00:00:00 | 2021-04-30 00:00:00 | 2022-07-28 00:00:00 | 2021-08-25 00:00:00 | 2022-01-31 00:00:00 | 2021-02-01 00:00:00 | 2022-10-29 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_type | 10001 | 10001 | 10005 | 10005 | 10001 | 10005 | 10001 | 10005 | 10001 | 10005 | 10001 | 10005 | 10001 | 10005 | 10005 | 10001 | 10001 | 10005 | 10005 | 10005 | 10001 | 10001 | 10005 | 10001 | 10005 | 10001 | 10005 | 10005 | 10001 | 10001 | 10001 | 10005 | 10005 | 10001 | 10005 | 10001 | 10005 | 10001 | 10001 | 10005 | 10001 | 10005 | 10005 | 10001 | 10001 | 10005 | 10005 | 10001 | 10005 | 10001 | 10006 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10006 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10006 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10006 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10005 | 10001 | 10001 | 10001 | 10006 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10006 | 10006 | 10005 | 10002 | 10001 | 10002 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10006 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10006 | 10001 | 10001 | 10001 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_status | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 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 | 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 | 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 | 11003 | 11001 | 11001 | 11001 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
session_id | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 2001 | 1999 | 1999 | 2001 | 2001 | 1999 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2003 | 2001 | 2001 | 2003 | 2003 | 2001 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2005 | 2003 | 2005 | 2005 | 2005 | 2005 | 2005 | 2007 | 2005 | 2007 | 2007 | 2005 | 2007 | 2013 | 2015 | 2015 | 2015 | 2013 | 2015 | 2013 | 2013 | 2007 | 2007 | 2007 | 2007 | 2007 | 2009 | 2009 | 2007 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2011 | 2011 | 2011 | 2011 | 2009 | 2009 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2013 | 2013 | 2013 | 2015 | 2013 | 2011 | 2013 | 2013 | 2011 | 2013 | 2013 | 2015 | 2015 | 2017 | 2017 | 2017 | 2019 | 2019 | 2017 | 2017 | 2019 | 2017 | 2017 | 2015 | 2015 | 2015 | 2015 | 2015 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2019 | 2019 | 2017 | 2019 | 2019 | 2019 | 2017 | 2021 | 2019 | 2019 | 2019 | 2021 | 2019 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2019 | 2021 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
user_id | * | * | TTHAM | * | * | DHORRELL | * | SARRIAGA | * | CFLAGG | * | DHORRELL | * | TWALLS | GPEREZ | * | * | YBONILLA | YBONILLA | YBONILLA | * | * | YBONILLA | * | YBONILLA | * | BSMITH | YBONILLA | COMPLETED | COMPLETED | COMPLETED | YBONILLA | YBONILLA | COMPLETED | YBONILLA | COMPLETED | LTHIBAUL | COMPLETED | COMPLETED | LTHIBAUL | COMPLETED | LTHIBAUL | LTHIBAUL | COMPLETED | COMPLETED | LTHIBAUL | LTHIBAUL | YRODRIGU | CFLAGG | * | SARRIAGA | YRODRIGU | * | YRODRIGU | YRODRIGU | CFLAGG | YRODRIGU | YRODRIGU | ASAETERN | JINGRAM | PBANFORD | JINGRAM | ASAETERN | PBANFORD | AGLADNEY | ASAETERN | YRODRIGU | LTHIBAUL | YRODRIGU | LTHIBAUL | CFLAGG | * | YRODRIGU | CFLAGG | CFLAGG | YRODRIGU | CFLAGG | CFLAGG | CFLAGG | JINGRAM | ASAETERN | YRODRIGU | YRODRIGU | GKURIMOT | * | ASAETERN | ASAETERN | ASAETERN | JINGRAM | ASAETERN | ASAETERN | ASAETERN | AGLADNEY | PBANFORD | ASAETERN | ASAETERN | PBANFORD | SARRIAGA | ASAETERN | PBANFORD | SARRIAGA | ASAETERN | ASAETERN | ASAETERN | PBANFORD | JINGRAM | JFRONEFIELD | AGLADNEY | AGLADNEY | GPEREZ | VUKSTINA | SMCCONNAN | GPEREZ | VUKSTINA | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | JINGRAM | AGLADNEY | KBANH | JINGRAM | SARRIAGA | PBANFORD | SARRIAGA | KBANH | SMCCONNAN | SUSHAKOV | GTAYLOR | GPEREZ | VUKSTINA | VUKSTINA | GTAYLOR | JFRONEFIELD | MKIRKHAM | MWOODS | JFRONEFIELD | GPEREZ | GTAYLOR | CVANLIEW | CAFILER | MKIRKHAM | MKIRKHAM | GTAYLOR | CAFILER | SARRIAGA | RATTIYEH | JRAMOS | CAFILER | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
special_audit | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11002 | 11003 | 11003 | 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 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fine_audit | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 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 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 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 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_start | 1999-04-01 00:00:00 | 1999-07-01 00:00:00 | 2000-01-01 00:00:00 | 1999-10-01 00:00:00 | 2000-01-01 00:00:00 | 2000-04-01 00:00:00 | 2000-04-01 00:00:00 | 2000-07-01 00:00:00 | 2000-10-01 00:00:00 | 1900-01-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-07-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-10-01 00:00:00 | 2002-01-01 00:00:00 | 2002-04-01 00:00:00 | 2002-04-01 00:00:00 | 2002-01-01 00:00:00 | 2002-07-01 00:00:00 | 1900-01-01 00:00:00 | 2002-07-01 00:00:00 | 2002-10-01 00:00:00 | 2003-07-20 00:00:00 | 2003-01-01 00:00:00 | 2002-10-01 00:00:00 | 2003-01-01 00:00:00 | 2003-04-01 00:00:00 | 2003-04-01 00:00:00 | 2003-07-01 00:00:00 | 2003-07-01 00:00:00 | 2004-04-01 00:00:00 | 2003-10-01 00:00:00 | 2004-01-01 00:00:00 | 2004-01-01 00:00:00 | 2003-10-01 00:00:00 | 2004-04-01 00:00:00 | 2004-10-01 00:00:00 | 2004-07-01 00:00:00 | 2004-10-01 00:00:00 | 2004-07-01 00:00:00 | 2006-01-17 00:00:00 | 1900-01-01 00:00:00 | 2006-02-07 00:00:00 | 1900-01-01 00:00:00 | 2006-04-01 00:00:00 | 2006-12-06 00:00:00 | 2006-07-01 00:00:00 | 2007-01-01 00:00:00 | 1900-01-01 00:00:00 | 2006-10-01 00:00:00 | 2007-04-01 00:00:00 | 2013-04-01 00:00:00 | 2015-01-01 00:00:00 | 2015-06-16 00:00:00 | 2015-04-01 00:00:00 | 2014-04-01 00:00:00 | 1900-01-01 00:00:00 | 2014-10-01 00:00:00 | 2014-07-01 00:00:00 | 2008-01-01 00:00:00 | 2007-07-01 00:00:00 | 2007-10-01 00:00:00 | 2008-04-01 00:00:00 | 2008-10-01 00:00:00 | 2008-12-29 00:00:00 | 1900-01-01 00:00:00 | 2008-07-01 00:00:00 | 2009-01-01 00:00:00 | 1900-01-01 00:00:00 | 2009-10-01 00:00:00 | 2009-07-01 00:00:00 | 2009-04-01 00:00:00 | 2010-01-01 00:00:00 | 2010-04-01 00:00:00 | 2010-12-03 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2011-01-14 00:00:00 | 2010-07-01 00:00:00 | 2010-10-01 00:00:00 | 2011-04-01 00:00:00 | 2011-01-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 | 1900-01-01 00:00:00 | 2013-07-01 00:00:00 | 2013-10-01 00:00:00 | 2014-12-15 00:00:00 | 2012-12-17 00:00:00 | 2012-07-01 00:00:00 | 2013-01-29 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 | 1900-01-01 00:00:00 | 2015-07-01 00:00:00 | 2018-07-01 00:00:00 | 2017-11-01 00:00:00 | 2017-10-01 00:00:00 | 1900-01-01 00:00:00 | 2019-10-01 00:00:00 | 2017-07-01 00:00:00 | 1900-01-01 00:00:00 | 2019-04-01 00:00:00 | 2018-01-01 00:00:00 | 2018-04-01 00:00:00 | 2015-10-01 00:00:00 | 2016-01-01 00:00:00 | 2016-04-01 00:00:00 | 2016-07-01 00:00:00 | 2016-10-01 00:00:00 | 2016-12-13 00:00:00 | 2017-01-01 00:00:00 | None | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2017-02-24 00:00:00 | 2017-04-01 00:00:00 | 2019-05-23 00:00:00 | 2019-01-01 00:00:00 | 2017-10-31 00:00:00 | 2019-07-01 00:00:00 | 2020-01-01 00:00:00 | 2020-07-01 00:00:00 | 2018-10-01 00:00:00 | 2020-12-08 00:00:00 | 1900-01-01 00:00:00 | 2019-01-01 00:00:00 | 2018-12-18 00:00:00 | 2021-07-01 00:00:00 | 2020-04-01 00:00:00 | 2022-01-01 00:00:00 | 1900-01-01 00:00:00 | 2021-04-01 00:00:00 | 2021-01-01 00:00:00 | 2022-04-01 00:00:00 | 1900-01-01 00:00:00 | 2021-10-01 00:00:00 | 2020-10-01 00:00:00 | 2022-07-01 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_end | 1999-06-30 00:00:00 | 1999-09-30 00:00:00 | 2000-03-31 00:00:00 | 1999-12-31 00:00:00 | 2000-03-31 00:00:00 | 2000-06-30 00:00:00 | 2000-06-30 00:00:00 | 2000-09-30 00:00:00 | 2000-12-31 00:00:00 | 1900-01-01 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-09-30 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-12-31 00:00:00 | 2002-03-31 00:00:00 | 2002-06-30 00:00:00 | 2002-06-30 00:00:00 | 2002-03-31 00:00:00 | 2002-09-30 00:00:00 | 1900-01-01 00:00:00 | 2002-09-30 00:00:00 | 2002-12-31 00:00:00 | 2003-07-20 00:00:00 | 2003-03-31 00:00:00 | 2002-12-31 00:00:00 | 2003-03-31 00:00:00 | 2003-06-30 00:00:00 | 2003-06-30 00:00:00 | 2003-09-30 00:00:00 | 2003-09-30 00:00:00 | 2004-06-30 00:00:00 | 2003-12-31 00:00:00 | 2004-03-31 00:00:00 | 2004-03-31 00:00:00 | 2003-12-31 00:00:00 | 2004-06-30 00:00:00 | 2004-12-31 00:00:00 | 2004-09-30 00:00:00 | 2004-12-31 00:00:00 | 2004-09-30 00:00:00 | 2006-03-31 00:00:00 | 1900-01-01 00:00:00 | 2006-02-07 00:00:00 | 1900-01-01 00:00:00 | 2006-06-30 00:00:00 | 2006-12-06 00:00:00 | 2006-09-30 00:00:00 | 2007-03-31 00:00:00 | 1900-01-01 00:00:00 | 2006-12-31 00:00:00 | 2007-06-30 00:00:00 | 2013-06-30 00:00:00 | 2015-03-31 00:00:00 | 2015-06-16 00:00:00 | 2015-06-30 00:00:00 | 2014-06-30 00:00:00 | 1900-01-01 00:00:00 | 2014-12-31 00:00:00 | 2014-09-30 00:00:00 | 2008-03-31 00:00:00 | 2007-09-30 00:00:00 | 2007-12-31 00:00:00 | 2008-06-30 00:00:00 | 2008-12-31 00:00:00 | 2008-12-29 00:00:00 | 1900-01-01 00:00:00 | 2008-09-30 00:00:00 | 2009-03-31 00:00:00 | 1900-01-01 00:00:00 | 2009-12-31 00:00:00 | 2009-09-30 00:00:00 | 2009-06-30 00:00:00 | 2010-03-31 00:00:00 | 2010-06-30 00:00:00 | 2010-12-03 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2011-01-14 00:00:00 | 2010-09-30 00:00:00 | 2010-12-31 00:00:00 | 2011-06-30 00:00:00 | 2011-03-31 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 | 1900-01-01 00:00:00 | 2013-09-30 00:00:00 | 2013-12-31 00:00:00 | 2014-12-15 00:00:00 | 2012-12-17 00:00:00 | 2012-09-30 00:00:00 | 2013-01-29 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 | 1900-01-01 00:00:00 | 2015-09-30 00:00:00 | 2018-09-30 00:00:00 | 2017-12-31 00:00:00 | 2017-10-31 00:00:00 | 1900-01-01 00:00:00 | 2019-12-31 00:00:00 | 2017-09-30 00:00:00 | 1900-01-01 00:00:00 | 2019-06-30 00:00:00 | 2018-03-31 00:00:00 | 2018-06-30 00:00:00 | 2015-12-31 00:00:00 | 2016-03-31 00:00:00 | 2016-06-30 00:00:00 | 2016-09-30 00:00:00 | 2016-12-31 00:00:00 | 2016-12-13 00:00:00 | 2017-03-31 00:00:00 | None | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2017-02-24 00:00:00 | 2017-06-30 00:00:00 | 2019-05-23 00:00:00 | 2019-03-31 00:00:00 | 2017-10-31 00:00:00 | 2019-09-30 00:00:00 | 2020-03-31 00:00:00 | 2020-09-30 00:00:00 | 2018-12-31 00:00:00 | 2020-12-08 00:00:00 | 1900-01-01 00:00:00 | 2019-03-31 00:00:00 | 2018-12-18 00:00:00 | 2021-09-30 00:00:00 | 2020-06-30 00:00:00 | 2022-03-31 00:00:00 | 1900-01-01 00:00:00 | 2021-06-30 00:00:00 | 2021-03-31 00:00:00 | 2022-06-30 00:00:00 | 1900-01-01 00:00:00 | 2021-12-31 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | 22001 | 22001 | None | None | 22001 | None | 22001 | None | 22001 | 22001 | None | 22001 | None | None | 22001 | 22001 | None | None | 22001 | None | 22001 | None | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | None | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 |
filer_id | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_type | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | |||||||||||||
active | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | N | |||||||||||||
race | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||
session_id | 2001 | 1999 | 2003 | 2005 | 2007 | 2011 | 2013 | 2009 | 2015 | 2021 | 2019 | 2017 | 2023 | |||||||||||||
category | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||
category_type | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||
sub_category | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||
effect_dt | 2001-01-01 00:00:00 | 1999-04-26 00:00:00 | 2003-01-01 00:00:00 | 2006-01-17 00:00:00 | 2007-01-01 00:00:00 | 2011-01-01 00:00:00 | 2013-01-01 00:00:00 | 2009-01-01 00:00:00 | 2015-01-01 00:00:00 | 2021-01-01 00:00:00 | 2019-01-01 00:00:00 | 2017-01-01 00:00:00 | 2023-01-01 00:00:00 | |||||||||||||
sub_category_type | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||
election_type | 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 | |||||||||||||
nyq_dt | None | None | None | 2000-01-01 00:00:00 | 2000-01-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 | |||||||||||||
county_cd | 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 |
filer_id | 1149573 | |
---|---|---|
xref_id | L25795 | |
effect_dt | 1999-12-08 00:00:00 | |
migration_source | MASTER |
xref_filer_id | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | L25795 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_id | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filer_type | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | 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 | 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 | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | GARCIA | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
namf | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY Z. | ELOY Z. | ELOY Z. | ELOY Z. | ELOY Z. | ELOY Z. | ELOY Z. | ELOY Z. | ELOY Z. | ELOY Z. | ELOY Z. | ELOY Z. | ELOY Z. | ELOY Z. | ELOY Z. | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY | ELOY Z. | ELOY Z. | ELOY Z. | ELOY Z. | ELOY Z. | ELOY Z. | ELOY Z. | ELOY Z. | ELOY Z. | ELOY Z. | ELOY Z. | ELOY Z. | ELOY Z. | ELOY Z. | ELOY Z. | ELOY Z. | ELOY Z. | ELOY Z. | ELOY Z. | ELOY Z. | ELOY Z. | ELOY Z. | ELOY Z. | ELOY Z. | ELOY Z. | ELOY Z. | ELOY Z. | ELOY Z. | ELOY Z. | ELOY Z. | ELOY Z. | ELOY Z. | ELOY Z. | ELOY Z. | ELOY Z. | ELOY Z. | ELOY Z. | ELOY Z. | ELOY Z. | ELOY Z. | ELOY Z. | ELOY Z. | ELOY Z. | ELOY Z. | ELOY Z. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
phon | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9163076689 | 9163076689 | 9162305957 | 9162305957 | 9162305957 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9163076689 | 9163076689 | 9162305957 | 9162305957 | 9162305957 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9163076689 | 9163076689 | 9162305957 | 9162305957 | 9162305957 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9163076689 | 9163076689 | 9162305957 | 9162305957 | 9162305957 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9163076689 | 9163076689 | 9162305957 | 9162305957 | 9162305957 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9163076689 | 9163076689 | 9162305957 | 9162305957 | 9162305957 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9163076689 | 9163076689 | 9162305957 | 9162305957 | 9162305957 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9163076689 | 9163076689 | 9162305957 | 9162305957 | 9162305957 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9163076689 | 9163076689 | 9162305957 | 9162305957 | 9162305957 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9163076689 | 9163076689 | 9162305957 | 9162305957 | 9162305957 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9163076689 | 9163076689 | 9162305957 | 9162305957 | 9162305957 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9163076689 | 9163076689 | 9162305957 | 9162305957 | 9162305957 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fax | 9164480577 | 9164480577 | 9164480577 | 9164480577 | 9164480577 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164480577 | 9164480577 | 9164480577 | 9164480577 | 9164480577 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164480577 | 9164480577 | 9164480577 | 9164480577 | 9164480577 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164480577 | 9164480577 | 9164480577 | 9164480577 | 9164480577 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164480577 | 9164480577 | 9164480577 | 9164480577 | 9164480577 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164480577 | 9164480577 | 9164480577 | 9164480577 | 9164480577 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164480577 | 9164480577 | 9164480577 | 9164480577 | 9164480577 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164480577 | 9164480577 | 9164480577 | 9164480577 | 9164480577 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164480577 | 9164480577 | 9164480577 | 9164480577 | 9164480577 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164480577 | 9164480577 | 9164480577 | 9164480577 | 9164480577 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164480577 | 9164480577 | 9164480577 | 9164480577 | 9164480577 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164480577 | 9164480577 | 9164480577 | 9164480577 | 9164480577 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
[email protected] | [email protected] | None | None | None | None | None | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | None | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | None | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | None | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | None | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | None | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | None | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | None | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | None | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | None | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | None | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | None | None | None | None | None | None | None | [email protected] | [email protected] |
filer_id | 1149573 |
---|
filer_id | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
change_no | 2 | 1 | 10 | 11 | 3 | 4 | 8 | 9 | 6 | 7 | 5 | 12 | 0 | 13 | 14 | |||||||||||||||
session_id | 1999 | 1999 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2003 | 2005 | 2017 | 2017 | |||||||||||||||
log_dt | 2000-11-28 00:00:00 | 2000-11-28 00:00:00 | 2001-04-12 00:00:00 | 2001-04-12 00:00:00 | 2001-04-12 00:00:00 | 2001-04-12 00:00:00 | 2001-04-12 00:00:00 | 2001-04-12 00:00:00 | 2001-04-12 00:00:00 | 2001-04-12 00:00:00 | 2001-04-12 00:00:00 | 2003-06-10 00:00:00 | 2006-02-01 00:00:00 | 2017-11-02 00:00:00 | 2017-10-31 00:00:00 | |||||||||||||||
filer_type | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | |||||||||||||||
correction_flg | None | None | None | None | None | None | None | None | None | None | None | Y | None | Y | Y | |||||||||||||||
action | SET ACTIVE | SET ACTIVE | IN SUSPENSE | IN SUSPENSE | IN SUSPENSE | IN SUSPENSE | IN SUSPENSE | IN SUSPENSE | IN SUSPENSE | IN SUSPENSE | IN SUSPENSE | DELETED | ADDED | DELETED | ADDED | |||||||||||||||
attribute_changed | CLIENT | CLIENT | EMPLOYER | EMPLOYER | LOBBYIST | CLIENT | EMPLOYER | CLIENT | CLIENT | CLIENT | EMPLOYER | None | FIRM | FIRM | FIRM | |||||||||||||||
ethics_dt | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
interests | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
filer_full_name | ELOY Z. GARCIA | ELOY Z. GARCIA | ELOY Z. GARCIA | ELOY Z. GARCIA | ELOY Z. GARCIA | ELOY Z. GARCIA | ELOY Z. GARCIA | ELOY Z. GARCIA | ELOY Z. GARCIA | ELOY Z. GARCIA | ELOY Z. GARCIA | GARCIA, ELOY Z. | ELOY Z. GARCIA | GARCIA, ELOY | GARCIA, ELOY | |||||||||||||||
filer_city | Los Angeles | Trona | SACRAMENTO | SACRAMENTO | None | Sacramento | SACRAMENTO | SACRAMENTO | CYPRESS | Roseville | Sacramento | None | None | None | SACRAMENTO | |||||||||||||||
filer_st | CA | CA | CA | CA | None | CA | CA | CA | CA | CA | CA | None | None | None | CA | |||||||||||||||
filer_zip | 90007 | 93592 | 95814 | 95814 | None | 95814 | 95814 | 95814 | 90630 | 95661 | 95814 | None | None | None | 95814 | |||||||||||||||
filer_phone | 2137633346 | 7603722042 | 9164475793 | 9164475793 | None | 9164482162 | 9164446670 | 9164467100 | 7142263582 | 9167743381 | 9164467100 | None | None | None | 9164482162 | |||||||||||||||
entity_type | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | |||||||||||||||
entity_name | KAHL/POWNALL ADVOCATES | KAHL/POWNALL ADVOCATES | KAHL/POWNALL ADVOCATES | KAHL/POWNALL ADVOCATES | KAHL/POWNALL ADVOCATES | KAHL/POWNALL ADVOCATES | KAHL/POWNALL ADVOCATES | KAHL/POWNALL ADVOCATES | KAHL/POWNALL ADVOCATES | KAHL/POWNALL ADVOCATES | KAHL/POWNALL ADVOCATES | KAHL/POWNALL ADVOCATES | KP ADVOCATES | KP PUBLIC AFFAIRS | GARCIA GOVERNMENT AFFAIRS, LLC | |||||||||||||||
entity_city | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
entity_st | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
entity_zip | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
entity_phone | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
entity_id | 1147235 | 1147235 | 1147235 | 1147235 | 1147235 | 1147235 | 1147235 | 1147235 | 1147235 | 1147235 | 1147235 | 1147235 | 1147235 | 1147235 | None | |||||||||||||||
responsible_officer | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
effect_dt | None | None | None | None | None | None | None | None | None | None | None | 2003-05-31 00:00:00 | 2006-01-17 00:00:00 | 2017-10-31 00:00:00 | 2017-11-01 00:00:00 |
filer_id | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | 1149573 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_file_name | 638514_0.cal | 646233_0.cal | 683009_0.cal | 719330_0.cal | 746550_0.cal | 770784_0.cal | 791690_0.cal | 813572_0.cal | 837422_0.cal | 855975_0.cal | 879346_0.cal | 909452_0.cal | 929301_0.cal | 942895_0.cal | 283831.cal | 945222_0.cal | 969481_0.cal | 990481_0.cal | 1027310_0.cal | 1014163_0.cal | 1059285_0.cal | 1076690_0.cal | 1152660_0.cal | 1166454_0.cal | 1189267_0.cal | 1329113_0.cal | 1507792_0.cal | 1554235_0.cal | 1392912_0.cal | 1350744_0.cal | 1484419_0.cal | 1451277_0.cal | 1236382_0.cal | 1215711_0.cal | 1260045_0.cal | 1225243_0.cal | 1464204_0.cal | 1282980_0.cal | 1436554_0.cal | 1421395_0.cal | 1294314_0.cal | 1386442_0.cal | 1377279_0.cal | 1311706_0.cal | 1845809_0.cal | 1720587_1.cal | 1734139_0.cal | 1678926_0.cal | 1782371_0.cal | 1538321_0.cal | 1554235_1.cal | 1571075_0.cal | 1817118_0.cal | 1607794_0.cal | 1590629_0.cal | 1800296_0.cal | 1765119_0.cal | 1637128_0.cal | 1620455_0.cal | 1707963_0.cal | 1720587_0.cal | 1657242_0.cal | 1872429_0.cal | 1965459_0.cal | 1922058_1.cal | 1979108_0.cal | 2154935_0.cal | 2127840_0.cal | 2113676_1.cal | 2059464_0.cal | 1996606_0.cal | 2009343_0.cal | 2113676_0.cal | 2102121_0.cal | 1922058_0.cal | 1911503_0.cal | 2037807_0.cal | 1935103_0.cal | 2175815_0.cal | 2319673_0.cal | 2211663_0.cal | 2208001_0.cal | 2381561_0.cal | 2191714_0.cal | 2275371_0.cal | 2242557_0.cal | 2415971_0.cal | 149455.cal | 2195925_0.cal | 2397200_0.cal | 2469768_0.cal | 2349899_0.cal | 2330528_1.cal | 2381561_1.cal | 2442973_0.cal | 2330528_0.cal | 2487303_0.cal | 2562825_0.cal | 2621774_0.cal | 99465.cal | 2674021_0.cal | 2581021_0.cal | 2703268_0.cal | 2554221_0.cal | 2531261_0.cal | 2746061_0.cal | 2602663_0.cal | 2644795_0.cal | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
received_date | 2000-07-10 00:00:00 | 2000-08-01 00:00:00 | 2000-10-31 00:00:00 | 2001-01-31 00:00:00 | 2001-04-30 00:00:00 | 2001-07-27 00:00:00 | 2001-10-31 00:00:00 | 2002-01-31 00:00:00 | 2002-04-25 00:00:00 | 2002-07-31 00:00:00 | 2002-10-25 00:00:00 | 2003-01-30 00:00:00 | 2003-04-28 00:00:00 | 2003-07-20 00:00:00 | 2003-07-31 00:00:00 | 2003-07-28 00:00:00 | 2003-10-31 00:00:00 | 2004-02-02 00:00:00 | 2004-07-28 00:00:00 | 2004-04-30 00:00:00 | 2004-11-01 00:00:00 | 2005-01-27 00:00:00 | 2006-02-23 00:00:00 | 2006-04-28 00:00:00 | 2006-07-28 00:00:00 | 2008-04-30 00:00:00 | 2010-08-02 00:00:00 | 2010-12-28 00:00:00 | 2009-01-27 00:00:00 | 2008-07-31 00:00:00 | 2010-04-29 00:00:00 | 2009-10-29 00:00:00 | 2007-01-30 00:00:00 | 2006-10-30 00:00:00 | 2007-04-26 00:00:00 | 2006-12-29 00:00:00 | 2010-01-31 00:00:00 | 2007-07-30 00:00:00 | 2009-07-30 00:00:00 | 2009-04-30 00:00:00 | 2007-10-23 00:00:00 | 2008-12-30 00:00:00 | 2008-10-30 00:00:00 | 2008-01-31 00:00:00 | 2014-04-30 00:00:00 | 2013-01-30 00:00:00 | 2013-01-28 00:00:00 | 2012-07-31 00:00:00 | 2013-07-31 00:00:00 | 2010-10-28 00:00:00 | 2011-01-20 00:00:00 | 2011-01-31 00:00:00 | 2014-01-30 00:00:00 | 2011-08-01 00:00:00 | 2011-04-29 00:00:00 | 2013-10-31 00:00:00 | 2013-04-30 00:00:00 | 2012-01-31 00:00:00 | 2011-10-27 00:00:00 | 2012-10-30 00:00:00 | 2012-12-27 00:00:00 | 2012-04-30 00:00:00 | 2014-07-31 00:00:00 | 2015-04-30 00:00:00 | 2015-06-23 00:00:00 | 2015-07-29 00:00:00 | 2017-04-27 00:00:00 | 2017-01-30 00:00:00 | 2017-02-24 00:00:00 | 2016-07-27 00:00:00 | 2015-10-30 00:00:00 | 2016-01-28 00:00:00 | 2016-12-22 00:00:00 | 2016-10-31 00:00:00 | 2014-12-30 00:00:00 | 2014-10-31 00:00:00 | 2016-05-02 00:00:00 | 2015-01-30 00:00:00 | 2017-07-31 00:00:00 | 2018-10-31 00:00:00 | 2018-01-31 00:00:00 | 2018-01-29 00:00:00 | 2019-04-30 00:00:00 | 2017-10-30 00:00:00 | 2018-07-31 00:00:00 | 2018-04-30 00:00:00 | 2019-10-27 00:00:00 | 2017-11-13 00:00:00 | 2017-11-13 00:00:00 | 2019-07-30 00:00:00 | 2020-04-29 00:00:00 | 2019-01-31 00:00:00 | 2019-05-29 00:00:00 | 2019-07-30 00:00:00 | 2020-01-31 00:00:00 | 2018-12-28 00:00:00 | 2020-07-31 00:00:00 | 2021-03-04 00:00:00 | 2021-10-28 00:00:00 | 2021-03-04 00:00:00 | 2022-04-28 00:00:00 | 2021-04-30 00:00:00 | 2022-07-28 00:00:00 | 2021-02-01 00:00:00 | 2020-11-02 00:00:00 | 2022-10-29 00:00:00 | 2021-08-02 00:00:00 | 2022-01-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 | /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/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/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 | /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 | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_id | 638514 | 646233 | 683009 | 719330 | 746550 | 770784 | 791690 | 813572 | 837422 | 855975 | 879346 | 909452 | 929301 | 942895 | None | 945222 | 969481 | 990481 | 1027310 | 1014163 | 1059285 | 1076690 | 1152660 | 1166454 | 1189267 | 1329113 | 1507792 | 1554235 | 1392912 | 1350744 | 1484419 | 1451277 | 1236382 | 1215711 | 1260045 | 1225243 | 1464204 | 1282980 | 1436554 | 1421395 | 1294314 | 1386442 | 1377279 | 1311706 | 1845809 | 1720587 | 1734139 | 1678926 | 1782371 | 1538321 | 1554235 | 1571075 | 1817118 | 1607794 | 1590629 | 1800296 | 1765119 | 1637128 | 1620455 | 1707963 | 1720587 | 1657242 | 1872429 | 1965459 | 1922058 | 1979108 | 2154935 | 2127840 | 2113676 | 2059464 | 1996606 | 2009343 | 2113676 | 2102121 | 1922058 | 1911503 | 2037807 | 1935103 | 2175815 | 2319673 | 2211663 | 2208001 | 2381561 | 2191714 | 2275371 | 2242557 | 2415971 | None | 2195925 | 2397200 | 2469768 | 2349899 | 2330528 | 2381561 | 2442973 | 2330528 | 2487303 | 2562825 | 2621774 | None | 2674021 | 2581021 | 2703268 | 2554221 | 2531261 | 2746061 | 2602663 | 2644795 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | None | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F604 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | None | F604 | F615 | F615 | F615 | F604 | F615 | F615 | F604 | F615 | F604 | F615 | None | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 passed validation, but failed DB constraints | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing 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 | 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 passed validation, but failed DB constraints | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing passed validation, but failed DB constraints | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted |