filer_id | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
adrid | 1106931 | 1103429 | 1102084 | 1132617 | 2043642 | 2081974 | 2112900 | 2175531 | 2203076 | 2410846 | 2260297 | 2337297 | ||||||||||||
effect_dt | 1995-01-01 00:00:00 | 1997-01-01 00:00:00 | 1999-01-01 00:00:00 | 2000-01-18 00:00:00 | 2003-01-01 00:00:00 | 2005-01-01 00:00:00 | 2007-01-01 00:00:00 | 2009-01-01 00:00:00 | 2011-01-01 00:00:00 | 2017-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 | 7051 | 7051 | 7051 | ||||||||||||
session_id | 1995 | 1997 | 1999 | 1999 | 2003 | 2005 | 2007 | 2009 | 2011 | 2017 | 2013 | 2015 |
filer_id | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
session_id | 1997 | 2001 | 1995 | 2005 | 2003 | 2007 | 2009 | 2011 | 2013 | 2015 | 2017 | |||||||||||
ethics_date | 1996-11-13 00:00:00 | 2000-11-14 00:00:00 | 1994-08-04 00:00:00 | 2004-11-17 00:00:00 | 2002-11-13 00:00:00 | 2007-01-18 00:00:00 | 2009-04-24 00:00:00 | 2011-05-19 00:00:00 | 2013-06-20 00:00:00 | 2015-04-09 00:00:00 | 2017-02-02 00:00:00 |
filer_id | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 520846 | 524365 | 522960 | 517085 | 511509 | 512610 | 515759 | 542461 | 526479 | 527161 | 527161 | 528497 | 529152 | 522273 | 525066 | 517748 | 510845 | 514610 | 529152 | 529152 | 513942 | 517748 | 636288 | 636291 | 617417 | 632356 | 623261 | 623263 | 681968 | 653429 | 703961 | 693288 | 741633 | 970929 | 759403 | 747926 | 725182 | 769497 | 778487 | 797835 | 792933 | 819751 | 808668 | 837323 | 836582 | 859415 | 846104 | 840700 | 889574 | 893016 | 917782 | 913089 | 901070 | 930280 | 934840 | 946825 | 956673 | 938983 | 976701 | 986263 | 1011248 | 996952 | 1018355 | 1026431 | 1030714 | 1071436 | 1069781 | 1075304 | 1093130 | 1065736 | 1057367 | 1132532 | 1103300 | 1113329 | 1168083 | 1148124 | 1192556 | 1216800 | 1229048 | 1225041 | 1250141 | 1272352 | 1261934 | 1294713 | 1307021 | 1765257 | 1782279 | 1772028 | 1969669 | 1966193 | 1968648 | 1977129 | 1871350 | 1800937 | 1958518 | 1328480 | 1286525 | 1346271 | 1382155 | 1391798 | 1425113 | 1420893 | 1426709 | 1437989 | 1424319 | 1449071 | 1460571 | 1504919 | 1481394 | 1534643 | 1560554 | 1570294 | 1622018 | 1588729 | 1594978 | 1605405 | 1636708 | 1656755 | 1675684 | 1818397 | 1934589 | 1913451 | 1738750 | 1707876 | 1845951 | 1840366 | 1995420 | 2205005 | 2261335 | 2008592 | 2031328 | 2055373 | 2093168 | 2122035 | 2114105 | 2153583 | 2112849 | 2135857 | 2267066 | 2167391 | 2191897 | 2236843 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
period_id | 152 | 146 | 153 | 143 | 149 | 157 | 158 | 144 | 147 | 155 | 155 | 148 | 156 | 145 | 154 | 151 | 141 | 150 | 156 | 156 | 142 | 151 | None | None | 160 | 161 | 160 | 159 | 163 | 162 | None | 163 | 164 | 175 | 165 | 165 | 164 | 166 | None | None | 167 | None | 168 | 169 | None | None | None | None | 171 | None | 172 | None | None | 173 | None | 174 | None | None | None | 176 | 177 | None | None | 178 | None | None | 180 | 180 | None | None | 178 | 183 | 181 | 182 | 185 | 184 | 186 | 187 | None | 188 | 188 | None | 189 | 191 | 192 | 213 | 214 | None | None | 221 | 222 | 222 | 218 | 215 | None | 193 | 190 | 194 | 195 | 196 | None | 197 | None | 198 | 198 | 199 | 200 | 202 | 201 | 203 | None | 204 | 207 | 205 | None | 206 | 208 | 209 | 210 | 216 | 220 | 219 | 212 | 211 | 217 | None | 223 | 232 | None | 224 | 225 | 226 | 227 | 228 | None | 229 | 228 | None | 234 | 230 | 231 | 233 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F690 | F615 | F615 | F615 | F615 | F690 | F615 | F615 | F690 | F690 | F615 | F615 | F615 | F690 | F615 | F615 | F690 | F690 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F690 | F615 | F615 | F690 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F604 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F604 | F604 | F615 | F604 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F604 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F606 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F604 | F604 | F615 | F615 | F615 | F615 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_sequence | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 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 | 1998-01-28 00:00:00 | 1996-07-31 00:00:00 | 1998-04-30 00:00:00 | 1995-10-31 00:00:00 | 1997-04-29 00:00:00 | 1999-04-30 00:00:00 | 1999-08-02 00:00:00 | 1996-01-31 00:00:00 | 1996-10-30 00:00:00 | 1998-10-30 00:00:00 | 1999-04-30 00:00:00 | 1997-01-29 00:00:00 | 1999-02-01 00:00:00 | 1996-04-30 00:00:00 | 1998-07-31 00:00:00 | 1999-04-30 00:00:00 | 1995-04-28 00:00:00 | 1997-07-31 00:00:00 | 1999-04-30 00:00:00 | 1999-07-14 00:00:00 | 1995-07-31 00:00:00 | 1997-10-30 00:00:00 | 2000-02-11 00:00:00 | 2000-06-19 00:00:00 | 2000-01-31 00:00:00 | 2000-04-28 00:00:00 | 2000-02-11 00:00:00 | 2000-02-11 00:00:00 | 2000-10-31 00:00:00 | 2000-07-31 00:00:00 | 2000-12-28 00:00:00 | 2000-10-31 00:00:00 | 2001-02-13 00:00:00 | 2003-11-07 00:00:00 | 2001-05-03 00:00:00 | 2001-05-03 00:00:00 | 2001-02-13 00:00:00 | 2001-07-24 00:00:00 | 2001-07-24 00:00:00 | 2001-10-30 00:00:00 | 2001-11-01 00:00:00 | 2002-01-22 00:00:00 | 2002-01-22 00:00:00 | 2002-04-25 00:00:00 | 2002-01-15 00:00:00 | 2002-07-29 00:00:00 | 2002-04-25 00:00:00 | 2002-01-15 00:00:00 | 2002-11-05 00:00:00 | 2002-10-29 00:00:00 | 2003-02-10 00:00:00 | 2003-01-28 00:00:00 | 2002-12-30 00:00:00 | 2003-04-29 00:00:00 | 2003-04-29 00:00:00 | 2003-07-30 00:00:00 | 2003-07-30 00:00:00 | 2003-06-17 00:00:00 | 2003-11-06 00:00:00 | 2004-01-26 00:00:00 | 2004-04-26 00:00:00 | 2004-01-28 00:00:00 | 2004-04-30 00:00:00 | 2004-07-27 00:00:00 | 2004-07-27 00:00:00 | 2004-12-30 00:00:00 | 2005-01-04 00:00:00 | 2005-01-25 00:00:00 | 2005-01-31 00:00:00 | 2004-10-29 00:00:00 | 2004-10-29 00:00:00 | 2005-10-28 00:00:00 | 2005-04-27 00:00:00 | 2005-07-21 00:00:00 | 2006-05-01 00:00:00 | 2006-01-31 00:00:00 | 2006-07-31 00:00:00 | 2006-10-31 00:00:00 | 2006-12-29 00:00:00 | 2006-12-28 00:00:00 | 2007-03-02 00:00:00 | 2007-06-06 00:00:00 | 2007-04-30 00:00:00 | 2007-10-25 00:00:00 | 2008-01-28 00:00:00 | 2013-04-30 00:00:00 | 2013-07-31 00:00:00 | 2013-06-20 00:00:00 | 2015-05-15 00:00:00 | 2015-04-30 00:00:00 | 2015-05-15 00:00:00 | 2015-07-24 00:00:00 | 2014-07-31 00:00:00 | 2013-10-31 00:00:00 | 2015-04-09 00:00:00 | 2008-04-29 00:00:00 | 2007-08-02 00:00:00 | 2008-07-25 00:00:00 | 2008-11-24 00:00:00 | 2009-01-26 00:00:00 | 2009-04-24 00:00:00 | 2009-04-30 00:00:00 | 2009-06-15 00:00:00 | 2009-07-31 00:00:00 | 2009-05-20 00:00:00 | 2009-10-22 00:00:00 | 2010-01-26 00:00:00 | 2010-07-29 00:00:00 | 2010-04-22 00:00:00 | 2010-10-25 00:00:00 | 2011-01-12 00:00:00 | 2011-01-31 00:00:00 | 2011-10-31 00:00:00 | 2011-04-27 00:00:00 | 2011-05-19 00:00:00 | 2011-07-28 00:00:00 | 2012-01-31 00:00:00 | 2012-04-30 00:00:00 | 2012-07-27 00:00:00 | 2014-01-31 00:00:00 | 2015-01-30 00:00:00 | 2014-11-03 00:00:00 | 2013-01-31 00:00:00 | 2012-10-30 00:00:00 | 2014-04-30 00:00:00 | 2014-04-02 00:00:00 | 2015-10-28 00:00:00 | 2018-01-24 00:00:00 | 2018-06-21 00:00:00 | 2016-01-28 00:00:00 | 2016-04-22 00:00:00 | 2016-07-14 00:00:00 | 2016-10-21 00:00:00 | 2017-01-23 00:00:00 | 2016-12-21 00:00:00 | 2017-04-26 00:00:00 | 2016-12-21 00:00:00 | 2017-02-02 00:00:00 | 2018-07-20 00:00:00 | 2017-07-14 00:00:00 | 2017-10-30 00:00:00 | 2018-04-26 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 | 10001 | 10001 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10001 | 10005 | 10005 | 10005 | 10005 | 10001 | 10005 | 10001 | 10001 | 10001 | 10005 | 10005 | 10001 | 10005 | 10001 | 10001 | 10005 | 10005 | 10005 | 10005 | 10001 | 10005 | 10001 | 10005 | 10005 | 10001 | 10005 | 10001 | 10005 | 10002 | 10005 | 10001 | 10001 | 10005 | 10005 | 10001 | 10005 | 10005 | 10001 | 10001 | 10005 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10006 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10006 | 10001 | 10001 | 10001 | 10001 | 10001 | 10006 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10006 | 10001 | 10001 | 10001 | 10001 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_status | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
session_id | 1997 | 1995 | 1997 | 1995 | 1997 | 1999 | 1999 | 1995 | 1995 | 1997 | 1997 | 1995 | 1997 | 1995 | 1997 | 1997 | 1995 | 1997 | 1997 | 1997 | 1995 | 1997 | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 2001 | 1999 | 1999 | 2003 | 2001 | 2001 | 1999 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2005 | 2005 | 2003 | 2003 | 2003 | 2003 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2007 | 2007 | 2005 | 2007 | 2007 | 2007 | 2007 | 2013 | 2013 | 2013 | 2015 | 2015 | 2015 | 2015 | 2013 | 2013 | 2015 | 2007 | 2007 | 2007 | 2007 | 2007 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2011 | 2009 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2013 | 2013 | 2013 | 2011 | 2011 | 2013 | 2013 | 2015 | 2017 | 2017 | 2015 | 2015 | 2015 | 2015 | 2015 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
user_id | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | DHORRELL | DHORRELL | * | YBONILLA | TTHAM | TTHAM | YBONILLA | YBONILLA | DHORRELL | YBONILLA | DHORRELL | COMPLETED | YBONILLA | * | * | * | LTHIBAUL | LTHIBAUL | * | LTHIBAUL | * | * | LTHIBAUL | LTHIBAUL | LTHIBAUL | DBARRICK | * | LTHIBAUL | COMPLETED | LTHIBAUL | GPEREZ | COMPLETED | KVOONG1 | COMPLETED | LTHIBAUL | GPEREZ | LTHIBAUL | COMPLETED | COMPLETED | LTHIBAUL | LTHIBAUL | COMPLETED | EMCENTEE | SARRIAGA | COMPLETED | COMPLETED | KLARRY | EMCENTEE | COMPLETED | LTHIBAUL | LTHIBAUL | LTHIBAUL | DHORRELL | LTHIBAUL | LTHIBAUL | LTHIBAUL | YRODRIGU | * | DHORRELL | GPEREZ | LTHIBAUL | LTHIBAUL | LTHIBAUL | AGLADNEY | AGLADNEY | PBANFORD | YRODRIGU | JINGRAM | PBANFORD | JINGRAM | AGLADNEY | AGLADNEY | PBANFORD | LTHIBAUL | LTHIBAUL | LTHIBAUL | MGUERRA | MGUERRA | YRODRIGU | MGUERRA | YRODRIGU | MGUERRA | * | MGUERRA | WBROWN | ASAETERN | JINGRAM | AGLADNEY | DMCCASTL | ASAETERN | ASAETERN | JINGRAM | PBANFORD | ASAETERN | ASAETERN | ASAETERN | AGLADNEY | AGLADNEY | MPACHECO | GCLARA | ASAETERN | ASAETERN | AGLADNEY | YRODRIGU | JINGRAM | AGLADNEY | GPEREZ | AGLADNEY | AGLADNEY | AGLADNEY | JINGRAM | AGLADNEY | SARRIAGA | SMCCONNAN | KBANH | KBANH | JFRONEFIELD | SMCCONNAN | AGLADNEY | CAFILER | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
special_audit | 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 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 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 | 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 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 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 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_start | 1997-10-01 00:00:00 | 1996-04-01 00:00:00 | 1998-01-01 00:00:00 | 1995-07-01 00:00:00 | 1997-01-01 00:00:00 | 1999-01-01 00:00:00 | 1999-04-01 00:00:00 | 1995-10-01 00:00:00 | 1996-07-01 00:00:00 | 1998-07-01 00:00:00 | 1998-07-01 00:00:00 | 1996-10-01 00:00:00 | 1998-10-01 00:00:00 | 1996-01-01 00:00:00 | 1998-04-01 00:00:00 | 1997-07-01 00:00:00 | 1995-01-01 00:00:00 | 1997-04-01 00:00:00 | 1998-10-01 00:00:00 | 1998-10-01 00:00:00 | 1995-04-01 00:00:00 | 1997-07-01 00:00:00 | 1999-07-01 00:00:00 | 1999-07-01 00:00:00 | 1999-10-01 00:00:00 | 2000-01-01 00:00:00 | 1999-10-01 00:00:00 | 1999-07-01 00:00:00 | 2000-07-01 00:00:00 | 2000-04-01 00:00:00 | 1900-01-01 00:00:00 | 2000-07-01 00:00:00 | 2000-10-01 00:00:00 | 2003-07-01 00:00:00 | 2001-01-01 00:00:00 | 2001-01-01 00:00:00 | 2000-10-01 00:00:00 | 2001-04-01 00:00:00 | 2001-04-01 00:00:00 | 2001-07-01 00:00:00 | 2001-07-01 00:00:00 | 2001-10-01 00:00:00 | 2001-10-01 00:00:00 | 2002-01-01 00:00:00 | 2001-01-01 00:00:00 | 2002-04-01 00:00:00 | 2002-01-01 00:00:00 | 2001-01-01 00:00:00 | 2002-07-01 00:00:00 | 2002-07-01 00:00:00 | 2002-10-01 00:00:00 | 2002-10-01 00:00:00 | 1900-01-01 00:00:00 | 2003-01-01 00:00:00 | 2003-01-01 00:00:00 | 2003-04-01 00:00:00 | 2003-04-01 00:00:00 | 1900-01-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 | 1900-01-01 00:00:00 | 2004-12-21 00:00:00 | 2004-10-01 00:00:00 | 2004-10-01 00:00:00 | 2004-07-01 00:00:00 | 2004-06-01 00:00:00 | 2005-07-01 00:00:00 | 2005-01-01 00:00:00 | 2005-04-01 00:00:00 | 2006-01-01 00:00:00 | 2005-10-01 00:00:00 | 2006-04-01 00:00:00 | 2006-07-01 00:00:00 | 1900-01-01 00:00:00 | 2006-12-28 00:00:00 | 2006-10-01 00:00:00 | 1900-01-01 00:00:00 | 2007-01-01 00:00:00 | 2007-07-01 00:00:00 | 2007-10-01 00:00:00 | 2013-01-01 00:00:00 | 2013-04-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-05-15 00:00:00 | 2015-04-01 00:00:00 | 2014-04-01 00:00:00 | 2013-07-01 00:00:00 | 1900-01-01 00:00:00 | 2008-01-01 00:00:00 | 2007-04-01 00:00:00 | 2008-04-01 00:00:00 | 2008-07-01 00:00:00 | 2008-10-01 00:00:00 | 1900-01-01 00:00:00 | 2009-01-01 00:00:00 | 1900-01-01 00:00:00 | 2009-04-01 00:00:00 | 2009-05-20 00:00:00 | 2009-07-01 00:00:00 | 2009-10-01 00:00:00 | 2010-04-01 00:00:00 | 2010-01-01 00:00:00 | 2010-07-01 00:00:00 | 1900-01-01 00:00:00 | 2010-10-01 00:00:00 | 2011-07-01 00:00:00 | 2011-01-01 00:00:00 | 1900-01-01 00:00:00 | 2011-04-01 00:00:00 | 2011-10-01 00:00:00 | 2012-01-01 00:00:00 | 2012-04-01 00:00:00 | 2013-10-01 00:00:00 | 2014-10-01 00:00:00 | 2014-07-31 00:00:00 | 2012-10-01 00:00:00 | 2012-07-01 00:00:00 | 2014-01-01 00:00:00 | 1900-01-01 00:00:00 | 2015-07-01 00:00:00 | 2017-10-01 00:00:00 | 1900-01-01 00:00:00 | 2015-10-01 00:00:00 | 2016-01-01 00:00:00 | 2016-04-01 00:00:00 | 2016-07-01 00:00:00 | 2016-10-01 00:00:00 | 1900-01-01 00:00:00 | 2017-01-01 00:00:00 | 2016-12-21 00:00:00 | None | 2018-04-01 00:00:00 | 2017-04-01 00:00:00 | 2017-07-01 00:00:00 | 2018-01-01 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_end | 1997-12-31 00:00:00 | 1996-06-30 00:00:00 | 1998-03-31 00:00:00 | 1995-09-30 00:00:00 | 1997-03-31 00:00:00 | 1999-03-31 00:00:00 | 1999-06-30 00:00:00 | 1995-12-31 00:00:00 | 1996-09-30 00:00:00 | 1998-09-30 00:00:00 | 1998-09-30 00:00:00 | 1996-12-31 00:00:00 | 1998-12-31 00:00:00 | 1996-03-31 00:00:00 | 1998-06-30 00:00:00 | 1997-09-30 00:00:00 | 1995-03-31 00:00:00 | 1997-06-30 00:00:00 | 1998-12-31 00:00:00 | 1998-12-31 00:00:00 | 1995-06-30 00:00:00 | 1997-09-30 00:00:00 | 1999-09-30 00:00:00 | 1999-09-30 00:00:00 | 1999-12-31 00:00:00 | 2000-03-31 00:00:00 | 1999-12-31 00:00:00 | 1999-09-30 00:00:00 | 2000-09-30 00:00:00 | 2000-06-30 00:00:00 | 1900-01-01 00:00:00 | 2000-09-30 00:00:00 | 2000-12-31 00:00:00 | 2003-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-06-30 00:00:00 | 2001-09-30 00:00:00 | 2001-09-30 00:00:00 | 2001-12-31 00:00:00 | 2001-12-31 00:00:00 | 2002-03-31 00:00:00 | 2001-03-31 00:00:00 | 2002-06-30 00:00:00 | 2002-03-31 00:00:00 | 2001-03-31 00:00:00 | 2002-09-30 00:00:00 | 2002-09-30 00:00:00 | 2002-12-31 00:00:00 | 2002-12-31 00:00:00 | 1900-01-01 00:00:00 | 2003-03-31 00:00:00 | 2003-03-31 00:00:00 | 2003-06-30 00:00:00 | 2003-06-30 00:00:00 | 1900-01-01 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 | 1900-01-01 00:00:00 | 2004-12-21 00:00:00 | 2004-12-31 00:00:00 | 2004-12-31 00:00:00 | 2004-09-30 00:00:00 | 2004-09-01 00:00:00 | 2005-09-30 00:00:00 | 2005-03-31 00:00:00 | 2005-06-30 00:00:00 | 2006-03-31 00:00:00 | 2005-12-31 00:00:00 | 2006-06-30 00:00:00 | 2006-09-30 00:00:00 | 1900-01-01 00:00:00 | 2006-12-28 00:00:00 | 2006-12-31 00:00:00 | 1900-01-01 00:00:00 | 2007-03-31 00:00:00 | 2007-09-30 00:00:00 | 2007-12-31 00:00:00 | 2013-03-31 00:00:00 | 2013-06-30 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2015-03-30 00:00:00 | 2015-05-15 00:00:00 | 2015-06-30 00:00:00 | 2014-06-30 00:00:00 | 2013-09-30 00:00:00 | 1900-01-01 00:00:00 | 2008-03-31 00:00:00 | 2007-06-30 00:00:00 | 2008-06-30 00:00:00 | 2008-09-30 00:00:00 | 2008-12-31 00:00:00 | 1900-01-01 00:00:00 | 2009-03-31 00:00:00 | 1900-01-01 00:00:00 | 2009-06-30 00:00:00 | 2009-05-20 00:00:00 | 2009-09-30 00:00:00 | 2009-12-31 00:00:00 | 2010-06-30 00:00:00 | 2010-03-31 00:00:00 | 2010-09-30 00:00:00 | 1900-01-01 00:00:00 | 2010-12-31 00:00:00 | 2011-09-30 00:00:00 | 2011-03-31 00:00:00 | 1900-01-01 00:00:00 | 2011-06-30 00:00:00 | 2011-12-31 00:00:00 | 2012-03-31 00:00:00 | 2012-06-30 00:00:00 | 2013-12-31 00:00:00 | 2014-12-31 00:00:00 | 2014-09-30 00:00:00 | 2013-12-31 00:00:00 | 2012-09-30 00:00:00 | 2014-03-31 00:00:00 | 1900-01-01 00:00:00 | 2015-09-30 00:00:00 | 2017-12-31 00:00:00 | 1900-01-01 00:00:00 | 2015-12-31 00:00:00 | 2016-03-31 00:00:00 | 2016-06-30 00:00:00 | 2016-09-30 00:00:00 | 2016-12-31 00:00:00 | 1900-01-01 00:00:00 | 2017-03-31 00:00:00 | 2016-12-21 00:00:00 | None | 2018-06-30 00:00:00 | 2017-06-30 00:00:00 | 2017-09-30 00:00:00 | 2018-03-31 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_date | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | 22001 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 22001 | None | None | 22001 | None | 22001 | None | None | None | 22001 | 22001 | None | None | 22001 | None | None | 22001 | 22001 | None | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | None | None | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 |
filer_id | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_type | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | ||||||||||||||
active | T | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | T | Y | N | ||||||||||||||
race | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | 0 | None | None | ||||||||||||||
session_id | 1999 | 1995 | 1997 | 2001 | 2003 | 2005 | 2007 | 2013 | 2011 | 2009 | 2015 | 2017 | 2017 | 2019 | ||||||||||||||
category | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | 0 | None | None | ||||||||||||||
category_type | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | 0 | None | None | ||||||||||||||
sub_category | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | 0 | None | None | ||||||||||||||
effect_dt | 1999-01-01 00:00:00 | 1995-01-01 00:00:00 | 1997-01-01 00:00:00 | 2001-01-01 00:00:00 | 2003-01-01 00:00:00 | 2005-01-01 00:00:00 | 2007-01-01 00:00:00 | 2013-01-01 00:00:00 | 2011-01-01 00:00:00 | 2009-01-01 00:00:00 | 2015-01-01 00:00:00 | 2018-06-14 00:00:00 | 2017-01-01 00:00:00 | 2019-01-01 00:00:00 | ||||||||||||||
sub_category_type | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | 0 | None | None | ||||||||||||||
election_type | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | 0 | None | None | ||||||||||||||
sub_category_a | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
nyq_dt | None | None | None | None | None | 2000-07-01 00:00:00 | 2000-07-01 00:00:00 | None | None | 2000-07-01 00:00:00 | None | None | None | None | ||||||||||||||
party_cd | 0 | None | None | 0 | None | None | None | None | None | None | None | 0 | None | None | ||||||||||||||
county_cd | 0 | None | None | 0 | None | None | None | None | None | None | None | 0 | None | None | ||||||||||||||
district_cd | 0 | None | None | 0 | None | None | None | None | None | None | None | 0 | None | None |
filer_id | 1148241 | |
---|---|---|
xref_id | L22038 | |
effect_dt | 1999-12-08 00:00:00 | |
migration_source | MASTER |
xref_filer_id | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | L22038 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_id | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filer_type | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
status | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
effect_dt | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
naml | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | HOLMES-GEN | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
namf | BONNIE | BONNIE | BONNIE | BONNIE | BONNIE | BONNIE | BONNIE | BONNIE | BONNIE | BONNIE | BONNIE | BONNIE | BONNIE | BONNIE | BONNIE | BONNIE | BONNIE | BONNIE | BONNIE | BONNIE | BONNIE | BONNIE | BONNIE | BONNIE | BONNIE | BONNIE | BONNIE | BONNIE | BONNIE | BONNIE | BONNIE | BONNIE | BONNIE | BONNIE | BONNIE | BONNIE | BONNIE | BONNIE | BONNIE | BONNIE | BONNIE | BONNIE | BONNIE | BONNIE | BONNIE | BONNIE | BONNIE | BONNIE | BONNIE | BONNIE | BONNIE | BONNIE | BONNIE | BONNIE | BONNIE | BONNIE | BONNIE | BONNIE | BONNIE | BONNIE | BONNIE R. | BONNIE R. | BONNIE R. | BONNIE R. | BONNIE R. | BONNIE R. | BONNIE R. | BONNIE R. | BONNIE R. | BONNIE R. | BONNIE R. | BONNIE R. | BONNIE R. | BONNIE R. | BONNIE R. | BONNIE R. | BONNIE R. | BONNIE R. | BONNIE R. | BONNIE R. | BONNIE R. | BONNIE R. | BONNIE R. | BONNIE R. | BONNIE | BONNIE | BONNIE | BONNIE | BONNIE | BONNIE | BONNIE | BONNIE | BONNIE | BONNIE | BONNIE | BONNIE | BONNIE | BONNIE | BONNIE | BONNIE | BONNIE | BONNIE | BONNIE | BONNIE | BONNIE | BONNIE | BONNIE | BONNIE | BONNIE R. | BONNIE R. | BONNIE R. | BONNIE R. | BONNIE R. | BONNIE R. | BONNIE R. | BONNIE R. | BONNIE R. | BONNIE R. | BONNIE R. | BONNIE R. | BONNIE R. | BONNIE R. | BONNIE R. | BONNIE R. | BONNIE R. | BONNIE R. | BONNIE R. | BONNIE R. | BONNIE R. | BONNIE R. | BONNIE R. | BONNIE R. | BONNIE | BONNIE | BONNIE | BONNIE | BONNIE | BONNIE | BONNIE | BONNIE | BONNIE | BONNIE | BONNIE | BONNIE | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
namt | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
nams | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
adr1 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
adr2 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
city | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
st | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
zip4 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
phon | 9165571100 | 9165571100 | 9165571100 | 9164424446 | 9164424446 | 9164424446 | 9164424446 | 9165545864 | 9165545864 | 9165545864 | 9165545864 | 9165545864 | 9165571100 | 9165571100 | 9165571100 | 9164424446 | 9164424446 | 9164424446 | 9164424446 | 9165545864 | 9165545864 | 9165545864 | 9165545864 | 9165545864 | 9165571100 | 9165571100 | 9165571100 | 9164424446 | 9164424446 | 9164424446 | 9164424446 | 9165545864 | 9165545864 | 9165545864 | 9165545864 | 9165545864 | 9165571100 | 9165571100 | 9165571100 | 9164424446 | 9164424446 | 9164424446 | 9164424446 | 9165545864 | 9165545864 | 9165545864 | 9165545864 | 9165545864 | 9165571100 | 9165571100 | 9165571100 | 9164424446 | 9164424446 | 9164424446 | 9164424446 | 9165545864 | 9165545864 | 9165545864 | 9165545864 | 9165545864 | 9165571100 | 9165571100 | 9165571100 | 9164424446 | 9164424446 | 9164424446 | 9164424446 | 9165545864 | 9165545864 | 9165545864 | 9165545864 | 9165545864 | 9165571100 | 9165571100 | 9165571100 | 9164424446 | 9164424446 | 9164424446 | 9164424446 | 9165545864 | 9165545864 | 9165545864 | 9165545864 | 9165545864 | 9165571100 | 9165571100 | 9165571100 | 9164424446 | 9164424446 | 9164424446 | 9164424446 | 9165545864 | 9165545864 | 9165545864 | 9165545864 | 9165545864 | 9165571100 | 9165571100 | 9165571100 | 9164424446 | 9164424446 | 9164424446 | 9164424446 | 9165545864 | 9165545864 | 9165545864 | 9165545864 | 9165545864 | 9165571100 | 9165571100 | 9165571100 | 9164424446 | 9164424446 | 9164424446 | 9164424446 | 9165545864 | 9165545864 | 9165545864 | 9165545864 | 9165545864 | 9165571100 | 9165571100 | 9165571100 | 9164424446 | 9164424446 | 9164424446 | 9164424446 | 9165545864 | 9165545864 | 9165545864 | 9165545864 | 9165545864 | 9165571100 | 9165571100 | 9165571100 | 9164424446 | 9164424446 | 9164424446 | 9164424446 | 9165545864 | 9165545864 | 9165545864 | 9165545864 | 9165545864 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fax | None | None | None | 9164428585 | 9164428585 | 9164428585 | 9164428585 | 9164428585 | 9164428585 | None | None | None | 9164428585 | 9164428585 | 9164428585 | 9164428585 | 9164428585 | 9164428585 | None | None | None | 9164428585 | 9164428585 | 9164428585 | 9164428585 | 9164428585 | 9164428585 | None | None | None | 9164428585 | 9164428585 | 9164428585 | 9164428585 | 9164428585 | 9164428585 | None | None | None | 9164428585 | 9164428585 | 9164428585 | 9164428585 | 9164428585 | 9164428585 | None | None | None | 9164428585 | 9164428585 | 9164428585 | 9164428585 | 9164428585 | 9164428585 | None | None | None | 9164428585 | 9164428585 | 9164428585 | 9164428585 | 9164428585 | 9164428585 | None | None | None | 9164428585 | 9164428585 | 9164428585 | 9164428585 | 9164428585 | 9164428585 | None | None | None | 9164428585 | 9164428585 | 9164428585 | 9164428585 | 9164428585 | 9164428585 | None | None | None | 9164428585 | 9164428585 | 9164428585 | 9164428585 | 9164428585 | 9164428585 | None | None | None | 9164428585 | 9164428585 | 9164428585 | 9164428585 | 9164428585 | 9164428585 | None | None | None | 9164428585 | 9164428585 | 9164428585 | 9164428585 | 9164428585 | 9164428585 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
None | None | None | [email protected] | None | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | None | None | [email protected] | None | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | None | None | [email protected] | None | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | None | None | [email protected] | None | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | None | None | [email protected] | None | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | None | None | [email protected] | None | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | None | None | [email protected] | None | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | None | None | [email protected] | None | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | None | None | [email protected] | None | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | None | None | [email protected] | None | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | None | None | [email protected] | None | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | None | None | [email protected] | None | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None |
filer_id | 1148241 |
---|
filer_id | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | |||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
change_no | 1 | 2 | 3 | 4 | 5 | 6 | 7 | |||||||
session_id | 2003 | 2009 | 2013 | 2015 | 2017 | 2017 | 2017 | |||||||
log_dt | 2003-06-17 00:00:00 | 2009-11-13 00:00:00 | 2014-04-02 00:00:00 | 2015-05-26 00:00:00 | 2018-06-21 00:00:00 | 2018-06-21 00:00:00 | 2018-06-21 00:00:00 | |||||||
filer_type | 4 | 4 | 4 | 4 | 4 | 4 | 4 | |||||||
correction_flg | None | Y | None | Y | Y | None | None | |||||||
action | None | ADDED | SET ACTIVE | ADDED | TERMINATED | TERMINATED | TERMINATED | |||||||
attribute_changed | ETHICS DATE | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | |||||||||
ethics_dt | 2002-11-13 00:00:00 | None | None | None | None | None | None | |||||||
interests | None | None | None | None | None | None | None | |||||||
filer_full_name | HOLMES-GEN, BONNIE | HOLMES-GEN, BONNIE R. | BONNIE HOLMES-GEN | HOLMES-GEN, BONNIE | HOLMES-GEN, BONNIE | HOLMES-GEN, BONNIE | HOLMES-GEN, BONNIE | |||||||
filer_city | None | None | None | SACRAMENTO | None | None | None | |||||||
filer_st | None | None | None | CA | None | None | None | |||||||
filer_zip | None | None | None | 95814 | None | None | None | |||||||
filer_phone | None | None | None | 9165571100 | None | None | None | |||||||
entity_type | 4 | 2 | 2 | 2 | 2 | 4 | 4 | |||||||
entity_name | None | AMERICAN LUNG ASSOCIATION OF CALIFORNIA | AMERICAN LUNG ASSOCIATION IN CALIFORNIA | AMERICAN LUNG ASSOCIATION IN CALIFORNIA | AMERICAN LUNG ASSOCIATION DBA AMERICAN LUNG ASSOCIATION IN CALIFORNIA | None | None | |||||||
entity_city | None | None | None | None | None | None | None | |||||||
entity_st | None | None | None | None | None | None | None | |||||||
entity_zip | None | None | None | None | None | None | None | |||||||
entity_phone | None | None | None | None | None | None | None | |||||||
entity_id | 0 | 1146906 | 1146906 | None | 1146906 | 0 | 0 | |||||||
responsible_officer | None | None | None | None | None | None | None | |||||||
effect_dt | 2002-11-13 00:00:00 | 2009-01-01 00:00:00 | 2013-01-01 00:00:00 | 2015-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017-01-02 00:00:00 | 2018-06-14 00:00:00 |
filer_id | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | 1148241 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_file_name | 681968_0.cal | 725182_0.cal | 747926_0.cal | 769497_0.cal | 792933_0.cal | 808668_0.cal | 837323_0.cal | 889574_0.cal | 917782_0.cal | 930280_0.cal | 946825_0.cal | 970929_0.cal | 986263_0.cal | 1011248_0.cal | 1026431_0.cal | 1057367_0.cal | 1075304_0.cal | 1103300_0.cal | 1113329_0.cal | 1132532_0.cal | 1148124_0.cal | 1168083_0.cal | 1192556_0.cal | 1328480_0.cal | 1504919_0.cal | 1391798_0.cal | 1346271_0.cal | 1216800_0.cal | 1250141_0.cal | 1225041_0.cal | 1481394_0.cal | 1261934_0.cal | 1424319_0.cal | 1449071_0.cal | 1460571_0.cal | 1420893_0.cal | 1437989_0.cal | 1286525_0.cal | 1294713_0.cal | 1382155_0.cal | 1307021_0.cal | 1845951_0.cal | 1738750_0.cal | 1675684_0.cal | 1782279_0.cal | 1800937_0.cal | 1534643_0.cal | 1588729_0.cal | 1570294_0.cal | 1818397_0.cal | 1605405_0.cal | 1622018_0.cal | 1765257_0.cal | 1636708_0.cal | 1707876_0.cal | 1656755_0.cal | 1871350_0.cal | 298973.cal | 1977129_0.cal | 1966193_0.cal | 2122035_0.cal | 2153583_0.cal | 2055373_0.cal | 2008592_0.cal | 1995420_0.cal | 2112849_0.cal | 2093168_0.cal | 1913451_0.cal | 2031328_0.cal | 1934589_0.cal | 2167391_0.cal | 2205005_0.cal | 2267066_0.cal | 2191897_0.cal | 2236843_0.cal | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
received_date | 2000-10-31 00:00:00 | 2001-02-13 00:00:00 | 2001-05-03 00:00:00 | 2001-07-24 00:00:00 | 2001-11-01 00:00:00 | 2002-01-22 00:00:00 | 2002-04-25 00:00:00 | 2002-11-05 00:00:00 | 2003-02-10 00:00:00 | 2003-04-29 00:00:00 | 2003-07-30 00:00:00 | 2003-11-07 00:00:00 | 2004-01-26 00:00:00 | 2004-04-26 00:00:00 | 2004-07-27 00:00:00 | 2004-10-29 00:00:00 | 2005-01-25 00:00:00 | 2005-04-27 00:00:00 | 2005-07-21 00:00:00 | 2005-10-28 00:00:00 | 2006-01-31 00:00:00 | 2006-05-01 00:00:00 | 2006-07-31 00:00:00 | 2008-04-29 00:00:00 | 2010-07-29 00:00:00 | 2009-01-26 00:00:00 | 2008-07-25 00:00:00 | 2006-10-31 00:00:00 | 2007-03-02 00:00:00 | 2006-12-28 00:00:00 | 2010-04-22 00:00:00 | 2007-04-30 00:00:00 | 2009-05-20 00:00:00 | 2009-10-22 00:00:00 | 2010-01-26 00:00:00 | 2009-04-30 00:00:00 | 2009-07-31 00:00:00 | 2007-08-02 00:00:00 | 2007-10-25 00:00:00 | 2008-11-24 00:00:00 | 2008-01-28 00:00:00 | 2014-04-30 00:00:00 | 2013-01-31 00:00:00 | 2012-07-27 00:00:00 | 2013-07-31 00:00:00 | 2013-10-31 00:00:00 | 2010-10-25 00:00:00 | 2011-04-27 00:00:00 | 2011-01-31 00:00:00 | 2014-01-31 00:00:00 | 2011-07-28 00:00:00 | 2011-10-31 00:00:00 | 2013-04-30 00:00:00 | 2012-01-31 00:00:00 | 2012-10-30 00:00:00 | 2012-04-30 00:00:00 | 2014-07-31 00:00:00 | 2014-07-31 00:00:00 | 2015-07-24 00:00:00 | 2015-04-30 00:00:00 | 2017-01-23 00:00:00 | 2017-04-26 00:00:00 | 2016-07-14 00:00:00 | 2016-01-28 00:00:00 | 2015-10-28 00:00:00 | 2016-12-21 00:00:00 | 2016-10-21 00:00:00 | 2014-11-03 00:00:00 | 2016-04-22 00:00:00 | 2015-01-30 00:00:00 | 2017-07-14 00:00:00 | 2018-01-24 00:00:00 | 2018-07-20 00:00:00 | 2017-10-30 00:00:00 | 2018-04-26 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_directory | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/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/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_id | 681968 | 725182 | 747926 | 769497 | 792933 | 808668 | 837323 | 889574 | 917782 | 930280 | 946825 | 970929 | 986263 | 1011248 | 1026431 | 1057367 | 1075304 | 1103300 | 1113329 | 1132532 | 1148124 | 1168083 | 1192556 | 1328480 | 1504919 | 1391798 | 1346271 | 1216800 | 1250141 | 1225041 | 1481394 | 1261934 | 1424319 | 1449071 | 1460571 | 1420893 | 1437989 | 1286525 | 1294713 | 1382155 | 1307021 | 1845951 | 1738750 | 1675684 | 1782279 | 1800937 | 1534643 | 1588729 | 1570294 | 1818397 | 1605405 | 1622018 | 1765257 | 1636708 | 1707876 | 1656755 | 1871350 | None | 1977129 | 1966193 | 2122035 | 2153583 | 2055373 | 2008592 | 1995420 | 2112849 | 2093168 | 1913451 | 2031328 | 1934589 | 2167391 | 2205005 | 2267066 | 2191897 | 2236843 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | None | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
receive_comment | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing passed validation, but failed DB constraints | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted |