filer_id | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
adrid | 1101599 | 2042360 | 2079428 | 2116257 | 2160105 | 2203612 | 2410223 | 2266216 | 2465699 | 2338429 | ||||||||||
effect_dt | 1999-01-01 00:00:00 | 2003-01-01 00:00:00 | 2005-01-01 00:00:00 | 2007-01-01 00:00:00 | 2009-01-01 00:00:00 | 2011-01-01 00:00:00 | 2017-02-14 00:00:00 | 2013-01-01 00:00:00 | 2019-01-01 00:00:00 | 2015-01-01 00:00:00 | ||||||||||
add_type | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | ||||||||||
session_id | 1999 | 2003 | 2005 | 2007 | 2009 | 2011 | 2017 | 2013 | 2019 | 2015 |
filer_id | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
session_id | 1997 | 1999 | 2001 | 1995 | 2003 | 2005 | 2009 | 2007 | 2011 | 2015 | 2013 | 2017 | 2019 | |||||||||||||
ethics_date | 1998-11-19 00:00:00 | 1998-11-19 00:00:00 | 2000-11-14 00:00:00 | 1994-03-09 00:00:00 | 2002-11-13 00:00:00 | 2004-11-17 00:00:00 | 2008-11-12 00:00:00 | 2006-11-16 00:00:00 | 2010-11-17 00:00:00 | 2014-11-13 00:00:00 | 2012-11-18 00:00:00 | 2016-11-17 00:00:00 | 2018-11-15 00:00:00 |
filer_id | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 514496 | 510493 | 511392 | 522850 | 524035 | 521938 | 516055 | 516738 | 520732 | 524960 | 529052 | 542357 | 526153 | 527060 | 528181 | 519191 | 513592 | 512897 | 519846 | 632863 | 615340 | 660070 | 693087 | 701513 | 756726 | 745963 | 734159 | 795042 | 782256 | 775948 | 775098 | 772510 | 819024 | 792790 | 814534 | 839409 | 844402 | 861129 | 853898 | 880477 | 890325 | 898832 | 921499 | 932330 | 912015 | 946901 | 936690 | 956661 | 973732 | 987442 | 1001401 | 969691 | 1026734 | 1013987 | 1018731 | 1036017 | 1055438 | 1072207 | 1079584 | 1092526 | 1065449 | 1111978 | 1104393 | 1132387 | 1164783 | 1143465 | 1189800 | 1230737 | 1217943 | 1260222 | 1226253 | 1236040 | 1307363 | 1289048 | 1289054 | 1769100 | 1776344 | 1981532 | 1865107 | 1798934 | 1960624 | 1931842 | 1906432 | 1329007 | 1347032 | 1393435 | 1377735 | 1406009 | 1435786 | 1419427 | 1457954 | 1483056 | 1451708 | 1502644 | 1553668 | 1535534 | 1566796 | 1567205 | 1589254 | 1606993 | 1638199 | 1621446 | 1656009 | 1677644 | 1812525 | 1927795 | 1717072 | 1719701 | 1700947 | 1841221 | 1760788 | 1994281 | 2326532 | 2210927 | 2341562 | 2230619 | 2187898 | 2393792 | 2077975 | 2077987 | 2077999 | 2121976 | 2101116 | 2120025 | 2150477 | 2137758 | 2166408 | 2433167 | 2302756 | 2470763 | 2334657 | 2369703 | 2436233 | 2416564 | 2433169 | 2270543 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
period_id | 150 | 141 | 149 | 153 | 146 | 145 | 158 | 143 | 152 | 154 | 156 | 151 | 147 | 155 | 148 | 159 | 142 | 157 | 144 | None | 160 | 162 | 163 | None | 165 | 165 | 164 | None | None | None | None | 166 | None | 167 | 168 | 169 | None | None | 170 | 171 | None | None | None | 173 | 172 | 174 | None | None | None | 176 | None | 175 | 178 | 177 | None | None | 179 | None | 180 | None | None | 182 | 181 | 183 | 185 | 184 | 186 | None | 187 | 189 | 188 | 188 | 192 | 191 | 190 | 212 | 214 | 222 | 218 | 215 | 221 | 220 | 219 | 193 | 194 | 196 | 195 | None | 198 | 197 | 200 | 201 | 199 | 202 | 204 | 203 | 204 | None | 205 | 206 | 208 | 207 | 209 | 210 | 216 | None | 212 | None | 211 | 217 | 213 | 223 | 236 | 232 | 236 | 233 | 231 | 238 | 224 | 225 | 226 | 229 | 227 | 228 | 229 | None | 230 | 240 | 235 | 241 | None | 237 | None | 239 | 241 | 234 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F690 | F690 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | 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 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F604 | F604 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F604 | F615 | F606 | F615 | F606 | 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 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_date | 1997-07-31 00:00:00 | 1995-05-01 00:00:00 | 1997-04-30 00:00:00 | 1998-04-30 00:00:00 | 1996-07-31 00:00:00 | 1996-04-30 00:00:00 | 1999-08-02 00:00:00 | 1995-10-31 00:00:00 | 1998-02-02 00:00:00 | 1998-07-31 00:00:00 | 1999-02-01 00:00:00 | 1997-10-31 00:00:00 | 1996-10-31 00:00:00 | 1998-10-30 00:00:00 | 1997-01-31 00:00:00 | 1999-11-01 00:00:00 | 1995-07-31 00:00:00 | 1999-04-30 00:00:00 | 1996-01-31 00:00:00 | 2000-05-01 00:00:00 | 2000-01-28 00:00:00 | 2000-07-31 00:00:00 | 2000-10-31 00:00:00 | 2000-12-19 00:00:00 | 2001-04-30 00:00:00 | 2001-04-30 00:00:00 | 2001-01-31 00:00:00 | 2001-10-30 00:00:00 | 2001-08-13 00:00:00 | 2001-08-13 00:00:00 | 2001-07-26 00:00:00 | 2001-07-31 00:00:00 | 2002-01-30 00:00:00 | 2001-10-31 00:00:00 | 2002-01-31 00:00:00 | 2002-04-30 00:00:00 | 2002-04-30 00:00:00 | 2002-07-31 00:00:00 | 2002-07-30 00:00:00 | 2002-10-26 00:00:00 | 2002-10-29 00:00:00 | 2002-12-23 00:00:00 | 2003-01-31 00:00:00 | 2003-05-01 00:00:00 | 2003-01-31 00:00:00 | 2003-07-30 00:00:00 | 2003-04-30 00:00:00 | 2003-07-30 00:00:00 | 2003-10-31 00:00:00 | 2004-01-28 00:00:00 | 2004-01-29 00:00:00 | 2003-10-31 00:00:00 | 2004-07-27 00:00:00 | 2004-04-30 00:00:00 | 2004-04-30 00:00:00 | 2004-08-02 00:00:00 | 2004-10-27 00:00:00 | 2004-12-23 00:00:00 | 2005-01-31 00:00:00 | 2005-01-31 00:00:00 | 2004-11-01 00:00:00 | 2005-07-14 00:00:00 | 2005-04-29 00:00:00 | 2005-10-28 00:00:00 | 2006-04-25 00:00:00 | 2006-01-24 00:00:00 | 2006-07-29 00:00:00 | 2007-01-03 00:00:00 | 2006-11-01 00:00:00 | 2007-04-27 00:00:00 | 2007-01-03 00:00:00 | 2007-01-30 00:00:00 | 2008-01-28 00:00:00 | 2007-08-10 00:00:00 | 2007-08-10 00:00:00 | 2013-05-21 00:00:00 | 2013-07-18 00:00:00 | 2015-07-31 00:00:00 | 2014-07-22 00:00:00 | 2013-10-29 00:00:00 | 2015-04-22 00:00:00 | 2015-01-28 00:00:00 | 2014-10-27 00:00:00 | 2008-04-30 00:00:00 | 2008-07-28 00:00:00 | 2009-01-28 00:00:00 | 2008-10-31 00:00:00 | 2008-12-23 00:00:00 | 2009-07-29 00:00:00 | 2009-04-28 00:00:00 | 2010-01-14 00:00:00 | 2010-04-27 00:00:00 | 2009-10-30 00:00:00 | 2010-07-23 00:00:00 | 2010-12-23 00:00:00 | 2010-10-26 00:00:00 | 2011-01-26 00:00:00 | 2010-12-27 00:00:00 | 2011-04-28 00:00:00 | 2011-07-29 00:00:00 | 2012-02-01 00:00:00 | 2011-10-28 00:00:00 | 2012-04-27 00:00:00 | 2012-07-30 00:00:00 | 2014-01-23 00:00:00 | 2015-01-09 00:00:00 | 2012-12-13 00:00:00 | 2012-12-13 00:00:00 | 2012-10-22 00:00:00 | 2014-04-24 00:00:00 | 2013-04-23 00:00:00 | 2015-10-26 00:00:00 | 2018-11-28 00:00:00 | 2018-01-31 00:00:00 | 2019-01-28 00:00:00 | 2018-04-12 00:00:00 | 2017-10-16 00:00:00 | 2019-07-26 00:00:00 | 2016-09-15 00:00:00 | 2016-09-15 00:00:00 | 2016-09-15 00:00:00 | 2017-01-23 00:00:00 | 2016-10-31 00:00:00 | 2017-01-17 00:00:00 | 2017-04-11 00:00:00 | 2017-02-14 00:00:00 | 2017-07-11 00:00:00 | 2020-01-22 00:00:00 | 2018-10-05 00:00:00 | 2020-04-30 00:00:00 | 2018-12-20 00:00:00 | 2019-04-01 00:00:00 | 2020-01-23 00:00:00 | 2019-10-28 00:00:00 | 2020-01-22 00:00:00 | 2018-07-27 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_type | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10001 | 10005 | 10005 | 10005 | 10006 | 10006 | 10001 | 10005 | 10001 | 10001 | 10001 | 10005 | 10005 | 10001 | 10001 | 10005 | 10005 | 10005 | 10001 | 10001 | 10001 | 10005 | 10005 | 10005 | 10001 | 10005 | 10001 | 10001 | 10001 | 10005 | 10005 | 10001 | 10005 | 10001 | 10005 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 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 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10005 | 10001 | 10001 | 10001 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_status | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 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 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
session_id | 1997 | 1995 | 1997 | 1997 | 1995 | 1995 | 1999 | 1995 | 1997 | 1997 | 1997 | 1997 | 1995 | 1997 | 1995 | 1999 | 1995 | 1999 | 1995 | 1999 | 1999 | 1999 | 1999 | 2001 | 2001 | 2001 | 1999 | 2001 | 2001 | 2001 | 1999 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2003 | 2001 | 2003 | 2001 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2005 | 2003 | 2003 | 2003 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2007 | 2005 | 2007 | 2007 | 2005 | 2007 | 2007 | 2007 | 2011 | 2013 | 2015 | 2013 | 2013 | 2015 | 2013 | 2013 | 2007 | 2007 | 2007 | 2007 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2011 | 2009 | 2009 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2013 | 2015 | 2013 | 2013 | 2011 | 2013 | 2013 | 2015 | 2019 | 2017 | 2017 | 2017 | 2017 | 2019 | 2015 | 2015 | 2015 | 2017 | 2015 | 2015 | 2017 | 2017 | 2017 | 2019 | 2017 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2017 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
user_id | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | KCHAN | * | YBONILLA | YBONILLA | YBONILLA | YBONILLA | * | GPEREZ | PBANFORD | JBRANNAN | JBRANNAN | YBONILLA | * | LTHIBAUL | * | * | * | LTHIBAUL | LTHIBAUL | * | * | LTHIBAUL | GPEREZ | LTHIBAUL | COMPLETED | COMPLETED | COMPLETED | LTHIBAUL | MHOANG | LTHIBAUL | COMPLETED | LTHIBAUL | COMPLETED | COMPLETED | COMPLETED | LTHIBAUL | LTHIBAUL | COMPLETED | SARRIAGA | COMPLETED | LTHIBAUL | KVANG | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | PBANFORD | LTHIBAUL | LTHIBAUL | * | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | RGEREMIA | AGLADNEY | JINGRAM | AGLADNEY | AGLADNEY | MPACHECO | AGLADNEY | AGLADNEY | LTHIBAUL | LTHIBAUL | JINGRAM | JINGRAM | SARRIAGA | MGUERRA | MGUERRA | MGUERRA | JINGRAM | MGUERRA | ASAETERN | YRODRIGU | ASAETERN | ASAETERN | CFLAGG | JINGRAM | ASAETERN | ASAETERN | JINGRAM | ASAETERN | AGLADNEY | AGLADNEY | PBANFORD | PBANFORD | PBANFORD | ASAETERN | AGLADNEY | AGLADNEY | JINGRAM | PBANFORD | AGLADNEY | JFRONEFIELD | AGLADNEY | AGLADNEY | VUKSTINA | DWALKER | DWALKER | DWALKER | CAFILER | AGLADNEY | AGLADNEY | JINGRAM | DMCCASTL | SMCCONNAN | VUKSTINA | JFRONEFIELD | VUKSTINA | PBANFORD | VUKSTINA | GPEREZ | VUKSTINA | GPEREZ | JFRONEFIELD | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
special_audit | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11002 | 11003 | 11003 | 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fine_audit | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 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 | 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 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_start | 1997-04-01 00:00:00 | 1995-01-01 00:00:00 | 1997-01-01 00:00:00 | 1998-01-01 00:00:00 | 1996-04-01 00:00:00 | 1996-01-01 00:00:00 | 1999-04-01 00:00:00 | 1995-07-01 00:00:00 | 1997-10-01 00:00:00 | 1998-04-01 00:00:00 | 1998-10-01 00:00:00 | 1997-07-01 00:00:00 | 1996-07-01 00:00:00 | 1998-07-01 00:00:00 | 1996-10-01 00:00:00 | 1999-07-01 00:00:00 | 1995-04-01 00:00:00 | 1999-01-01 00:00:00 | 1995-10-01 00:00:00 | 2000-01-01 00:00:00 | 1999-10-01 00:00:00 | 2000-04-01 00:00:00 | 2000-07-01 00:00:00 | 1900-01-01 00:00:00 | 2001-01-01 00:00:00 | 2001-01-01 00:00:00 | 2000-10-01 00:00:00 | 2001-07-01 00:00:00 | 2001-04-01 00:00:00 | 2001-04-01 00:00:00 | 2000-07-01 00:00:00 | 2001-04-01 00:00:00 | 2001-10-01 00:00:00 | 2001-07-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 | 1900-01-01 00:00:00 | 2002-10-01 00:00:00 | 2003-01-01 00:00:00 | 2002-10-01 00:00:00 | 2003-04-01 00:00:00 | 2003-01-01 00:00:00 | 2003-04-01 00:00:00 | 2003-07-01 00:00:00 | 2003-10-01 00:00:00 | 2003-10-01 00:00:00 | 2003-07-01 00:00:00 | 2004-04-01 00:00:00 | 2004-01-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 | 2004-10-01 00:00:00 | 2004-07-01 00:00:00 | 2005-04-01 00:00:00 | 2005-01-01 00:00:00 | 2005-07-01 00:00:00 | 2006-01-01 00:00:00 | 2005-10-01 00:00:00 | 2006-04-01 00:00:00 | 1900-01-01 00:00:00 | 2006-07-01 00:00:00 | 2007-01-01 00:00:00 | 2006-12-20 00:00:00 | 2006-10-01 00:00:00 | 2007-10-01 00:00:00 | 2007-07-01 00:00:00 | 2007-04-01 00:00:00 | 2012-10-01 00:00:00 | 2013-04-01 00:00:00 | 2015-04-01 00:00:00 | 2014-04-01 00:00:00 | 2013-07-01 00:00:00 | 2015-01-01 00:00:00 | 2014-10-01 00:00:00 | 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-04-01 00:00:00 | 2009-01-01 00:00:00 | 2009-10-01 00:00:00 | 2010-01-01 00:00:00 | 2009-07-01 00:00:00 | 2010-04-01 00:00:00 | 2010-12-23 00:00:00 | 2010-07-01 00:00:00 | 2010-10-01 00:00:00 | 1900-01-01 00:00:00 | 2011-01-01 00:00:00 | 2011-04-01 00:00:00 | 2011-10-01 00:00:00 | 2011-07-01 00:00:00 | 2012-01-01 00:00:00 | 2012-04-01 00:00:00 | 2013-10-01 00:00:00 | 1900-01-01 00:00:00 | 2012-12-13 00:00:00 | 1900-01-01 00:00:00 | 2012-07-01 00:00:00 | 2014-01-01 00:00:00 | 2013-01-01 00:00:00 | 2015-07-01 00:00:00 | 2018-11-28 00:00:00 | 2017-10-01 00:00:00 | 2018-10-01 00:00:00 | 2018-01-01 00:00:00 | 2017-07-01 00:00:00 | 2019-04-01 00:00:00 | 2015-10-01 00:00:00 | 2016-01-01 00:00:00 | 2016-04-01 00:00:00 | 2017-01-23 00:00:00 | 2016-07-01 00:00:00 | 2016-10-01 00:00:00 | 2017-01-01 00:00:00 | 1900-01-01 00:00:00 | 2017-04-01 00:00:00 | 2019-10-01 00:00:00 | 2018-07-01 00:00:00 | 2020-01-01 00:00:00 | 1900-01-01 00:00:00 | 2019-01-01 00:00:00 | 1900-01-01 00:00:00 | 2019-07-01 00:00:00 | 2020-01-22 00:00:00 | 2018-04-01 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_end | 1997-06-30 00:00:00 | 1995-03-31 00:00:00 | 1997-03-31 00:00:00 | 1998-03-31 00:00:00 | 1996-06-30 00:00:00 | 1996-03-31 00:00:00 | 1999-06-30 00:00:00 | 1995-09-30 00:00:00 | 1997-12-31 00:00:00 | 1998-06-30 00:00:00 | 1998-12-31 00:00:00 | 1997-09-30 00:00:00 | 1996-09-30 00:00:00 | 1998-09-30 00:00:00 | 1996-12-31 00:00:00 | 1999-09-30 00:00:00 | 1995-06-30 00:00:00 | 1999-03-31 00:00:00 | 1995-12-31 00:00:00 | 2000-03-31 00:00:00 | 1999-12-31 00:00:00 | 2000-06-30 00:00:00 | 2000-09-30 00:00:00 | 1900-01-01 00:00:00 | 2001-03-31 00:00:00 | 2001-03-31 00:00:00 | 2000-12-31 00:00:00 | 2001-09-30 00:00:00 | 2001-06-30 00:00:00 | 2001-06-30 00:00:00 | 2000-09-30 00:00:00 | 2001-06-30 00:00:00 | 2001-12-31 00:00:00 | 2001-09-30 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 | 1900-01-01 00:00:00 | 2002-12-31 00:00:00 | 2003-03-31 00:00:00 | 2002-12-31 00:00:00 | 2003-06-30 00:00:00 | 2003-03-31 00:00:00 | 2003-06-30 00:00:00 | 2003-09-30 00:00:00 | 2003-12-31 00:00:00 | 2003-12-31 00:00:00 | 2003-09-30 00:00:00 | 2004-06-30 00:00:00 | 2004-03-31 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 | 2004-12-31 00:00:00 | 2044-09-30 00:00:00 | 2005-06-30 00:00:00 | 2005-03-31 00:00:00 | 2005-09-30 00:00:00 | 2006-03-31 00:00:00 | 2005-12-31 00:00:00 | 2006-06-30 00:00:00 | 1900-01-01 00:00:00 | 2006-09-30 00:00:00 | 2007-03-31 00:00:00 | 2006-12-20 00:00:00 | 2006-12-31 00:00:00 | 2007-12-31 00:00:00 | 2007-09-30 00:00:00 | 2007-06-30 00:00:00 | 2012-12-31 00:00:00 | 2013-06-30 00:00:00 | 2015-06-30 00:00:00 | 2014-06-30 00:00:00 | 2013-09-30 00:00:00 | 2015-03-31 00:00:00 | 2014-12-31 00:00:00 | 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-06-30 00:00:00 | 2009-03-31 00:00:00 | 2009-12-31 00:00:00 | 2010-03-31 00:00:00 | 2009-09-30 00:00:00 | 2010-06-30 00:00:00 | 2010-12-23 00:00:00 | 2010-09-30 00:00:00 | 2010-12-31 00:00:00 | 1900-01-01 00:00:00 | 2011-03-31 00:00:00 | 2011-06-30 00:00:00 | 2011-12-31 00:00:00 | 2011-09-30 00:00:00 | 2012-03-31 00:00:00 | 2012-06-30 00:00:00 | 2013-12-31 00:00:00 | 1900-01-01 00:00:00 | 2012-12-13 00:00:00 | 1900-01-01 00:00:00 | 2012-09-30 00:00:00 | 2014-03-31 00:00:00 | 2013-03-31 00:00:00 | 2015-09-30 00:00:00 | 2018-11-28 00:00:00 | 2017-12-31 00:00:00 | 2018-12-31 00:00:00 | 2018-03-31 00:00:00 | 2017-09-30 00:00:00 | 2019-06-30 00:00:00 | 2015-12-31 00:00:00 | 2016-03-31 00:00:00 | 2016-06-30 00:00:00 | 2017-01-23 00:00:00 | 2016-09-30 00:00:00 | 2016-12-31 00:00:00 | 2017-03-31 00:00:00 | 1900-01-01 00:00:00 | 2017-06-30 00:00:00 | 2019-12-31 00:00:00 | 2018-09-30 00:00:00 | 2020-03-31 00:00:00 | 1900-01-01 00:00:00 | 2019-03-31 00:00:00 | 1900-01-01 00:00:00 | 2019-09-30 00:00:00 | 2020-01-22 00:00:00 | 2018-06-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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_type | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 22001 | 22001 | 22001 | None | None | None | 22001 | None | 22001 | 22001 | 22001 | None | None | 22001 | None | 22001 | None | None | 22006 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | None | 22001 | None | 22001 | 22001 | 22001 |
filer_id | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_type | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | ||||||||||||||
active | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | T | Y | Y | Y | ||||||||||||||
race | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
session_id | 1997 | 1999 | 1995 | 2001 | 2003 | 2005 | 2007 | 2011 | 2013 | 2009 | 2019 | 2015 | 2017 | 2019 | ||||||||||||||
category | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
category_type | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
sub_category | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
effect_dt | 1997-01-01 00:00:00 | 1999-01-01 00:00:00 | 1995-01-01 00:00:00 | 2001-01-01 00:00:00 | 2003-01-01 00:00:00 | 2005-01-01 00:00:00 | 2007-01-01 00:00:00 | 2011-01-01 00:00:00 | 2013-01-01 00:00:00 | 2009-01-01 00:00:00 | 2020-01-03 00:00:00 | 2015-01-01 00:00:00 | 2017-02-14 00:00:00 | 2019-01-01 00:00:00 | ||||||||||||||
sub_category_type | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
election_type | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
sub_category_a | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
nyq_dt | None | None | None | None | None | 2001-01-01 00:00:00 | 2001-01-01 00:00:00 | 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 | 1147869 | |
---|---|---|
xref_id | L00227 | |
effect_dt | 1999-12-08 00:00:00 | |
migration_source | MASTER |
xref_filer_id | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | L00227 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_id | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
status | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
effect_dt | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
naml | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | CREEL | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
namf | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ALEXANDER E. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
phon | 9164442045 | 9164442045 | 9164442045 | 9164925200 | 9164925200 | 9164925200 | 9164925200 | 9164925200 | 9164925200 | 9164925200 | 9164442045 | 9164442045 | 9164442045 | 9164925200 | 9164925200 | 9164925200 | 9164925200 | 9164925200 | 9164925200 | 9164925200 | 9164442045 | 9164442045 | 9164442045 | 9164925200 | 9164925200 | 9164925200 | 9164925200 | 9164925200 | 9164925200 | 9164925200 | 9164442045 | 9164442045 | 9164442045 | 9164925200 | 9164925200 | 9164925200 | 9164925200 | 9164925200 | 9164925200 | 9164925200 | 9164442045 | 9164442045 | 9164442045 | 9164925200 | 9164925200 | 9164925200 | 9164925200 | 9164925200 | 9164925200 | 9164925200 | 9164442045 | 9164442045 | 9164442045 | 9164925200 | 9164925200 | 9164925200 | 9164925200 | 9164925200 | 9164925200 | 9164925200 | 9164442045 | 9164442045 | 9164442045 | 9164925200 | 9164925200 | 9164925200 | 9164925200 | 9164925200 | 9164925200 | 9164925200 | 9164442045 | 9164442045 | 9164442045 | 9164925200 | 9164925200 | 9164925200 | 9164925200 | 9164925200 | 9164925200 | 9164925200 | 9164442045 | 9164442045 | 9164442045 | 9164925200 | 9164925200 | 9164925200 | 9164925200 | 9164925200 | 9164925200 | 9164925200 | 9164442045 | 9164442045 | 9164442045 | 9164925200 | 9164925200 | 9164925200 | 9164925200 | 9164925200 | 9164925200 | 9164925200 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fax | 9164442033 | 9164442033 | 9164442033 | 9164442033 | 9164442033 | 9164442033 | 9164442033 | 9164442033 | 9164441794 | 9164442033 | 9164442033 | 9164442033 | 9164442033 | 9164442033 | 9164442033 | 9164442033 | 9164442033 | 9164441794 | 9164442033 | 9164442033 | 9164442033 | 9164442033 | 9164442033 | 9164442033 | 9164442033 | 9164442033 | 9164441794 | 9164442033 | 9164442033 | 9164442033 | 9164442033 | 9164442033 | 9164442033 | 9164442033 | 9164442033 | 9164441794 | 9164442033 | 9164442033 | 9164442033 | 9164442033 | 9164442033 | 9164442033 | 9164442033 | 9164442033 | 9164441794 | 9164442033 | 9164442033 | 9164442033 | 9164442033 | 9164442033 | 9164442033 | 9164442033 | 9164442033 | 9164441794 | 9164442033 | 9164442033 | 9164442033 | 9164442033 | 9164442033 | 9164442033 | 9164442033 | 9164442033 | 9164441794 | 9164442033 | 9164442033 | 9164442033 | 9164442033 | 9164442033 | 9164442033 | 9164442033 | 9164442033 | 9164441794 | 9164442033 | 9164442033 | 9164442033 | 9164442033 | 9164442033 | 9164442033 | 9164442033 | 9164442033 | 9164441794 | 9164442033 | 9164442033 | 9164442033 | 9164442033 | 9164442033 | 9164442033 | 9164442033 | 9164442033 | 9164441794 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
None | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] |
filer_id | 1147869 |
---|
filer_id | 1147869 | 1147869 | ||
---|---|---|---|---|
change_no | 1 | 2 | ||
session_id | 2019 | 2019 | ||
log_dt | 2020-08-05 00:00:00 | 2020-01-23 00:00:00 | ||
filer_type | 4 | 4 | ||
correction_flg | None | None | ||
action | DELETED | TERMINATED | ||
attribute_changed | EMPLOYER | |||
ethics_dt | None | None | ||
interests | None | None | ||
filer_full_name | ALEXANDER E. CREEL | CREEL, ALEXANDER E. | ||
filer_city | None | None | ||
filer_st | None | None | ||
filer_zip | None | None | ||
filer_phone | None | None | ||
entity_type | 2 | 4 | ||
entity_name | CALIFORNIA ASSOCIATION OF REALTORS | None | ||
entity_city | None | None | ||
entity_st | None | None | ||
entity_zip | None | None | ||
entity_phone | None | None | ||
entity_id | 1146782 | 0 | ||
responsible_officer | None | None | ||
effect_dt | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 |
filer_id | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | 1147869 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_file_name | 745963_0.cal | 772510_0.cal | 792790_0.cal | 814534_0.cal | 839409_0.cal | 853898_0.cal | 880477_0.cal | 912015_0.cal | 932330_0.cal | 946901_0.cal | 969691_0.cal | 987442_0.cal | 1013987_0.cal | 1026734_0.cal | 1055438_0.cal | 1079584_0.cal | 184780.cal | 1132387_0.cal | 1143465_0.cal | 1164783_0.cal | 1189800_0.cal | 1329007_0.cal | 1502644_0.cal | 1393435_0.cal | 1347032_0.cal | 1451708_0.cal | 1217943_0.cal | 1236040_0.cal | 1226253_0.cal | 1483056_0.cal | 1260222_0.cal | 1457954_0.cal | 1435786_0.cal | 1419427_0.cal | 1289054_0.cal | 1289048_0.cal | 1377735_0.cal | 1307363_0.cal | 1677644_0.cal | 1841221_0.cal | 1798934_0.cal | 1553668_0.cal | 1535534_0.cal | 1700947_0.cal | 1589254_0.cal | 1566796_0.cal | 1812525_0.cal | 1606993_0.cal | 1760788_0.cal | 1769100_0.cal | 1776344_0.cal | 1638199_0.cal | 1621446_0.cal | 1656009_0.cal | 1717072_0.cal | 1865107_0.cal | 1981532_0.cal | 2121976_0.cal | 1994281_0.cal | 2150477_0.cal | 2120025_0.cal | 2101116_0.cal | 1906432_0.cal | 2077975_0.cal | 2077987_0.cal | 2077999_0.cal | 1960624_0.cal | 1931842_0.cal | 2166408_0.cal | 2326532_0.cal | 2341562_0.cal | 2210927_0.cal | 2393792_0.cal | 2416564_0.cal | 2433167_0.cal | 2230619_0.cal | 2187898_0.cal | 2302756_0.cal | 2369703_0.cal | 2433169_0.cal | 2270543_0.cal | 2470763_0.cal | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
received_date | 2001-04-30 00:00:00 | 2001-07-31 00:00:00 | 2001-10-31 00:00:00 | 2002-01-31 00:00:00 | 2002-04-30 00:00:00 | 2002-07-30 00:00:00 | 2002-10-26 00:00:00 | 2003-01-31 00:00:00 | 2003-05-01 00:00:00 | 2003-07-30 00:00:00 | 2003-10-31 00:00:00 | 2004-01-28 00:00:00 | 2004-04-30 00:00:00 | 2004-07-27 00:00:00 | 2004-10-27 00:00:00 | 2005-01-31 00:00:00 | 2005-05-01 00:00:00 | 2005-10-28 00:00:00 | 2006-01-24 00:00:00 | 2006-04-25 00:00:00 | 2006-07-29 00:00:00 | 2008-04-30 00:00:00 | 2010-07-23 00:00:00 | 2009-01-28 00:00:00 | 2008-07-28 00:00:00 | 2009-10-30 00:00:00 | 2006-11-01 00:00:00 | 2007-01-30 00:00:00 | 2007-01-03 00:00:00 | 2010-04-27 00:00:00 | 2007-04-27 00:00:00 | 2010-01-14 00:00:00 | 2009-07-29 00:00:00 | 2009-04-28 00:00:00 | 2007-08-10 00:00:00 | 2007-08-10 00:00:00 | 2008-10-31 00:00:00 | 2008-01-28 00:00:00 | 2012-07-30 00:00:00 | 2014-04-24 00:00:00 | 2013-10-29 00:00:00 | 2010-12-23 00:00:00 | 2010-10-26 00:00:00 | 2012-10-22 00:00:00 | 2011-04-28 00:00:00 | 2011-01-26 00:00:00 | 2014-01-23 00:00:00 | 2011-07-29 00:00:00 | 2013-04-23 00:00:00 | 2013-05-21 00:00:00 | 2013-07-18 00:00:00 | 2012-02-01 00:00:00 | 2011-10-28 00:00:00 | 2012-04-27 00:00:00 | 2012-12-13 00:00:00 | 2014-07-22 00:00:00 | 2015-07-31 00:00:00 | 2017-01-23 00:00:00 | 2015-10-26 00:00:00 | 2017-04-11 00:00:00 | 2017-01-17 00:00:00 | 2016-10-31 00:00:00 | 2014-10-27 00:00:00 | 2016-09-15 00:00:00 | 2016-09-15 00:00:00 | 2016-09-15 00:00:00 | 2015-04-22 00:00:00 | 2015-01-28 00:00:00 | 2017-07-11 00:00:00 | 2018-11-28 00:00:00 | 2019-01-28 00:00:00 | 2018-01-31 00:00:00 | 2019-07-26 00:00:00 | 2019-10-28 00:00:00 | 2020-01-22 00:00:00 | 2018-04-12 00:00:00 | 2017-10-16 00:00:00 | 2018-10-05 00:00:00 | 2019-04-01 00:00:00 | 2020-01-22 00:00:00 | 2018-07-27 00:00:00 | 2020-04-30 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 | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_id | 745963 | 772510 | 792790 | 814534 | 839409 | 853898 | 880477 | 912015 | 932330 | 946901 | 969691 | 987442 | 1013987 | 1026734 | 1055438 | 1079584 | None | 1132387 | 1143465 | 1164783 | 1189800 | 1329007 | 1502644 | 1393435 | 1347032 | 1451708 | 1217943 | 1236040 | 1226253 | 1483056 | 1260222 | 1457954 | 1435786 | 1419427 | 1289054 | 1289048 | 1377735 | 1307363 | 1677644 | 1841221 | 1798934 | 1553668 | 1535534 | 1700947 | 1589254 | 1566796 | 1812525 | 1606993 | 1760788 | 1769100 | 1776344 | 1638199 | 1621446 | 1656009 | 1717072 | 1865107 | 1981532 | 2121976 | 1994281 | 2150477 | 2120025 | 2101116 | 1906432 | 2077975 | 2077987 | 2077999 | 1960624 | 1931842 | 2166408 | 2326532 | 2341562 | 2210927 | 2393792 | 2416564 | 2433167 | 2230619 | 2187898 | 2302756 | 2369703 | 2433169 | 2270543 | 2470763 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | None | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F606 | F615 | F615 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
receive_comment | Filing accepted | Filing accepted, but with warnings | Filing accepted | Filing accepted | 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 passed validation, but failed DB constraints | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted |