filer_id | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
adrid | 1104504 | 2079256 | 2042416 | 2113261 | 2159939 | 2203472 | 2409930 | 2421964 | 2254796 | 2337024 | ||||||||||
effect_dt | 1999-01-01 00:00:00 | 2005-01-01 00:00:00 | 2003-01-01 00:00:00 | 2007-01-01 00:00:00 | 2009-01-01 00:00:00 | 2011-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017-01-01 00:00:00 | 2013-01-01 00:00:00 | 2015-01-01 00:00:00 | ||||||||||
add_type | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7082 | 7051 | 7051 | ||||||||||
session_id | 1999 | 2005 | 2003 | 2007 | 2009 | 2011 | 2017 | 2017 | 2013 | 2015 |
filer_id | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
session_id | 1999 | 1997 | 2001 | 2003 | 2005 | 2009 | 2007 | 2011 | 2013 | 2015 | 2017 | |||||||||||
ethics_date | 1999-01-08 00:00:00 | 1999-01-08 00:00:00 | 2001-01-18 00:00:00 | 2002-11-13 00:00:00 | 2005-01-12 00:00:00 | 2009-01-16 00:00:00 | 2006-11-16 00:00:00 | 2011-04-21 00:00:00 | 2012-11-08 00:00:00 | 2014-11-13 00:00:00 | 2016-11-17 00:00:00 |
filer_id | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 517997 | 519059 | 514877 | 512763 | 515919 | 527349 | 525271 | 523171 | 521084 | 529333 | 633437 | 620047 | 670311 | 662543 | 696490 | 713564 | 706686 | 757550 | 744098 | 738916 | 706686 | 788181 | 769942 | 779496 | 796759 | 811986 | 829055 | 837728 | 844726 | 861159 | 849361 | 851065 | 837728 | 892769 | 884451 | 898716 | 899056 | 910278 | 930903 | 911686 | 949740 | 936672 | 946204 | 968537 | 973427 | 988007 | 1010613 | 1017110 | 1001444 | 1023235 | 1029120 | 1047109 | 1065920 | 1070833 | 1063578 | 1073037 | 1063578 | 1091628 | 1112146 | 1100496 | 1070833 | 1142638 | 1127926 | 1162562 | 1184705 | 1184707 | 1184705 | 1207400 | 1223961 | 1229716 | 1229654 | 1256875 | 1276010 | 1302523 | 1292118 | 1775355 | 1975729 | 1793659 | 1810561 | 1959384 | 1899054 | 1302523 | 1324831 | 1344143 | 1367373 | 1381442 | 1389165 | 1405308 | 1405310 | 1429438 | 1416294 | 1446698 | 1456489 | 1476871 | 1521701 | 1499328 | 1542914 | 1559817 | 1559817 | 1552870 | 1592829 | 1616645 | 1542914 | 1587744 | 1626921 | 1600154 | 1652813 | 1671008 | 1693856 | 1914928 | 1929760 | 1920514 | 1715403 | 1862200 | 1723536 | 1723887 | 1838824 | 1756573 | 1990480 | 2002876 | 2197791 | 2200927 | 2025810 | 2053576 | 2089604 | 2107728 | 2115158 | 2151159 | 2122752 | 2172452 | 2197325 | 2190836 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
period_id | 151 | 159 | 150 | 157 | 158 | 155 | 154 | 153 | 152 | 156 | None | None | 163 | 162 | 163 | 164 | None | 165 | 165 | 164 | None | 167 | 166 | None | None | 168 | None | 169 | None | None | None | 170 | 169 | None | 171 | 172 | None | 172 | 173 | None | 174 | None | 174 | 175 | None | 176 | 177 | None | None | 178 | None | 179 | None | None | 180 | 180 | 180 | None | 182 | 181 | None | 184 | 183 | 185 | 186 | 186 | 186 | 187 | 188 | 188 | None | 189 | 190 | 192 | 191 | 214 | 222 | 215 | 216 | 221 | 219 | 192 | 193 | 194 | 195 | 196 | 196 | None | None | 198 | 197 | 199 | 200 | 201 | 203 | 202 | 204 | 204 | 204 | None | None | 207 | 206 | 205 | 208 | 206 | 209 | 210 | 211 | 220 | 220 | None | 212 | 218 | None | 212 | 217 | 213 | 223 | 224 | None | 232 | 225 | 226 | 227 | 228 | None | 229 | 228 | 230 | 232 | 231 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F615 | F615 | F615 | F615 | F615 | 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 | F690 | F615 | F615 | F615 | F615 | F604 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F604 | F615 | F604 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F604 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F604 | F604 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F604 | F604 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F606 | F615 | F615 | F615 | F615 | F604 | F604 | F615 | F615 | 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 | 1 | 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 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_date | 1997-10-31 00:00:00 | 1999-10-28 00:00:00 | 1997-07-28 00:00:00 | 1999-04-27 00:00:00 | 1999-07-27 00:00:00 | 1998-10-27 00:00:00 | 1998-07-31 00:00:00 | 1998-04-28 00:00:00 | 1998-01-27 00:00:00 | 1999-02-01 00:00:00 | 2000-04-27 00:00:00 | 2000-01-20 00:00:00 | 2000-10-12 00:00:00 | 2000-07-31 00:00:00 | 2000-10-12 00:00:00 | 2001-01-23 00:00:00 | 2000-12-29 00:00:00 | 2001-04-25 00:00:00 | 2001-04-26 00:00:00 | 2001-01-24 00:00:00 | 2001-04-25 00:00:00 | 2001-10-22 00:00:00 | 2001-07-25 00:00:00 | 2001-07-30 00:00:00 | 2001-10-29 00:00:00 | 2002-01-29 00:00:00 | 2002-01-31 00:00:00 | 2002-04-26 00:00:00 | 2002-04-30 00:00:00 | 2002-07-30 00:00:00 | 2002-05-06 00:00:00 | 2002-07-23 00:00:00 | 2002-05-03 00:00:00 | 2002-10-29 00:00:00 | 2002-10-31 00:00:00 | 2002-12-31 00:00:00 | 2002-12-26 00:00:00 | 2003-01-30 00:00:00 | 2003-04-30 00:00:00 | 2003-01-30 00:00:00 | 2003-07-30 00:00:00 | 2003-05-01 00:00:00 | 2003-07-30 00:00:00 | 2003-10-29 00:00:00 | 2003-10-30 00:00:00 | 2004-01-29 00:00:00 | 2004-04-22 00:00:00 | 2004-04-28 00:00:00 | 2004-01-29 00:00:00 | 2004-07-15 00:00:00 | 2004-07-27 00:00:00 | 2004-10-12 00:00:00 | 2004-10-25 00:00:00 | 2004-12-30 00:00:00 | 2004-11-30 00:00:00 | 2005-01-19 00:00:00 | 2005-01-13 00:00:00 | 2005-01-25 00:00:00 | 2005-07-15 00:00:00 | 2005-04-15 00:00:00 | 2005-01-21 00:00:00 | 2006-01-19 00:00:00 | 2005-10-13 00:00:00 | 2006-04-17 00:00:00 | 2006-07-17 00:00:00 | 2006-07-17 00:00:00 | 2006-07-17 00:00:00 | 2006-10-13 00:00:00 | 2006-12-20 00:00:00 | 2007-01-22 00:00:00 | 2006-12-29 00:00:00 | 2007-04-16 00:00:00 | 2007-07-03 00:00:00 | 2008-01-08 00:00:00 | 2007-10-04 00:00:00 | 2013-07-15 00:00:00 | 2015-07-21 00:00:00 | 2013-10-10 00:00:00 | 2014-01-16 00:00:00 | 2015-04-20 00:00:00 | 2014-10-16 00:00:00 | 2008-03-26 00:00:00 | 2008-04-16 00:00:00 | 2008-07-18 00:00:00 | 2008-10-20 00:00:00 | 2008-11-13 00:00:00 | 2009-01-13 00:00:00 | 2008-12-15 00:00:00 | 2009-01-16 00:00:00 | 2009-07-07 00:00:00 | 2009-04-03 00:00:00 | 2009-10-05 00:00:00 | 2010-01-04 00:00:00 | 2010-03-31 00:00:00 | 2010-10-04 00:00:00 | 2010-07-06 00:00:00 | 2010-11-05 00:00:00 | 2011-01-13 00:00:00 | 2011-01-13 00:00:00 | 2010-12-20 00:00:00 | 2011-04-21 00:00:00 | 2011-10-06 00:00:00 | 2011-05-23 00:00:00 | 2011-04-22 00:00:00 | 2012-01-05 00:00:00 | 2011-07-13 00:00:00 | 2012-04-18 00:00:00 | 2012-07-12 00:00:00 | 2012-10-04 00:00:00 | 2014-11-13 00:00:00 | 2015-01-26 00:00:00 | 2014-12-18 00:00:00 | 2012-11-30 00:00:00 | 2014-07-10 00:00:00 | 2012-12-31 00:00:00 | 2013-01-10 00:00:00 | 2014-04-16 00:00:00 | 2013-04-15 00:00:00 | 2015-10-05 00:00:00 | 2016-01-08 00:00:00 | 2017-12-05 00:00:00 | 2018-01-09 00:00:00 | 2016-04-04 00:00:00 | 2016-07-06 00:00:00 | 2016-10-17 00:00:00 | 2016-11-17 00:00:00 | 2016-12-21 00:00:00 | 2017-04-13 00:00:00 | 2017-01-24 00:00:00 | 2017-07-27 00:00:00 | 2017-11-30 00:00:00 | 2017-10-26 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_type | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10005 | 10001 | 10005 | 10005 | 10001 | 10005 | 10005 | 10001 | 10005 | 10006 | 10001 | 10001 | 10005 | 10005 | 10001 | 10005 | 10001 | 10005 | 10005 | 10006 | 10001 | 10002 | 10005 | 10001 | 10001 | 10005 | 10001 | 10001 | 10005 | 10005 | 10005 | 10001 | 10001 | 10005 | 10001 | 10001 | 10005 | 10005 | 10001 | 10005 | 10001 | 10005 | 10005 | 10001 | 10001 | 10002 | 10005 | 10001 | 10001 | 10006 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10006 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10005 | 10002 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_status | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
session_id | 1997 | 1999 | 1997 | 1999 | 1999 | 1997 | 1997 | 1997 | 1997 | 1997 | 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 | 2003 | 2003 | 2001 | 2003 | 2001 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2005 | 2005 | 2003 | 2005 | 2003 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2007 | 2005 | 2007 | 2007 | 2007 | 2007 | 2007 | 2013 | 2015 | 2013 | 2013 | 2015 | 2013 | 2007 | 2007 | 2007 | 2007 | 2009 | 2007 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2011 | 2009 | 2009 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2015 | 2013 | 2015 | 2013 | 2013 | 2013 | 2011 | 2013 | 2013 | 2015 | 2015 | 2017 | 2017 | 2015 | 2015 | 2015 | 2017 | 2017 | 2017 | 2015 | 2017 | 2017 | 2017 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
user_id | * | * | * | * | * | * | * | * | * | * | TTHAM | * | * | YBONILLA | YBONILLA | * | GKURIMOT | JBRANNAN | * | YBONILLA | SARRIAGA | * | * | LTHIBAUL | LTHIBAUL | * | GGILMORE | * | RALLMOND | LTHIBAUL | LTHIBAUL | * | * | DHORRELL | * | BSMITH | BSMITH | COMPLETED | COMPLETED | LTHIBAUL | LTHIBAUL | LTHIBAUL | COMPLETED | COMPLETED | LTHIBAUL | COMPLETED | COMPLETED | LTHIBAUL | LTHIBAUL | COMPLETED | LTHIBAUL | COMPLETED | LTHIBAUL | DMCCASTL | COMPLETED | COMPLETED | COMPLETED | JWHITE | LTHIBAUL | LTHIBAUL | YBONILLA | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | * | LTHIBAUL | SARRIAGA | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | ASAETERN | JINGRAM | AGLADNEY | ASAETERN | AGLADNEY | AGLADNEY | LTHIBAUL | LTHIBAUL | LTHIBAUL | JINGRAM | * | JINGRAM | NLANDERS | SARRIAGA | MGUERRA | MGUERRA | MGUERRA | MGUERRA | JINGRAM | ASAETERN | ASAETERN | * | ASAETERN | ASAETERN | CFLAGG | CFLAGG | JINGRAM | * | JINGRAM | JINGRAM | ASAETERN | ASAETERN | ASAETERN | ASAETERN | YRODRIGU | AGLADNEY | GKURIMOT | SARRIAGA | AGLADNEY | SARRIAGA | ASAETERN | AGLADNEY | AGLADNEY | JINGRAM | AGLADNEY | GPEREZ | AGLADNEY | AGLADNEY | AGLADNEY | JINGRAM | YRODRIGU | YRODRIGU | JINGRAM | AGLADNEY | SMCCONNAN | GPEREZ | AGLADNEY | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
special_audit | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11002 | 11003 | 11002 | 11002 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 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 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 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 | 11003 | 11003 | 11001 | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_start | 1997-07-01 00:00:00 | 1999-07-01 00:00:00 | 1997-04-01 00:00:00 | 1999-01-01 00:00:00 | 1999-04-01 00:00:00 | 1998-07-01 00:00:00 | 1998-04-01 00:00:00 | 1998-01-01 00:00:00 | 1997-10-01 00:00:00 | 1998-10-01 00:00:00 | 2000-01-01 00:00:00 | 1999-10-01 00:00:00 | 2000-07-01 00:00:00 | 2000-04-01 00:00:00 | 2000-07-01 00:00:00 | 2000-10-01 00:00:00 | 1900-01-01 00:00:00 | 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-07-01 00:00:00 | 2001-04-01 00:00:00 | 2001-04-01 00:00:00 | 2001-07-01 00:00:00 | 2001-10-01 00:00:00 | 2001-10-01 00:00:00 | 2002-01-01 00:00:00 | 2002-01-01 00:00:00 | 2002-04-01 00:00:00 | 2002-01-01 00:00:00 | 2002-04-01 00:00:00 | 2002-01-01 00:00:00 | 2002-07-01 00:00:00 | 2002-07-01 00:00:00 | 2002-12-13 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-07-01 00:00:00 | 2003-10-01 00:00:00 | 2004-01-01 00:00:00 | 2004-01-01 00:00:00 | 2003-10-01 00:00:00 | 2004-04-30 00:00:00 | 2004-04-01 00:00:00 | 2004-07-01 00:00:00 | 2004-07-01 00:00:00 | 1900-01-01 00:00:00 | 2004-12-16 00:00:00 | 2004-10-01 00:00:00 | 2004-12-16 00:00:00 | 2004-10-01 00:00:00 | 2005-04-01 00:00:00 | 2005-01-01 00:00:00 | 1900-01-01 00:00:00 | 2005-10-01 00:00:00 | 2005-07-01 00:00:00 | 2006-01-01 00:00:00 | 2006-04-01 00:00:00 | 2006-04-01 00:00:00 | 2006-04-01 00:00:00 | 2006-07-01 00:00:00 | 2006-12-20 00:00:00 | 2006-10-01 00:00:00 | 1900-01-01 00:00:00 | 2007-01-01 00:00:00 | 2007-04-01 00:00:00 | 2007-10-01 00:00:00 | 2007-07-01 00:00:00 | 2013-04-01 00:00:00 | 2015-04-01 00:00:00 | 2013-07-01 00:00:00 | 2013-10-01 00:00:00 | 2015-01-01 00:00:00 | 2014-07-01 00:00:00 | 2007-10-01 00:00:00 | 2008-01-01 00:00:00 | 2008-04-01 00:00:00 | 2008-07-01 00:00:00 | 2008-11-13 00:00:00 | 2008-10-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2009-04-01 00:00:00 | 2009-01-01 00:00:00 | 2009-07-01 00:00:00 | 2009-10-01 00:00:00 | 2010-01-01 00:00:00 | 2010-07-01 00:00:00 | 2010-04-01 00:00:00 | 2010-11-05 00:00:00 | 2010-10-01 00:00:00 | 2010-10-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2011-07-01 00:00:00 | 2011-05-23 00:00:00 | 2011-01-01 00:00:00 | 2011-10-01 00:00:00 | 2011-04-01 00:00:00 | 2012-01-01 00:00:00 | 2012-04-01 00:00:00 | 2012-07-01 00:00:00 | 2014-11-13 00:00:00 | 2014-10-01 00:00:00 | 1900-01-01 00:00:00 | 2012-11-30 00:00:00 | 2014-04-01 00:00:00 | 1900-01-01 00:00:00 | 2012-10-01 00:00:00 | 2014-01-01 00:00:00 | 2013-01-01 00:00:00 | 2015-07-01 00:00:00 | 2015-10-01 00:00:00 | 1900-01-01 00:00:00 | 2017-10-01 00:00:00 | 2016-01-01 00:00:00 | 2016-04-01 00:00:00 | 2016-07-01 00:00:00 | 2016-11-17 00:00:00 | 1900-01-01 00:00:00 | 2017-01-01 00:00:00 | 2016-10-01 00:00:00 | 2017-04-01 00:00:00 | 2017-11-30 00:00:00 | 2017-07-01 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_end | 1997-09-30 00:00:00 | 1999-09-30 00:00:00 | 1997-06-30 00:00:00 | 1999-03-31 00:00:00 | 1999-06-30 00:00:00 | 1998-09-30 00:00:00 | 1998-06-30 00:00:00 | 1998-03-31 00:00:00 | 1997-12-31 00:00:00 | 1998-12-31 00:00:00 | 2000-03-31 00:00:00 | 1999-12-31 00:00:00 | 2000-09-30 00:00:00 | 2000-06-30 00:00:00 | 2000-09-30 00:00:00 | 2000-12-31 00:00:00 | 1900-01-01 00:00:00 | 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-09-30 00:00:00 | 2001-06-30 00:00:00 | 2001-06-30 00:00:00 | 2001-09-30 00:00:00 | 2001-12-31 00:00:00 | 2001-12-31 00:00:00 | 2002-03-31 00:00:00 | 2002-03-31 00:00:00 | 2002-06-30 00:00:00 | 2002-03-31 00:00:00 | 2002-06-30 00:00:00 | 2002-03-31 00:00:00 | 2002-09-30 00:00:00 | 2002-09-30 00:00:00 | 2002-12-13 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-09-30 00:00:00 | 2003-12-31 00:00:00 | 2004-03-31 00:00:00 | 2004-03-31 00:00:00 | 2003-12-31 00:00:00 | 2004-06-30 00:00:00 | 2004-06-30 00:00:00 | 2004-09-30 00:00:00 | 2004-09-30 00:00:00 | 1900-01-01 00:00:00 | 2004-12-16 00:00:00 | 2004-12-31 00:00:00 | 2004-12-16 00:00:00 | 2004-12-31 00:00:00 | 2005-06-30 00:00:00 | 2005-03-31 00:00:00 | 1900-01-01 00:00:00 | 2005-12-31 00:00:00 | 2005-09-30 00:00:00 | 2006-03-31 00:00:00 | 2006-06-01 00:00:00 | 2006-06-30 00:00:00 | 2006-06-01 00:00:00 | 2006-09-30 00:00:00 | 2006-12-20 00:00:00 | 2006-12-31 00:00:00 | 1900-01-01 00:00:00 | 2007-03-31 00:00:00 | 2207-06-30 00:00:00 | 2007-12-31 00:00:00 | 2007-09-30 00:00:00 | 2013-06-30 00:00:00 | 2015-06-30 00:00:00 | 2013-09-30 00:00:00 | 2013-12-31 00:00:00 | 2015-03-31 00:00:00 | 2014-09-30 00:00:00 | 2007-12-31 00:00:00 | 2008-03-31 00:00:00 | 2008-06-30 00:00:00 | 2008-09-30 00:00:00 | 2008-11-13 00:00:00 | 2008-12-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2009-06-30 00:00:00 | 2009-03-31 00:00:00 | 2009-09-30 00:00:00 | 2009-12-31 00:00:00 | 2010-03-31 00:00:00 | 2010-09-30 00:00:00 | 2010-06-30 00:00:00 | 2010-11-05 00:00:00 | 2010-12-31 00:00:00 | 2010-12-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2011-09-30 00:00:00 | 2011-05-23 00:00:00 | 2011-03-31 00:00:00 | 2011-12-31 00:00:00 | 2011-06-30 00:00:00 | 2012-03-31 00:00:00 | 2012-06-30 00:00:00 | 2012-09-30 00:00:00 | 2014-11-13 00:00:00 | 2014-12-31 00:00:00 | 1900-01-01 00:00:00 | 2012-11-30 00:00:00 | 2014-06-30 00:00:00 | 1900-01-01 00:00:00 | 2012-12-31 00:00:00 | 2014-03-31 00:00:00 | 2013-03-31 00:00:00 | 2015-09-30 00:00:00 | 2015-12-31 00:00:00 | 1900-01-01 00:00:00 | 2017-12-31 00:00:00 | 2016-03-31 00:00:00 | 2016-06-30 00:00:00 | 2016-09-30 00:00:00 | 2016-11-17 00:00:00 | 1900-01-01 00:00:00 | 2017-03-31 00:00:00 | 2016-12-31 00:00:00 | 2017-06-30 00:00:00 | 2017-11-30 00:00:00 | 2017-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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | 22001 | 22001 | None | None | None | 22001 | 22001 | None | 22001 | 22001 | None | None | 22001 | None | 22001 | None | None | 22001 | 22001 | 22001 | None | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22006 | 22001 | None | 22001 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 |
filer_id | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_type | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | ||||||||||||
active | Y | Y | Y | Y | Y | Y | Y | Y | Y | T | Y | Y | ||||||||||||
race | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | ||||||||||||
session_id | 2001 | 1997 | 1999 | 2003 | 2005 | 2007 | 2011 | 2013 | 2009 | 2017 | 2015 | 2017 | ||||||||||||
category | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | ||||||||||||
category_type | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | ||||||||||||
sub_category | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | ||||||||||||
effect_dt | 2001-01-01 00:00:00 | 1997-04-07 00:00:00 | 1999-01-01 00:00:00 | 2003-01-01 00:00:00 | 2005-01-01 00:00:00 | 2007-01-01 00:00:00 | 2011-01-01 00:00:00 | 2013-01-01 00:00:00 | 2009-01-01 00:00:00 | 2017-11-16 00:00:00 | 2015-01-01 00:00:00 | 2017-01-01 00:00:00 | ||||||||||||
sub_category_type | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | ||||||||||||
election_type | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | ||||||||||||
sub_category_a | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
nyq_dt | None | None | None | None | 2000-07-01 00:00:00 | 2000-07-01 00:00:00 | None | None | None | None | None | None | ||||||||||||
party_cd | 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 | ||||||||||||
district_cd | None | None | None | None | None | None | None | None | None | None | None | None |
filer_id | 1149276 | |
---|---|---|
xref_id | L25482 | |
effect_dt | 1999-12-08 00:00:00 | |
migration_source | MASTER |
xref_filer_id | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | L25482 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_id | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
naml | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | BERENDS | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
namf | EDWIN | EDWIN | EDWIN | EDWIN | EDWIN | EDWIN | EDWIN | EDWIN | EDWIN | EDWIN | EDWIN | EDWIN | EDWIN | EDWIN | EDWIN | EDWIN | EDWIN | EDWIN | EDWIN | EDWIN | EDWIN | EDWIN | EDWIN | EDWIN | EDWIN | EDWIN | EDWIN | EDWIN | EDWIN | EDWIN | EDWIN | EDWIN | EDWIN | EDWIN | EDWIN | EDWIN | EDWIN | EDWIN | EDWIN | EDWIN | EDWIN | EDWIN | EDWIN | EDWIN | EDWIN | EDWIN | EDWIN | EDWIN | EDWIN | EDWIN | EDWIN | EDWIN | EDWIN | EDWIN | EDWIN | EDWIN | EDWIN | EDWIN | EDWIN | EDWIN | EDWIN | EDWIN | EDWIN | EDWIN | EDWIN | EDWIN | EDWIN | EDWIN | EDWIN | EDWIN | EDWIN | EDWIN | EDWIN | EDWIN | EDWIN | EDWIN | EDWIN | EDWIN | EDWIN | EDWIN | ED | ED | ED | ED | ED | ED | ED | ED | ED | ED | EDWIN | EDWIN | EDWIN | EDWIN | EDWIN | EDWIN | EDWIN | EDWIN | EDWIN | EDWIN | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | LOS ANGELES | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | LOS ANGELES | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | LOS ANGELES | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | LOS ANGELES | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | LOS ANGELES | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | LOS ANGELES | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | LOS ANGELES | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | LOS ANGELES | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | LOS ANGELES | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | LOS ANGELES | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | 90064 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 90064 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 90064 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 90064 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 90064 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 90064 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 90064 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 90064 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 90064 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 90064 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
phon | 9164417888 | 9164417888 | 9164417888 | 9164417888 | 9164417888 | 9164417888 | 9164417888 | 9164417888 | 9164417888 | 9164417888 | 9164417888 | 9164417888 | 9164417888 | 9164417888 | 9164417888 | 9164417888 | 9164417888 | 9164417888 | 9164417888 | 9164417888 | 9164417888 | 9164417888 | 9164417888 | 9164417888 | 9164417888 | 9164417888 | 9164417888 | 9164417888 | 9164417888 | 9164417888 | 9164417888 | 9164417888 | 9164417888 | 9164417888 | 9164417888 | 9164417888 | 9164417888 | 9164417888 | 9164417888 | 9164417888 | 9164417888 | 9164417888 | 9164417888 | 9164417888 | 9164417888 | 9164417888 | 9164417888 | 9164417888 | 9164417888 | 9164417888 | 9164417888 | 9164417888 | 9164417888 | 9164417888 | 9164417888 | 9164417888 | 9164417888 | 9164417888 | 9164417888 | 9164417888 | 9164417888 | 9164417888 | 9164417888 | 9164417888 | 9164417888 | 9164417888 | 9164417888 | 9164417888 | 9164417888 | 9164417888 | 9164417888 | 9164417888 | 9164417888 | 9164417888 | 9164417888 | 9164417888 | 9164417888 | 9164417888 | 9164417888 | 9164417888 | 9164417888 | 9164417888 | 9164417888 | 9164417888 | 9164417888 | 9164417888 | 9164417888 | 9164417888 | 9164417888 | 9164417888 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fax | 9164451424 | 9164451424 | 9164451424 | 9164451424 | 9164451424 | 9164451424 | 9164451424 | 9164451424 | 9164451424 | 9164451424 | 9164451424 | 9164451424 | 9164451424 | 9164451424 | 9164451424 | 9164451424 | 9164451424 | 9164451424 | 9164451424 | 9164451424 | 9164451424 | 9164451424 | 9164451424 | 9164451424 | 9164451424 | 9164451424 | 9164451424 | 9164451424 | 9164451424 | 9164451424 | 9164451424 | 9164451424 | 9164451424 | 9164451424 | 9164451424 | 9164451424 | 9164451424 | 9164451424 | 9164451424 | 9164451424 | 9164451424 | 9164451424 | 9164451424 | 9164451424 | 9164451424 | 9164451424 | 9164451424 | 9164451424 | 9164451424 | 9164451424 | 9164451424 | 9164451424 | 9164451424 | 9164451424 | 9164451424 | 9164451424 | 9164451424 | 9164451424 | 9164451424 | 9164451424 | 9164451424 | 9164451424 | 9164451424 | 9164451424 | 9164451424 | 9164451424 | 9164451424 | 9164451424 | 9164451424 | 9164451424 | 9164451424 | 9164451424 | 9164451424 | 9164451424 | 9164451424 | 9164451424 | 9164451424 | 9164451424 | 9164451424 | 9164451424 | 9164451424 | 9164451424 | 9164451424 | 9164451424 | 9164451424 | 9164451424 | 9164451424 | 9164451424 | 9164451424 | 9164451424 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
[email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None |
filer_id | 1149276 |
---|
filer_id | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | |||||
---|---|---|---|---|---|---|---|---|---|---|
change_no | 1 | 2 | 3 | 4 | 5 | |||||
session_id | 2001 | 2001 | 1999 | 2017 | 2017 | |||||
log_dt | 2001-05-14 00:00:00 | 2001-05-14 00:00:00 | 2001-05-14 00:00:00 | 2017-12-05 00:00:00 | 2017-12-05 00:00:00 | |||||
filer_type | 4 | 4 | 4 | 4 | 4 | |||||
correction_flg | None | None | None | None | None | |||||
action | ADDED | ADDED | CHANGED | DELETED | TERMINATED | |||||
attribute_changed | ETHICS | ETHICS | None | EMPLOYER | ||||||
ethics_dt | 2001-01-17 00:00:00 | 2001-01-18 00:00:00 | None | None | None | |||||
interests | None | None | None | None | None | |||||
filer_full_name | EDWIN BERENDS | EDWIN BERENDS | EDWIN BERENDS | EDWIN BERENDS | BERENDS, EDWIN | |||||
filer_city | None | None | SACRAMENTO | None | None | |||||
filer_st | None | None | CA | None | None | |||||
filer_zip | None | None | 95814 | None | None | |||||
filer_phone | None | None | 9164417888 | None | None | |||||
entity_type | 4 | 4 | 4 | 2 | 4 | |||||
entity_name | None | None | None | LOS ANGELES; COUNTY OF | None | |||||
entity_city | None | None | None | None | None | |||||
entity_st | None | None | None | None | None | |||||
entity_zip | None | None | None | None | None | |||||
entity_phone | None | None | None | None | None | |||||
entity_id | 0 | 0 | 0 | 1146830 | 0 | |||||
responsible_officer | None | None | None | None | None | |||||
effect_dt | None | None | None | 2017-11-16 00:00:00 | 2017-11-16 00:00:00 |
filer_id | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | 1149276 | ||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_file_name | 670311_0.cal | 29848.cal | 713564_0.cal | 744098_0.cal | 769942_0.cal | 788181_0.cal | 811986_0.cal | 837728_0.cal | 358384.cal | 837728_1.cal | 851065_0.cal | 884451_0.cal | 898716_0.cal | 910278_0.cal | 930903_0.cal | 946204_0.cal | 968537_0.cal | 988007_0.cal | 1010613_0.cal | 1023235_0.cal | 1047109_0.cal | 1063578_0.cal | 1073037_0.cal | 1100496_0.cal | 1127926_0.cal | 1112146_0.cal | 224303.cal | 1142638_0.cal | 1162562_0.cal | 1184705_0.cal | 1184707_0.cal | 1184705_1.cal | 1207400_0.cal | 1229716_0.cal | 1223961_0.cal | 1256875_0.cal | 1381442_0.cal | 1542914_0.cal | 1542914_1.cal | 1715403_0.cal | 2107728_0.cal | 1914928_0.cal | ||||||||||||||||||||||||||||||||||||||||||
received_date | 2000-10-12 00:00:00 | 2001-01-23 00:00:00 | 2001-01-23 00:00:00 | 2001-04-26 00:00:00 | 2001-07-25 00:00:00 | 2001-10-22 00:00:00 | 2002-01-29 00:00:00 | 2002-04-26 00:00:00 | 2002-05-03 00:00:00 | 2002-05-03 00:00:00 | 2002-07-23 00:00:00 | 2002-10-31 00:00:00 | 2002-12-31 00:00:00 | 2003-01-30 00:00:00 | 2003-04-30 00:00:00 | 2003-07-30 00:00:00 | 2003-10-29 00:00:00 | 2004-01-29 00:00:00 | 2004-04-22 00:00:00 | 2004-07-15 00:00:00 | 2004-10-12 00:00:00 | 2004-11-30 00:00:00 | 2005-01-19 00:00:00 | 2005-04-15 00:00:00 | 2005-10-13 00:00:00 | 2005-07-15 00:00:00 | 2005-07-15 00:00:00 | 2006-01-19 00:00:00 | 2006-04-17 00:00:00 | 2006-07-17 00:00:00 | 2006-07-17 00:00:00 | 2006-07-17 00:00:00 | 2006-10-13 00:00:00 | 2007-01-22 00:00:00 | 2006-12-20 00:00:00 | 2007-04-16 00:00:00 | 2008-11-13 00:00:00 | 2010-11-05 00:00:00 | 2011-05-23 00:00:00 | 2012-11-30 00:00:00 | 2016-11-17 00:00:00 | 2014-11-13 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||
filing_directory | /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 | /usr/users/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/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 | ||||||||||||||||||||||||||||||||||||||||||
filing_id | 670311 | None | 713564 | 744098 | 769942 | 788181 | 811986 | 837728 | None | 837728 | 851065 | 884451 | 898716 | 910278 | 930903 | 946204 | 968537 | 988007 | 1010613 | 1023235 | 1047109 | 1063578 | 1073037 | 1100496 | 1127926 | 1112146 | None | 1142638 | 1162562 | 1184705 | 1184707 | 1184705 | 1207400 | 1229716 | 1223961 | 1256875 | 1381442 | 1542914 | 1542914 | 1715403 | 2107728 | 1914928 | ||||||||||||||||||||||||||||||||||||||||||
form_id | F615 | None | F615 | F615 | F615 | F615 | F615 | F615 | None | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | None | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F604 | F604 | F604 | F604 | F604 | F604 | ||||||||||||||||||||||||||||||||||||||||||
receive_comment | Filing accepted | Filing passed validation, but failed DB constraints | 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, but with warnings | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing 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 |