filer_id | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
adrid | 1110438 | 2046679 | 2081494 | 2118074 | 2164219 | 2208004 | 2418175 | 2515894 | 2471670 | 2275912 | 2551758 | 2342692 | 2542477 | |||||||||||||
effect_dt | 1999-01-01 00:00:00 | 2003-01-01 00:00:00 | 2005-01-01 00:00:00 | 2007-01-22 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 | 2019-01-01 00:00:00 | 2013-01-01 00:00:00 | 2023-01-01 00:00:00 | 2015-01-01 00:00:00 | 2022-08-15 00:00:00 | |||||||||||||
add_type | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | |||||||||||||
session_id | 1999 | 2003 | 2005 | 2007 | 2009 | 2011 | 2017 | 2021 | 2019 | 2013 | 2023 | 2015 | 2021 |
filer_id | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 663339 | 468988 | 474521 | 497453 | 482953 | 493842 | 477440 | 486487 | 471920 | 480112 | 490152 | 493842 | 486487 | 490152 | 471920 | 631675 | 614269 | 652273 | 683433 | 702560 | 712557 | 712559 | 715606 | 689727 | 730292 | 743259 | 758319 | 768375 | 789334 | 780958 | 795621 | 808941 | 819204 | 836213 | 861295 | 851164 | 842439 | 876767 | 890494 | 914315 | 918126 | 942909 | 930587 | 928179 | 921768 | 943819 | 965602 | 974522 | 1010026 | 1011535 | 984294 | 997277 | 1027873 | 1023939 | 1020727 | 1048694 | 1066286 | 1085762 | 1092977 | 1101609 | 1113394 | 1113394 | 1078901 | 1129032 | 1129404 | 1144106 | 1165057 | 1181903 | 1185864 | 1186378 | 1209885 | 1230081 | 1241824 | 1258085 | 1280756 | 1304861 | 1293783 | 1776407 | 1973703 | 1957312 | 1864143 | 1950866 | 1907945 | 1325653 | 1344064 | 1367486 | 1385946 | 1390382 | 1411472 | 1417894 | 1431928 | 1449262 | 1458882 | 1481305 | 1502328 | 1531136 | 1557215 | 1563408 | 1553370 | 1587377 | 1602858 | 1587377 | 1633676 | 1618689 | 1652996 | 1814182 | 1796920 | 1674779 | 1928606 | 1921113 | 1718013 | 1706134 | 1729825 | 1726569 | 1839812 | 1763109 | 1991320 | 2002795 | 2400007 | 2420210 | 2212285 | 2194413 | 2321235 | 2443872 | 2360880 | 2027466 | 2054378 | 2085897 | 2117874 | 2142292 | 2177096 | 2158374 | 2350812 | 2381585 | 2329747 | 2532058 | 2555093 | 2580697 | 2471529 | 2541762 | 2277271 | 2243001 | 2603782 | 2678361 | 2487996 | 2714397 | 2645048 | 2570206 | 2625277 | 2708478 | 2749099 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
period_id | 162 | 157 | 158 | 156 | 152 | 155 | 151 | 153 | 150 | 159 | 154 | 155 | 153 | 154 | 150 | 161 | 160 | 161 | 163 | None | 163 | 162 | 164 | 163 | 164 | 165 | 165 | 166 | 167 | None | None | 168 | None | 169 | None | 170 | None | 171 | None | None | 172 | 174 | None | 173 | None | 174 | 175 | None | 177 | None | 176 | None | None | 178 | None | 179 | None | None | None | 181 | 182 | 182 | 180 | None | 183 | 184 | 185 | None | 186 | None | 187 | 188 | None | 189 | 190 | 192 | 191 | 214 | 222 | 221 | 218 | None | 219 | 193 | 194 | 195 | 196 | 196 | None | 197 | 198 | 199 | 200 | 201 | 202 | 203 | None | 204 | 204 | 205 | 206 | 205 | 208 | 207 | 209 | 216 | 215 | 210 | 220 | 220 | 212 | 211 | 212 | None | 217 | 213 | 223 | 224 | 238 | 239 | 232 | 231 | 235 | 240 | None | 225 | 226 | 227 | 228 | None | 230 | 229 | 236 | 237 | 236 | 243 | 244 | 245 | 241 | 244 | 234 | 233 | 246 | 249 | 242 | None | 248 | None | 247 | 250 | 251 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F690 | F635 | F690 | F690 | F690 | F635 | F635 | F635 | F635 | F690 | F635 | F602 | F690 | F690 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F690 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F690 | F635 | F635 | F635 | F602 | F635 | F602 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F602 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F602 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F605 | F635 | F602 | F635 | F635 | F635 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_sequence | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 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 | 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 | 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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_date | 2000-07-28 00:00:00 | 1999-04-27 00:00:00 | 1999-09-24 00:00:00 | 1999-01-29 00:00:00 | 1998-02-02 00:00:00 | 1998-11-03 00:00:00 | 1997-10-31 00:00:00 | 1998-04-30 00:00:00 | 1997-10-31 00:00:00 | 1999-11-01 00:00:00 | 1999-01-29 00:00:00 | 1999-01-29 00:00:00 | 1999-01-29 00:00:00 | 1998-07-30 00:00:00 | 1997-07-31 00:00:00 | 2000-05-01 00:00:00 | 2000-01-28 00:00:00 | 2000-08-11 00:00:00 | 2000-11-01 00:00:00 | 2000-12-26 00:00:00 | 2000-11-07 00:00:00 | 2000-11-07 00:00:00 | 2001-01-27 00:00:00 | 2000-10-31 00:00:00 | 2001-01-26 00:00:00 | 2001-04-24 00:00:00 | 2001-04-30 00:00:00 | 2001-07-19 00:00:00 | 2001-10-25 00:00:00 | 2001-07-25 00:00:00 | 2001-10-29 00:00:00 | 2002-01-22 00:00:00 | 2002-01-28 00:00:00 | 2002-04-19 00:00:00 | 2002-07-29 00:00:00 | 2002-07-23 00:00:00 | 2002-04-25 00:00:00 | 2002-10-23 00:00:00 | 2002-10-28 00:00:00 | 2002-12-24 00:00:00 | 2003-02-11 00:00:00 | 2003-07-20 00:00:00 | 2003-04-21 00:00:00 | 2003-04-21 00:00:00 | 2003-02-11 00:00:00 | 2003-07-22 00:00:00 | 2003-10-20 00:00:00 | 2003-10-27 00:00:00 | 2004-04-20 00:00:00 | 2004-04-26 00:00:00 | 2004-01-21 00:00:00 | 2004-01-23 00:00:00 | 2004-07-23 00:00:00 | 2004-07-19 00:00:00 | 2004-06-14 00:00:00 | 2004-10-18 00:00:00 | 2004-10-25 00:00:00 | 2004-12-29 00:00:00 | 2005-01-31 00:00:00 | 2005-04-21 00:00:00 | 2005-07-22 00:00:00 | 2005-07-22 00:00:00 | 2005-01-28 00:00:00 | 2005-01-27 00:00:00 | 2005-10-21 00:00:00 | 2006-01-25 00:00:00 | 2006-04-26 00:00:00 | 2006-06-29 00:00:00 | 2006-07-21 00:00:00 | 2006-07-21 00:00:00 | 2006-10-23 00:00:00 | 2007-01-23 00:00:00 | 2007-01-24 00:00:00 | 2007-04-20 00:00:00 | 2007-07-26 00:00:00 | 2008-01-22 00:00:00 | 2007-10-22 00:00:00 | 2013-07-18 00:00:00 | 2015-07-10 00:00:00 | 2015-04-10 00:00:00 | 2014-07-18 00:00:00 | 2014-12-29 00:00:00 | 2014-10-29 00:00:00 | 2008-04-21 00:00:00 | 2008-07-18 00:00:00 | 2008-10-20 00:00:00 | 2008-12-29 00:00:00 | 2009-01-21 00:00:00 | 2008-12-29 00:00:00 | 2009-04-21 00:00:00 | 2009-07-21 00:00:00 | 2009-10-23 00:00:00 | 2010-01-21 00:00:00 | 2010-04-22 00:00:00 | 2010-07-22 00:00:00 | 2010-10-21 00:00:00 | 2010-12-21 00:00:00 | 2011-01-21 00:00:00 | 2010-12-22 00:00:00 | 2011-04-21 00:00:00 | 2011-07-25 00:00:00 | 2011-07-25 00:00:00 | 2012-01-30 00:00:00 | 2011-10-21 00:00:00 | 2012-04-19 00:00:00 | 2014-01-28 00:00:00 | 2013-10-24 00:00:00 | 2012-07-26 00:00:00 | 2015-01-23 00:00:00 | 2014-12-29 00:00:00 | 2012-12-18 00:00:00 | 2012-10-29 00:00:00 | 2013-01-22 00:00:00 | 2012-12-19 00:00:00 | 2014-04-21 00:00:00 | 2013-04-29 00:00:00 | 2015-10-09 00:00:00 | 2016-01-08 00:00:00 | 2019-07-31 00:00:00 | 2019-10-31 00:00:00 | 2018-01-31 00:00:00 | 2017-10-31 00:00:00 | 2018-10-31 00:00:00 | 2020-01-31 00:00:00 | 2018-12-28 00:00:00 | 2016-04-12 00:00:00 | 2016-07-11 00:00:00 | 2016-10-06 00:00:00 | 2017-01-09 00:00:00 | 2016-12-30 00:00:00 | 2017-07-31 00:00:00 | 2017-05-02 00:00:00 | 2019-01-31 00:00:00 | 2019-04-30 00:00:00 | 2018-12-27 00:00:00 | 2020-11-02 00:00:00 | 2021-02-01 00:00:00 | 2021-04-30 00:00:00 | 2020-04-30 00:00:00 | 2020-12-31 00:00:00 | 2018-07-31 00:00:00 | 2018-04-30 00:00:00 | 2021-08-02 00:00:00 | 2022-05-02 00:00:00 | 2020-07-31 00:00:00 | 2022-08-24 00:00:00 | 2022-01-31 00:00:00 | 2020-12-30 00:00:00 | 2021-11-01 00:00:00 | 2022-08-01 00:00:00 | 2022-10-31 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_type | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10005 | 10005 | 10001 | 10005 | 10005 | 10005 | 10001 | 10005 | 10005 | 10001 | 10005 | 10001 | 10001 | 10005 | 10005 | 10001 | 10005 | 10001 | 10005 | 10001 | 10005 | 10001 | 10005 | 10005 | 10001 | 10001 | 10005 | 10001 | 10005 | 10005 | 10001 | 10005 | 10001 | 10005 | 10001 | 10005 | 10005 | 10001 | 10006 | 10001 | 10005 | 10005 | 10005 | 10001 | 10002 | 10001 | 10001 | 10006 | 10001 | 10001 | 10001 | 10005 | 10001 | 10005 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | 10005 | 10001 | 10001 | 10001 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_status | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 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 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 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 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
session_id | 1999 | 1999 | 1999 | 1997 | 1997 | 1997 | 1997 | 1997 | 1997 | 1999 | 1997 | 1997 | 1997 | 1997 | 1997 | 1999 | 1999 | 1999 | 1999 | 2001 | 1999 | 1999 | 1999 | 1999 | 1999 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2003 | 2001 | 2003 | 2003 | 2003 | 2001 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2005 | 2003 | 2005 | 2005 | 2005 | 2003 | 2003 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2007 | 2007 | 2007 | 2007 | 2007 | 2013 | 2015 | 2015 | 2013 | 2015 | 2013 | 2007 | 2007 | 2007 | 2009 | 2007 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2011 | 2009 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2013 | 2013 | 2011 | 2013 | 2015 | 2013 | 2011 | 2011 | 2013 | 2013 | 2013 | 2015 | 2015 | 2019 | 2019 | 2017 | 2017 | 2017 | 2019 | 2019 | 2015 | 2015 | 2015 | 2015 | 2017 | 2017 | 2017 | 2017 | 2019 | 2019 | 2019 | 2019 | 2021 | 2019 | 2021 | 2017 | 2017 | 2021 | 2021 | 2019 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
user_id | YBONILLA | * | * | * | * | * | * | * | * | * | * | * | * | * | * | TTHAM | * | JLEHMAN | * | CFLAGG | YBONILLA | YBONILLA | * | YBONILLA | YBONILLA | * | YBONILLA | * | * | YBONILLA | LTHIBAUL | * | LTHIBAUL | * | LTHIBAUL | * | LTHIBAUL | * | LTHIBAUL | SARRIAGA | DHORRELL | COMPLETED | LTHIBAUL | COMPLETED | LTHIBAUL | GPEREZ | COMPLETED | LTHIBAUL | COMPLETED | LTHIBAUL | COMPLETED | LTHIBAUL | LTHIBAUL | COMPLETED | EMCENTEE | COMPLETED | LTHIBAUL | CFLAGG | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | COMPLETED | GGILMORE | LTHIBAUL | LTHIBAUL | LTHIBAUL | CFLAGG | LTHIBAUL | CFLAGG | LTHIBAUL | LTHIBAUL | CFLAGG | LTHIBAUL | YRODRIGU | LTHIBAUL | YRODRIGU | AGLADNEY | AGLADNEY | AGLADNEY | ASAETERN | GPEREZ | ASAETERN | RGEREMIA | LTHIBAUL | ASAETERN | * | ASAETERN | SARRIAGA | WBROWN | WBROWN | WBROWN | WBROWN | ASAETERN | ASAETERN | ASAETERN | DMCCASTL | ASAETERN | * | AGLADNEY | ASAETERN | AGLADNEY | ASAETERN | ASAETERN | ASAETERN | AGLADNEY | ASAETERN | ASAETERN | ASAETERN | CAFILER | CAFILER | AGLADNEY | AGLADNEY | GPEREZ | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | VUKSTINA | VUKSTINA | AGLADNEY | AGLADNEY | AGLADNEY | VUKSTINA | DMCCASTL | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | YRODRIGU | AGLADNEY | KBANH | AGLADNEY | VUKSTINA | CAFILER | CHARTRIDGE | GTAYLOR | CHATRIDGE | VUKSTINA | CVANLIEW | AGLADNEY | AGLADNEY | CHATRIDGE | CAFILER | MKIRKHAM | CVANLIEW | GTAYLOR | CVANLIEW | GTAYLOR | CAFILER | CAFILER | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
special_audit | 11003 | 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 | 11002 | 11003 | 11002 | 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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fine_audit | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | 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 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | 11003 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_start | 2000-04-01 00:00:00 | 1999-01-01 00:00:00 | 1999-04-01 00:00:00 | 1998-10-01 00:00:00 | 1997-10-01 00:00:00 | 1998-07-01 00:00:00 | 1997-07-01 00:00:00 | 1998-01-01 00:00:00 | 1997-04-01 00:00:00 | 1999-07-01 00:00:00 | 1998-04-01 00:00:00 | 1998-07-01 00:00:00 | 1998-01-01 00:00:00 | 1998-04-01 00:00:00 | 1997-04-01 00:00:00 | 2000-01-01 00:00:00 | 1999-10-01 00:00:00 | 2000-01-01 00:00:00 | 2000-07-01 00:00:00 | 1900-01-01 00:00:00 | 2000-07-01 00:00:00 | 2000-04-01 00:00:00 | 2000-10-01 00:00:00 | 2000-07-01 00:00:00 | 2000-10-01 00:00:00 | 2001-01-01 00:00:00 | 2001-01-01 00:00:00 | 2001-04-01 00:00:00 | 2001-07-01 00:00:00 | 2001-04-01 00:00:00 | 2001-07-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 | 2002-07-01 00:00:00 | 1900-01-01 00:00:00 | 2002-10-01 00:00:00 | 2003-04-01 00:00:00 | 2003-01-01 00:00:00 | 2003-01-01 00:00:00 | 2002-10-01 00:00:00 | 2003-04-01 00:00:00 | 2003-07-01 00:00:00 | 2003-07-01 00:00:00 | 2004-01-01 00:00:00 | 2004-01-01 00:00:00 | 2003-10-01 00:00:00 | 2003-10-01 00:00:00 | 2004-04-01 00:00:00 | 2004-04-01 00:00:00 | 2003-10-01 00:00:00 | 2004-07-01 00:00:00 | 2004-07-01 00:00:00 | 1900-01-01 00:00:00 | 2004-10-01 00:00:00 | 2005-01-01 00:00:00 | 2005-04-01 00:00:00 | 2005-04-01 00:00:00 | 2004-10-01 00:00:00 | 2004-01-01 00:00:00 | 2005-07-01 00:00:00 | 2005-10-01 00:00:00 | 2006-01-01 00:00:00 | 1900-01-01 00:00:00 | 2006-04-01 00:00:00 | 1900-01-01 00:00:00 | 2006-07-01 00:00:00 | 2006-10-01 00:00:00 | 1900-01-01 00:00:00 | 2007-01-01 00:00:00 | 2007-04-01 00:00:00 | 2007-10-01 00:00:00 | 2007-07-01 00:00:00 | 2013-04-01 00:00:00 | 2015-04-01 00:00:00 | 2015-01-01 00:00:00 | 2014-04-01 00:00:00 | 1900-01-01 00:00:00 | 2014-07-01 00:00:00 | 2008-01-01 00:00:00 | 2008-04-01 00:00:00 | 2008-07-01 00:00:00 | 2008-12-29 00:00:00 | 2008-10-01 00:00:00 | 1900-01-01 00:00:00 | 2009-01-01 00:00:00 | 2009-04-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 | 1900-01-01 00:00:00 | 2010-10-01 00:00:00 | 2010-12-22 00:00:00 | 2011-01-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 | 2013-10-01 00:00:00 | 2013-07-01 00:00:00 | 2012-04-01 00:00:00 | 2014-10-01 00:00:00 | 2014-12-29 00:00:00 | 2012-12-18 00:00:00 | 2012-07-01 00:00:00 | 2012-10-01 00:00:00 | 1900-01-01 00:00:00 | 2014-01-01 00:00:00 | 2013-01-01 00:00:00 | 2015-07-01 00:00:00 | 2015-10-01 00:00:00 | 2019-04-01 00:00:00 | 2019-07-01 00:00:00 | 2017-10-01 00:00:00 | 2017-07-01 00:00:00 | 2018-07-01 00:00:00 | 2019-10-01 00:00:00 | 1900-01-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 | 1900-01-01 00:00:00 | 2017-04-01 00:00:00 | 2017-01-01 00:00:00 | 2018-10-01 00:00:00 | 2019-01-01 00:00:00 | 2018-12-27 00:00:00 | 2020-07-01 00:00:00 | 2020-10-01 00:00:00 | 2021-01-01 00:00:00 | 2020-01-01 00:00:00 | 2020-12-31 00:00:00 | 2018-04-01 00:00:00 | 2018-01-01 00:00:00 | 2021-04-01 00:00:00 | 2022-01-01 00:00:00 | 2020-04-01 00:00:00 | 1900-01-01 00:00:00 | 2021-10-01 00:00:00 | 1900-01-01 00:00:00 | 2021-07-01 00:00:00 | 2022-04-01 00:00:00 | 2022-07-01 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_end | 2000-06-30 00:00:00 | 1999-03-31 00:00:00 | 1999-06-30 00:00:00 | 1998-12-31 00:00:00 | 1997-12-31 00:00:00 | 1998-09-30 00:00:00 | 1997-09-30 00:00:00 | 1998-03-31 00:00:00 | 1997-06-30 00:00:00 | 1999-09-30 00:00:00 | 1998-06-30 00:00:00 | 1998-09-30 00:00:00 | 1998-03-31 00:00:00 | 1998-06-30 00:00:00 | 1997-06-30 00:00:00 | 2000-03-31 00:00:00 | 1999-12-31 00:00:00 | 2000-03-31 00:00:00 | 2000-09-30 00:00:00 | 1900-01-01 00:00:00 | 2000-09-30 00:00:00 | 2000-06-30 00:00:00 | 2000-12-31 00:00:00 | 2000-09-30 00:00:00 | 2000-12-31 00:00:00 | 2001-03-31 00:00:00 | 2001-03-31 00:00:00 | 2001-06-30 00:00:00 | 2001-09-30 00:00:00 | 2001-06-30 00:00:00 | 2001-09-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 | 2002-09-30 00:00:00 | 1900-01-01 00:00:00 | 2002-12-31 00:00:00 | 2003-06-30 00:00:00 | 2003-03-31 00:00:00 | 2003-03-31 00:00:00 | 2002-12-31 00:00:00 | 2003-06-30 00:00:00 | 2003-09-30 00:00:00 | 2003-09-30 00:00:00 | 2004-03-31 00:00:00 | 2004-03-31 00:00:00 | 2003-12-31 00:00:00 | 2003-12-31 00:00:00 | 2004-06-30 00:00:00 | 2004-06-30 00:00:00 | 2003-12-31 00:00:00 | 2004-09-30 00:00:00 | 2004-09-30 00:00:00 | 1900-01-01 00:00:00 | 2004-12-31 00:00:00 | 2005-03-31 00:00:00 | 2005-06-30 00:00:00 | 2005-06-30 00:00:00 | 2004-12-31 00:00:00 | 2004-03-31 00:00:00 | 2005-09-30 00:00:00 | 2005-12-31 00:00:00 | 2006-03-31 00:00:00 | 1900-01-01 00:00:00 | 2006-06-30 00:00:00 | 1900-01-01 00:00:00 | 2006-09-30 00:00:00 | 2006-12-31 00:00:00 | 1900-01-01 00:00:00 | 2007-03-31 00:00:00 | 2007-06-30 00:00:00 | 2007-12-31 00:00:00 | 2007-09-30 00:00:00 | 2013-06-30 00:00:00 | 2015-06-30 00:00:00 | 2015-03-31 00:00:00 | 2014-06-30 00:00:00 | 1900-01-01 00:00:00 | 2014-09-30 00:00:00 | 2008-03-31 00:00:00 | 2008-06-30 00:00:00 | 2008-09-30 00:00:00 | 2008-12-29 00:00:00 | 2008-12-31 00:00:00 | 1900-01-01 00:00:00 | 2009-03-31 00:00:00 | 2009-06-30 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 | 1900-01-01 00:00:00 | 2010-12-31 00:00:00 | 2010-12-22 00:00:00 | 2011-03-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 | 2013-12-31 00:00:00 | 2013-09-30 00:00:00 | 2012-06-30 00:00:00 | 2014-12-31 00:00:00 | 2014-12-29 00:00:00 | 2012-12-18 00:00:00 | 2012-09-30 00:00:00 | 2012-12-31 00:00:00 | 1900-01-01 00:00:00 | 2014-03-31 00:00:00 | 2013-03-31 00:00:00 | 2015-09-30 00:00:00 | 2015-12-31 00:00:00 | 2019-06-30 00:00:00 | 2019-09-30 00:00:00 | 2017-12-31 00:00:00 | 2017-09-30 00:00:00 | 2018-09-30 00:00:00 | 2019-12-31 00:00:00 | 1900-01-01 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 | 1900-01-01 00:00:00 | 2017-06-30 00:00:00 | 2017-03-31 00:00:00 | 2018-12-31 00:00:00 | 2019-03-31 00:00:00 | 2018-12-27 00:00:00 | 2020-09-30 00:00:00 | 2020-12-31 00:00:00 | 2021-03-31 00:00:00 | 2020-03-31 00:00:00 | 2020-12-31 00:00:00 | 2018-06-30 00:00:00 | 2018-03-31 00:00:00 | 2021-06-30 00:00:00 | 2022-03-31 00:00:00 | 2020-05-30 00:00:00 | 1900-01-01 00:00:00 | 2021-12-31 00:00:00 | 1900-01-01 00:00:00 | 2021-09-30 00:00:00 | 2022-06-30 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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | 22001 | 22001 | None | 22001 | None | None | 22001 | None | 22001 | None | 22001 | None | None | 22001 | None | 22001 | None | None | None | 22006 | 22006 | 22006 | 22001 | None | 22006 | 22006 | 22006 | None | 22006 | None | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22006 | 22006 | 22006 | 22006 | None | 22001 | 22001 | 22001 | 22001 | 22006 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | None | 22001 | 22001 | 22001 |
filer_id | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
session_id | 2003 | 1999 | 1997 | 2001 | 2013 | 2007 | 2009 | 2011 | 2005 | 2017 | 2015 | 2019 | 2021 | 2023 | ||||||||||||||
interest_cd | 40312 | 40310 | 40310 | 40315 | 40312 | 40312 | 40312 | 40312 | 40312 | 40310 | 40312 | 40310 | 40310 | 40310 | ||||||||||||||
effect_date | 2003-01-01 00:00:00 | 1999-01-01 00:00:00 | 1997-05-23 00:00:00 | 2001-01-01 00:00:00 | 2013-01-01 00:00:00 | 2007-01-22 00:00:00 | 2009-01-01 00:00:00 | 2011-01-01 00:00:00 | 2005-01-01 00:00:00 | 2017-01-01 00:00:00 | 2015-01-01 00:00:00 | 2019-01-01 00:00:00 | 2021-01-01 00:00:00 | 2023-01-01 00:00:00 |
filer_id | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_type | 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 | N | ||||||||||||||
race | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
session_id | 1999 | 1997 | 2001 | 2003 | 2005 | 2007 | 2013 | 2011 | 2009 | 2017 | 2021 | 2015 | 2019 | 2023 | ||||||||||||||
category | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
category_type | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
sub_category | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
effect_dt | 1999-01-01 00:00:00 | 1997-05-23 00:00:00 | 2001-01-01 00:00:00 | 2003-01-01 00:00:00 | 2005-01-01 00:00:00 | 2007-01-22 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 | 2021-01-01 00:00:00 | 2015-01-01 00:00:00 | 2019-01-01 00:00:00 | 2023-01-01 00:00:00 | ||||||||||||||
sub_category_type | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
election_type | 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 | ||||||||||||||
nyq_dt | 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 | ||||||||||||||
county_cd | 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 |
filer_id | 1145487 | |
---|---|---|
xref_id | C26984 | |
effect_dt | 1999-12-08 00:00:00 | |
migration_source | MASTER |
xref_filer_id | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | C26984 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_id | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | LISLE | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
st | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | IL | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
zip4 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | 60532 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
phon | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | 6305050160 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fax | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | 6305059637 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | 1145487 |
---|
filer_id | 1145487 | 1145487 | 1145487 | 1145487 | ||||
---|---|---|---|---|---|---|---|---|
change_no | 2 | 0 | 1 | 3 | ||||
session_id | 2005 | 2005 | 2005 | 2021 | ||||
log_dt | 2006-07-21 00:00:00 | 2006-06-29 00:00:00 | 2006-06-29 00:00:00 | 2020-12-30 00:00:00 | ||||
filer_type | 1 | 1 | 1 | 1 | ||||
correction_flg | None | None | None | None | ||||
action | SET ACTIVE | ADDED | IN SUSPENSE | CHANGED | ||||
attribute_changed | FIRM | FIRM | FIRM | RESPONSIBLE OFFICER | ||||
ethics_dt | None | None | None | None | ||||
interests | None | None | None | None | ||||
filer_full_name | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | WATER QUALITY ASSOCIATION | ||||
filer_city | None | None | None | None | ||||
filer_st | None | None | None | None | ||||
filer_zip | None | None | None | None | ||||
filer_phone | None | None | None | None | ||||
entity_type | 3 | 3 | 3 | 20 | ||||
entity_name | MADDOX GOVERNMENT RELATIONS, INC. | MADDOX GOVERNMENT RELATIONS, INC. | MADDOX GOVERNMENT RELATIONS, INC. | GOVERNMENT AFFAIRS DIRECTOR DAVID LOVEDAY | ||||
entity_city | None | None | None | None | ||||
entity_st | None | None | None | None | ||||
entity_zip | None | None | None | None | ||||
entity_phone | None | None | None | None | ||||
entity_id | 1281940 | 1281940 | 1281940 | 1437267 | ||||
responsible_officer | None | None | None | None | ||||
effect_dt | 2006-06-22 00:00:00 | 2006-06-02 00:00:00 | 2006-06-02 00:00:00 | 2021-01-01 00:00:00 |
filer_id | 1145487 | |
---|---|---|
filing_period_start_dt | 2000-10-01 00:00:00 | |
filing_period_end_dt | 2000-12-31 00:00:00 | |
contribution_dt | None | |
recipient_name | ||
recipient_id | 1070772 | |
amount | 0 |
filer_id | 1145487 | |
---|---|---|
filing_period_start_dt | 2000-10-01 00:00:00 | |
filing_period_end_dt | 2000-12-31 00:00:00 | |
contribution_dt | None | |
recipient_name | ||
recipient_id | 1070772 | |
amount | 0 |
filer_id | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | 1145487 | ||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_file_name | 683433_0.cal | 715606_0.cal | 743259_0.cal | 768375_0.cal | 789334_0.cal | 808941_0.cal | 836213_0.cal | 851164_0.cal | 876767_0.cal | 928179_0.cal | 918126_0.cal | 942909_0.cal | 965602_0.cal | 376596.cal | 112535.cal | 76519.cal | 76554.cal | 1010026_0.cal | 1023939_0.cal | 1048694_0.cal | 1078901_0.cal | 2177096_0.cal | 2158374_0.cal | 2194413_0.cal | 2212285_0.cal | 2321235_0.cal | 2350812_0.cal | 2471529_0.cal | 2400007_0.cal | 2381585_0.cal | 2443872_0.cal | 2277271_0.cal | 2420210_0.cal | 2487996_0.cal | 2243001_0.cal | 2580697_0.cal | 2749099_0.cal | 2532058_0.cal | 2603782_0.cal | 2625277_0.cal | 2708478_0.cal | 2678361_0.cal | 2645048_0.cal | 2555093_0.cal | ||||||||||||||||||||||||||||||||||||||||||||
received_date | 2000-11-01 00:00:00 | 2001-01-27 00:00:00 | 2001-04-24 00:00:00 | 2001-07-19 00:00:00 | 2001-10-25 00:00:00 | 2002-01-22 00:00:00 | 2002-04-19 00:00:00 | 2002-07-23 00:00:00 | 2002-10-23 00:00:00 | 2003-04-21 00:00:00 | 2003-02-11 00:00:00 | 2003-07-20 00:00:00 | 2003-10-20 00:00:00 | 2003-10-20 00:00:00 | 2004-01-21 00:00:00 | 2004-01-20 00:00:00 | 2004-01-20 00:00:00 | 2004-04-20 00:00:00 | 2004-07-19 00:00:00 | 2004-10-18 00:00:00 | 2005-01-28 00:00:00 | 2017-07-31 00:00:00 | 2017-05-02 00:00:00 | 2017-10-31 00:00:00 | 2018-01-31 00:00:00 | 2018-10-31 00:00:00 | 2019-01-31 00:00:00 | 2020-04-30 00:00:00 | 2019-07-31 00:00:00 | 2019-04-30 00:00:00 | 2020-01-31 00:00:00 | 2018-07-31 00:00:00 | 2019-10-31 00:00:00 | 2020-07-31 00:00:00 | 2018-04-30 00:00:00 | 2021-04-30 00:00:00 | 2022-10-31 00:00:00 | 2020-11-02 00:00:00 | 2021-08-02 00:00:00 | 2021-11-01 00:00:00 | 2022-08-01 00:00:00 | 2022-05-02 00:00:00 | 2022-01-31 00:00:00 | 2021-02-01 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/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | ||||||||||||||||||||||||||||||||||||||||||||
filing_id | 683433 | 715606 | 743259 | 768375 | 789334 | 808941 | 836213 | 851164 | 876767 | 928179 | 918126 | 942909 | 965602 | None | None | None | None | 1010026 | 1023939 | 1048694 | 1078901 | 2177096 | 2158374 | 2194413 | 2212285 | 2321235 | 2350812 | 2471529 | 2400007 | 2381585 | 2443872 | 2277271 | 2420210 | 2487996 | 2243001 | 2580697 | 2749099 | 2532058 | 2603782 | 2625277 | 2708478 | 2678361 | 2645048 | 2555093 | ||||||||||||||||||||||||||||||||||||||||||||
form_id | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | None | None | None | None | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | ||||||||||||||||||||||||||||||||||||||||||||
receive_comment | Filing accepted | Filing accepted, but with warnings | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing did not pass validation | Filing did not pass validation | Filing did not pass validation | Filing did not pass validation | 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 |