filer_id | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
adrid | 1103932 | 1101529 | 2046487 | 2079313 | 2119103 | 2159998 | 2203523 | 2276571 | 2341448 | |||||||||
effect_dt | 1994-12-15 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 | 2009-01-01 00:00:00 | 2011-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 | 7051 | 7051 | |||||||||
session_id | 1995 | 1999 | 2003 | 2005 | 2007 | 2009 | 2011 | 2013 | 2015 |
filer_id | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
session_id | 1997 | 1999 | 2001 | 1995 | 2003 | 2005 | 2007 | 2011 | 2009 | 2013 | 2015 | |||||||||||
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 | 2003-01-16 00:00:00 | 2004-11-17 00:00:00 | 2007-02-08 00:00:00 | 2011-01-13 00:00:00 | 2008-11-12 00:00:00 | 2013-01-24 00:00:00 | 2015-04-09 00:00:00 |
filer_id | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 510418 | 512481 | 513513 | 521860 | 521394 | 523488 | 523957 | 518305 | 525580 | 521394 | 519766 | 526075 | 529606 | 512053 | 515177 | 515627 | 542765 | 516654 | 528108 | 542403 | 625805 | 610863 | 654936 | 681093 | 703203 | 715778 | 686673 | 747256 | 745195 | 726076 | 776971 | 791811 | 771767 | 791811 | 815750 | 812746 | 794170 | 839580 | 840673 | 850609 | 890857 | 855740 | 915921 | 905932 | 883538 | 918330 | 930318 | 933126 | 944592 | 940136 | 952941 | 965750 | 972734 | 988224 | 1009999 | 991111 | 1009375 | 1031988 | 1032073 | 1069621 | 1062608 | 1081303 | 1086341 | 1061283 | 1114484 | 1089280 | 1104107 | 1134451 | 1168000 | 1148888 | 1216582 | 1192108 | 1225656 | 1249508 | 1284766 | 1246981 | 1304943 | 1290231 | 1262291 | 1979663 | 1963994 | 1866758 | 1796867 | 1782214 | 1957712 | 1922349 | 1953565 | 1911639 | 1296452 | 1329284 | 1349473 | 1387134 | 1378290 | 1395596 | 1421895 | 1423173 | 1450289 | 1462941 | 1437964 | 1485533 | 1506220 | 1538686 | 1556010 | 1564471 | 1590368 | 1598242 | 1571624 | 1606513 | 1556010 | 1631008 | 1621365 | 1657845 | 1675222 | 1934061 | 1701563 | 1720876 | 1734038 | 1845852 | 1816498 | 1744738 | 1758678 | 1765871 | 1997862 | 2012520 | 2027762 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
period_id | 141 | 157 | 142 | 145 | 152 | 153 | 146 | 151 | 154 | 152 | 144 | 147 | 156 | 149 | 150 | 158 | 155 | 143 | 148 | 159 | 161 | 160 | 162 | 163 | None | 164 | 163 | 165 | 165 | 164 | None | 167 | 165 | 167 | None | 168 | None | 169 | None | 170 | None | None | None | 172 | 171 | None | 173 | None | 174 | None | None | 175 | None | 176 | None | None | 177 | 178 | None | 181 | None | 180 | None | 179 | 182 | None | 181 | 183 | 185 | 184 | 187 | 186 | 188 | 188 | 190 | None | 192 | None | 189 | 222 | 221 | 218 | 215 | 214 | None | 220 | None | 219 | 191 | 193 | 194 | 196 | 195 | 196 | 197 | None | 199 | 200 | 198 | 201 | 202 | 203 | 204 | None | 205 | None | 204 | 206 | 206 | 208 | 207 | 209 | 210 | 220 | 211 | 212 | 212 | 217 | 216 | None | None | 213 | 223 | 224 | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F690 | F615 | F615 | 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 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F604 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F604 | F604 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F604 | F615 | F604 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F604 | F604 | F615 | F615 | F615 | F606 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_sequence | 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 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_date | 1995-05-01 00:00:00 | 1999-04-30 00:00:00 | 1995-07-31 00:00:00 | 1996-04-30 00:00:00 | 1998-01-30 00:00:00 | 1998-04-30 00:00:00 | 1996-07-25 00:00:00 | 1997-10-31 00:00:00 | 1998-07-31 00:00:00 | 1998-02-10 00:00:00 | 1996-01-31 00:00:00 | 1996-10-31 00:00:00 | 1999-01-29 00:00:00 | 1997-04-30 00:00:00 | 1997-07-29 00:00:00 | 1999-07-28 00:00:00 | 1998-10-30 00:00:00 | 1995-10-31 00:00:00 | 1997-01-30 00:00:00 | 1999-10-29 00:00:00 | 2000-05-01 00:00:00 | 2000-01-28 00:00:00 | 2000-07-26 00:00:00 | 2000-10-30 00:00:00 | 2000-12-21 00:00:00 | 2001-01-29 00:00:00 | 2000-10-31 00:00:00 | 2001-04-30 00:00:00 | 2001-04-28 00:00:00 | 2001-01-31 00:00:00 | 2001-07-30 00:00:00 | 2001-10-31 00:00:00 | 2001-07-30 00:00:00 | 2001-10-31 00:00:00 | 2002-01-31 00:00:00 | 2002-01-30 00:00:00 | 2001-10-31 00:00:00 | 2002-04-30 00:00:00 | 2002-04-30 00:00:00 | 2002-07-22 00:00:00 | 2002-10-31 00:00:00 | 2002-07-29 00:00:00 | 2002-12-20 00:00:00 | 2003-01-24 00:00:00 | 2002-10-30 00:00:00 | 2003-01-31 00:00:00 | 2003-04-29 00:00:00 | 2003-04-30 00:00:00 | 2003-07-25 00:00:00 | 2003-06-27 00:00:00 | 2003-07-25 00:00:00 | 2003-10-21 00:00:00 | 2003-10-28 00:00:00 | 2004-01-29 00:00:00 | 2004-04-16 00:00:00 | 2004-01-30 00:00:00 | 2004-04-16 00:00:00 | 2004-08-02 00:00:00 | 2004-07-30 00:00:00 | 2005-01-03 00:00:00 | 2004-11-01 00:00:00 | 2005-01-31 00:00:00 | 2005-01-31 00:00:00 | 2004-11-08 00:00:00 | 2005-07-26 00:00:00 | 2004-12-31 00:00:00 | 2005-04-29 00:00:00 | 2005-10-31 00:00:00 | 2006-05-01 00:00:00 | 2006-01-31 00:00:00 | 2006-10-31 00:00:00 | 2006-07-31 00:00:00 | 2007-01-02 00:00:00 | 2007-02-28 00:00:00 | 2007-07-31 00:00:00 | 2007-01-02 00:00:00 | 2008-01-22 00:00:00 | 2007-08-27 00:00:00 | 2007-04-30 00:00:00 | 2015-07-29 00:00:00 | 2015-04-29 00:00:00 | 2014-07-25 00:00:00 | 2013-10-24 00:00:00 | 2013-07-31 00:00:00 | 2015-04-09 00:00:00 | 2014-12-31 00:00:00 | 2014-12-31 00:00:00 | 2014-10-31 00:00:00 | 2007-10-30 00:00:00 | 2008-04-30 00:00:00 | 2008-07-30 00:00:00 | 2008-12-31 00:00:00 | 2008-10-31 00:00:00 | 2009-01-30 00:00:00 | 2009-04-30 00:00:00 | 2008-12-30 00:00:00 | 2009-10-27 00:00:00 | 2010-01-29 00:00:00 | 2009-07-31 00:00:00 | 2010-04-30 00:00:00 | 2010-07-30 00:00:00 | 2010-10-29 00:00:00 | 2010-12-30 00:00:00 | 2010-12-30 00:00:00 | 2011-04-29 00:00:00 | 2011-06-17 00:00:00 | 2011-01-31 00:00:00 | 2011-07-29 00:00:00 | 2011-06-13 00:00:00 | 2012-01-24 00:00:00 | 2011-10-28 00:00:00 | 2012-04-30 00:00:00 | 2012-07-26 00:00:00 | 2015-01-30 00:00:00 | 2012-10-23 00:00:00 | 2012-12-27 00:00:00 | 2013-01-28 00:00:00 | 2014-04-30 00:00:00 | 2014-01-30 00:00:00 | 2012-12-27 00:00:00 | 2013-01-29 00:00:00 | 2013-04-30 00:00:00 | 2015-11-02 00:00:00 | 2016-02-01 00:00:00 | 2016-04-11 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_type | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10005 | 10005 | 10001 | 10005 | 10001 | 10005 | 10005 | 10001 | 10005 | 10005 | 10001 | 10001 | 10002 | 10005 | 10001 | 10005 | 10001 | 10005 | 10001 | 10005 | 10005 | 10005 | 10001 | 10001 | 10005 | 10001 | 10005 | 10001 | 10006 | 10005 | 10001 | 10005 | 10001 | 10005 | 10005 | 10001 | 10001 | 10005 | 10001 | 10005 | 10001 | 10005 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10006 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10006 | 10001 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10006 | 10001 | 10001 | 10001 | 10003 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | 11003 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
session_id | 1995 | 1999 | 1995 | 1995 | 1997 | 1997 | 1995 | 1997 | 1997 | 1997 | 1995 | 1995 | 1997 | 1997 | 1997 | 1999 | 1997 | 1995 | 1995 | 1999 | 1999 | 1999 | 1999 | 1999 | 2001 | 1999 | 1999 | 2001 | 2001 | 1999 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2003 | 2001 | 2001 | 2001 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2005 | 2003 | 2003 | 2003 | 2003 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2007 | 2005 | 2007 | 2007 | 2007 | 2007 | 2007 | 2015 | 2015 | 2013 | 2013 | 2013 | 2015 | 2015 | 2015 | 2013 | 2007 | 2007 | 2007 | 2009 | 2007 | 2007 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2011 | 2011 | 2011 | 2011 | 2009 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2013 | 2011 | 2012 | 2011 | 2013 | 2013 | 2013 | 2013 | 2013 | 2015 | 2015 | 2015 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
user_id | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | GGILMORE | TTHAM | JLEHMAN | * | TTHAM | * | MKIENG | GPEREZ | * | MKIENG | YBONILLA | * | * | * | YBONILLA | * | YBONILLA | * | YBONILLA | * | YBONILLA | YBONILLA | SARRIAGA | COMPLETED | * | YBONILLA | COMPLETED | YBONILLA | COMPLETED | SARRIAGA | KVANG | COMPLETED | YBONILLA | COMPLETED | EMCENTEE | YBONILLA | COMPLETED | COMPLETED | EMCENTEE | COMPLETED | YRODRIGU | COMPLETED | YRODRIGU | COMPLETED | YRODRIGU | SARRIAGA | YRODRIGU | YRODRIGU | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | * | YRODRIGU | YRODRIGU | PBANFORD | LTHIBAUL | GPEREZ | YRODRIGU | SJENSEN | SJENSEN | ASAETERN | ASAETERN | ASAETERN | PBANFORD | YRODRIGU | YRODRIGU | ASAETERN | LTHIBAUL | YRODRIGU | LTHIBAUL | * | JINGRAM | JINGRAM | JINGRAM | PBANFORD | JINGRAM | JINGRAM | JINGRAM | JINGRAM | ASAETERN | ASAETERN | YRODRIGU | CFLAGG | JINGRAM | YRODRIGU | ASAETERN | ASAETERN | YRODRIGU | ASAETERN | ASAETERN | ASAETERN | AGLADNEY | AGLADNEY | ASAETERN | PBANFORD | ASAETERN | ASAETERN | ASAETERN | PBANFORD | SARRIAGA | ASAETERN | JINGRAM | AGLADNEY | YRODRIGU | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
special_audit | 11001 | 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 | 11003 | 11002 | 11003 | 11003 | 11003 | 11002 | 11003 | 11003 | 11002 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fine_audit | 11001 | 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 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 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 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_start | 1995-01-01 00:00:00 | 1999-01-01 00:00:00 | 1995-04-01 00:00:00 | 1996-01-01 00:00:00 | 1997-10-01 00:00:00 | 1998-01-01 00:00:00 | 1996-04-01 00:00:00 | 1997-07-01 00:00:00 | 1998-04-01 00:00:00 | 1997-10-01 00:00:00 | 1995-10-01 00:00:00 | 1996-07-01 00:00:00 | 1998-10-01 00:00:00 | 1997-01-01 00:00:00 | 1997-04-01 00:00:00 | 1999-04-01 00:00:00 | 1998-07-01 00:00:00 | 1995-07-01 00:00:00 | 1996-10-01 00:00:00 | 1999-07-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 | 2000-10-01 00:00:00 | 2000-07-01 00:00:00 | 2001-01-01 00:00:00 | 2001-01-01 00:00:00 | 2000-10-01 00:00:00 | 2001-03-01 00:00:00 | 2001-07-01 00:00:00 | 2001-03-01 00:00:00 | 2001-07-01 00:00:00 | 2001-10-01 00:00:00 | 2001-10-01 00:00:00 | 2001-07-01 00:00:00 | 2002-01-01 00:00:00 | 2002-01-01 00:00:00 | 2002-04-01 00:00:00 | 2002-07-01 00:00:00 | 2002-04-01 00:00:00 | 1900-01-01 00:00:00 | 2002-10-01 00:00:00 | 2002-07-01 00:00:00 | 2002-10-01 00:00:00 | 2003-01-01 00:00:00 | 2003-01-01 00:00:00 | 2003-04-01 00:00:00 | 1900-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 | 2003-10-01 00:00:00 | 2004-01-01 00:00:00 | 2004-04-01 00:00:00 | 2004-04-01 00:00:00 | 2005-01-03 00:00:00 | 2004-07-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 | 1900-01-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-07-01 00:00:00 | 2006-04-01 00:00:00 | 2006-12-18 00:00:00 | 2006-10-01 00:00:00 | 2007-04-01 00:00:00 | 1900-01-01 00:00:00 | 2007-10-01 00:00:00 | 1900-01-01 00:00:00 | 2007-01-01 00:00:00 | 2015-04-01 00:00:00 | 2015-01-01 00:00:00 | 2014-04-01 00:00:00 | 2013-07-01 00:00:00 | 2013-04-01 00:00:00 | 1900-01-01 00:00:00 | 2014-12-30 00:00:00 | 1900-01-01 00:00:00 | 2014-07-01 00:00:00 | 2007-07-01 00:00:00 | 2008-01-01 00:00:00 | 2008-04-01 00:00:00 | 2008-12-31 00:00:00 | 2008-07-01 00:00:00 | 2008-10-01 00:00:00 | 2009-01-01 00:00:00 | 1900-01-01 00:00:00 | 2009-07-01 00:00:00 | 2009-10-01 00:00:00 | 2009-04-01 00:00:00 | 2010-01-01 00:00:00 | 2010-04-01 00:00:00 | 2010-07-01 00:00:00 | 2010-12-30 00:00:00 | 1900-01-01 00:00:00 | 2011-01-01 00:00:00 | 1900-01-01 00:00:00 | 2010-10-01 00:00:00 | 2011-04-01 00:00:00 | 2011-06-10 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 | 2014-10-01 00:00:00 | 2012-07-01 00:00:00 | 2012-12-30 00:00:00 | 2012-10-01 00:00:00 | 2014-01-01 00:00:00 | 2013-10-01 00:00:00 | 1900-01-01 00:00:00 | 1900-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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_end | 1995-03-31 00:00:00 | 1999-03-31 00:00:00 | 1995-06-30 00:00:00 | 1996-03-31 00:00:00 | 1997-12-31 00:00:00 | 1998-03-31 00:00:00 | 1996-06-30 00:00:00 | 1997-09-30 00:00:00 | 1998-06-30 00:00:00 | 1997-12-31 00:00:00 | 1995-12-31 00:00:00 | 1996-09-30 00:00:00 | 1998-12-31 00:00:00 | 1997-03-31 00:00:00 | 1997-06-30 00:00:00 | 1999-06-30 00:00:00 | 1998-09-30 00:00:00 | 1995-09-30 00:00:00 | 1996-12-31 00:00:00 | 1999-09-30 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 | 2000-12-31 00:00:00 | 2000-09-30 00:00:00 | 2001-03-31 00:00:00 | 2001-03-31 00:00:00 | 2000-12-31 00:00:00 | 2001-06-30 00:00:00 | 2001-09-30 00:00:00 | 2001-06-30 00:00:00 | 2001-09-30 00:00:00 | 2001-12-31 00:00:00 | 2001-12-31 00:00:00 | 2001-09-30 00:00:00 | 2002-03-31 00:00:00 | 2002-03-01 00:00:00 | 2002-06-30 00:00:00 | 2002-09-30 00:00:00 | 2002-06-30 00:00:00 | 1900-01-01 00:00:00 | 2002-12-31 00:00:00 | 2002-09-30 00:00:00 | 2002-12-31 00:00:00 | 2003-03-31 00:00:00 | 2003-03-31 00:00:00 | 2003-06-30 00:00:00 | 1900-01-01 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 | 2003-12-31 00:00:00 | 2004-03-31 00:00:00 | 2004-06-30 00:00:00 | 2004-06-30 00:00:00 | 2005-01-03 00:00:00 | 2004-09-30 00:00:00 | 2004-12-31 00:00:00 | 2004-12-31 00:00:00 | 2004-09-30 00:00:00 | 2005-06-30 00:00:00 | 1900-01-01 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-09-30 00:00:00 | 2006-06-30 00:00:00 | 2006-12-18 00:00:00 | 2006-12-31 00:00:00 | 2007-06-30 00:00:00 | 1900-01-01 00:00:00 | 2007-12-31 00:00:00 | 1900-01-01 00:00:00 | 2007-03-31 00:00:00 | 2015-06-30 00:00:00 | 2015-03-31 00:00:00 | 2014-06-30 00:00:00 | 2013-09-30 00:00:00 | 2013-06-30 00:00:00 | 1900-01-01 00:00:00 | 2014-12-30 00:00:00 | 1900-01-01 00:00:00 | 2014-09-30 00:00:00 | 2007-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 | 2008-12-31 00:00:00 | 2009-03-31 00:00:00 | 1900-01-01 00:00:00 | 2009-09-30 00:00:00 | 2009-12-31 00:00:00 | 2009-06-30 00:00:00 | 2010-03-31 00:00:00 | 2010-06-30 00:00:00 | 2010-09-30 00:00:00 | 2010-12-30 00:00:00 | 1900-01-01 00:00:00 | 2011-03-31 00:00:00 | 1900-01-01 00:00:00 | 2010-12-31 00:00:00 | 2011-06-30 00:00:00 | 2011-06-10 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 | 2014-12-31 00:00:00 | 2012-09-30 00:00:00 | 2012-12-30 00:00:00 | 2012-12-31 00:00:00 | 2014-03-31 00:00:00 | 2013-12-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | None | None | 22001 | None | 22001 | None | None | 22001 | None | 22001 | None | None | 22001 | 22001 | None | 22001 | None | 22001 | None | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | None | 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 | None | None | 22001 | 22001 | 22001 | None |
filer_id | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_type | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | ||||||||||||
active | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | T | ||||||||||||
race | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | ||||||||||||
session_id | 1997 | 1999 | 1995 | 2001 | 2003 | 2005 | 2007 | 2011 | 2013 | 2009 | 2015 | 2015 | ||||||||||||
category | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | ||||||||||||
category_type | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | ||||||||||||
sub_category | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | ||||||||||||
effect_dt | 1997-01-01 00:00:00 | 1999-01-01 00:00:00 | 1994-12-15 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 | 2015-01-01 00:00:00 | 2016-01-01 00:00:00 | ||||||||||||
sub_category_type | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | ||||||||||||
election_type | 0 | 0 | 0 | 0 | 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 | None | 2000-07-01 00:00:00 | 2000-07-01 00:00:00 | 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 | 1148598 | |
---|---|---|
xref_id | L24731 | |
effect_dt | 1999-12-08 00:00:00 | |
migration_source | MASTER |
xref_filer_id | L24731 | L24731 | L24731 | L24731 | L24731 | L24731 | L24731 | L24731 | L24731 | L24731 | L24731 | L24731 | L24731 | L24731 | L24731 | L24731 | L24731 | L24731 | L24731 | L24731 | L24731 | L24731 | L24731 | L24731 | L24731 | L24731 | L24731 | L24731 | L24731 | L24731 | L24731 | L24731 | L24731 | L24731 | L24731 | L24731 | L24731 | L24731 | L24731 | L24731 | L24731 | L24731 | L24731 | L24731 | L24731 | L24731 | L24731 | L24731 | L24731 | L24731 | L24731 | L24731 | L24731 | L24731 | L24731 | L24731 | L24731 | L24731 | L24731 | L24731 | L24731 | L24731 | L24731 | L24731 | L24731 | L24731 | L24731 | L24731 | L24731 | L24731 | L24731 | L24731 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_id | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
effect_dt | 2016-01-01 00:00:00 | 2016-01-01 00:00:00 | 2016-01-01 00:00:00 | 2016-01-01 00:00:00 | 2016-01-01 00:00:00 | 2016-01-01 00:00:00 | 2016-01-01 00:00:00 | 2016-01-01 00:00:00 | 2016-01-01 00:00:00 | 2016-01-01 00:00:00 | 2016-01-01 00:00:00 | 2016-01-01 00:00:00 | 2016-01-01 00:00:00 | 2016-01-01 00:00:00 | 2016-01-01 00:00:00 | 2016-01-01 00:00:00 | 2016-01-01 00:00:00 | 2016-01-01 00:00:00 | 2016-01-01 00:00:00 | 2016-01-01 00:00:00 | 2016-01-01 00:00:00 | 2016-01-01 00:00:00 | 2016-01-01 00:00:00 | 2016-01-01 00:00:00 | 2016-01-01 00:00:00 | 2016-01-01 00:00:00 | 2016-01-01 00:00:00 | 2016-01-01 00:00:00 | 2016-01-01 00:00:00 | 2016-01-01 00:00:00 | 2016-01-01 00:00:00 | 2016-01-01 00:00:00 | 2016-01-01 00:00:00 | 2016-01-01 00:00:00 | 2016-01-01 00:00:00 | 2016-01-01 00:00:00 | 2016-01-01 00:00:00 | 2016-01-01 00:00:00 | 2016-01-01 00:00:00 | 2016-01-01 00:00:00 | 2016-01-01 00:00:00 | 2016-01-01 00:00:00 | 2016-01-01 00:00:00 | 2016-01-01 00:00:00 | 2016-01-01 00:00:00 | 2016-01-01 00:00:00 | 2016-01-01 00:00:00 | 2016-01-01 00:00:00 | 2016-01-01 00:00:00 | 2016-01-01 00:00:00 | 2016-01-01 00:00:00 | 2016-01-01 00:00:00 | 2016-01-01 00:00:00 | 2016-01-01 00:00:00 | 2016-01-01 00:00:00 | 2016-01-01 00:00:00 | 2016-01-01 00:00:00 | 2016-01-01 00:00:00 | 2016-01-01 00:00:00 | 2016-01-01 00:00:00 | 2016-01-01 00:00:00 | 2016-01-01 00:00:00 | 2016-01-01 00:00:00 | 2016-01-01 00:00:00 | 2016-01-01 00:00:00 | 2016-01-01 00:00:00 | 2016-01-01 00:00:00 | 2016-01-01 00:00:00 | 2016-01-01 00:00:00 | 2016-01-01 00:00:00 | 2016-01-01 00:00:00 | 2016-01-01 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
naml | BROWNSEY | BROWNSEY | BROWNSEY | BROWNSEY | BROWNSEY | BROWNSEY | BROWNSEY | BROWNSEY | BROWNSEY | BROWNSEY | BROWNSEY | BROWNSEY | BROWNSEY | BROWNSEY | BROWNSEY | BROWNSEY | BROWNSEY | BROWNSEY | BROWNSEY | BROWNSEY | BROWNSEY | BROWNSEY | BROWNSEY | BROWNSEY | BROWNSEY | BROWNSEY | BROWNSEY | BROWNSEY | BROWNSEY | BROWNSEY | BROWNSEY | BROWNSEY | BROWNSEY | BROWNSEY | BROWNSEY | BROWNSEY | BROWNSEY | BROWNSEY | BROWNSEY | BROWNSEY | BROWNSEY | BROWNSEY | BROWNSEY | BROWNSEY | BROWNSEY | BROWNSEY | BROWNSEY | BROWNSEY | BROWNSEY | BROWNSEY | BROWNSEY | BROWNSEY | BROWNSEY | BROWNSEY | BROWNSEY | BROWNSEY | BROWNSEY | BROWNSEY | BROWNSEY | BROWNSEY | BROWNSEY | BROWNSEY | BROWNSEY | BROWNSEY | BROWNSEY | BROWNSEY | BROWNSEY | BROWNSEY | BROWNSEY | BROWNSEY | BROWNSEY | BROWNSEY | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
namf | DONNE | DONNE | DONNE | DONNE | DONNE | DONNE | DONNE | DONNE | DONNE | DONNE | DONNE | DONNE | DONNE | DONNE | DONNE | DONNE | DONNE | DONNE | DONNE | DONNE | DONNE | DONNE | DONNE | DONNE | DONNE | DONNE | DONNE | DONNE | DONNE | DONNE | DONNE | DONNE | DONNE | DONNE | DONNE | DONNE | DONNE | DONNE | DONNE | DONNE | DONNE | DONNE | DONNE | DONNE | DONNE | DONNE | DONNE | DONNE | DONNE | DONNE | DONNE | DONNE | DONNE | DONNE | DONNE | DONNE | DONNE | DONNE | DONNE | DONNE | DONNE | DONNE | DONNE | DONNE | DONNE | DONNE | DONNE | DONNE | DONNE | DONNE | DONNE | DONNE | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
zip4 | 95814 | 95818 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95818 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95818 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95818 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95818 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95818 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95818 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95818 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
phon | 9164482260 | 9164578960 | 9164482260 | 9164481222 | 9164481222 | 9164481222 | 9164481222 | 9164481222 | 9164481222 | 9164482260 | 9164578960 | 9164482260 | 9164481222 | 9164481222 | 9164481222 | 9164481222 | 9164481222 | 9164481222 | 9164482260 | 9164578960 | 9164482260 | 9164481222 | 9164481222 | 9164481222 | 9164481222 | 9164481222 | 9164481222 | 9164482260 | 9164578960 | 9164482260 | 9164481222 | 9164481222 | 9164481222 | 9164481222 | 9164481222 | 9164481222 | 9164482260 | 9164578960 | 9164482260 | 9164481222 | 9164481222 | 9164481222 | 9164481222 | 9164481222 | 9164481222 | 9164482260 | 9164578960 | 9164482260 | 9164481222 | 9164481222 | 9164481222 | 9164481222 | 9164481222 | 9164481222 | 9164482260 | 9164578960 | 9164482260 | 9164481222 | 9164481222 | 9164481222 | 9164481222 | 9164481222 | 9164481222 | 9164482260 | 9164578960 | 9164482260 | 9164481222 | 9164481222 | 9164481222 | 9164481222 | 9164481222 | 9164481222 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fax | 9164482554 | None | 9164482554 | 9164482554 | None | 9164482554 | 9164482554 | None | 9164482554 | 9164482554 | None | 9164482554 | 9164482554 | None | 9164482554 | 9164482554 | None | 9164482554 | 9164482554 | None | 9164482554 | 9164482554 | None | 9164482554 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
None | None | None | None | None | None | None | None | [email protected] | None | None | None | None | None | None | None | None | [email protected] | None | None | None | None | None | None | None | None | [email protected] | None | None | None | None | None | None | None | None | [email protected] | None | None | None | None | None | None | None | None | [email protected] | None | None | None | None | None | None | None | None | [email protected] | None | None | None | None | None | None | None | None | [email protected] | None | None | None | None | None | None | None | None | [email protected] |
filer_id | 1148598 |
---|
filer_id | 1148598 | |
---|---|---|
change_no | 1 | |
session_id | 2015 | |
log_dt | 2016-04-11 00:00:00 | |
filer_type | 4 | |
correction_flg | Y | |
action | ADDED | |
attribute_changed | FIRM | |
ethics_dt | None | |
interests | None | |
filer_full_name | BROWNSEY, DONNE | |
filer_city | SACRAMENTO | |
filer_st | CA | |
filer_zip | 95814 | |
filer_phone | 9164482260 | |
entity_type | 3 | |
entity_name | SACRAMENTO ADVOCATES INC. | |
entity_city | None | |
entity_st | None | |
entity_zip | None | |
entity_phone | None | |
entity_id | None | |
responsible_officer | None | |
effect_dt | 2016-01-01 00:00:00 |
filer_id | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | 1148598 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_file_name | 681093_0.cal | 715778_0.cal | 745195_0.cal | 229791.cal | 229967.cal | 771767_0.cal | 791811_0.cal | 791811_1.cal | 812746_0.cal | 839580_0.cal | 850609_0.cal | 883538_0.cal | 905932_0.cal | 944592_0.cal | 930318_0.cal | 965750_0.cal | 988224_0.cal | 1009375_0.cal | 1031988_0.cal | 1061283_0.cal | 1081303_0.cal | 1069621_0.cal | 1395596_0.cal | 1349473_0.cal | 1485533_0.cal | 1506220_0.cal | 1462941_0.cal | 1450289_0.cal | 1249508_0.cal | 1225656_0.cal | 1262291_0.cal | 1421895_0.cal | 1437964_0.cal | 1284766_0.cal | 1296452_0.cal | 1304943_0.cal | 1378290_0.cal | 1387134_0.cal | 1329284_0.cal | 1845852_0.cal | 1734038_0.cal | 1675222_0.cal | 1765871_0.cal | 1782214_0.cal | 1796867_0.cal | 1538686_0.cal | 1701563_0.cal | 1571624_0.cal | 1556010_0.cal | 1816498_0.cal | 1606513_0.cal | 1556010_1.cal | 1590368_0.cal | 1621365_0.cal | 1631008_0.cal | 1720876_0.cal | 1657845_0.cal | 1866758_0.cal | 102550.cal | 102595.cal | 1997862_0.cal | 2012520_0.cal | 1911639_0.cal | 1922349_0.cal | 1963994_0.cal | 1934061_0.cal | 1979663_0.cal | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
received_date | 2000-10-30 00:00:00 | 2001-01-29 00:00:00 | 2001-04-28 00:00:00 | 2001-04-28 00:00:00 | 2001-04-28 00:00:00 | 2001-07-30 00:00:00 | 2001-10-31 00:00:00 | 2001-10-31 00:00:00 | 2002-01-30 00:00:00 | 2002-04-30 00:00:00 | 2002-07-22 00:00:00 | 2002-10-30 00:00:00 | 2003-01-24 00:00:00 | 2003-07-25 00:00:00 | 2003-04-29 00:00:00 | 2003-10-21 00:00:00 | 2004-01-29 00:00:00 | 2004-04-16 00:00:00 | 2004-08-02 00:00:00 | 2004-11-08 00:00:00 | 2005-01-31 00:00:00 | 2005-01-03 00:00:00 | 2009-01-30 00:00:00 | 2008-07-30 00:00:00 | 2010-04-30 00:00:00 | 2010-07-30 00:00:00 | 2010-01-29 00:00:00 | 2009-10-27 00:00:00 | 2007-02-28 00:00:00 | 2007-01-02 00:00:00 | 2007-04-30 00:00:00 | 2009-04-30 00:00:00 | 2009-07-31 00:00:00 | 2007-07-31 00:00:00 | 2007-10-30 00:00:00 | 2008-01-22 00:00:00 | 2008-10-31 00:00:00 | 2008-12-31 00:00:00 | 2008-04-30 00:00:00 | 2014-04-30 00:00:00 | 2013-01-28 00:00:00 | 2012-07-26 00:00:00 | 2013-04-30 00:00:00 | 2013-07-31 00:00:00 | 2013-10-24 00:00:00 | 2010-10-29 00:00:00 | 2012-10-23 00:00:00 | 2011-01-31 00:00:00 | 2010-12-30 00:00:00 | 2014-01-30 00:00:00 | 2011-07-29 00:00:00 | 2011-06-13 00:00:00 | 2011-04-29 00:00:00 | 2011-10-28 00:00:00 | 2012-01-24 00:00:00 | 2012-12-27 00:00:00 | 2012-04-30 00:00:00 | 2014-07-25 00:00:00 | 2014-07-25 00:00:00 | 2014-07-25 00:00:00 | 2015-11-02 00:00:00 | 2016-02-01 00:00:00 | 2014-10-31 00:00:00 | 2014-12-31 00:00:00 | 2015-04-29 00:00:00 | 2015-01-30 00:00:00 | 2015-07-29 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/temp | /usr/users/cafiler/disclose/ca99/temp | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_id | 681093 | 715778 | 745195 | None | None | 771767 | 791811 | 791811 | 812746 | 839580 | 850609 | 883538 | 905932 | 944592 | 930318 | 965750 | 988224 | 1009375 | 1031988 | 1061283 | 1081303 | 1069621 | 1395596 | 1349473 | 1485533 | 1506220 | 1462941 | 1450289 | 1249508 | 1225656 | 1262291 | 1421895 | 1437964 | 1284766 | 1296452 | 1304943 | 1378290 | 1387134 | 1329284 | 1845852 | 1734038 | 1675222 | 1765871 | 1782214 | 1796867 | 1538686 | 1701563 | 1571624 | 1556010 | 1816498 | 1606513 | 1556010 | 1590368 | 1621365 | 1631008 | 1720876 | 1657845 | 1866758 | None | None | 1997862 | 2012520 | 1911639 | 1922349 | 1963994 | 1934061 | 1979663 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F615 | F615 | F615 | None | None | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F604 | F615 | F615 | F615 | F604 | F615 | F615 | None | None | F615 | F615 | F615 | F604 | F615 | F615 | F615 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
receive_comment | Filing accepted | Filing accepted | Filing accepted | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing accepted | Filing accepted, but with warnings | 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 accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted |