filer_id | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
adrid | 1106270 | 2015308 | 2042181 | 2082139 | 2115406 | 2155960 | 2166339 | 2203928 | 2410910 | 2469492 | 2552097 | 2277175 | 2340167 | 2511982 | 2444505 | |||||||||||||||
effect_dt | 1999-02-16 00:00:00 | 2001-02-20 00:00:00 | 2003-01-01 00:00:00 | 2005-01-01 00:00:00 | 2007-01-01 00:00:00 | 2008-04-07 00:00:00 | 2009-01-01 00:00:00 | 2011-01-01 00:00:00 | 2017-01-01 00:00:00 | 2019-01-01 00:00:00 | 2023-01-01 00:00:00 | 2013-01-01 00:00:00 | 2015-01-01 00:00:00 | 2021-01-01 00:00:00 | 2018-01-18 00:00:00 | |||||||||||||||
add_type | 7050 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | |||||||||||||||
session_id | 1999 | 2001 | 2003 | 2005 | 2007 | 2007 | 2009 | 2011 | 2017 | 2019 | 2023 | 2013 | 2015 | 2021 | 2017 |
filer_id | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
session_id | 2001 | 1999 | 2003 | 2005 | 2007 | 2011 | 2009 | 2013 | 2015 | 2019 | 2017 | 2021 | ||||||||||||
ethics_date | 2000-11-14 00:00:00 | 1999-11-17 00:00:00 | 2003-02-07 00:00:00 | 2004-11-17 00:00:00 | 2007-02-08 00:00:00 | 2011-02-24 00:00:00 | 2009-02-19 00:00:00 | 2013-04-11 00:00:00 | 2015-02-26 00:00:00 | 2018-11-15 00:00:00 | 2016-11-17 00:00:00 | 2020-12-03 00:00:00 |
filer_id | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 512555 | 515704 | 518837 | 626480 | 611299 | 638528 | 659347 | 646235 | 682996 | 719308 | 684093 | 711704 | 746534 | 749930 | 727064 | 748844 | 750818 | 773710 | 776597 | 770764 | 794356 | 796824 | 807416 | 816629 | 838934 | 841956 | 853217 | 850252 | 881361 | 890720 | 910058 | 899642 | 905592 | 941558 | 927832 | 931939 | 952865 | 922683 | 963874 | 972663 | 989345 | 985588 | 1009866 | 1023258 | 1047672 | 1015592 | 1022181 | 1062487 | 1076724 | 1072326 | 1099703 | 1084799 | 1111257 | 1127494 | 1141921 | 1165237 | 1188050 | 1209039 | 1223481 | 1259420 | 1231490 | 1278283 | 1250192 | 1304013 | 1294434 | 1974101 | 1862895 | 1862895 | 1793974 | 1777124 | 1957639 | 1942455 | 1952449 | 1899181 | 1324704 | 1344601 | 1392984 | 1374029 | 1410325 | 1419842 | 1435782 | 1424239 | 1451700 | 1458282 | 1504307 | 1484166 | 1536683 | 1564748 | 1572907 | 1586964 | 1602156 | 1579129 | 1619088 | 1628577 | 1652529 | 1677319 | 1813865 | 1927045 | 1918405 | 1706757 | 1731488 | 1722214 | 1731905 | 1838659 | 1757770 | 1758541 | 1992591 | 2393696 | 2377916 | 2263744 | 2188794 | 2414230 | 2547076 | 2548196 | 2342605 | 2006945 | 2029996 | 2057818 | 2095169 | 2126132 | 2112928 | 2152411 | 2141269 | 2126132 | 2167062 | 2205417 | 2328421 | 2480050 | 2231767 | 2536202 | 2520767 | 2204255 | 2575365 | 2575365 | 2466904 | 2360747 | 2436060 | 2310178 | 2598474 | 2671328 | 2636989 | 2621227 | 2699749 | 2737270 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
period_id | 157 | 158 | 159 | 161 | 160 | 161 | None | 162 | 163 | 164 | 163 | None | 165 | 165 | 164 | None | 165 | None | None | 166 | 167 | None | 168 | None | 169 | None | None | 170 | 171 | None | None | None | 172 | 174 | 173 | None | None | None | 175 | None | None | 176 | 177 | None | 179 | None | 178 | None | None | 180 | 181 | None | 182 | 183 | 184 | 185 | 186 | 187 | 188 | 189 | 188 | 190 | None | 192 | 191 | 222 | 217 | 218 | 215 | 214 | 221 | None | None | 219 | 193 | 194 | 196 | 195 | None | 197 | 198 | None | 199 | 200 | 202 | 201 | 203 | None | 204 | 205 | 206 | None | 207 | 208 | 209 | 210 | 216 | 220 | 220 | 211 | 212 | 213 | None | 217 | None | 213 | 223 | 238 | 237 | 234 | 231 | 239 | 244 | None | 236 | 224 | 225 | 226 | 227 | 232 | 228 | 229 | None | 228 | 230 | None | 236 | 242 | 233 | 244 | 243 | 232 | 245 | 245 | 241 | None | 240 | 235 | 246 | 249 | 248 | 247 | 250 | 251 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F604 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F604 | F604 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F604 | F615 | F615 | F604 | F604 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | 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 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_date | 1999-04-30 00:00:00 | 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-10-31 00:00:00 | 2001-01-31 00:00:00 | 2000-11-01 00:00:00 | 2000-12-29 00:00:00 | 2001-04-30 00:00:00 | 2001-04-30 00:00:00 | 2001-01-31 00:00:00 | 2001-04-12 00:00:00 | 2001-04-26 00:00:00 | 2001-07-31 00:00:00 | 2001-07-31 00:00:00 | 2001-07-27 00:00:00 | 2001-11-06 00:00:00 | 2001-11-14 00:00:00 | 2002-01-15 00:00:00 | 2002-01-18 00:00:00 | 2002-04-29 00:00:00 | 2002-04-30 00:00:00 | 2002-07-19 00:00:00 | 2002-07-18 00:00:00 | 2002-10-28 00:00:00 | 2002-10-29 00:00:00 | 2003-01-27 00:00:00 | 2002-12-24 00:00:00 | 2003-01-23 00:00:00 | 2003-07-14 00:00:00 | 2003-04-17 00:00:00 | 2003-04-28 00:00:00 | 2003-07-22 00:00:00 | 2003-02-07 00:00:00 | 2003-10-13 00:00:00 | 2003-10-20 00:00:00 | 2004-01-28 00:00:00 | 2004-01-23 00:00:00 | 2004-04-20 00:00:00 | 2004-07-15 00:00:00 | 2004-10-14 00:00:00 | 2004-04-30 00:00:00 | 2004-07-12 00:00:00 | 2004-10-18 00:00:00 | 2004-12-30 00:00:00 | 2005-01-14 00:00:00 | 2005-04-11 00:00:00 | 2005-01-27 00:00:00 | 2005-07-08 00:00:00 | 2005-10-07 00:00:00 | 2006-01-13 00:00:00 | 2006-04-26 00:00:00 | 2006-07-26 00:00:00 | 2006-10-19 00:00:00 | 2006-12-14 00:00:00 | 2007-04-25 00:00:00 | 2007-01-25 00:00:00 | 2007-07-19 00:00:00 | 2006-12-28 00:00:00 | 2008-01-16 00:00:00 | 2007-10-24 00:00:00 | 2015-07-13 00:00:00 | 2014-07-14 00:00:00 | 2014-07-15 00:00:00 | 2013-10-13 00:00:00 | 2013-07-22 00:00:00 | 2015-04-13 00:00:00 | 2014-12-30 00:00:00 | 2015-02-26 00:00:00 | 2014-10-16 00:00:00 | 2008-04-15 00:00:00 | 2008-07-21 00:00:00 | 2009-01-27 00:00:00 | 2008-10-28 00:00:00 | 2008-12-16 00:00:00 | 2009-04-29 00:00:00 | 2009-07-29 00:00:00 | 2009-02-19 00:00:00 | 2009-10-30 00:00:00 | 2010-01-19 00:00:00 | 2010-07-28 00:00:00 | 2010-04-29 00:00:00 | 2010-10-27 00:00:00 | 2010-12-29 00:00:00 | 2011-01-31 00:00:00 | 2011-04-19 00:00:00 | 2011-07-21 00:00:00 | 2011-02-24 00:00:00 | 2011-10-24 00:00:00 | 2012-01-13 00:00:00 | 2012-04-17 00:00:00 | 2012-07-30 00:00:00 | 2014-01-27 00:00:00 | 2015-01-20 00:00:00 | 2014-12-15 00:00:00 | 2012-10-29 00:00:00 | 2013-01-24 00:00:00 | 2013-01-02 00:00:00 | 2013-01-03 00:00:00 | 2014-04-15 00:00:00 | 2013-04-11 00:00:00 | 2013-04-17 00:00:00 | 2015-10-20 00:00:00 | 2019-07-26 00:00:00 | 2019-04-26 00:00:00 | 2018-07-11 00:00:00 | 2017-10-19 00:00:00 | 2019-10-22 00:00:00 | 2021-01-25 00:00:00 | 2020-12-18 00:00:00 | 2019-01-29 00:00:00 | 2016-01-26 00:00:00 | 2016-04-20 00:00:00 | 2016-07-25 00:00:00 | 2016-10-25 00:00:00 | 2017-01-28 00:00:00 | 2016-12-21 00:00:00 | 2017-04-23 00:00:00 | 2016-12-30 00:00:00 | 2017-05-10 00:00:00 | 2017-07-13 00:00:00 | 2018-01-23 00:00:00 | 2018-12-17 00:00:00 | 2020-07-22 00:00:00 | 2018-04-16 00:00:00 | 2020-12-03 00:00:00 | 2020-10-22 00:00:00 | 2018-01-23 00:00:00 | 2021-04-20 00:00:00 | 2021-04-20 00:00:00 | 2020-04-22 00:00:00 | 2018-12-21 00:00:00 | 2020-01-27 00:00:00 | 2018-10-22 00:00:00 | 2021-07-28 00:00:00 | 2022-04-27 00:00:00 | 2022-01-24 00:00:00 | 2021-10-28 00:00:00 | 2022-07-21 00:00:00 | 2022-10-20 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_type | 10001 | 10001 | 10001 | 10005 | 10005 | 10001 | 10005 | 10001 | 10001 | 10001 | 10005 | 10005 | 10001 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10001 | 10001 | 10005 | 10001 | 10005 | 10001 | 10005 | 10005 | 10001 | 10001 | 10005 | 10005 | 10005 | 10001 | 10001 | 10001 | 10005 | 10005 | 10006 | 10001 | 10005 | 10005 | 10001 | 10001 | 10005 | 10001 | 10005 | 10001 | 10005 | 10005 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | 10001 | 10001 | 10005 | 10006 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10006 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10006 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10006 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10002 | 10001 | 10006 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_status | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11003 | 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 | 11003 | 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 | 11003 | 11001 | 11001 | 11003 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
session_id | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 2001 | 2001 | 2001 | 1999 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2003 | 2001 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 1931 | 2003 | 2003 | 2003 | 2005 | 2003 | 2005 | 2003 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2007 | 2007 | 2005 | 2007 | 2007 | 2007 | 2007 | 2015 | 2013 | 2013 | 2013 | 2013 | 2015 | 2015 | 2015 | 2013 | 2007 | 2007 | 2007 | 2007 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2011 | 2009 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2013 | 2013 | 2015 | 2011 | 2011 | 2013 | 2013 | 2013 | 2013 | 2013 | 2015 | 2019 | 2019 | 2017 | 2017 | 2019 | 2019 | 2021 | 2017 | 2015 | 2015 | 2015 | 2015 | 2017 | 2017 | 2017 | 2017 | 2015 | 2017 | 2017 | 2019 | 2019 | 2017 | 2021 | 2019 | 2017 | 2021 | 2021 | 2019 | 2019 | 2019 | 2017 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
user_id | * | * | * | TTHAM | * | * | DHORRELL | * | * | * | SARRIAGA | CFLAGG | * | TWALLS | GPEREZ | SARRIAGA | TWALLS | PBANFORD | GPEREZ | * | * | YBONILLA | * | YBONILLA | * | YBONILLA | YBONILLA | * | * | YBONILLA | YBONILLA | GPEREZ | COMPLETED | COMPLETED | COMPLETED | YBONILLA | YBONILLA | GGILMORE | COMPLETED | YBONILLA | EMCENTEE | COMPLETED | COMPLETED | LTHIBAUL | COMPLETED | LTHIBAUL | COMPLETED | YRODRIGU | CFLAGG | COMPLETED | YRODRIGU | YRODRIGU | YRODRIGU | YRODRIGU | LTHIBAUL | YRODRIGU | YRODRIGU | YRODRIGU | * | YRODRIGU | YRODRIGU | LTHIBAUL | PBANFORD | LTHIBAUL | LTHIBAUL | JINGRAM | AGLADNEY | AGLADNEY | ASAETERN | ASAETERN | AGLADNEY | GPEREZ | ASAETERN | ASAETERN | LTHIBAUL | LTHIBAUL | CFLAGG | CFLAGG | SARRIAGA | YRODRIGU | YRODRIGU | YRODRIGU | YRODRIGU | CFLAGG | ASAETERN | JINGRAM | ASAETERN | YRODRIGU | ASAETERN | JINGRAM | ASAETERN | SMCCONNAN | ASAETERN | ASAETERN | ASAETERN | AGLADNEY | ASAETERN | AGLADNEY | CAFILER | ASAETERN | ASAETERN | CAFILER | GPEREZ | ASAETERN | SMCCONNAN | ASAETERN | JINGRAM | VUKSTINA | VUKSTINA | AGLADNEY | SMCCONNAN | VUKSTINA | JRAMOS | MMERCHANT | JFRONEFIELD | AGLADNEY | AGLADNEY | AGLADNEY | JINGRAM | AGLADNEY | YRODRIGU | AGLADNEY | YRODRIGU | AGLADNEY | SMCCONNAN | YRODRIGU | YRODRIGU | VUKSTINA | AGLADNEY | MMERCHANT | MKIRKHAM | YRODRIGU | MKIRKHAM | MKIRKHAM | VUKSTINA | YRODRIGU | VUKSTINA | JFRONEFIELD | MKIRKHAM | CAFILER | RATTIYEH | CHATRIDGE | CAFILER | CAFILER | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
special_audit | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11002 | 11003 | 11002 | 11002 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fine_audit | 11001 | 11001 | 11001 | 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 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 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 | 11003 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_start | 1999-01-01 00:00:00 | 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 | 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 | 1900-01-01 00:00:00 | 2001-01-01 00:00:00 | 2001-04-01 00:00:00 | 2001-04-01 00:00:00 | 2001-04-01 00:00:00 | 2001-07-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-01-01 00:00:00 | 2002-04-01 00:00:00 | 2002-04-01 00:00:00 | 2002-07-01 00:00:00 | 2002-07-01 00:00:00 | 2002-10-01 00:00:00 | 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 | 2003-04-01 00:00:00 | None | 2003-07-01 00:00:00 | 2003-07-01 00:00:00 | 2003-10-01 00:00:00 | 2003-10-01 00:00:00 | 2004-01-01 00:00:00 | 2004-04-01 00:00:00 | 1931-07-01 00:00:00 | 2004-01-01 00:00:00 | 2004-04-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 | 2004-10-01 00:00:00 | 2005-04-01 00:00:00 | 2005-07-01 00:00:00 | 2005-10-01 00:00:00 | 2006-01-01 00:00:00 | 2006-04-01 00:00:00 | 2006-07-01 00:00:00 | 2006-12-14 00:00:00 | 2007-01-01 00:00:00 | 2006-10-01 00:00:00 | 2007-04-01 00:00:00 | 1900-01-01 00:00:00 | 2007-10-01 00:00:00 | 2007-07-01 00:00:00 | 2015-04-01 00:00:00 | 2014-03-01 00:00:00 | 2014-04-01 00:00:00 | 2013-07-01 00:00:00 | 2013-04-01 00:00:00 | 2015-01-01 00:00:00 | 1900-01-01 00:00:00 | None | 2014-07-01 00:00:00 | 2008-01-01 00:00:00 | 2008-04-01 00:00:00 | 2008-10-01 00:00:00 | 2008-07-01 00:00:00 | 1900-01-01 00:00:00 | 2009-01-01 00:00:00 | 2009-04-01 00:00:00 | 1900-01-01 00:00:00 | 2009-07-01 00:00:00 | 2009-10-01 00:00:00 | 2010-04-01 00:00:00 | 2010-01-01 00:00:00 | 2010-07-01 00:00:00 | 1900-01-01 00:00:00 | 2010-10-01 00:00:00 | 2011-01-01 00:00:00 | 2011-04-01 00:00:00 | 1900-01-01 00:00:00 | 2011-07-01 00:00:00 | 2011-10-01 00:00:00 | 2012-01-01 00:00:00 | 2012-04-01 00:00:00 | 2013-10-01 00:00:00 | 2014-10-01 00:00:00 | 2014-12-15 00:00:00 | 2012-07-01 00:00:00 | 2012-10-01 00:00:00 | 2013-01-02 00:00:00 | 1900-01-01 00:00:00 | 2014-01-01 00:00:00 | 1900-01-01 00:00:00 | 2013-01-01 00:00:00 | 2015-07-01 00:00:00 | 2019-04-01 00:00:00 | 2019-01-01 00:00:00 | 2018-04-01 00:00:00 | 2017-07-01 00:00:00 | 2019-07-01 00:00:00 | 2020-10-01 00:00:00 | 1900-01-01 00:00:00 | 2018-10-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 | 2017-10-01 00:00:00 | 2016-12-21 00:00:00 | 2017-01-01 00:00:00 | 1900-01-01 00:00:00 | 2016-10-01 00:00:00 | 2017-04-01 00:00:00 | 1900-01-01 00:00:00 | 2018-12-17 00:00:00 | 2020-04-01 00:00:00 | 2018-01-01 00:00:00 | 2020-12-03 00:00:00 | 2020-07-01 00:00:00 | 2017-10-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2020-01-01 00:00:00 | 1900-01-01 00:00:00 | 2019-10-01 00:00:00 | 2018-07-01 00:00:00 | 2021-04-01 00:00:00 | 2022-01-01 00:00:00 | 2021-10-01 00:00:00 | 2021-07-01 00:00:00 | 2022-04-01 00:00:00 | 2022-07-01 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_end | 1999-03-31 00:00:00 | 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 | 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 | 1900-01-01 00:00:00 | 2001-03-31 00:00:00 | 2001-06-30 00:00:00 | 2001-06-30 00:00:00 | 2001-06-30 00:00:00 | 2001-09-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-03-31 00:00:00 | 2002-06-30 00:00:00 | 2002-06-30 00:00:00 | 2002-09-30 00:00:00 | 2002-09-30 00:00:00 | 2002-12-31 00:00:00 | 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 | 2003-06-30 00:00:00 | None | 2003-09-30 00:00:00 | 2003-09-30 00:00:00 | 2003-12-31 00:00:00 | 2003-12-31 00:00:00 | 2004-03-31 00:00:00 | 2004-06-30 00:00:00 | 2004-09-30 00:00:00 | 2004-03-31 00:00:00 | 2004-06-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 | 2004-12-31 00:00:00 | 2005-06-30 00:00:00 | 2005-09-30 00:00:00 | 2005-12-31 00:00:00 | 2006-03-31 00:00:00 | 2006-06-30 00:00:00 | 2006-09-30 00:00:00 | 2006-12-14 00:00:00 | 2007-03-31 00:00:00 | 2006-12-31 00:00:00 | 2007-06-30 00:00:00 | 1900-01-01 00:00:00 | 2007-12-31 00:00:00 | 2007-09-30 00:00:00 | 2015-06-30 00:00:00 | 2014-06-30 00:00:00 | 2014-06-30 00:00:00 | 2013-09-30 00:00:00 | 2013-06-30 00:00:00 | 2015-03-31 00:00:00 | 1900-01-01 00:00:00 | None | 2014-09-30 00:00:00 | 2008-03-31 00:00:00 | 2008-06-30 00:00:00 | 2008-12-31 00:00:00 | 2008-09-30 00:00:00 | 1900-01-01 00:00:00 | 2009-03-31 00:00:00 | 2009-06-30 00:00:00 | 1900-01-01 00:00:00 | 2009-09-30 00:00:00 | 2009-12-31 00:00:00 | 2010-06-30 00:00:00 | 2010-03-31 00:00:00 | 2010-09-30 00:00:00 | 1900-01-01 00:00:00 | 2010-12-31 00:00:00 | 2011-03-31 00:00:00 | 2011-06-30 00:00:00 | 1900-01-01 00:00:00 | 2011-09-30 00:00:00 | 2011-12-31 00:00:00 | 2012-03-31 00:00:00 | 2012-06-30 00:00:00 | 2013-12-31 00:00:00 | 2014-12-31 00:00:00 | 2014-12-15 00:00:00 | 2012-09-30 00:00:00 | 2012-12-31 00:00:00 | 2013-01-02 00:00:00 | 1900-01-01 00:00:00 | 2014-03-31 00:00:00 | 1900-01-01 00:00:00 | 2013-03-31 00:00:00 | 2015-09-30 00:00:00 | 2019-06-30 00:00:00 | 2019-03-31 00:00:00 | 2018-06-30 00:00:00 | 2017-09-30 00:00:00 | 2019-09-30 00:00:00 | 2020-12-31 00:00:00 | 1900-01-01 00:00:00 | 2018-12-31 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 | 2017-12-31 00:00:00 | 2016-12-21 00:00:00 | 2017-03-31 00:00:00 | 1900-01-01 00:00:00 | 2016-12-31 00:00:00 | 2017-06-30 00:00:00 | 1900-01-01 00:00:00 | 2018-12-17 00:00:00 | 2020-06-30 00:00:00 | 2018-03-31 00:00:00 | 2020-12-03 00:00:00 | 2020-09-30 00:00:00 | 2017-12-31 00:00:00 | 2021-01-01 00:00:00 | 2021-03-31 00:00:00 | 2020-03-31 00:00:00 | 1900-01-01 00:00:00 | 2019-12-31 00:00:00 | 2018-09-30 00:00:00 | 2021-06-30 00:00:00 | 2022-03-31 00:00:00 | 2021-12-31 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | 22001 | 22006 | 22006 | None | None | None | 22006 | None | None | 22006 | 22006 | None | 22006 | None | 22006 | None | None | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | None | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 |
filer_id | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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-02-16 00:00:00 | 2003-01-01 00:00:00 | 2005-01-01 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 | 2000-01-01 00:00:00 | 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 | 1149552 | |
---|---|---|
xref_id | L25774 | |
effect_dt | 1999-12-08 00:00:00 | |
migration_source | MASTER |
xref_filer_id | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | L25774 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_id | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | JOHNS | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
namf | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S. J. | CRAIG S.J. | CRAIG S.J. | CRAIG S.J. | CRAIG S.J. | CRAIG S.J. | CRAIG S.J. | CRAIG S.J. | CRAIG S.J. | CRAIG S.J. | CRAIG S.J. | CRAIG S.J. | CRAIG S.J. | CRAIG S.J. | CRAIG S.J. | CRAIG S.J. | CRAIG S.J. | CRAIG S.J. | CRAIG S.J. | CRAIG S.J. | CRAIG S.J. | CRAIG S.J. | CRAIG S.J. | CRAIG S.J. | CRAIG S.J. | CRAIG S.J. | CRAIG S.J. | CRAIG S.J. | CRAIG S.J. | CRAIG S.J. | CRAIG S.J. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9167670916 | 9167670916 | 9164482162 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9167670916 | 9167670916 | 9164482162 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9167670916 | 9167670916 | 9164482162 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9167670916 | 9167670916 | 9164482162 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9167670916 | 9167670916 | 9164482162 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9167670916 | 9167670916 | 9164482162 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9167670916 | 9167670916 | 9164482162 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9167670916 | 9167670916 | 9164482162 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9167670916 | 9167670916 | 9164482162 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9167670916 | 9167670916 | 9164482162 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9167670916 | 9167670916 | 9164482162 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9164983326 | 9167670916 | 9167670916 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fax | 9164484923 | 9164415449 | 9164415449 | 9164415449 | 9167822788 | 9167822788 | 9167822788 | 9167822788 | 9167822788 | 9167822788 | 9167822788 | 9167822788 | 9164484923 | 9164415449 | 9164415449 | 9164415449 | 9167822788 | 9167822788 | 9167822788 | 9167822788 | 9167822788 | 9167822788 | 9167822788 | 9167822788 | 9164484923 | 9164415449 | 9164415449 | 9164415449 | 9167822788 | 9167822788 | 9167822788 | 9167822788 | 9167822788 | 9167822788 | 9167822788 | 9167822788 | 9164484923 | 9164415449 | 9164415449 | 9164415449 | 9167822788 | 9167822788 | 9167822788 | 9167822788 | 9167822788 | 9167822788 | 9167822788 | 9167822788 | 9164484923 | 9164415449 | 9164415449 | 9164415449 | 9167822788 | 9167822788 | 9167822788 | 9167822788 | 9167822788 | 9167822788 | 9167822788 | 9167822788 | 9164484923 | 9164415449 | 9164415449 | 9164415449 | 9167822788 | 9167822788 | 9167822788 | 9167822788 | 9167822788 | 9167822788 | 9167822788 | 9167822788 | 9164484923 | 9164415449 | 9164415449 | 9164415449 | 9167822788 | 9167822788 | 9167822788 | 9167822788 | 9167822788 | 9167822788 | 9167822788 | 9167822788 | 9164484923 | 9164415449 | 9164415449 | 9164415449 | 9167822788 | 9167822788 | 9167822788 | 9167822788 | 9167822788 | 9167822788 | 9167822788 | 9167822788 | 9164484923 | 9164415449 | 9164415449 | 9164415449 | 9167822788 | 9167822788 | 9167822788 | 9167822788 | 9167822788 | 9167822788 | 9167822788 | 9167822788 | 9164484923 | 9164415449 | 9164415449 | 9164415449 | 9167822788 | 9167822788 | 9167822788 | 9167822788 | 9167822788 | 9167822788 | 9167822788 | 9167822788 | 9164484923 | 9164415449 | 9164415449 | 9164415449 | 9167822788 | 9167822788 | 9167822788 | 9167822788 | 9167822788 | 9167822788 | 9167822788 | 9167822788 | 9164484923 | 9164415449 | 9164415449 | 9164415449 | 9167822788 | 9167822788 | 9167822788 | 9167822788 | 9167822788 | 9167822788 | 9167822788 | 9167822788 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
[email protected] | [email protected] | None | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] |
filer_id | 1149552 |
---|
filer_id | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | |||||
---|---|---|---|---|---|---|---|---|---|---|
change_no | 1 | 2 | 3 | 4 | 5 | |||||
session_id | 1999 | 1999 | 2001 | 2001 | 2001 | |||||
log_dt | 2000-11-28 00:00:00 | 2000-11-28 00:00:00 | 2001-03-06 00:00:00 | 2001-05-05 00:00:00 | 2001-03-01 00:00:00 | |||||
filer_type | 4 | 4 | 4 | 4 | 4 | |||||
correction_flg | None | None | Y | None | Y | |||||
action | SET ACTIVE | SET ACTIVE | ADDED | CHANGED | DELETED | |||||
attribute_changed | CLIENT | CLIENT | LOBBYIST | ADDRESS AND PHONE | LOBBYIST | |||||
ethics_dt | None | None | None | None | None | |||||
interests | None | None | None | None | None | |||||
filer_full_name | CRAIG S.J. JOHNS | CRAIG S.J. JOHNS | JOHNS, CRAIG S. J. | CRAIG S.J. JOHNS | JOHNS, CRAIG S. J. | |||||
filer_city | Trona | Los Angeles | None | None | None | |||||
filer_st | CA | CA | None | None | None | |||||
filer_zip | 93592 | 90007 | None | None | None | |||||
filer_phone | 7603722042 | 2137633346 | None | None | None | |||||
entity_type | 3 | 3 | 4 | 0 | 4 | |||||
entity_name | KAHL/POWNALL ADVOCATES | KAHL/POWNALL ADVOCATES | CALIFORNIA RESOURCE STRATEGIES | CALIFORNIA RESOURCE STRATEGIES | KAHL/POWNALL ADVOCATES | |||||
entity_city | None | None | None | SACRAMENTO | None | |||||
entity_st | None | None | None | CA | None | |||||
entity_zip | None | None | None | 95814 | None | |||||
entity_phone | None | None | None | 9164983326 | None | |||||
entity_id | 1147235 | 1147235 | 1234564 | 1234564 | 1147235 | |||||
responsible_officer | None | None | None | None | None | |||||
effect_dt | None | None | 2001-02-20 00:00:00 | None | 2001-02-16 00:00:00 |
filer_id | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | 1149552 | ||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_file_name | 638528_0.cal | 646235_0.cal | 682996_0.cal | 719308_0.cal | 274444.cal | 746534_0.cal | 770764_0.cal | 794356_0.cal | 807416_0.cal | 838934_0.cal | 850252_0.cal | 881361_0.cal | 927832_0.cal | 905592_0.cal | 941558_0.cal | 963874_0.cal | 1223481_0.cal | 1722214_0.cal | 2112928_0.cal | 1918405_0.cal | 2328421_0.cal | 2536202_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-04-30 00:00:00 | 2001-07-27 00:00:00 | 2001-11-06 00:00:00 | 2002-01-15 00:00:00 | 2002-04-29 00:00:00 | 2002-07-18 00:00:00 | 2002-10-28 00:00:00 | 2003-04-17 00:00:00 | 2003-01-23 00:00:00 | 2003-07-14 00:00:00 | 2003-10-13 00:00:00 | 2006-12-14 00:00:00 | 2013-01-02 00:00:00 | 2016-12-21 00:00:00 | 2014-12-15 00:00:00 | 2018-12-17 00:00:00 | 2020-12-03 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/temp | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | ||||||||||||||||||||||
filing_id | 638528 | 646235 | 682996 | 719308 | None | 746534 | 770764 | 794356 | 807416 | 838934 | 850252 | 881361 | 927832 | 905592 | 941558 | 963874 | 1223481 | 1722214 | 2112928 | 1918405 | 2328421 | 2536202 | ||||||||||||||||||||||
form_id | F615 | F615 | F615 | F615 | None | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F604 | F604 | F604 | F604 | F604 | ||||||||||||||||||||||
receive_comment | 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, but with warnings | Filing accepted | Filing accepted, but with warnings | Filing accepted, but with warnings | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted |