filing_id | 1217070 | 1238636 | 1191446 | 1420326 | 1451879 | 1434472 | 1451879 | 1462071 | 1537362 | 1504907 | 1483591 | 1622466 | 1602051 | 1571316 | 1589944 | 1632844 | 1709815 | 1679467 | 1655967 | 1736974 | 1632844 | 1655967 | 1679467 | 1709815 | 1766021 | 1780606 | 1766021 | 1622466 | 1817937 | 1801285 | 1844420 | 1996352 | 2064547 | 2038045 | 2010500 | 2010500 | 2102328 | 2175256 | 2157877 | 2102328 | 2127577 | 2127577 | 2191602 | 2208969 | 2240145 | 2191602 | 2276493 | 2208969 | 2240145 | 2208969 | 2397410 | 2380984 | 2348236 | 2320523 | 2418081 | 2439269 | 2469609 | 2547933 | 2482925 | 2527928 | 2482925 | 2469609 | 2621960 | 2599725 | 2578712 | 2641576 | 2641576 | 2578712 | 2674508 | 2621960 | 2703927 | 2599725 | 2621960 | 2599725 | 2746134 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
amend_id | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 1 | 0 | 1 | 0 | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 2 | 0 | 1 | 1 | 2 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rec_type | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_type | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
sender_id | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filer_id | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
entity_cd | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filer_naml | BEST BEST & KRIEGER | BEST BEST & KRIEGER | BEST BEST & KRIEGER | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filer_namf | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filer_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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filer_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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
report_num | 000 | 000 | 000 | 000 | 000 | 000 | 001 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 001 | 001 | 001 | 001 | 001 | 000 | 000 | 001 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 001 | 000 | 000 | 000 | 001 | 001 | 000 | 000 | 001 | 000 | 001 | 000 | 002 | 001 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 001 | 000 | 000 | 001 | 000 | 000 | 000 | 001 | 000 | 001 | 000 | 002 | 000 | 001 | 001 | 002 | 000 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_date | 2006-10-31 00:00:00 | 2007-01-31 00:00:00 | 2006-07-31 00:00:00 | 2009-04-29 00:00:00 | 2009-10-30 00:00:00 | 2009-07-28 00:00:00 | 2010-01-28 00:00:00 | 2010-01-28 00:00:00 | 2010-10-28 00:00:00 | 2010-07-29 00:00:00 | 2010-04-28 00:00:00 | 2011-10-31 00:00:00 | 2011-07-21 00:00:00 | 2011-01-31 00:00:00 | 2011-04-29 00:00:00 | 2012-01-27 00:00:00 | 2012-10-31 00:00:00 | 2012-07-31 00:00:00 | 2012-04-27 00:00:00 | 2013-01-30 00:00:00 | 2012-01-27 00:00:00 | 2012-04-27 00:00:00 | 2012-07-31 00:00:00 | 2012-10-31 00:00:00 | 2013-07-31 00:00:00 | 2013-07-31 00:00:00 | 2013-04-30 00:00:00 | 2011-10-31 00:00:00 | 2014-01-31 00:00:00 | 2013-10-31 00:00:00 | 2014-04-30 00:00:00 | 2015-10-31 00:00:00 | 2016-07-31 00:00:00 | 2016-04-30 00:00:00 | 2016-01-31 00:00:00 | 2016-01-31 00:00:00 | 2016-10-31 00:00:00 | 2017-07-31 00:00:00 | 2017-04-30 00:00:00 | 2016-10-31 00:00:00 | 2017-01-31 00:00:00 | 2017-01-31 00:00:00 | 2017-10-31 00:00:00 | 2017-12-31 00:00:00 | 2018-04-30 00:00:00 | 2017-10-31 00:00:00 | 2018-07-31 00:00:00 | 2017-12-31 00:00:00 | 2018-04-30 00:00:00 | 2018-01-31 00:00:00 | 2019-07-31 00:00:00 | 2019-04-30 00:00:00 | 2019-01-31 00:00:00 | 2018-10-31 00:00:00 | 2019-10-31 00:00:00 | 2020-01-31 00:00:00 | 2020-04-30 00:00:00 | 2021-01-31 00:00:00 | 2020-10-05 00:00:00 | 2020-10-31 00:00:00 | 2020-07-31 00:00:00 | 2020-10-05 00:00:00 | 2021-11-01 00:00:00 | 2021-07-31 00:00:00 | 2021-04-30 00:00:00 | 2022-03-31 00:00:00 | 2022-01-31 00:00:00 | 2022-02-10 00:00:00 | 2022-04-30 00:00:00 | 2022-03-31 00:00:00 | 2022-08-01 00:00:00 | 2022-01-31 00:00:00 | 2022-01-31 00:00:00 | 2022-03-31 00:00:00 | 2022-10-31 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
from_date | 2006-07-01 00:00:00 | 2006-10-01 00:00:00 | 2006-04-01 00:00:00 | 2009-01-01 00:00:00 | 2009-07-31 00:00:00 | 2009-04-01 00:00:00 | 2009-07-01 00:00:00 | 2009-10-01 00:00:00 | 2010-07-01 00:00:00 | 2010-04-01 00:00:00 | 2010-01-01 00:00:00 | 2011-07-01 00:00:00 | 2011-04-01 00:00:00 | 2010-10-01 00:00:00 | 2011-01-01 00:00:00 | 2011-10-01 00:00:00 | 2012-07-01 00:00:00 | 2012-04-01 00:00:00 | 2012-01-01 00:00:00 | 2012-10-01 00:00:00 | 2011-10-01 00:00:00 | 2012-01-01 00:00:00 | 2012-04-01 00:00:00 | 2012-07-01 00:00:00 | 2013-01-01 00:00:00 | 2013-04-01 00:00:00 | 2013-01-01 00:00:00 | 2011-07-01 00:00:00 | 2013-10-01 00:00:00 | 2013-07-01 00:00:00 | 2014-01-01 00:00:00 | 2015-07-01 00:00:00 | 2016-04-01 00:00:00 | 2016-01-01 00:00:00 | 2015-10-01 00:00:00 | 2015-10-01 00:00:00 | 2016-07-01 00:00:00 | 2017-04-01 00:00:00 | 2017-01-01 00:00:00 | 2016-07-01 00:00:00 | 2016-10-01 00:00:00 | 2016-10-01 00:00:00 | 2017-07-01 00:00:00 | 2017-10-01 00:00:00 | 2018-01-01 00:00:00 | 2017-07-01 00:00:00 | 2018-04-01 00:00:00 | 2017-10-01 00:00:00 | 2018-01-01 00:00:00 | 2017-10-01 00:00:00 | 2019-04-01 00:00:00 | 2019-01-01 00:00:00 | 2018-10-01 00:00:00 | 2018-07-01 00:00:00 | 2019-07-01 00:00:00 | 2019-10-01 00:00:00 | 2020-01-01 00:00:00 | 2020-10-01 00:00:00 | 2020-04-01 00:00:00 | 2020-07-01 00:00:00 | 2020-04-01 00:00:00 | 2020-01-01 00:00:00 | 2021-07-01 00:00:00 | 2021-04-01 00:00:00 | 2021-01-01 00:00:00 | 2021-10-01 00:00:00 | 2021-10-01 00:00:00 | 2021-01-01 00:00:00 | 2022-01-01 00:00:00 | 2021-07-01 00:00:00 | 2022-04-01 00:00:00 | 2021-04-01 00:00:00 | 2021-07-01 00:00:00 | 2021-04-01 00:00:00 | 2022-07-01 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
thru_date | 2006-09-30 00:00:00 | 2006-12-31 00:00:00 | 2006-06-30 00:00:00 | 2009-03-31 00:00:00 | 2009-09-30 00:00:00 | 2009-06-30 00:00:00 | 2009-09-30 00:00:00 | 2009-12-31 00:00:00 | 2010-09-30 00:00:00 | 2010-06-30 00:00:00 | 2010-03-31 00:00:00 | 2011-09-30 00:00:00 | 2011-06-30 00:00:00 | 2010-12-31 00:00:00 | 2011-03-31 00:00:00 | 2011-12-31 00:00:00 | 2012-09-30 00:00:00 | 2012-06-30 00:00:00 | 2012-03-31 00:00:00 | 2012-12-31 00:00:00 | 2011-12-31 00:00:00 | 2012-03-31 00:00:00 | 2012-06-30 00:00:00 | 2012-09-30 00:00:00 | 2013-03-31 00:00:00 | 2013-06-30 00:00:00 | 2013-03-31 00:00:00 | 2011-09-30 00:00:00 | 2013-12-31 00:00:00 | 2013-09-30 00:00:00 | 2014-03-31 00:00:00 | 2015-09-30 00:00:00 | 2016-06-30 00:00:00 | 2016-03-31 00:00:00 | 2015-12-31 00:00:00 | 2015-12-31 00:00:00 | 2016-09-30 00:00:00 | 2017-06-30 00:00:00 | 2017-03-31 00:00:00 | 2016-09-30 00:00:00 | 2016-12-31 00:00:00 | 2016-12-31 00:00:00 | 2017-09-30 00:00:00 | 2017-12-31 00:00:00 | 2018-03-31 00:00:00 | 2017-09-30 00:00:00 | 2018-06-30 00:00:00 | 2017-12-31 00:00:00 | 2018-03-31 00:00:00 | 2017-12-31 00:00:00 | 2019-06-30 00:00:00 | 2019-03-31 00:00:00 | 2018-12-31 00:00:00 | 2018-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-12-31 00:00:00 | 2020-03-31 00:00:00 | 2020-12-31 00:00:00 | 2020-06-30 00:00:00 | 2020-09-30 00:00:00 | 2020-06-30 00:00:00 | 2020-03-31 00:00:00 | 2021-09-30 00:00:00 | 2021-06-30 00:00:00 | 2021-03-31 00:00:00 | 2021-12-31 00:00:00 | 2021-12-31 00:00:00 | 2021-03-31 00:00:00 | 2022-03-31 00:00:00 | 2021-09-30 00:00:00 | 2022-06-30 00:00:00 | 2021-06-30 00:00:00 | 2021-09-30 00:00:00 | 2021-06-30 00:00:00 | 2022-09-30 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
cum_beg_dt | 2006-04-01 00:00:00 | 2006-04-01 00:00:00 | 2006-04-01 00:00:00 | None | 2009-01-01 00:00:00 | 2009-01-01 00:00:00 | 2009-01-01 00:00:00 | 2009-01-01 00:00:00 | 2009-01-01 00:00:00 | 2009-01-01 00:00:00 | 2009-01-01 00:00:00 | 2011-01-01 00:00:00 | 2011-01-01 00:00:00 | 2009-01-01 00:00:00 | 2011-01-01 00:00:00 | 2011-01-01 00:00:00 | 2011-01-01 00:00:00 | 2011-01-01 00:00:00 | 2011-01-01 00:00:00 | 2011-01-01 00:00:00 | 2011-01-01 00:00:00 | 2011-01-01 00:00:00 | 2011-01-01 00:00:00 | 2011-01-01 00:00:00 | 2013-01-01 00:00:00 | 2013-01-01 00:00:00 | 2013-01-01 00:00:00 | 2011-01-01 00:00:00 | 2013-01-01 00:00:00 | 2013-01-01 00:00:00 | 2013-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017-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 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
firm_id | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | None | 1285845 | 1285845 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
firm_name | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | None | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
firm_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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
firm_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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
firm_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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
firm_phon | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | (916) 325-4000 | (916) 325-4000 | (916) 325-4000 | (916) 325-4000 | (916) 325-4000 | (916) 325-4000 | 9163254000 | (916) 325-4000 | (916) 325-4000 | (916) 325-4000 | (916) 325-4000 | (916) 325-4000 | (916) 325-4000 | (916) 325-4000 | (916) 325-4000 | (916) 325-4000 | (916) 325-4000 | (916) 325-4000 | (916) 325-4000 | (916) 325-4000 | (916) 325-4000 | (916) 325-4000 | (916) 325-4000 | (916) 325-4000 | (916) 325-4000 | (916) 325-4000 | (916) 325-4000 | (916) 325-4000 | (916) 325-4000 | (916) 325-4000 | (916) 325-4000 | (916) 325-4000 | (916) 325-4000 | (916) 325-4000 | (916) 325-4000 | (916) 325-4000 | (916) 325-4000 | (916) 325-4000 | (916) 325-4000 | (916) 325-4000 | (916) 325-4000 | (916) 325-4000 | (916) 325-4000 | (916) 325-4000 | (916) 325-4000 | (916) 325-4000 | (916) 325-4000 | (916) 325-4000 | (916) 325-4000 | (916) 325-4000 | (916) 325-4000 | (916) 325-4000 | (916) 325-4000 | (916) 325-4000 | (916) 325-4000 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
mail_city | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
mail_st | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
mail_zip4 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
mail_phon | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
sig_date | 2006-10-31 00:00:00 | 2007-01-31 00:00:00 | 2006-07-31 00:00:00 | 2009-04-29 00:00:00 | 2009-10-30 00:00:00 | 2009-07-28 00:00:00 | 2010-01-28 00:00:00 | 2010-01-28 00:00:00 | 2010-10-28 00:00:00 | 2010-07-29 00:00:00 | 2010-04-28 00:00:00 | 2011-10-31 00:00:00 | 2011-07-21 00:00:00 | 2011-01-31 00:00:00 | 2011-04-29 00:00:00 | 2012-01-27 00:00:00 | 2012-10-31 00:00:00 | 2012-07-31 00:00:00 | 2012-04-27 00:00:00 | 2013-01-30 00:00:00 | 2013-05-17 00:00:00 | 2013-05-17 00:00:00 | 2013-05-17 00:00:00 | 2013-05-17 00:00:00 | 2013-07-29 00:00:00 | 2013-07-29 00:00:00 | 2013-04-30 00:00:00 | 2013-05-17 00:00:00 | 2014-01-31 00:00:00 | 2013-10-31 00:00:00 | 2014-04-30 00:00:00 | 2015-10-31 00:00:00 | 2016-07-31 00:00:00 | 2016-04-30 00:00:00 | 2016-01-31 00:00:00 | 2016-04-05 00:00:00 | 2016-10-31 00:00:00 | 2017-07-31 00:00:00 | 2017-04-30 00:00:00 | 2017-03-06 00:00:00 | 2017-04-30 00:00:00 | 2017-01-31 00:00:00 | 2017-10-31 00:00:00 | 2018-04-30 00:00:00 | 2018-04-30 00:00:00 | 2018-04-30 00:00:00 | 2018-07-31 00:00:00 | 2018-04-30 00:00:00 | 2018-04-30 00:00:00 | 2018-01-31 00:00:00 | 2019-07-31 00:00:00 | 2019-04-30 00:00:00 | 2019-01-31 00:00:00 | 2018-10-31 00:00:00 | 2019-10-31 00:00:00 | 2020-01-31 00:00:00 | 2020-04-30 00:00:00 | 2021-01-31 00:00:00 | 2020-10-05 00:00:00 | 2020-10-31 00:00:00 | 2020-07-31 00:00:00 | 2020-10-05 00:00:00 | 2021-11-01 00:00:00 | 2021-07-31 00:00:00 | 2021-04-30 00:00:00 | 2022-03-31 00:00:00 | 2022-01-31 00:00:00 | 2022-02-10 00:00:00 | 2022-04-30 00:00:00 | 2022-03-31 00:00:00 | 2022-08-01 00:00:00 | 2022-01-31 00:00:00 | 2022-01-31 00:00:00 | 2022-03-31 00:00:00 | 2022-10-31 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
sig_loc | Riverside, California | Riverside, CA | Riverside, California | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | SACRAMENTO | Sacramento | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | SAN RAFAEL, CA | SAN RAFAEL, CA | SAN RAFAEL, CA | SAN RAFAEL, CA | SACRAMENTO, CA | SACRAMENTO, CA | Sacramento, CA | SAN RAFAEL, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
sig_naml | GARNER | Garner | Garner | Thomas | Thomas | Thomas | Thomas | Thomas | THOMAS | Thomas | Thomas | Thomas | Thomas | Thomas | Thomas | Thomas | Thomas | Thomas | Thomas | Thomas | SKINNELL | SKINNELL | SKINNELL | SKINNELL | THOMAS | THOMAS | Thomas | SKINNELL | THOMAS | THOMAS | THOMAS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
sig_namf | ERIC | Eric | Eric | William | William | William | William | William | WILLIAM | William | William | William | William | William | William | William | William | William | William | William | CHRISTOPHER | CHRISTOPHER | CHRISTOPHER | CHRISTOPHER | WILLIAM J. | WILLIAM J. | William | CHRISTOPHER | WILLIAM J. | WILLIAM J. | WILLIAM J. | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
sig_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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
sig_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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
prn_naml | GARNER | Garner | Garner | Thomas | Thomas | Thomas | Thomas | Thomas | THOMAS | Thomas | Thomas | Thomas | Thomas | Thomas | Thomas | Thomas | Thomas | Thomas | Thomas | Thomas | SKINNELL | SKINNELL | SKINNELL | SKINNELL | THOMAS | THOMAS | Thomas | SKINNELL | THOMAS | THOMAS | THOMAS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
prn_namf | ERIC | Eric | Eric | William | William | William | William | William | WILLIAM | William | William | William | William | William | William | William | William | William | William | William | CHRISTOPHER | CHRISTOPHER | CHRISTOPHER | CHRISTOPHER | WILLIAM J. | WILLIAM J. | William | CHRISTOPHER | WILLIAM J. | WILLIAM J. | WILLIAM J. | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
prn_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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
prn_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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
sig_title | MANAGING PARTNER | Managing Partner | Managing Partner | Of Counsel | Of Counsel | Of Counsel | Of Counsel | Of Counsel | OF COUNSEL | Of Counsel | Of Counsel | Of Counsel | Of Counsel | Of Counsel | Of Counsel | Of Counsel | Of Counsel | Of Counsel | Of Counsel | Of Counsel | ATTORNEY & AGENT FOR FILER | ATTORNEY & AGENT FOR FILER | ATTORNEY & AGENT FOR FILER | ATTORNEY & AGENT FOR FILER | ATTORNEY & AGENT FOR FILER | ATTORNEY & AGENT FOR FILER | Of Counsel | ATTORNEY & AGENT FOR FILER | ATTORNEY & AGENT FOR FILER | ATTORNEY & AGENT FOR FILER | ATTORNEY & AGENT FOR FILER | DIRECTOR, GOVERNMENTAL AFFAIRS | DIRECTOR, GOVERNMENTAL AFFAIRS | DIRECTOR, GOVERNMENTAL AFFAIRS | DIRECTOR, GOVERNMENTAL AFFAIRS | DIRECTOR, GOVERNMENTAL AFFAIRS | DIRECTOR, GOVERNMENTAL AFFAIRS | DIRECTOR, GOVERNMENTAL AFFAIRS | DIRECTOR, GOVERNMENTAL AFFAIRS | DIRECTOR, GOVERNMENTAL AFFAIRS | DIRECTOR, GOVERNMENTAL AFFAIRS | DIRECTOR, GOVERNMENTAL AFFAIRS | DIRECTOR, GOVERNMENTAL AFFAIRS | DIRECTOR, GOVERNMENTAL AFFAIRS | DIRECTOR, GOVERNMENTAL AFFAIRS | DIRECTOR, GOVERNMENTAL AFFAIRS | DIRECTOR, GOVERNMENTAL AFFAIRS | DIRECTOR, GOVERNMENTAL AFFAIRS | DIRECTOR, GOVERNMENTAL AFFAIRS | DIRECTOR, GOVERNMENTAL AFFAIRS | DIRECTOR, GOVERNMENTAL AFFAIRS | DIRECTOR, GOVERNMENTAL AFFAIRS | DIRECTOR, GOVERNMENTAL AFFAIRS | DIRECTOR, GOVERNMENTAL AFFAIRS | DIRECTOR, GOVERNMENTAL AFFAIRS | DIRECTOR, GOVERNMENTAL AFFAIRS | DIRECTOR, GOVERNMENTAL AFFAIRS | DIRECTOR, GOVERNMENTAL AFFAIRS | DIRECTOR, GOVERNMENTAL AFFAIRS | DIRECTOR, GOVERNMENTAL AFFAIRS | DIRECTOR, GOVERNMENTAL AFFAIRS | DIRECTOR, GOVERNMENTAL AFFAIRS | DIRECTOR, GOVERNMENTAL AFFAIRS | DIRECTOR, GOVERNMENTAL AFFAIRS | DIRECTOR, GOVERNMENTAL AFFAIRS | DIRECTOR, GOVERNMENTAL AFFAIRS | DIRECTOR, GOVERNMENTAL AFFAIRS | DIRECTOR, GOVERNMENTAL AFFAIRS | DIRECTOR, GOVERNMENTAL AFFAIRS | DIRECTOR, GOVERNMENTAL AFFAIRS | DIRECTOR, GOVERNMENTAL AFFAIRS | DIRECTOR, GOVERNMENTAL AFFAIRS | DIRECTOR, GOVERNMENTAL AFFAIRS | DIRECTOR, GOVERNMENTAL AFFAIRS | DIRECTOR, GOVERNMENTAL AFFAIRS | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
nopart1_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
nopart2_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
part1_1_cb | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
part1_2_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
ctrib_n_cb | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | None | None | X | None | None | None | None | None | X | None | None | None | X | None | None | X | None | None | None | None | X | None | X | X | X | X | None | None | None | X | None | X | X | X | None | None | None | X | X | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
ctrib_y_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | X | X | None | X | X | X | X | X | None | X | X | X | None | X | X | None | X | X | X | X | None | X | None | None | None | None | X | X | X | None | X | None | None | None | X | X | X | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
lby_actvty | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
lobby_n_cb | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
lobby_y_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
major_naml | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
major_namf | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
major_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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
major_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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rcpcmte_nm | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | BEST, BEST & KRIEGER, LLP | None | None | BEST, BEST & KRIEGER, LLP | BEST, BEST & KRIEGER, LLP | BEST, BEST & KRIEGER, LLP | BEST, BEST & KRIEGER, LLP | None | BEST, BEST & KRIEGER, LLP | BEST, BEST & KRIEGER, LLP | BEST, BEST & KRIEGER, LLP | None | BEST, BEST & KRIEGER, LLP | BEST, BEST & KRIEGER, LLP | None | BEST, BEST & KRIEGER, LLP | None | BEST, BEST & KRIEGER, LLP | BEST, BEST & KRIEGER, LLP | None | BEST, BEST & KRIEGER, LLP | None | None | None | None | None | None | None | None | None | None | None | None | BEST, BEST & KRIEGER, LLP | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rcpcmte_id | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 1272623 | 1272623 | None | None | None | None | None | None | None | None | 1272623 | None | 1272623 | None | None | None | None | 1272623 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None |
filing_id | 1225189 | 1387162 | 1809129 | 1809129 | 1872199 | 1809129 | 1986859 | 1986859 | 1986859 | 1986859 | 1986859 | 1986859 | 1986859 | 2115521 | 2115521 | 1986859 | 2115521 | 2115521 | 2115521 | 2115521 | 2115521 | 2115521 | 2334523 | 2334523 | 2334523 | 2334523 | 2334523 | 2334523 | 2334523 | 2539033 | 2539033 | 2539033 | 2539033 | 2539033 | 2539033 | 2539033 | ||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
amend_id | 0 | 0 | 0 | 1 | 0 | 2 | 1 | 2 | 0 | 3 | 5 | 4 | 6 | 0 | 1 | 7 | 4 | 2 | 5 | 3 | 7 | 6 | 0 | 1 | 2 | 4 | 5 | 6 | 3 | 0 | 1 | 4 | 5 | 3 | 2 | 6 | ||||||||||||||||||||||||||||||||||||
rec_type | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | ||||||||||||||||||||||||||||||||||||
form_type | F606 | F601 | F601 | F601 | F607 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | ||||||||||||||||||||||||||||||||||||
sender_id | 1285845 | F24550 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | ||||||||||||||||||||||||||||||||||||
filer_id | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | ||||||||||||||||||||||||||||||||||||
entity_cd | LBY | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | ||||||||||||||||||||||||||||||||||||
filer_naml | BEST BEST & KRIEGER | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | ||||||||||||||||||||||||||||||||||||
filer_namf | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||
filer_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 | ||||||||||||||||||||||||||||||||||||
filer_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 | ||||||||||||||||||||||||||||||||||||
report_num | 000 | 000 | 000 | 001 | 000 | 002 | 001 | 002 | 000 | 003 | 005 | 004 | 006 | 000 | 001 | 007 | 004 | 002 | 005 | 003 | 007 | 006 | 000 | 001 | 002 | 004 | 005 | 006 | 003 | 000 | 001 | 004 | 005 | 003 | 002 | 006 | ||||||||||||||||||||||||||||||||||||
rpt_date | 2006-12-29 00:00:00 | 2008-12-31 00:00:00 | 2012-12-31 00:00:00 | 2014-01-02 00:00:00 | 2014-07-31 00:00:00 | 2014-01-31 00:00:00 | 2016-02-03 00:00:00 | 2016-02-18 00:00:00 | 2015-08-11 00:00:00 | 2016-02-18 00:00:00 | 2016-10-05 00:00:00 | 2016-04-05 00:00:00 | 2016-11-10 00:00:00 | 2016-11-10 00:00:00 | 2017-01-18 00:00:00 | 2017-06-05 00:00:00 | 2017-09-13 00:00:00 | 2017-04-24 00:00:00 | 2017-11-15 00:00:00 | 2017-07-14 00:00:00 | 2018-07-18 00:00:00 | 2018-03-05 00:00:00 | 2018-12-31 00:00:00 | 2019-06-03 00:00:00 | 2019-08-01 00:00:00 | 2020-05-07 00:00:00 | 2020-07-30 00:00:00 | 2020-09-08 00:00:00 | 2020-03-31 00:00:00 | 2021-01-01 00:00:00 | 2021-06-17 00:00:00 | 2022-02-14 00:00:00 | 2022-05-17 00:00:00 | 2022-01-26 00:00:00 | 2021-10-19 00:00:00 | 2022-10-12 00:00:00 | ||||||||||||||||||||||||||||||||||||
ls_beg_yr | 2007 | 2009 | 2013 | 2013 | 2013 | 2013 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2017 | 2017 | 2015 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | ||||||||||||||||||||||||||||||||||||
ls_end_yr | 2008 | 2010 | 2014 | 2014 | 2014 | 2014 | 2016 | 2016 | 2016 | 2016 | 2016 | 2016 | 2016 | 2018 | 2018 | 2016 | 2018 | 2018 | 2018 | 2018 | 2018 | 2018 | 2020 | 2020 | 2020 | 2020 | 2020 | 2020 | 2020 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | ||||||||||||||||||||||||||||||||||||
qual_date | None | None | None | None | None | None | None | None | 2015-08-10 00:00:00 | None | None | None | None | 2017-01-01 00:00:00 | None | None | None | None | None | None | None | None | 2019-01-01 00:00:00 | None | None | None | None | None | None | 2021-01-01 00:00:00 | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||
eff_date | 2006-12-31 00:00:00 | None | None | None | 2013-01-01 00:00:00 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||
bus_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 | ||||||||||||||||||||||||||||||||||||
bus_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 | ||||||||||||||||||||||||||||||||||||
bus_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 | ||||||||||||||||||||||||||||||||||||
bus_phon | 9163254000 | 9163254000 | 916 325-4000 | 916 325-4000 | 415-389-6800 | 916 325-4000 | 916 325-4000 | 916 325-4000 | 916 325-4000 | 916 325-4000 | 916 325-4000 | 916 325-4000 | 916 325-4000 | 916 325-4000 | 916 325-4000 | 916 325-4000 | 916 325-4000 | 916 325-4000 | 916 325-4000 | 916 325-4000 | 916 325-4000 | 916 325-4000 | (916) 325-4000 | (916) 325-4000 | (916) 325-4000 | (916) 325-4000 | (916) 325-4000 | (916) 325-4000 | (916) 325-4000 | (916) 325-4000 | (916) 325-4000 | (916) 325-4000 | (916) 325-4000 | (916) 325-4000 | (916) 325-4000 | (916) 325-4000 | ||||||||||||||||||||||||||||||||||||
bus_fax | None | 9163254010 | 916 325-4010 | 916 325-4010 | None | 916 325-4010 | 916 325-4010 | 916 325-4010 | 916 325-4010 | 916 325-4010 | 916 325-4010 | 916 325-4010 | 916 325-4010 | 916 325-4010 | 916 325-4010 | 916 325-4010 | 916 325-4010 | 916 325-4010 | 916 325-4010 | 916 325-4010 | 916 325-4010 | 916 325-4010 | (916) 325-4010 | (916) 325-4010 | (916) 325-4010 | (916) 325-4010 | (916) 325-4010 | (916) 325-4010 | (916) 325-4010 | (916) 325-4010 | (916) 325-4010 | (916) 325-4010 | (916) 325-4010 | (916) 325-4010 | (916) 325-4010 | (916) 325-4010 | ||||||||||||||||||||||||||||||||||||
bus_email | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||
mail_city | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||
mail_st | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||
mail_zip4 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||
mail_phon | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||
sig_date | 2006-12-29 00:00:00 | 2008-12-31 00:00:00 | 2012-12-27 00:00:00 | 2013-12-19 00:00:00 | 2014-07-31 00:00:00 | 2014-01-31 00:00:00 | 2016-02-03 00:00:00 | 2016-02-18 00:00:00 | 2015-08-11 00:00:00 | 2016-02-18 00:00:00 | 2016-10-05 00:00:00 | 2016-04-05 00:00:00 | 2016-11-10 00:00:00 | 2016-12-15 00:00:00 | 2017-01-18 00:00:00 | 2017-06-05 00:00:00 | 2017-09-13 00:00:00 | 2017-04-24 00:00:00 | 2017-11-15 00:00:00 | 2017-07-14 00:00:00 | None | 2018-03-05 00:00:00 | 2018-12-31 00:00:00 | 2019-06-03 00:00:00 | 2019-08-01 00:00:00 | 2020-05-07 00:00:00 | 2020-07-30 00:00:00 | 2020-09-08 00:00:00 | 2020-03-31 00:00:00 | 2021-01-01 00:00:00 | 2021-06-17 00:00:00 | 2022-02-14 00:00:00 | 2022-05-17 00:00:00 | 2022-01-26 00:00:00 | 2021-10-19 00:00:00 | 2022-10-12 00:00:00 | ||||||||||||||||||||||||||||||||||||
sig_loc | None | None | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | ||||||||||||||||||||||||||||||||||||
sig_naml | GARNER | THOMAS | THOMAS | THOMAS | THOMAS | THOMAS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | ||||||||||||||||||||||||||||||||||||
sig_namf | ERIC L. | WILLIAM | WILLIAM J. | WILLIAM J. | WILLIAM J. | WILLIAM J. | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | ||||||||||||||||||||||||||||||||||||
sig_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 | ||||||||||||||||||||||||||||||||||||
sig_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 | ||||||||||||||||||||||||||||||||||||
prn_naml | GARNER | THOMAS | THOMAS | THOMAS | THOMAS | THOMAS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | DEVERS | ||||||||||||||||||||||||||||||||||||
prn_namf | ERIC L. | WILLIAM | WILLIAM J. | WILLIAM J. | WILLIAM J. | WILLIAM J. | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | SYRUS | ||||||||||||||||||||||||||||||||||||
prn_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 | ||||||||||||||||||||||||||||||||||||
prn_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 | ||||||||||||||||||||||||||||||||||||
sig_title | MANAGING PARTNER | OF COUNSEL | OF COUNSEL | ATTORNEY | ATTORNEY & AGENT FOR FILER | ATTORNEY | DIRECTOR, GOVERNMENTAL AFFAIRS | DIRECTOR, GOVERNMENTAL AFFAIRS | DIRECTOR, GOVERNMENTAL AFFAIRS | DIRECTOR, GOVERNMENTAL AFFAIRS | DIRECTOR, GOVERNMENTAL AFFAIRS | DIRECTOR, GOVERNMENTAL AFFAIRS | DIRECTOR, GOVERNMENTAL AFFAIRS | DIRECTOR, GOVERNMENTAL AFFAIRS | DIRECTOR, GOVERNMENTAL AFFAIRS | DIRECTOR, GOVERNMENTAL AFFAIRS | DIRECTOR, GOVERNMENTAL AFFAIRS | DIRECTOR, GOVERNMENTAL AFFAIRS | DIRECTOR, GOVERNMENTAL AFFAIRS | DIRECTOR, GOVERNMENTAL AFFAIRS | DIRECTOR, GOVERNMENTAL AFFAIRS | DIRECTOR, GOVERNMENTAL AFFAIRS | DIRECTOR, GOVERNMENTAL AFFAIRS | DIRECTOR, GOVERNMENTAL AFFAIRS | DIRECTOR, GOVERNMENTAL AFFAIRS | DIRECTOR, GOVERNMENTAL AFFAIRS | DIRECTOR, GOVERNMENTAL AFFAIRS | DIRECTOR, GOVERNMENTAL AFFAIRS | DIRECTOR, GOVERNMENTAL AFFAIRS | DIRECTOR, GOVERNMENTAL AFFAIRS | DIRECTOR, GOVERNMENTAL AFFAIRS | DIRECTOR, GOVERNMENTAL AFFAIRS | DIRECTOR, GOVERNMENTAL AFFAIRS | DIRECTOR, GOVERNMENTAL AFFAIRS | DIRECTOR, GOVERNMENTAL AFFAIRS | DIRECTOR, GOVERNMENTAL AFFAIRS | ||||||||||||||||||||||||||||||||||||
stmt_firm | None | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | None | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | ||||||||||||||||||||||||||||||||||||
ind_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||
bus_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||
trade_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||
oth_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||
a_b_name | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||
a_b_city | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||
a_b_st | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||
a_b_zip4 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||
descrip_1 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||
descrip_2 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||
c_less50 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||
c_more50 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||
ind_class | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||
ind_descr | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||
bus_class | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||
bus_descr | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||
auth_name | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||
auth_city | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||
auth_st | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||
auth_zip4 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||
lobby_int | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||
influen_yn | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||
firm_name | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||
newcert_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||
rencert_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||
complet_dt | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||
lby_reg_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||
lby_604_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||
st_leg_yn | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||
st_agency | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||
lobby_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||
l_firm_cb | None | None | None | None | X | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None |
filer_id | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
adrid | 2102281 | 2166099 | 2204609 | 2412282 | 2549086 | 2227877 | 2465414 | 2278602 | 2373218 | 2506876 | ||||||||||
effect_dt | 2006-04-01 00:00:00 | 2009-01-01 00:00:00 | 2011-01-01 00:00:00 | 2017-01-01 00:00:00 | 2023-01-01 00:00:00 | 2011-12-05 00:00:00 | 2019-01-01 00:00:00 | 2013-01-01 00:00:00 | 2015-08-10 00:00:00 | 2021-01-01 00:00:00 | ||||||||||
add_type | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | ||||||||||
session_id | 2005 | 2009 | 2011 | 2017 | 2023 | 2011 | 2019 | 2013 | 2015 | 2021 |
filer_id | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 1165772 | 1169273 | 1191446 | 1217070 | 1225189 | 1227537 | 1227539 | 1238636 | 1632844 | 1655967 | 1679467 | 1709815 | 1766021 | 1784583 | 1780606 | 1771932 | 1771935 | 1622466 | 1872199 | 1844420 | 1801285 | 1809129 | 1809129 | 1790444 | 1387162 | 1434472 | 1420326 | 1408798 | 1433674 | 1462071 | 1451879 | 1451879 | 1483591 | 1504907 | 1537362 | 1555156 | 1571316 | 1589944 | 1602051 | 1625243 | 1622466 | 1624012 | 1632844 | 1655967 | 1645778 | 1679552 | 1679467 | 1814246 | 1809129 | 1824606 | 1817937 | 1709815 | 1876478 | 1736974 | 1732170 | 1766021 | 1996352 | 1986859 | 1988712 | 2334523 | 2339026 | 2334523 | 2191602 | 2566866 | 2186417 | 2547933 | 2439269 | 2334523 | 2115521 | 2380984 | 2334523 | 2407907 | 2348236 | 2259632 | 2498358 | 2418081 | 2115521 | 2197225 | 1986859 | 2018438 | 2018447 | 1986859 | 2010500 | 2018421 | 1986859 | 2038045 | 2010500 | 1986859 | 2064547 | 2042196 | 1986859 | 1986859 | 2102328 | 2127577 | 2108381 | 2115521 | 2115521 | 2140635 | 2135240 | 2175256 | 2115521 | 2127577 | 2164931 | 2115521 | 2157877 | 2102328 | 2158318 | 1986859 | 2164044 | 2191602 | 2208969 | 2276493 | 2397410 | 2180973 | 2364916 | 2320523 | 2334523 | 2334523 | 2115521 | 2465545 | 2208969 | 2240145 | 2482925 | 2387735 | 2539033 | 2115521 | 2474552 | 2469609 | 2469609 | 2208969 | 2240145 | 2334523 | 2259226 | 2259241 | 2222668 | 2507755 | 2641576 | 2641576 | 2631847 | 2539033 | 2650022 | 2628674 | 2693864 | 2578712 | 2674508 | 2482925 | 2527928 | 2621960 | 2539033 | 2599725 | 2621960 | 2599725 | 2621960 | 2599725 | 2703927 | 2539033 | 2539033 | 2655486 | 2578712 | 2539033 | 2539033 | 2746134 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
period_id | None | None | 186 | 187 | 188 | None | None | 188 | 208 | 209 | 210 | 211 | 213 | None | 214 | None | None | 207 | 219 | 217 | 215 | 212 | 217 | None | 196 | 198 | 197 | None | None | 200 | 199 | 199 | 201 | 202 | 203 | None | 204 | 205 | 206 | None | 207 | None | 208 | 209 | None | None | 210 | None | 217 | None | 216 | 211 | None | 212 | None | 213 | 223 | 223 | None | 238 | None | 242 | 231 | None | None | 244 | 240 | 243 | 232 | 237 | 236 | None | 236 | None | None | 239 | 231 | None | 225 | None | None | 225 | 224 | None | 225 | 225 | 224 | 226 | 226 | None | 228 | 228 | 227 | 228 | None | 228 | 229 | None | None | 230 | 231 | 228 | None | 230 | 229 | 227 | None | 230 | None | 231 | 232 | 234 | 238 | None | None | 235 | 243 | 239 | 235 | None | 232 | 233 | 242 | None | 245 | 233 | None | 241 | 241 | 232 | 233 | 241 | None | None | None | None | 248 | 248 | None | 250 | None | None | None | 245 | 249 | 242 | 243 | 247 | 249 | 246 | 247 | 246 | 247 | 246 | 250 | 246 | 248 | None | 245 | 249 | 252 | 251 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F601 | F999 | F625 | F625 | F606 | F605 | F606 | F625 | F625 | F625 | F625 | F625 | F625 | F607 | F625 | F605 | F605 | F625 | F607 | F625 | F625 | F601 | F601 | F666 | F601 | F625 | F625 | F601 | F605 | F625 | F625 | F625 | F625 | F625 | F625 | F601 | F625 | F625 | F625 | F605 | F625 | F605 | F625 | F625 | F605 | F605 | F625 | F605 | F601 | F605 | F625 | F625 | F607 | F625 | F601 | F625 | F625 | F601 | F601 | F601 | F601 | F601 | F625 | F601 | F605 | F625 | F625 | F601 | F601 | F625 | F601 | F605 | F625 | F602 | F605 | F625 | F601 | F605 | F601 | F605 | F605 | F601 | F625 | F605 | F601 | F625 | F625 | F601 | F625 | F605 | F601 | F601 | F625 | F625 | F605 | F601 | F601 | F605 | F601 | F625 | F601 | F625 | F605 | F601 | F625 | F625 | F605 | F601 | F605 | F625 | F625 | F625 | F625 | F605 | F605 | F625 | F601 | F601 | F601 | F605 | F625 | F625 | F625 | F605 | F601 | F601 | F605 | F625 | F625 | F625 | F625 | F601 | F605 | F605 | F605 | F605 | F625 | F625 | F605 | F601 | F605 | F605 | F605 | F625 | F625 | F625 | F625 | F625 | F601 | F625 | F625 | F625 | F625 | F625 | F625 | F601 | F601 | F605 | F625 | F601 | F601 | F625 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_sequence | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 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 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 4 | 1 | 0 | 0 | 0 | 0 | 6 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | 2 | 0 | 0 | 3 | 0 | 0 | 1 | 0 | 1 | 4 | 0 | 0 | 5 | 6 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 3 | 1 | 0 | 2 | 0 | 1 | 0 | 7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 2 | 7 | 0 | 1 | 0 | 0 | 0 | 0 | 6 | 0 | 0 | 1 | 2 | 1 | 3 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 5 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 2 | 4 | 1 | 1 | 2 | 0 | 0 | 0 | 1 | 2 | 0 | 0 | 3 | 6 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_date | 2006-04-26 00:00:00 | 2006-05-08 00:00:00 | 2006-07-31 00:00:00 | 2006-10-31 00:00:00 | 2006-12-29 00:00:00 | 2007-01-05 00:00:00 | 2007-01-05 00:00:00 | 2007-01-31 00:00:00 | 2013-05-20 00:00:00 | 2013-05-20 00:00:00 | 2013-05-20 00:00:00 | 2013-05-20 00:00:00 | 2013-07-30 00:00:00 | 2013-07-23 00:00:00 | 2013-07-30 00:00:00 | 2013-04-23 00:00:00 | 2013-04-30 00:00:00 | 2013-05-20 00:00:00 | 2014-07-31 00:00:00 | 2014-04-30 00:00:00 | 2013-10-31 00:00:00 | 2014-01-08 00:00:00 | 2014-01-08 00:00:00 | 2013-08-30 00:00:00 | 2008-12-31 00:00:00 | 2009-07-28 00:00:00 | 2009-04-29 00:00:00 | 2008-12-30 00:00:00 | 2009-03-12 00:00:00 | 2010-01-28 00:00:00 | 2010-01-28 00:00:00 | 2009-10-30 00:00:00 | 2010-04-28 00:00:00 | 2010-07-29 00:00:00 | 2010-10-28 00:00:00 | 2010-12-28 00:00:00 | 2011-01-31 00:00:00 | 2011-04-29 00:00:00 | 2011-07-21 00:00:00 | 2011-11-15 00:00:00 | 2011-10-31 00:00:00 | 2011-10-28 00:00:00 | 2012-01-27 00:00:00 | 2012-04-27 00:00:00 | 2012-02-01 00:00:00 | 2012-07-31 00:00:00 | 2012-07-31 00:00:00 | 2014-01-02 00:00:00 | 2014-01-31 00:00:00 | 2014-02-03 00:00:00 | 2014-01-31 00:00:00 | 2012-10-31 00:00:00 | 2014-08-08 00:00:00 | 2013-01-30 00:00:00 | 2012-12-31 00:00:00 | 2013-04-30 00:00:00 | 2015-10-29 00:00:00 | 2015-08-24 00:00:00 | 2015-08-21 00:00:00 | 2019-06-11 00:00:00 | 2019-01-10 00:00:00 | 2020-06-03 00:00:00 | 2018-05-01 00:00:00 | 2020-12-30 00:00:00 | 2017-10-03 00:00:00 | 2021-01-27 00:00:00 | 2020-01-30 00:00:00 | 2020-09-25 00:00:00 | 2017-11-30 00:00:00 | 2019-04-30 00:00:00 | 2019-01-15 00:00:00 | 2019-08-08 00:00:00 | 2019-01-31 00:00:00 | 2018-05-30 00:00:00 | 2020-08-18 00:00:00 | 2019-10-30 00:00:00 | 2017-10-10 00:00:00 | 2017-11-29 00:00:00 | 2016-02-19 00:00:00 | 2016-02-22 00:00:00 | 2016-02-26 00:00:00 | 2016-02-25 00:00:00 | 2016-01-29 00:00:00 | 2016-02-19 00:00:00 | 2016-02-08 00:00:00 | 2016-05-02 00:00:00 | 2016-04-05 00:00:00 | 2016-04-05 00:00:00 | 2016-08-01 00:00:00 | 2016-05-06 00:00:00 | 2016-10-30 00:00:00 | 2016-11-18 00:00:00 | 2016-10-31 00:00:00 | 2017-01-30 00:00:00 | 2016-11-21 00:00:00 | 2016-12-29 00:00:00 | 2017-02-22 00:00:00 | 2017-02-22 00:00:00 | 2016-12-29 00:00:00 | 2017-07-31 00:00:00 | 2017-08-02 00:00:00 | 2017-05-01 00:00:00 | 2017-06-22 00:00:00 | 2017-06-06 00:00:00 | 2017-05-01 00:00:00 | 2017-05-01 00:00:00 | 2017-02-23 00:00:00 | 2017-06-26 00:00:00 | 2017-05-11 00:00:00 | 2017-10-30 00:00:00 | 2018-01-30 00:00:00 | 2018-07-31 00:00:00 | 2019-07-31 00:00:00 | 2017-08-02 00:00:00 | 2019-01-04 00:00:00 | 2018-10-31 00:00:00 | 2020-08-14 00:00:00 | 2019-08-09 00:00:00 | 2018-07-18 00:00:00 | 2020-04-09 00:00:00 | 2018-04-28 00:00:00 | 2018-04-28 00:00:00 | 2020-07-29 00:00:00 | 2019-06-10 00:00:00 | 2020-12-29 00:00:00 | 2018-03-15 00:00:00 | 2020-05-29 00:00:00 | 2020-04-29 00:00:00 | 2020-10-08 00:00:00 | 2018-05-01 00:00:00 | 2018-05-01 00:00:00 | 2020-04-15 00:00:00 | 2018-06-01 00:00:00 | 2018-05-31 00:00:00 | 2018-03-14 00:00:00 | 2020-09-22 00:00:00 | 2022-03-31 00:00:00 | 2022-01-28 00:00:00 | 2021-06-30 00:00:00 | 2022-06-03 00:00:00 | 2022-02-01 00:00:00 | 2021-10-26 00:00:00 | 2022-06-06 00:00:00 | 2022-02-10 00:00:00 | 2022-04-29 00:00:00 | 2020-10-08 00:00:00 | 2020-10-30 00:00:00 | 2022-03-31 00:00:00 | 2022-02-28 00:00:00 | 2022-01-28 00:00:00 | 2022-01-28 00:00:00 | 2022-03-31 00:00:00 | 2021-10-29 00:00:00 | 2021-07-29 00:00:00 | 2022-07-29 00:00:00 | 2021-06-29 00:00:00 | 2021-10-25 00:00:00 | 2022-03-01 00:00:00 | 2021-04-29 00:00:00 | 2022-01-31 00:00:00 | 2022-10-17 00:00:00 | 2022-10-29 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_type | 10005 | 10005 | 10001 | 10001 | 10001 | 10005 | 10005 | 10001 | 10002 | 10002 | 10002 | 10002 | 10002 | 10005 | 10001 | 10006 | 10006 | 10002 | 10001 | 10001 | 10001 | 10001 | 10002 | 10005 | 10001 | 10001 | 10001 | 10005 | 10006 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10006 | 10001 | 10006 | 10001 | 10001 | 10006 | 10005 | 10001 | 10006 | 10002 | 10006 | 10001 | 10001 | 10005 | 10001 | 10005 | 10001 | 10001 | 10001 | 10005 | 10002 | 10001 | 10002 | 10002 | 10001 | 10005 | 10001 | 10001 | 10002 | 10002 | 10001 | 10001 | 10005 | 10001 | 10005 | 10005 | 10001 | 10002 | 10006 | 10002 | 10005 | 10005 | 10002 | 10001 | 10005 | 10002 | 10001 | 10002 | 10002 | 10001 | 10005 | 10002 | 10002 | 10001 | 10001 | 10005 | 10001 | 10002 | 10006 | 10005 | 10001 | 10002 | 10002 | 10005 | 10002 | 10001 | 10002 | 10005 | 10002 | 10006 | 10001 | 10001 | 10001 | 10001 | 10006 | 10005 | 10001 | 10002 | 10002 | 10002 | 10005 | 10002 | 10001 | 10001 | 10005 | 10001 | 10002 | 10005 | 10001 | 10002 | 10002 | 10002 | 10002 | 10006 | 10006 | 10006 | 10002 | 10002 | 10001 | 10002 | 10002 | 10002 | 10005 | 10005 | 10002 | 10001 | 10002 | 10001 | 10002 | 10002 | 10002 | 10002 | 10002 | 10001 | 10001 | 10001 | 10002 | 10002 | 10002 | 10001 | 10002 | 10002 | 10001 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_status | 11001 | 11001 | 11003 | 11003 | 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 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
session_id | 2005 | 2005 | 2005 | 2005 | 2007 | 2007 | 2007 | 2005 | 2011 | 2011 | 2011 | 2011 | 2013 | 2011 | 2013 | 2013 | 2013 | 2011 | 2013 | 2013 | 2013 | 2013 | 2013 | 2011 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2011 | 2009 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2013 | 2013 | 2013 | 2013 | 2011 | 2013 | 2011 | 2013 | 2013 | 2015 | 2015 | 2015 | 2019 | 2019 | 2019 | 2017 | 2021 | 2017 | 2019 | 2019 | 2019 | 2017 | 2019 | 2019 | 2019 | 2017 | 2017 | 2019 | 2019 | 2017 | 2017 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2017 | 2017 | 2015 | 2017 | 2017 | 2017 | 2015 | 2015 | 2017 | 2017 | 2015 | 2017 | 2015 | 2017 | 2017 | 2017 | 2017 | 2019 | 2017 | 2017 | 2017 | 2019 | 2019 | 2017 | 2019 | 2017 | 2017 | 2019 | 2019 | 2021 | 2017 | 2019 | 2019 | 2019 | 2017 | 2017 | 2019 | 2017 | 2017 | 2017 | 2019 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2019 | 2019 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
user_id | CFLAGG | CFLAGG | * | * | YRODRIGU | CFLAGG | CFLAGG | YRODRIGU | ASAETERN | ASAETERN | ASAETERN | ASAETERN | ASAETERN | YRODRIGU | ASAETERN | YRODRIGU | YRODRIGU | ASAETERN | YRODRIGU | ASAETERN | ASAETERN | YRODRIGU | YRODRIGU | NLANDERS | YRODRIGU | YRODRIGU | YRODRIGU | JVAZQUEZ | YRODRIGU | YRODRIGU | YRODRIGU | YRODRIGU | CFLAGG | ASAETERN | ASAETERN | YRODRIGU | ASAETERN | ASAETERN | ASAETERN | YRODRIGU | ASAETERN | YRODRIGU | ASAETERN | ASAETERN | YRODRIGU | YRODRIGU | AGLADNEY | YRODRIGU | YRODRIGU | PBANFORD | ASAETERN | ASAETERN | YRODRIGU | ASAETERN | SARRIAGA | ASAETERN | AGLADNEY | YRODRIGU | YRODRIGU | GPEREZ | DMCCASTL | SARRIAGA | AGLADNEY | CVANLIEW | GPEREZ | MKIRKHAM | AGLADNEY | MMERCHANT | YRODRIGU | AGLADNEY | GPEREZ | SARRIAGA | AGLADNEY | YRODRIGU | GPEREZ | AGLADNEY | GPEREZ | YRODRIGU | GPEREZ | GPEREZ | GPEREZ | GPEREZ | AGLADNEY | GPEREZ | GPEREZ | AGLADNEY | AGLADNEY | GPEREZ | AGLADNEY | GPEREZ | YRODRIGU | YRODRIGU | AGLADNEY | AGLADNEY | GPEREZ | YRODRIGU | GPEREZ | YRODRIGU | YRODRIGU | AGLADNEY | YRODRIGU | AGLADNEY | GPEREZ | YRODRIGU | AGLADNEY | AGLADNEY | GPEREZ | GPEREZ | YRODRIGU | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | YRODRIGU | GPEREZ | AGLADNEY | GPEREZ | SARRIAGA | GPEREZ | GPEREZ | AGLADNEY | AGLADNEY | MKIRKHAM | GPEREZ | CVANLIEW | YRODRIGU | SARRIAGA | MKIRKHAM | CAFILER | AGLADNEY | AGLADNEY | GPEREZ | YRODRIGU | YRODRIGU | YRODRIGU | MMERCHANT | CHATRIDGE | CHATRIDGE | CVANLIEW | SARRIAGA | CVANLIEW | SARRIAGA | SARRIAGA | CAFILER | CAFILER | CAFILER | MKIRKHAM | CHATRIDGE | CVANLIEW | MKIRKHAM | CHATRIDGE | CAFILER | CHATRIDGE | MKIRKHAM | CAFILER | CVANLIEW | SARRIAGA | CVANLIEW | MKIRKHAM | CVANLIEW | CAFILER | CAFILER | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
special_audit | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 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 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 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 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_start | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2006-04-01 00:00:00 | 2006-07-01 00:00:00 | 2006-12-29 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2006-10-01 00:00:00 | 2011-10-01 00:00:00 | 2012-01-01 00:00:00 | 2012-04-01 00:00:00 | 2012-07-01 00:00:00 | 2013-01-01 00:00:00 | 1900-01-01 00:00:00 | 2013-04-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2011-07-01 00:00:00 | 2014-07-31 00:00:00 | 2014-01-01 00:00:00 | 2013-07-01 00:00:00 | 2012-12-31 00:00:00 | 2014-01-02 00:00:00 | 2011-01-01 00:00:00 | 2008-12-31 00:00:00 | 2009-04-01 00:00:00 | 2009-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2009-10-01 00:00:00 | 2009-07-01 00:00:00 | 2009-07-31 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-01-01 00:00:00 | 2011-04-01 00:00:00 | 1900-01-01 00:00:00 | 2011-07-01 00:00:00 | 1900-01-01 00:00:00 | 2011-10-01 00:00:00 | 2012-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2012-04-01 00:00:00 | 1900-01-01 00:00:00 | 2014-01-31 00:00:00 | 1900-01-01 00:00:00 | 2013-10-01 00:00:00 | 2012-07-01 00:00:00 | 1900-01-01 00:00:00 | 2012-10-01 00:00:00 | 1900-01-01 00:00:00 | 2013-01-01 00:00:00 | 2015-07-01 00:00:00 | 2015-08-11 00:00:00 | 1900-01-01 00:00:00 | 2019-06-03 00:00:00 | 1900-01-01 00:00:00 | 2020-05-07 00:00:00 | 2017-07-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2020-10-01 00:00:00 | 2019-10-01 00:00:00 | 2020-09-08 00:00:00 | 2017-11-15 00:00:00 | 2019-01-01 00:00:00 | 2018-12-31 00:00:00 | 1900-01-01 00:00:00 | 2018-10-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2019-07-01 00:00:00 | 2017-09-13 00:00:00 | 1900-01-01 00:00:00 | 2016-02-18 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2016-02-18 00:00:00 | 2015-10-01 00:00:00 | 1900-01-01 00:00:00 | 2016-02-03 00:00:00 | 2016-01-01 00:00:00 | 2015-10-01 00:00:00 | 2016-04-05 00:00:00 | 2016-04-01 00:00:00 | 1900-01-01 00:00:00 | 2016-10-05 00:00:00 | 2016-11-10 00:00:00 | 2016-07-01 00:00:00 | 2016-10-01 00:00:00 | 1900-01-01 00:00:00 | 2016-11-10 00:00:00 | 2017-01-18 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2017-04-01 00:00:00 | 2017-07-14 00:00:00 | 2016-10-01 00:00:00 | 1900-01-01 00:00:00 | 2017-04-24 00:00:00 | 2017-01-01 00:00:00 | 2016-07-01 00:00:00 | 1900-01-01 00:00:00 | 2017-06-05 00:00:00 | 1900-01-01 00:00:00 | 2017-07-01 00:00:00 | 2017-10-01 00:00:00 | 2018-04-01 00:00:00 | 2019-04-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2018-07-01 00:00:00 | 2020-07-30 00:00:00 | 2019-08-01 00:00:00 | 2018-07-18 00:00:00 | 1900-01-01 00:00:00 | 2017-10-01 00:00:00 | 2018-01-01 00:00:00 | 2020-04-01 00:00:00 | 1900-01-01 00:00:00 | 2021-01-01 00:00:00 | 2018-03-05 00:00:00 | 1900-01-01 00:00:00 | 2020-01-01 00:00:00 | 2020-01-01 00:00:00 | 2017-10-01 00:00:00 | 2018-01-01 00:00:00 | 2020-03-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2021-10-01 00:00:00 | 2021-10-01 00:00:00 | 1900-01-01 00:00:00 | 2022-05-17 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2021-01-01 00:00:00 | 2022-01-01 00:00:00 | 2020-04-01 00:00:00 | 2020-07-01 00:00:00 | 2021-07-01 00:00:00 | 2022-02-14 00:00:00 | 2021-04-01 00:00:00 | 2021-07-01 00:00:00 | 2021-04-01 00:00:00 | 2021-07-01 00:00:00 | 2021-04-01 00:00:00 | 2022-04-01 00:00:00 | 2021-06-17 00:00:00 | 2021-10-19 00:00:00 | 1900-01-01 00:00:00 | 2021-01-01 00:00:00 | 2022-01-26 00:00:00 | 2022-10-12 00:00:00 | 2022-07-01 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_end | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2006-06-30 00:00:00 | 2006-09-30 00:00:00 | 2006-12-29 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2006-12-31 00:00:00 | 2011-12-31 00:00:00 | 2012-03-31 00:00:00 | 2012-06-30 00:00:00 | 2012-09-30 00:00:00 | 2013-03-31 00:00:00 | 1900-01-01 00:00:00 | 2013-06-30 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2011-09-30 00:00:00 | 2014-07-31 00:00:00 | 2014-03-31 00:00:00 | 2013-09-30 00:00:00 | 2012-12-31 00:00:00 | 2014-01-02 00:00:00 | 2012-12-31 00:00:00 | 2008-12-31 00:00:00 | 2009-06-30 00:00:00 | 2009-03-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2009-12-31 00:00:00 | 2009-09-30 00:00:00 | 2009-09-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-03-31 00:00:00 | 2011-06-30 00:00:00 | 1900-01-01 00:00:00 | 2011-09-30 00:00:00 | 1900-01-01 00:00:00 | 2011-12-31 00:00:00 | 2012-03-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2012-06-30 00:00:00 | 1900-01-01 00:00:00 | 2014-01-31 00:00:00 | 1900-01-01 00:00:00 | 2013-12-31 00:00:00 | 2012-09-30 00:00:00 | 1900-01-01 00:00:00 | 2012-12-31 00:00:00 | 1900-01-01 00:00:00 | 2013-03-31 00:00:00 | 2015-09-30 00:00:00 | 2015-08-11 00:00:00 | 1900-01-01 00:00:00 | 2019-06-03 00:00:00 | 1900-01-01 00:00:00 | 2020-05-07 00:00:00 | 2017-09-30 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2020-12-31 00:00:00 | 2019-12-31 00:00:00 | 2020-09-08 00:00:00 | 2017-11-15 00:00:00 | 2019-03-31 00:00:00 | 2018-12-31 00:00:00 | 1900-01-01 00:00:00 | 2018-12-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2019-09-30 00:00:00 | 2017-09-13 00:00:00 | 1900-01-01 00:00:00 | 2016-02-18 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2016-02-18 00:00:00 | 2015-12-31 00:00:00 | 1900-01-01 00:00:00 | 2016-02-03 00:00:00 | 2016-03-31 00:00:00 | 2015-12-31 00:00:00 | 2016-04-05 00:00:00 | 2016-06-30 00:00:00 | 1900-01-01 00:00:00 | 2016-10-05 00:00:00 | 2016-11-10 00:00:00 | 2016-09-30 00:00:00 | 2016-12-31 00:00:00 | 1900-01-01 00:00:00 | 2016-11-10 00:00:00 | 2017-01-18 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2017-06-30 00:00:00 | 2017-07-14 00:00:00 | 2016-12-31 00:00:00 | 1900-01-01 00:00:00 | 2017-04-24 00:00:00 | 2017-03-31 00:00:00 | 2016-09-30 00:00:00 | 1900-01-01 00:00:00 | 2017-06-05 00:00:00 | 1900-01-01 00:00:00 | 2017-09-30 00:00:00 | 2017-12-31 00:00:00 | 2018-06-30 00:00:00 | 2019-06-30 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2018-09-30 00:00:00 | 2020-07-30 00:00:00 | 2019-08-01 00:00:00 | 2018-07-18 00:00:00 | 1900-01-01 00:00:00 | 2017-12-31 00:00:00 | 2018-03-31 00:00:00 | 2020-06-30 00:00:00 | 1900-01-01 00:00:00 | 2021-01-01 00:00:00 | 2018-03-05 00:00:00 | 1900-01-01 00:00:00 | 2020-03-31 00:00:00 | 2020-03-31 00:00:00 | 2017-12-31 00:00:00 | 2018-03-31 00:00:00 | 2020-03-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2021-12-31 00:00:00 | 2021-12-31 00:00:00 | 1900-01-01 00:00:00 | 2022-05-17 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2021-03-31 00:00:00 | 2022-03-31 00:00:00 | 2020-06-30 00:00:00 | 2020-09-30 00:00:00 | 2021-09-30 00:00:00 | 2022-02-14 00:00:00 | 2021-06-30 00:00:00 | 2021-09-30 00:00:00 | 2021-06-30 00:00:00 | 2021-09-30 00:00:00 | 2021-06-30 00:00:00 | 2022-06-30 00:00:00 | 2021-06-17 00:00:00 | 2021-10-19 00:00:00 | 1900-01-01 00:00:00 | 2021-03-31 00:00:00 | 2022-01-26 00:00:00 | 2022-10-12 00:00:00 | 2022-09-30 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_date | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | 22006 | 22006 | 22006 | None | None | 22006 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | None | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22006 | 22006 | 22006 | None | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | None | 22006 | None | 22006 | 22006 | None | None | 22006 | None | 22001 | None | 22001 | 22006 | None | 22006 | None | 22006 | 22001 | 22001 | None | 22001 | None | 22001 | 22001 | None | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | None | None | 22001 | 22001 | None | 22001 | None | None | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | None | None | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | None | 22001 | None | 22001 | 22001 | 22001 | 22001 | None | None | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | None | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | None | None | None | None | 22001 | 22001 | None | 22001 | None | None | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 |
filer_id | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_type | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | |||||||||||
active | Y | T | Y | Y | Y | W | Y | Y | Y | Y | N | |||||||||||
race | 0 | 0 | None | None | 0 | None | None | None | None | None | None | |||||||||||
session_id | 2005 | 2005 | 2011 | 2013 | 2009 | 2013 | 2015 | 2021 | 2017 | 2019 | 2023 | |||||||||||
category | 0 | 0 | None | None | 0 | None | None | None | None | None | None | |||||||||||
category_type | 0 | 0 | None | None | 0 | None | None | None | None | None | None | |||||||||||
sub_category | 0 | 0 | None | None | 0 | None | None | None | None | None | None | |||||||||||
effect_dt | 2006-04-01 00:00:00 | 2006-12-31 00:00:00 | 2011-01-01 00:00:00 | 2013-01-01 00:00:00 | 2009-01-01 00:00:00 | 2013-01-02 00:00:00 | 2015-08-10 00:00:00 | 2021-01-01 00:00:00 | 2017-01-01 00:00:00 | 2019-01-01 00:00:00 | 2023-01-01 00:00:00 | |||||||||||
sub_category_type | 0 | 0 | None | None | 0 | None | None | None | None | None | None | |||||||||||
election_type | 0 | 0 | None | None | 0 | None | None | None | None | None | None | |||||||||||
sub_category_a | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
nyq_dt | 2006-04-01 00:00:00 | 2006-04-01 00:00:00 | None | None | 2006-04-01 00:00:00 | None | None | None | None | None | None | |||||||||||
party_cd | 0 | 0 | None | None | 0 | None | None | None | None | None | None | |||||||||||
county_cd | 0 | 0 | None | None | 0 | None | None | None | None | None | None | |||||||||||
district_cd | 0 | 0 | None | None | 0 | None | None | None | None | None | None |
filer_id | 1285845 | |
---|---|---|
xref_id | 1285845 | |
effect_dt | 2006-04-27 00:00:00 | |
migration_source | CLAIMS |
xref_filer_id | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_id | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filer_type | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
effect_dt | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
naml | BEST BEST & KRIEGER | BEST BEST & KRIEGER | BEST BEST & KRIEGER | BEST BEST & KRIEGER | BEST BEST & KRIEGER | BEST BEST & KRIEGER | BEST BEST & KRIEGER | BEST BEST & KRIEGER | BEST BEST & KRIEGER | BEST BEST & KRIEGER | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER | BEST BEST & KRIEGER | BEST BEST & KRIEGER | BEST BEST & KRIEGER | BEST BEST & KRIEGER | BEST BEST & KRIEGER | BEST BEST & KRIEGER | BEST BEST & KRIEGER | BEST BEST & KRIEGER | BEST BEST & KRIEGER | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
namf | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
phon | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fax | None | None | 9163254010 | 9163254010 | 9163254010 | 9163254010 | 9163254010 | 9163254010 | 9163254010 | 9163254010 | None | None | 9163254010 | 9163254010 | 9163254010 | 9163254010 | 9163254010 | 9163254010 | 9163254010 | 9163254010 | None | None | 9163254010 | 9163254010 | 9163254010 | 9163254010 | 9163254010 | 9163254010 | 9163254010 | 9163254010 | None | None | 9163254010 | 9163254010 | 9163254010 | 9163254010 | 9163254010 | 9163254010 | 9163254010 | 9163254010 | None | None | 9163254010 | 9163254010 | 9163254010 | 9163254010 | 9163254010 | 9163254010 | 9163254010 | 9163254010 | None | None | 9163254010 | 9163254010 | 9163254010 | 9163254010 | 9163254010 | 9163254010 | 9163254010 | 9163254010 | None | None | 9163254010 | 9163254010 | 9163254010 | 9163254010 | 9163254010 | 9163254010 | 9163254010 | 9163254010 | None | None | 9163254010 | 9163254010 | 9163254010 | 9163254010 | 9163254010 | 9163254010 | 9163254010 | 9163254010 | None | None | 9163254010 | 9163254010 | 9163254010 | 9163254010 | 9163254010 | 9163254010 | 9163254010 | 9163254010 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
None | None | william.thomas@bbklaw.com | william.thomas@bbklaw.com | None | None | None | None | None | None | None | None | william.thomas@bbklaw.com | william.thomas@bbklaw.com | None | None | None | None | None | None | None | None | william.thomas@bbklaw.com | william.thomas@bbklaw.com | None | None | None | None | None | None | None | None | william.thomas@bbklaw.com | william.thomas@bbklaw.com | None | None | None | None | None | None | None | None | william.thomas@bbklaw.com | william.thomas@bbklaw.com | None | None | None | None | None | None | None | None | william.thomas@bbklaw.com | william.thomas@bbklaw.com | None | None | None | None | None | None | None | None | william.thomas@bbklaw.com | william.thomas@bbklaw.com | None | None | None | None | None | None | None | None | william.thomas@bbklaw.com | william.thomas@bbklaw.com | None | None | None | None | None | None | None | None | william.thomas@bbklaw.com | william.thomas@bbklaw.com | None | None | None | None | None | None |
filer_id | 1285845 |
---|
filer_id | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | ||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
change_no | 4 | 5 | 2 | 3 | 0 | 1 | 6 | 7 | 9 | 8 | 12 | 10 | 11 | 13 | 15 | 16 | 14 | 24 | 17 | 19 | 18 | 21 | 22 | 23 | 20 | 30 | 26 | 27 | 28 | 25 | 29 | 32 | 33 | 31 | ||||||||||||||||||||||||||||||||||
session_id | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2009 | 2009 | 2011 | 2011 | 2013 | 2011 | 2013 | 2013 | 2013 | 2013 | 2013 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2017 | 2015 | 2017 | 2017 | 2017 | 2017 | 2019 | 2019 | 2017 | ||||||||||||||||||||||||||||||||||
log_dt | 2007-01-05 00:00:00 | 2007-01-05 00:00:00 | 2006-04-26 00:00:00 | 2006-04-26 00:00:00 | 2006-04-26 00:00:00 | 2006-04-27 00:00:00 | 2009-03-12 00:00:00 | 2010-04-06 00:00:00 | 2011-11-15 00:00:00 | 2011-10-28 00:00:00 | 2014-02-03 00:00:00 | 2012-07-31 00:00:00 | 2014-01-02 00:00:00 | 2014-08-08 00:00:00 | 2014-08-08 00:00:00 | 2014-08-08 00:00:00 | 2014-08-08 00:00:00 | 2016-11-21 00:00:00 | 2015-08-21 00:00:00 | 2015-08-21 00:00:00 | 2015-08-21 00:00:00 | 2016-02-26 00:00:00 | 2016-02-22 00:00:00 | 2016-02-19 00:00:00 | 2016-05-06 00:00:00 | 2017-10-03 00:00:00 | 2017-06-22 00:00:00 | 2017-05-11 00:00:00 | 2017-05-11 00:00:00 | 2017-02-23 00:00:00 | 2017-08-02 00:00:00 | 2020-04-09 00:00:00 | 2020-08-18 00:00:00 | 2019-01-04 00:00:00 | ||||||||||||||||||||||||||||||||||
filer_type | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | ||||||||||||||||||||||||||||||||||
correction_flg | None | None | None | None | None | None | Y | Y | None | None | Y | None | None | None | None | None | None | None | Y | Y | Y | Y | Y | Y | Y | Y | None | Y | Y | Y | Y | None | None | None | ||||||||||||||||||||||||||||||||||
action | DELETED | TERMINATED | SET ACTIVE | SET ACTIVE | ADDED | IN SUSPENSE | ADDED | TERMINATED | SET ACTIVE | ADDED | DELETED | ADDED | DELETED | DELETED | DELETED | WITHDRAWAL | DELETED | SET ACTIVE | ADDED | ADDED | ADDED | ADDED | ADDED | ADDED | DELETED | ADDED | DELETED | ADDED | ADDED | ADDED | ADDED | DELETED | DELETED | SET ACTIVE | ||||||||||||||||||||||||||||||||||
attribute_changed | LOBBYIST | CLIENT | CLIENT | LOBBYIST | LOBBYIST | LOBBYIST | CLIENT | CLIENT | EMPLOYER | CLIENT | CLIENT | CLIENT | LOBBYIST | CLIENT | CLIENT | LOBBYIST | EMPLOYER | LOBBYIST | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | CLIENT | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | CLIENT | CLIENT | CLIENT | |||||||||||||||||||||||||||||||||||||
ethics_dt | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||
interests | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||
filer_full_name | BEST BEST & KRIEGER | BEST BEST & KRIEGER | BEST BEST & KRIEGER | BEST BEST & KRIEGER | BEST BEST & KRIEGER | BEST BEST & KRIEGER | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER | BEST BEST & KRIEGER | BEST BEST & KRIEGER | BEST BEST & KRIEGER | BEST BEST & KRIEGER | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | BEST BEST & KRIEGER LLP | ||||||||||||||||||||||||||||||||||
filer_city | None | None | None | None | None | None | SACRAMENTO | SACRAMENTO | None | None | None | None | None | None | None | None | None | None | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | None | None | None | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | None | None | None | ||||||||||||||||||||||||||||||||||
filer_st | None | None | None | None | None | None | CA | CA | None | None | None | None | None | None | None | None | None | None | CA | CA | CA | CA | CA | CA | None | None | None | CA | CA | CA | CA | None | None | None | ||||||||||||||||||||||||||||||||||
filer_zip | None | None | None | None | None | None | 95814 | 95814 | None | None | None | None | None | None | None | None | None | None | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | None | None | None | 95814 | 95814 | 95814 | 95814 | None | None | None | ||||||||||||||||||||||||||||||||||
filer_phone | None | None | None | None | None | None | 9163254000 | 9163254000 | None | None | None | None | None | None | None | None | None | None | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | 9163254000 | None | None | None | 9163254000 | 9163254000 | 9163254000 | 9163254000 | None | None | None | ||||||||||||||||||||||||||||||||||
entity_type | 4 | 3 | 1 | 1 | 4 | 3 | 4 | 4 | 1 | 1 | 2 | 1 | 1 | 1 | 4 | 3 | 1 | 1 | 4 | 2 | 4 | 2 | 2 | 2 | 2 | 2 | 1 | 2 | 2 | 2 | 2 | 1 | 1 | 1 | ||||||||||||||||||||||||||||||||||
entity_name | WILLIAM J. THOMAS | None | ALLIANCE OF THE METHYL BROMIDE INDUSTRY | SOUTHERN SAN JOAQUIN VALLEY WATER QUALITY COALITION | WILLIAM J. THOMAS | None | VAN RUITEN, ANTHONY J. | VAN RUITEN, ANTHONY J. | CALIFORNIA ASSOCIATION OF RESOURCE CONSERVATION DISTRICTS | CALIFORNIA ASSOCIATION OF RESOURCE CONSERVATION DISTRICTS | CALIFORNIA ASSOCIATION OF RESOURCE CONSERVATION DISTRICTS | SALTON SEA AUTHORITY | ALLIANCE OF THE METHYL BROMIDE INDUSTRY | SALTON SEA AUTHORITY | WILLIAM J. THOMAS | None | SOUTHERN SAN JOAQUIN VALLEY WATER QUALITY COALITION | LAS VIRGENES - TRIUNFO JOINT POWERS AUTHORITY | THOMAS, WILLIAM J. | SAN GORGONIO PASS WATER AGENCY | DEVERS, SYRUS | LOS ANGELES; COUNTY OF | MUNICIPAL WATER DISTRICT OF ORANGE COUNTY | FALCON WATERFREE TECHNOLOGIES | LOS ANGELES; COUNTY OF | WESTERN RIVERSIDE COUNCIL OF GOVERNMENTS | FALCON WATERFREE TECHNOLOGIES | PASO ROBLES; CITY OF | SACRAMENTO METROPOLITAN CABLE TV COMMISSION | ONTARIO; CITY OF | SANTA CLARA DBA SILICON VALLEY POWER; CITY OF | RANCHO GUEJITO CORPORATION | ELSINORE VALLEY MUNICIPAL WATER DISTRICT | OMNITRANS - SAN BERNARDINO COUNTY PUBLIC TRANSIT | ||||||||||||||||||||||||||||||||||
entity_city | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||
entity_st | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||
entity_zip | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||
entity_phone | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||
entity_id | 1147925 | 0 | 1145843 | 1256009 | 1147925 | 0 | None | None | 1143667 | 1143667 | 1143667 | 1277180 | 1145843 | 1277180 | 1147925 | 0 | 1256009 | 1392296 | None | None | None | None | None | None | 1146830 | 1333933 | 1298878 | None | None | None | None | 1411217 | 1146367 | 1415119 | ||||||||||||||||||||||||||||||||||
responsible_officer | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||
effect_dt | 2006-12-31 00:00:00 | 2006-12-31 00:00:00 | 2006-04-01 00:00:00 | 2006-04-01 00:00:00 | 2006-04-01 00:00:00 | 2006-04-01 00:00:00 | 2009-03-13 00:00:00 | 2010-03-31 00:00:00 | 2011-08-01 00:00:00 | 2011-08-01 00:00:00 | 2013-12-31 00:00:00 | 2012-04-01 00:00:00 | 2013-12-17 00:00:00 | 2013-01-01 00:00:00 | 2013-01-01 00:00:00 | 2013-01-02 00:00:00 | 2013-01-01 00:00:00 | 2016-10-01 00:00:00 | 2015-08-10 00:00:00 | 2015-08-10 00:00:00 | 2015-08-10 00:00:00 | 2016-01-15 00:00:00 | 2016-01-15 00:00:00 | 2016-01-18 00:00:00 | 2016-03-31 00:00:00 | 2017-09-12 00:00:00 | 2016-06-27 00:00:00 | 2017-04-14 00:00:00 | 2017-04-03 00:00:00 | 2017-01-10 00:00:00 | 2017-07-14 00:00:00 | 2020-01-31 00:00:00 | 2020-07-22 00:00:00 | 2018-11-28 00:00:00 |
filer_id | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | 1285845 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_file_name | 218388.cal | 218477.cal | 239716.cal | 1809129_2.cal | 1809129_0.cal | 1809129_1.cal | 158075.cal | 1986859_0.cal | 2115521_1.cal | 34289.cal | 122517.cal | 1986859_6.cal | 243361.cal | 1986859_1.cal | 242472.cal | 1986859_2.cal | 242192.cal | 391942.cal | 1986859_4.cal | 2115521_0.cal | 1986859_5.cal | 5393.cal | 6073.cal | 6290.cal | 1986859_7.cal | 2115521_3.cal | 309115.cal | 2115521_2.cal | 67003.cal | 490273.cal | 191030.cal | 490100.cal | 490058.cal | 2115521_5.cal | 2334523_0.cal | 241683.cal | 374928.cal | 2115521_4.cal | 105911.cal | 2334523_1.cal | 2334523_5.cal | 2334523_4.cal | 2334523_3.cal | 2115521_6.cal | 157169.cal | 2334523_2.cal | 2334523_6.cal | 2539033_4.cal | 2539033_1.cal | 2539033_2.cal | 2539033_0.cal | 2539033_5.cal | 518561.cal | 2539033_6.cal | 518395.cal | 2539033_3.cal | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
received_date | 2014-04-29 00:00:00 | 2014-04-29 00:00:00 | 2014-04-30 00:00:00 | 2014-01-31 00:00:00 | 2014-01-08 00:00:00 | 2014-01-08 00:00:00 | 2015-08-24 00:00:00 | 2015-08-24 00:00:00 | 2017-02-22 00:00:00 | 2017-01-30 00:00:00 | 2016-11-18 00:00:00 | 2016-11-18 00:00:00 | 2016-02-08 00:00:00 | 2016-02-08 00:00:00 | 2016-02-08 00:00:00 | 2016-02-19 00:00:00 | 2016-02-08 00:00:00 | 2016-02-19 00:00:00 | 2016-04-05 00:00:00 | 2016-12-29 00:00:00 | 2016-10-30 00:00:00 | 2016-05-02 00:00:00 | 2016-05-02 00:00:00 | 2016-05-02 00:00:00 | 2017-06-26 00:00:00 | 2017-08-02 00:00:00 | 2017-08-02 00:00:00 | 2017-06-06 00:00:00 | 2017-06-06 00:00:00 | 2017-05-01 00:00:00 | 2017-05-16 00:00:00 | 2017-05-01 00:00:00 | 2017-05-01 00:00:00 | 2017-11-30 00:00:00 | 2019-01-15 00:00:00 | 2018-07-31 00:00:00 | 2018-07-18 00:00:00 | 2017-10-10 00:00:00 | 2019-01-12 00:00:00 | 2019-06-11 00:00:00 | 2020-08-14 00:00:00 | 2020-06-03 00:00:00 | 2020-04-15 00:00:00 | 2018-03-15 00:00:00 | 2019-08-09 00:00:00 | 2019-08-09 00:00:00 | 2020-09-25 00:00:00 | 2022-02-28 00:00:00 | 2021-06-29 00:00:00 | 2021-10-25 00:00:00 | 2020-12-29 00:00:00 | 2022-06-03 00:00:00 | 2020-10-08 00:00:00 | 2022-10-17 00:00:00 | 2020-10-08 00:00:00 | 2022-01-31 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_directory | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /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/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /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/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/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_id | None | None | None | 1809129 | 1809129 | 1809129 | None | 1986859 | 2115521 | None | None | 1986859 | None | 1986859 | None | 1986859 | None | None | 1986859 | 2115521 | 1986859 | None | None | None | 1986859 | 2115521 | None | 2115521 | None | None | None | None | None | 2115521 | 2334523 | None | None | 2115521 | None | 2334523 | 2334523 | 2334523 | 2334523 | 2115521 | None | 2334523 | 2334523 | 2539033 | 2539033 | 2539033 | 2539033 | 2539033 | None | 2539033 | None | 2539033 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | None | None | None | F601 | F601 | F601 | None | F601 | F601 | None | None | F601 | None | F601 | None | F601 | None | None | F601 | F601 | F601 | None | None | None | F601 | F601 | None | F601 | None | None | None | None | None | F601 | F601 | None | None | F601 | None | F601 | F601 | F601 | F601 | F601 | None | F601 | F601 | F601 | F601 | F601 | F601 | F601 | None | F601 | None | F601 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
receive_comment | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing accepted | Filing accepted | Filing accepted | Filing passed validation, but failed DB constraints | Filing accepted | Filing accepted | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing accepted | Filing passed validation, but failed DB constraints | Filing accepted | Filing passed validation, but failed DB constraints | Filing accepted | Filing did not pass validation | Filing passed validation, but failed DB constraints | Filing accepted | Filing accepted | Filing accepted | Filing passed validation, but failed DB constraints | Filing did not pass validation | Filing did not pass validation | Filing accepted | Filing accepted | Filing did not pass validation | Filing accepted | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing did not pass validation | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing accepted | Filing accepted | Filing passed validation, but failed DB constraints | Filing did not pass validation | Filing accepted | Filing did not pass validation | 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 passed validation, but failed DB constraints | Filing accepted | Filing passed validation, but failed DB constraints | Filing accepted |