filer_id | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
adrid | 1105517 | 2040862 | 2079364 | 2113232 | 2160038 | 2203553 | 2410101 | 2280627 | 2466553 | 2338828 | ||||||||||
effect_dt | 1999-01-01 00:00:00 | 2003-01-01 00:00:00 | 2005-01-01 00:00:00 | 2007-01-01 00:00:00 | 2009-01-01 00:00:00 | 2011-01-01 00:00:00 | 2017-01-01 00:00:00 | 2013-01-01 00:00:00 | 2019-01-01 00:00:00 | 2015-01-01 00:00:00 | ||||||||||
add_type | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | ||||||||||
session_id | 1999 | 2003 | 2005 | 2007 | 2009 | 2011 | 2017 | 2013 | 2019 | 2015 |
filer_id | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
session_id | 2001 | 1999 | 1997 | 2003 | 2007 | 2005 | 2009 | 2011 | 2013 | 2015 | 2017 | 2019 | ||||||||||||
ethics_date | 2001-01-25 00:00:00 | 1998-05-01 00:00:00 | 1998-05-01 00:00:00 | 2003-02-07 00:00:00 | 2007-04-19 00:00:00 | 2005-02-09 00:00:00 | 2009-01-16 00:00:00 | 2011-02-24 00:00:00 | 2013-01-24 00:00:00 | 2015-01-22 00:00:00 | 2017-02-02 00:00:00 | 2019-05-23 00:00:00 |
filer_id | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 515420 | 527638 | 529609 | 518555 | 523492 | 525584 | 512291 | 633896 | 620512 | 662805 | 650660 | 703575 | 741629 | 703575 | 732095 | 732426 | 758498 | 778760 | 797806 | 824505 | 864645 | 843346 | 893716 | 895727 | 896138 | 922278 | 912371 | 936631 | 950677 | 975222 | 1017093 | 1028852 | 997039 | 1070724 | 1069466 | 1067744 | 1094904 | 1083822 | 1105718 | 1109448 | 1112379 | 1134586 | 1145603 | 1161351 | 1185162 | 1229209 | 1216197 | 1223812 | 1231188 | 1285273 | 1265521 | 1293126 | 1303735 | 1262432 | 1780067 | 1964974 | 1975756 | 1846004 | 1800886 | 1926150 | 1933661 | 1909908 | 1325614 | 1343174 | 1365352 | 1392163 | 1381957 | 1404918 | 1404946 | 1419443 | 1448385 | 1461954 | 1434258 | 1481012 | 1506428 | 1532244 | 1550844 | 1570896 | 1601588 | 1550304 | 1619756 | 1578898 | 1589367 | 1635669 | 1656081 | 1818088 | 1680084 | 1931004 | 1920043 | 1707363 | 1872351 | 1724286 | 1721362 | 1724286 | 1736809 | 1818088 | 1752692 | 1763194 | 1996380 | 2411748 | 2392782 | 2319777 | 2340164 | 2269919 | 2010339 | 2031281 | 2060469 | 2098133 | 2121496 | 2127323 | 2115368 | 2155766 | 2133310 | 2115368 | 2172075 | 2221359 | 2379295 | 2418020 | 2379295 | 2192167 | 2385598 | 2348462 | 2233853 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
period_id | 158 | 155 | 156 | 159 | 153 | 154 | 157 | None | 160 | 162 | 161 | None | 164 | None | 163 | 161 | 165 | None | None | None | None | None | None | None | None | None | None | None | 174 | None | None | 178 | None | None | None | None | None | 181 | 181 | None | 182 | 183 | 184 | 185 | 186 | None | 187 | 188 | 188 | 190 | None | 191 | 192 | 189 | 214 | 221 | 222 | 217 | 215 | None | None | 219 | 193 | 194 | 195 | 196 | 196 | None | None | 197 | 199 | 200 | 198 | 201 | 202 | 203 | None | 204 | 206 | 204 | 207 | None | 205 | 208 | 209 | 220 | 210 | 220 | 220 | 211 | 218 | 213 | None | 213 | 212 | 216 | None | 213 | 223 | None | 238 | 235 | None | 234 | 224 | 225 | 226 | 227 | None | 228 | 229 | 229 | None | 228 | 230 | 232 | 237 | 239 | 237 | 231 | None | 236 | 233 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F604 | F615 | F690 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F604 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F604 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F604 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F604 | F615 | F615 | F615 | F615 | F615 | F604 | F604 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F604 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F604 | F604 | F604 | F615 | F615 | F604 | F615 | F615 | F606 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F604 | F615 | F604 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_sequence | 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 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_date | 1999-08-02 00:00:00 | 1998-10-31 00:00:00 | 1999-01-29 00:00:00 | 1999-11-01 00:00:00 | 1998-04-30 00:00:00 | 1998-07-31 00:00:00 | 1999-04-30 00:00:00 | 2000-05-02 00:00:00 | 2000-02-03 00:00:00 | 2000-07-28 00:00:00 | 2000-08-09 00:00:00 | 2000-12-28 00:00:00 | 2001-02-23 00:00:00 | 2001-01-25 00:00:00 | 2001-02-23 00:00:00 | 2001-01-08 00:00:00 | 2001-04-30 00:00:00 | 2001-07-25 00:00:00 | 2001-10-22 00:00:00 | 2002-01-28 00:00:00 | 2002-07-30 00:00:00 | 2002-04-30 00:00:00 | 2002-10-31 00:00:00 | 2002-12-02 00:00:00 | 2002-12-02 00:00:00 | 2003-02-07 00:00:00 | 2003-01-28 00:00:00 | 2003-04-30 00:00:00 | 2003-07-31 00:00:00 | 2003-10-23 00:00:00 | 2004-04-30 00:00:00 | 2004-07-28 00:00:00 | 2004-01-27 00:00:00 | 2004-12-22 00:00:00 | 2004-11-01 00:00:00 | 2004-10-29 00:00:00 | 2005-01-31 00:00:00 | 2005-02-03 00:00:00 | 2005-05-02 00:00:00 | 2005-06-07 00:00:00 | 2005-07-18 00:00:00 | 2005-11-01 00:00:00 | 2006-01-27 00:00:00 | 2006-04-10 00:00:00 | 2006-07-19 00:00:00 | 2006-12-20 00:00:00 | 2006-10-31 00:00:00 | 2006-12-19 00:00:00 | 2007-01-24 00:00:00 | 2007-07-31 00:00:00 | 2007-04-19 00:00:00 | 2007-10-15 00:00:00 | 2008-01-15 00:00:00 | 2007-04-30 00:00:00 | 2013-07-29 00:00:00 | 2015-04-30 00:00:00 | 2015-07-21 00:00:00 | 2014-04-30 00:00:00 | 2013-10-31 00:00:00 | 2014-12-22 00:00:00 | 2015-01-22 00:00:00 | 2014-10-30 00:00:00 | 2008-04-21 00:00:00 | 2008-07-14 00:00:00 | 2008-10-10 00:00:00 | 2009-01-26 00:00:00 | 2008-11-20 00:00:00 | 2008-11-25 00:00:00 | 2009-01-16 00:00:00 | 2009-04-28 00:00:00 | 2009-10-20 00:00:00 | 2010-01-28 00:00:00 | 2009-07-28 00:00:00 | 2010-04-21 00:00:00 | 2010-07-30 00:00:00 | 2010-10-22 00:00:00 | 2010-12-14 00:00:00 | 2011-01-31 00:00:00 | 2011-07-20 00:00:00 | 2010-12-13 00:00:00 | 2011-10-26 00:00:00 | 2011-02-24 00:00:00 | 2011-04-28 00:00:00 | 2012-01-31 00:00:00 | 2012-04-27 00:00:00 | 2014-01-31 00:00:00 | 2012-07-31 00:00:00 | 2015-01-27 00:00:00 | 2014-12-22 00:00:00 | 2012-10-30 00:00:00 | 2014-07-31 00:00:00 | 2013-01-30 00:00:00 | 2012-12-26 00:00:00 | 2013-01-11 00:00:00 | 2013-01-30 00:00:00 | 2014-03-28 00:00:00 | 2013-02-05 00:00:00 | 2013-04-29 00:00:00 | 2015-10-29 00:00:00 | 2019-10-04 00:00:00 | 2019-07-24 00:00:00 | 2018-10-31 00:00:00 | 2019-01-07 00:00:00 | 2018-07-26 00:00:00 | 2016-01-29 00:00:00 | 2016-04-22 00:00:00 | 2016-07-28 00:00:00 | 2016-10-27 00:00:00 | 2016-12-22 00:00:00 | 2017-01-30 00:00:00 | 2017-03-24 00:00:00 | 2017-04-28 00:00:00 | 2017-02-02 00:00:00 | 2016-12-29 00:00:00 | 2017-07-26 00:00:00 | 2018-03-12 00:00:00 | 2019-04-30 00:00:00 | 2019-10-30 00:00:00 | 2019-04-29 00:00:00 | 2017-10-30 00:00:00 | 2019-05-28 00:00:00 | 2019-01-31 00:00:00 | 2018-04-23 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_type | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10005 | 10005 | 10001 | 10005 | 10005 | 10006 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10006 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10006 | 10005 | 10005 | 10001 | 10001 | 10006 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10006 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10006 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10006 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10006 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10005 | 10001 | 10001 | 10002 | 10006 | 10001 | 10001 | 10005 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10002 | 10001 | 10006 | 10001 | 10001 | 10001 | 10002 | 10001 | 10001 | 10001 | 10006 | 10001 | 10001 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_status | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
session_id | 1999 | 1997 | 1997 | 1999 | 1997 | 1997 | 1999 | 1999 | 1999 | 1999 | 1999 | 2001 | 1999 | 2001 | 1999 | 1999 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2003 | 2003 | 2001 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2005 | 2005 | 2003 | 2003 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2007 | 2005 | 2007 | 2005 | 2007 | 2007 | 2007 | 2007 | 2007 | 2013 | 2015 | 2015 | 2013 | 2013 | 2015 | 2015 | 2013 | 2007 | 2007 | 2007 | 2007 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2011 | 2009 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2013 | 2011 | 2013 | 2015 | 2011 | 2013 | 2013 | 2013 | 2013 | 2011 | 2013 | 2013 | 2013 | 2015 | 2019 | 2019 | 2017 | 2019 | 2017 | 2015 | 2015 | 2015 | 2015 | 2017 | 2015 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2019 | 2019 | 2019 | 2017 | 2019 | 2017 | 2017 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
user_id | * | * | * | * | * | * | * | DHORRELL | * | YBONILLA | * | GKURIMOT | YBONILLA | BSMITH | DHORRELL | YBONILLA | JBRANNAN | LTHIBAUL | LTHIBAUL | DPASTRAN | DBARRICK | LTHIBAUL | LTHIBAUL | CFLAGG | PBANFORD | GGILMORE | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | DMCCASTL | EMCENTEE | LTHIBAUL | LTHIBAUL | COMPLETED | LTHIBAUL | SARRIAGA | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | SARRIAGA | LTHIBAUL | * | LTHIBAUL | LTHIBAUL | SARRIAGA | LTHIBAUL | LTHIBAUL | LTHIBAUL | ASAETERN | AGLADNEY | JINGRAM | AGLADNEY | ASAETERN | GPEREZ | ASAETERN | AGLADNEY | LTHIBAUL | LTHIBAUL | JINGRAM | JINGRAM | * | YRODRIGU | YRODRIGU | MGUERRA | MGUERRA | MGUERRA | MGUERRA | JINGRAM | ASAETERN | ASAETERN | GKURIMOT | AGLADNEY | ASAETERN | YRODRIGU | JINGRAM | YRODRIGU | JINGRAM | ASAETERN | ASAETERN | AGLADNEY | AGLADNEY | AGLADNEY | GPEREZ | ASAETERN | AGLADNEY | YRODRIGU | GKURIMOT | GKURIMOT | ASAETERN | AGLADNEY | YRODRIGU | ASAETERN | JINGRAM | GPEREZ | GTAYLOR | AGLADNEY | GPEREZ | JFRONEFIELD | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | GPEREZ | AGLADNEY | GPEREZ | JINGRAM | KBANH | KBANH | SMCCONNAN | AGLADNEY | VUKSTINA | CAFILER | GTAYLOR | AGLADNEY | SUSHAKOV | JFRONEFIELD | AGLADNEY | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
special_audit | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 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 | 11003 | 11003 | 11003 | 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 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_start | 1999-04-01 00:00:00 | 1998-07-01 00:00:00 | 1998-10-01 00:00:00 | 1999-07-01 00:00:00 | 1998-01-01 00:00:00 | 1998-04-01 00:00:00 | 1999-01-01 00:00:00 | 2000-01-01 00:00:00 | 1999-10-01 00:00:00 | 2000-04-01 00:00:00 | 2000-01-01 00:00:00 | 1900-01-01 00:00:00 | 2000-10-01 00:00:00 | 1900-01-01 00:00:00 | 2000-07-01 00:00:00 | 2000-01-01 00:00:00 | 2001-01-01 00:00:00 | 2001-04-01 00:00:00 | 2001-07-01 00:00:00 | 2001-10-01 00:00:00 | 2002-04-01 00:00:00 | 2002-01-01 00:00:00 | 2002-07-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | None | 2002-10-01 00:00:00 | 2003-01-01 00:00:00 | 2003-04-01 00:00:00 | 2003-07-01 00:00:00 | 2004-01-01 00:00:00 | 2004-04-01 00:00:00 | 2003-10-01 00:00:00 | 1900-01-01 00:00:00 | 2004-07-01 00:00:00 | 2004-07-01 00:00:00 | 2004-10-01 00:00:00 | 2005-02-03 00:00:00 | 2005-01-01 00:00:00 | 1900-01-01 00:00:00 | 2005-04-01 00:00:00 | 2005-07-01 00:00:00 | 2005-10-01 00:00:00 | 2006-01-01 00:00:00 | 2006-04-01 00:00:00 | 1900-01-01 00:00:00 | 2006-07-01 00:00:00 | 2006-12-19 00:00:00 | 2006-10-01 00:00:00 | 2007-04-01 00:00:00 | 1900-01-01 00:00:00 | 2007-07-01 00:00:00 | 2007-10-01 00:00:00 | 2007-01-01 00:00:00 | 2013-04-01 00:00:00 | 2015-01-01 00:00:00 | 2015-04-01 00:00:00 | 2014-01-01 00:00:00 | 2013-07-01 00:00:00 | 1900-01-01 00:00:00 | None | 2014-07-01 00:00:00 | 2008-01-01 00:00:00 | 2008-04-01 00:00:00 | 2008-07-01 00:00:00 | 2008-10-01 00:00:00 | 2008-11-20 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2009-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 | 1900-01-01 00:00:00 | 2010-10-01 00:00:00 | 2011-04-01 00:00:00 | 2010-12-13 00:00:00 | 2011-07-01 00:00:00 | 1900-01-01 00:00:00 | 2011-01-01 00:00:00 | 2011-10-01 00:00:00 | 2012-01-01 00:00:00 | 2014-10-01 00:00:00 | 2012-04-01 00:00:00 | 2014-10-01 00:00:00 | 2014-12-22 00:00:00 | 2012-07-01 00:00:00 | 2014-04-01 00:00:00 | 2013-01-30 00:00:00 | 1900-01-01 00:00:00 | 2013-01-11 00:00:00 | 2012-10-01 00:00:00 | 2013-10-01 00:00:00 | 1900-01-01 00:00:00 | 2013-01-01 00:00:00 | 2015-07-01 00:00:00 | 1900-01-01 00:00:00 | 2019-04-01 00:00:00 | 2018-07-01 00:00:00 | 1900-01-01 00:00:00 | 2018-04-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 | 1900-01-01 00:00:00 | 2016-10-01 00:00:00 | 2017-03-24 00:00:00 | 2017-01-01 00:00:00 | None | 2016-12-29 00:00:00 | 2017-04-01 00:00:00 | 2017-10-01 00:00:00 | 2019-01-01 00:00:00 | 2019-07-01 00:00:00 | 2019-01-01 00:00:00 | 2017-07-01 00:00:00 | 1900-01-01 00:00:00 | 2018-10-01 00:00:00 | 2018-01-01 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_end | 1999-06-30 00:00:00 | 1998-09-30 00:00:00 | 1998-12-31 00:00:00 | 1999-09-30 00:00:00 | 1998-03-31 00:00:00 | 1998-06-30 00:00:00 | 1999-03-31 00:00:00 | 2000-03-31 00:00:00 | 1999-12-31 00:00:00 | 2000-06-30 00:00:00 | 2000-03-31 00:00:00 | 1900-01-01 00:00:00 | 2000-12-31 00:00:00 | 1900-01-01 00:00:00 | 2000-09-30 00:00:00 | 2000-03-31 00:00:00 | 2001-03-31 00:00:00 | 2001-06-30 00:00:00 | 2001-09-30 00:00:00 | 2001-12-31 00:00:00 | 2002-06-30 00:00:00 | 2002-03-31 00:00:00 | 2002-09-30 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | None | 2002-12-31 00:00:00 | 2003-03-31 00:00:00 | 2003-06-30 00:00:00 | 2003-09-30 00:00:00 | 2004-03-31 00:00:00 | 2004-06-30 00:00:00 | 2003-12-31 00:00:00 | 1900-01-01 00:00:00 | 2004-09-30 00:00:00 | 2004-09-30 00:00:00 | 2004-12-31 00:00:00 | 2005-02-03 00:00:00 | 2005-03-31 00:00:00 | 1900-01-01 00:00:00 | 2005-06-30 00:00:00 | 2005-09-30 00:00:00 | 2005-12-31 00:00:00 | 2006-03-31 00:00:00 | 2006-06-30 00:00:00 | 1900-01-01 00:00:00 | 2006-09-30 00:00:00 | 2006-12-19 00:00:00 | 2006-12-31 00:00:00 | 2007-06-30 00:00:00 | 1900-01-01 00:00:00 | 2007-09-30 00:00:00 | 2007-12-31 00:00:00 | 2007-03-31 00:00:00 | 2013-06-30 00:00:00 | 2015-03-31 00:00:00 | 2015-06-30 00:00:00 | 2014-03-31 00:00:00 | 2013-09-30 00:00:00 | 1900-01-01 00:00:00 | None | 2014-09-30 00:00:00 | 2008-03-31 00:00:00 | 2008-06-30 00:00:00 | 2008-09-30 00:00:00 | 2008-12-31 00:00:00 | 2008-11-20 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2009-03-31 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 | 1900-01-01 00:00:00 | 2010-12-31 00:00:00 | 2011-06-30 00:00:00 | 2010-12-13 00:00:00 | 2011-09-30 00:00:00 | 1900-01-01 00:00:00 | 2011-03-31 00:00:00 | 2011-12-31 00:00:00 | 2012-03-31 00:00:00 | 2014-12-31 00:00:00 | 2012-06-30 00:00:00 | 2014-12-31 00:00:00 | 2014-12-22 00:00:00 | 2012-09-30 00:00:00 | 2014-06-30 00:00:00 | 2013-01-30 00:00:00 | 1900-01-01 00:00:00 | 2013-01-11 00:00:00 | 2012-12-31 00:00:00 | 2013-12-31 00:00:00 | 1900-01-01 00:00:00 | 2013-03-31 00:00:00 | 2015-09-30 00:00:00 | 1900-01-01 00:00:00 | 2019-06-30 00:00:00 | 2018-09-30 00:00:00 | 1900-01-01 00:00:00 | 2018-06-30 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 | 1900-01-01 00:00:00 | 2016-12-31 00:00:00 | 2017-03-24 00:00:00 | 2017-03-31 00:00:00 | None | 2016-12-29 00:00:00 | 2017-06-30 00:00:00 | 2017-12-31 00:00:00 | 2019-03-31 00:00:00 | 2019-09-30 00:00:00 | 2020-12-31 00:00:00 | 2017-09-30 00:00:00 | 1900-01-01 00:00:00 | 2018-12-31 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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_type | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 22001 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | None | 22006 | 22006 | None | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 |
filer_id | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_type | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | |||||||||||||
active | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | T | |||||||||||||
race | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | |||||||||||||
session_id | 2001 | 1999 | 1997 | 2003 | 2005 | 2007 | 2011 | 2013 | 2009 | 2015 | 2017 | 2019 | 2019 | |||||||||||||
category | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | |||||||||||||
category_type | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | |||||||||||||
sub_category | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | |||||||||||||
effect_dt | 2001-01-01 00:00:00 | 1999-01-01 00:00:00 | 1998-03-02 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 | 2017-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-09-30 00:00:00 | |||||||||||||
sub_category_type | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | |||||||||||||
election_type | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | |||||||||||||
sub_category_a | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||
nyq_dt | None | None | None | None | 2000-01-01 00:00:00 | 2000-01-01 00:00:00 | None | None | None | None | None | None | None | |||||||||||||
party_cd | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||
county_cd | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||
district_cd | None | None | None | None | None | None | None | None | None | None | None | None | None |
filer_id | 1149387 | |
---|---|---|
xref_id | L25602 | |
effect_dt | 1999-12-08 00:00:00 | |
migration_source | MASTER |
xref_filer_id | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | L25602 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_id | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filer_type | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
status | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
effect_dt | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
naml | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | CARRIGG | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
namf | DANIEL | DANIEL | DANIEL | DANIEL | DANIEL | DANIEL | DANIEL | DANIEL | DANIEL | DANIEL | DANIEL | DANIEL | DANIEL | DANIEL | DANIEL | DANIEL | DANIEL | DANIEL | DANIEL | DANIEL | DANIEL | DANIEL | DANIEL | DANIEL | DANIEL | DANIEL | DANIEL | DANIEL | DANIEL | DANIEL | DANIEL J. | DANIEL J. | DANIEL J. | DANIEL J. | DANIEL J. | DANIEL J. | DANIEL J. | DANIEL J. | DANIEL J. | DANIEL J. | DANIEL J. | DANIEL J. | DANIEL J. | DANIEL J. | DANIEL J. | DANIEL J. | DANIEL J. | DANIEL J. | DANIEL J. | DANIEL J. | DANIEL J. | DANIEL J. | DANIEL J. | DANIEL J. | DANIEL J. | DANIEL J. | DANIEL J. | DANIEL J. | DANIEL J. | DANIEL J. | DANIEL | DANIEL | DANIEL | DANIEL | DANIEL | DANIEL | DANIEL | DANIEL | DANIEL | DANIEL | DANIEL | DANIEL | DANIEL | DANIEL | DANIEL | DANIEL | DANIEL | DANIEL | DANIEL | DANIEL | DANIEL J. | DANIEL J. | DANIEL J. | DANIEL J. | DANIEL J. | DANIEL J. | DANIEL J. | DANIEL J. | DANIEL J. | DANIEL J. | DANIEL J. | DANIEL J. | DANIEL J. | DANIEL J. | DANIEL J. | DANIEL J. | DANIEL J. | DANIEL J. | DANIEL J. | DANIEL J. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
namt | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
nams | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
adr1 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
adr2 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
city | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
st | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
zip4 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
phon | 9166588222 | 9166588222 | 9166588222 | 9166588222 | 9166588222 | 9166588222 | 9166588222 | 9166588222 | 9166588222 | 9166588200 | 9166588222 | 9166588222 | 9166588222 | 9166588222 | 9166588222 | 9166588222 | 9166588222 | 9166588222 | 9166588222 | 9166588200 | 9166588222 | 9166588222 | 9166588222 | 9166588222 | 9166588222 | 9166588222 | 9166588222 | 9166588222 | 9166588222 | 9166588200 | 9166588222 | 9166588222 | 9166588222 | 9166588222 | 9166588222 | 9166588222 | 9166588222 | 9166588222 | 9166588222 | 9166588200 | 9166588222 | 9166588222 | 9166588222 | 9166588222 | 9166588222 | 9166588222 | 9166588222 | 9166588222 | 9166588222 | 9166588200 | 9166588222 | 9166588222 | 9166588222 | 9166588222 | 9166588222 | 9166588222 | 9166588222 | 9166588222 | 9166588222 | 9166588200 | 9166588222 | 9166588222 | 9166588222 | 9166588222 | 9166588222 | 9166588222 | 9166588222 | 9166588222 | 9166588222 | 9166588200 | 9166588222 | 9166588222 | 9166588222 | 9166588222 | 9166588222 | 9166588222 | 9166588222 | 9166588222 | 9166588222 | 9166588200 | 9166588222 | 9166588222 | 9166588222 | 9166588222 | 9166588222 | 9166588222 | 9166588222 | 9166588222 | 9166588222 | 9166588200 | 9166588222 | 9166588222 | 9166588222 | 9166588222 | 9166588222 | 9166588222 | 9166588222 | 9166588222 | 9166588222 | 9166588200 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fax | 9166588240 | 9166588240 | 9166588240 | 9166588240 | 9166588240 | 9166588240 | 9166588240 | 9166588240 | 9166588240 | 9166588240 | 9166588240 | 9166588240 | 9166588240 | 9166588240 | 9166588240 | 9166588240 | 9166588240 | 9166588240 | 9166588240 | 9166588240 | 9166588240 | 9166588240 | 9166588240 | 9166588240 | 9166588240 | 9166588240 | 9166588240 | 9166588240 | 9166588240 | 9166588240 | 9166588240 | 9166588240 | 9166588240 | 9166588240 | 9166588240 | 9166588240 | 9166588240 | 9166588240 | 9166588240 | 9166588240 | 9166588240 | 9166588240 | 9166588240 | 9166588240 | 9166588240 | 9166588240 | 9166588240 | 9166588240 | 9166588240 | 9166588240 | 9166588240 | 9166588240 | 9166588240 | 9166588240 | 9166588240 | 9166588240 | 9166588240 | 9166588240 | 9166588240 | 9166588240 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None |
filer_id | 1149387 |
---|
filer_id | 1149387 | 1149387 | ||
---|---|---|---|---|
change_no | 1 | 2 | ||
session_id | 2019 | 2019 | ||
log_dt | 2019-10-04 00:00:00 | 2019-10-04 00:00:00 | ||
filer_type | 4 | 4 | ||
correction_flg | None | None | ||
action | DELETED | TERMINATED | ||
attribute_changed | EMPLOYER | |||
ethics_dt | None | None | ||
interests | None | None | ||
filer_full_name | DANIEL CARRIGG | CARRIGG, DANIEL | ||
filer_city | None | None | ||
filer_st | None | None | ||
filer_zip | None | None | ||
filer_phone | None | None | ||
entity_type | 2 | 4 | ||
entity_name | LEAGUE OF CALIFORNIA CITIES | None | ||
entity_city | None | None | ||
entity_st | None | None | ||
entity_zip | None | None | ||
entity_phone | None | None | ||
entity_id | 1146828 | 0 | ||
responsible_officer | None | None | ||
effect_dt | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 |
filer_id | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | 1149387 | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_file_name | 650660_0.cal | 1083822_0.cal | 1223812_0.cal | 1381957_0.cal | 1724286_1.cal | 1724286_0.cal | 43111.cal | 1550304_0.cal | 2115368_1.cal | 2115368_0.cal | 1920043_0.cal | |||||||||||
received_date | 2000-08-09 00:00:00 | 2005-02-03 00:00:00 | 2006-12-19 00:00:00 | 2008-11-20 00:00:00 | 2013-01-30 00:00:00 | 2013-01-11 00:00:00 | 2013-01-30 00:00:00 | 2010-12-13 00:00:00 | 2017-03-24 00:00:00 | 2016-12-29 00:00:00 | 2014-12-22 00:00:00 | |||||||||||
filing_directory | /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/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | |||||||||||
filing_id | 650660 | 1083822 | 1223812 | 1381957 | 1724286 | 1724286 | None | 1550304 | 2115368 | 2115368 | 1920043 | |||||||||||
form_id | F615 | F604 | F604 | F604 | F604 | F604 | None | F604 | F604 | F604 | F604 | |||||||||||
receive_comment | 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 |