filing_id | 1261180 | 1280969 | 1280969 | 1261180 | 1261180 | 1328884 | 1293887 | 1306098 | 1349344 | 1306098 | 1374625 | 1452568 | 1437271 | 1420802 | 1396438 | 1452568 | 1437271 | 1506916 | 1484645 | 1463098 | 1569637 | 1539830 | 1607541 | 1621661 | 1591312 | 1635365 | 1707066 | 1677949 | 1656614 | 1735678 | 1798814 | 1779822 | 1764281 | 1815251 | 1867230 | 1843216 | 1909244 | 1994162 | 1978363 | 1964541 | 1937612 | 1937612 | 2060847 | 2033805 | 2009979 | 2100328 | 2157837 | 2130405 | 2177344 | 2177344 | 2188067 | 2240493 | 2273131 | 2211451 | 2317553 | 2380756 | 2391294 | 2345439 | 2443705 | 2470699 | 2443705 | 2420147 | 2529808 | 2553262 | 2482777 | 2624680 | 2602060 | 2529808 | 2553262 | 2581895 | 2470699 | 2482777 | 2646019 | 2678378 | 2708915 | 2678378 | 2708915 | 2749700 | 2624680 | 2646019 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
amend_id | 2 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | 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 | F625 | F625 | F625 | F625 | F625 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
sender_id | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filer_id | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | FRM | FRM | FRM | FRM | FRM | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filer_naml | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | HOUSING ADVOCATES | HOUSING ADVOCATES | HOUSING ADVOCATES | HOUSING ADVOCATES | HOUSING ADVOCATES | HOUSING ADVOCATES | HOUSING ADVOCATES | HOUSING ADVOCATES | HOUSING ADVOCATES | HOUSING ADVOCATES | HOUSING ADVOCATES | HOUSING ADVOCATES | HOUSING ADVOCATES | HOUSING ADVOCATES | PUBLIC INTEREST ADVOCATES | HOUSING ADVOCATES | HOUSING ADVOCATES | PUBLIC INTEREST ADVOCATES | PUBLIC INTEREST ADVOCATES | PUBLIC INTEREST ADVOCATES | PUBLIC INTEREST ADVOCATES | PUBLIC INTEREST ADVOCATES | PUBLIC INTEREST ADVOCATES | PUBLIC INTEREST ADVOCATES | PUBLIC INTEREST ADVOCATES | PUBLIC INTEREST ADVOCATES | PUBLIC INTEREST ADVOCATES | PUBLIC INTEREST ADVOCATES | PUBLIC INTEREST ADVOCATES | PUBLIC INTEREST ADVOCATES | PUBLIC INTEREST ADVOCATES | PUBLIC INTEREST ADVOCATES | PUBLIC INTEREST ADVOCATES | PUBLIC INTEREST ADVOCATES | PUBLIC INTEREST ADVOCATES | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | 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 | 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 | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
report_num | 002 | 001 | 000 | 000 | 001 | 000 | 000 | 001 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 001 | 001 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 001 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 001 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 001 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 001 | 001 | 000 | 001 | 001 | 000 | 000 | 000 | 001 | 001 | 000 | 001 | 001 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_date | 2007-09-04 00:00:00 | 2007-09-04 00:00:00 | 2007-07-26 00:00:00 | 2007-04-29 00:00:00 | 2007-05-03 00:00:00 | 2008-04-29 00:00:00 | 2007-10-22 00:00:00 | 2008-04-17 00:00:00 | 2008-07-30 00:00:00 | 2008-01-24 00:00:00 | 2008-10-29 00:00:00 | 2009-11-01 00:00:00 | 2009-07-30 00:00:00 | 2009-04-30 00:00:00 | 2009-01-31 00:00:00 | 2010-01-22 00:00:00 | 2010-01-22 00:00:00 | 2010-07-31 00:00:00 | 2010-04-29 00:00:00 | 2010-01-29 00:00:00 | 2011-01-29 00:00:00 | 2010-10-31 00:00:00 | 2011-07-31 00:00:00 | 2011-10-30 00:00:00 | 2011-05-01 00:00:00 | 2012-01-30 00:00:00 | 2012-10-29 00:00:00 | 2012-07-30 00:00:00 | 2012-04-29 00:00:00 | 2013-01-30 00:00:00 | 2013-10-29 00:00:00 | 2013-07-29 00:00:00 | 2013-04-30 00:00:00 | 2014-01-29 00:00:00 | 2014-07-28 00:00:00 | 2014-04-29 00:00:00 | 2014-10-30 00:00:00 | 2015-10-26 00:00:00 | 2015-07-28 00:00:00 | 2015-04-29 00:00:00 | 2015-02-03 00:00:00 | 2015-02-02 00:00:00 | 2016-07-28 00:00:00 | 2016-04-27 00:00:00 | 2016-01-29 00:00:00 | 2016-10-29 00:00:00 | 2017-05-01 00:00:00 | 2017-01-31 00:00:00 | 2017-07-31 00:00:00 | 2017-10-17 00:00:00 | 2017-10-17 00:00:00 | 2018-04-30 00:00:00 | 2018-07-30 00:00:00 | 2018-01-31 00:00:00 | 2018-10-30 00:00:00 | 2019-04-30 00:00:00 | 2019-07-19 00:00:00 | 2019-01-30 00:00:00 | 2020-03-11 00:00:00 | 2020-04-30 00:00:00 | 2020-01-31 00:00:00 | 2019-10-31 00:00:00 | 2020-11-01 00:00:00 | 2021-02-01 00:00:00 | 2020-07-29 00:00:00 | 2021-11-01 00:00:00 | 2021-08-01 00:00:00 | 2021-07-06 00:00:00 | 2021-07-06 00:00:00 | 2021-04-30 00:00:00 | 2021-07-06 00:00:00 | 2021-07-06 00:00:00 | 2022-01-31 00:00:00 | 2022-05-02 00:00:00 | 2022-08-01 00:00:00 | 2022-10-30 00:00:00 | 2022-10-31 00:00:00 | 2022-10-31 00:00:00 | 2022-10-29 00:00:00 | 2022-10-30 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
from_date | 2007-01-01 00:00:00 | 2007-04-01 00:00:00 | 2007-04-01 00:00:00 | 2007-01-01 00:00:00 | 2007-01-01 00:00:00 | 2008-01-01 00:00:00 | 2007-07-01 00:00:00 | 2007-10-01 00:00:00 | 2008-04-01 00:00:00 | 2007-10-01 00:00:00 | 2008-07-01 00:00:00 | 2009-07-01 00:00:00 | 2009-04-01 00:00:00 | 2009-01-01 00:00:00 | 2008-10-01 00:00:00 | 2009-07-01 00:00:00 | 2009-04-01 00:00:00 | 2010-04-01 00:00:00 | 2010-01-01 00:00:00 | 2009-10-01 00:00:00 | 2010-10-01 00:00:00 | 2010-07-01 00:00:00 | 2011-04-01 00:00:00 | 2011-07-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 | 2013-07-01 00:00:00 | 2013-04-01 00:00:00 | 2013-01-01 00:00:00 | 2013-10-01 00:00:00 | 2014-04-01 00:00:00 | 2014-01-01 00:00:00 | 2014-07-01 00:00:00 | 2015-07-01 00:00:00 | 2015-04-01 00:00:00 | 2015-01-01 00:00:00 | 2014-10-01 00:00:00 | 2014-10-01 00:00:00 | 2016-04-01 00:00:00 | 2016-01-01 00:00:00 | 2015-10-01 00:00:00 | 2016-07-01 00:00:00 | 2017-01-01 00:00:00 | 2016-10-01 00:00:00 | 2017-04-01 00:00:00 | 2017-04-01 00:00:00 | 2017-07-01 00:00:00 | 2018-01-01 00:00:00 | 2018-04-01 00:00:00 | 2017-10-01 00:00:00 | 2018-07-01 00:00:00 | 2019-01-01 00:00:00 | 2019-04-01 00:00:00 | 2018-10-01 00:00:00 | 2019-10-01 00:00:00 | 2020-01-01 00:00:00 | 2019-10-01 00:00:00 | 2019-07-01 00:00:00 | 2020-07-01 00:00:00 | 2020-10-01 00:00:00 | 2020-04-01 00:00:00 | 2021-07-01 00:00:00 | 2021-04-01 00:00:00 | 2020-07-01 00:00:00 | 2020-10-01 00:00:00 | 2021-01-01 00:00:00 | 2020-01-01 00:00:00 | 2020-04-01 00:00:00 | 2021-10-01 00:00:00 | 2022-01-01 00:00:00 | 2022-04-01 00:00:00 | 2022-01-01 00:00:00 | 2022-04-01 00:00:00 | 2022-07-01 00:00:00 | 2021-07-01 00:00:00 | 2021-10-01 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
thru_date | 2007-03-31 00:00:00 | 2007-06-30 00:00:00 | 2007-06-30 00:00:00 | 2007-03-31 00:00:00 | 2007-03-31 00:00:00 | 2008-03-31 00:00:00 | 2007-09-30 00:00:00 | 2007-12-31 00:00:00 | 2008-06-30 00:00:00 | 2007-12-31 00:00:00 | 2008-09-30 00:00:00 | 2009-06-30 00:00:00 | 2009-06-30 00:00:00 | 2009-03-31 00:00:00 | 2008-12-31 00:00:00 | 2009-09-30 00:00:00 | 2009-06-30 00:00:00 | 2010-06-30 00:00:00 | 2010-03-31 00:00:00 | 2009-12-31 00:00:00 | 2010-12-31 00:00:00 | 2010-09-30 00:00:00 | 2011-06-30 00:00:00 | 2011-09-30 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 | 2013-09-30 00:00:00 | 2013-06-30 00:00:00 | 2013-03-31 00:00:00 | 2013-12-31 00:00:00 | 2014-06-30 00:00:00 | 2014-03-31 00:00:00 | 2014-09-30 00:00:00 | 2015-09-30 00:00:00 | 2015-06-30 00:00:00 | 2015-03-31 00:00:00 | 2014-12-31 00:00:00 | 2014-12-31 00:00:00 | 2016-06-30 00:00:00 | 2016-03-31 00:00:00 | 2015-12-31 00:00:00 | 2016-09-30 00:00:00 | 2017-03-31 00:00:00 | 2016-12-31 00:00:00 | 2017-06-30 00:00:00 | 2017-06-30 00:00:00 | 2017-09-30 00:00:00 | 2018-03-31 00:00:00 | 2018-06-30 00:00:00 | 2017-12-31 00:00:00 | 2018-09-30 00:00:00 | 2019-03-31 00:00:00 | 2019-06-30 00:00:00 | 2018-12-31 00:00:00 | 2019-12-31 00:00:00 | 2020-03-31 00:00:00 | 2019-12-31 00:00:00 | 2019-09-30 00:00:00 | 2020-09-30 00:00:00 | 2020-12-31 00:00:00 | 2020-06-30 00:00:00 | 2021-09-30 00:00:00 | 2021-06-30 00:00:00 | 2020-09-30 00:00:00 | 2020-12-31 00:00:00 | 2021-03-31 00:00:00 | 2020-03-31 00:00:00 | 2020-06-30 00:00:00 | 2021-12-31 00:00:00 | 2022-03-31 00:00:00 | 2022-06-30 00:00:00 | 2022-03-31 00:00:00 | 2022-06-30 00:00:00 | 2022-09-30 00:00:00 | 2021-09-30 00:00:00 | 2021-12-31 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
cum_beg_dt | 2007-01-01 00:00:00 | 2007-01-01 00:00:00 | 2007-01-01 00:00:00 | 2007-01-01 00:00:00 | 2007-01-01 00:00:00 | 2007-01-01 00:00:00 | 2007-01-01 00:00:00 | 2007-01-01 00:00:00 | 2007-01-01 00:00:00 | 2007-01-01 00:00:00 | 2007-01-01 00:00:00 | 2009-01-01 00:00:00 | 2009-01-01 00:00:00 | 2009-01-01 00:00:00 | 2007-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 | 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 | 2012-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 | 2013-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 | 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 | 2017-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 | 2019-01-01 00:00:00 | 2019-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 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2021-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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
firm_id | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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_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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | 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 | 95814 | 95814 | 95814 | 95814 | 95814 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
firm_phon | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164003136 | 9164003136 | 9164003136 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | 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 | 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 | 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 | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
sig_date | 2007-09-04 00:00:00 | 2007-09-04 00:00:00 | 2007-07-16 00:00:00 | 2007-04-27 00:00:00 | 2007-05-03 00:00:00 | 2008-04-28 00:00:00 | 2007-10-21 00:00:00 | 2008-04-17 00:00:00 | 2008-07-25 00:00:00 | 2008-01-20 00:00:00 | 2008-10-26 00:00:00 | 2009-10-25 00:00:00 | 2009-07-28 00:00:00 | 2009-04-27 00:00:00 | 2009-01-25 00:00:00 | 2010-01-22 00:00:00 | 2009-01-22 00:00:00 | 2010-07-24 00:00:00 | 2010-04-25 00:00:00 | 2010-01-22 00:00:00 | 2011-01-29 00:00:00 | 2010-10-25 00:00:00 | 2011-07-28 00:00:00 | 2011-10-28 00:00:00 | 2011-04-29 00:00:00 | 2012-01-30 00:00:00 | 2012-10-29 00:00:00 | 2012-07-22 00:00:00 | 2012-04-25 00:00:00 | 2013-01-23 00:00:00 | 2013-10-28 00:00:00 | 2013-07-29 00:00:00 | 2013-04-30 00:00:00 | 2014-01-29 00:00:00 | 2014-07-21 00:00:00 | 2014-04-29 00:00:00 | 2014-10-30 00:00:00 | 2015-10-25 00:00:00 | 2015-07-26 00:00:00 | 2015-04-25 00:00:00 | 2015-02-03 00:00:00 | 2015-01-29 00:00:00 | 2016-07-15 00:00:00 | 2016-04-25 00:00:00 | 2016-01-29 00:00:00 | 2016-10-28 00:00:00 | 2017-04-30 00:00:00 | 2017-01-31 00:00:00 | 2017-07-31 00:00:00 | 2017-10-17 00:00:00 | 2017-10-17 00:00:00 | 2018-04-30 00:00:00 | 2018-07-30 00:00:00 | 2018-01-31 00:00:00 | 2018-10-30 00:00:00 | 2019-04-30 00:00:00 | 2019-07-19 00:00:00 | 2019-01-30 00:00:00 | 2020-02-01 00:00:00 | 2020-04-25 00:00:00 | 2020-01-31 00:00:00 | 2019-10-31 00:00:00 | 2020-10-24 00:00:00 | 2021-01-31 00:00:00 | 2020-07-27 00:00:00 | 2021-10-31 00:00:00 | 2021-07-31 00:00:00 | 2021-07-06 00:00:00 | 2021-07-06 00:00:00 | 2021-04-26 00:00:00 | 2021-07-06 00:00:00 | 2021-07-06 00:00:00 | 2022-01-30 00:00:00 | 2022-05-01 00:00:00 | 2022-07-31 00:00:00 | 2022-10-28 00:00:00 | 2022-10-31 00:00:00 | 2022-10-31 00:00:00 | 2022-10-28 00:00:00 | 2022-10-28 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
sig_loc | 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 | 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 | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | AUGUSTA | AUGUSTA | Augusta | Augusta | AUGUSTA | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
sig_namf | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | BRIAN | BRIAN | Brian | Brian | BRIAN | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | 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 | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
prn_naml | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | AUGUSTA | AUGUSTA | Augusta | Augusta | AUGUSTA | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
prn_namf | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | BRIAN | BRIAN | Brian | Brian | BRIAN | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | 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 | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
sig_title | Owner | Owner | Owner | Owner | Owner | Owner | Owner | Owner | Owner | Owner | Owner | Owner | Owner | Owner | Owner | Owner | Owner | Legislative Advocate | Legislative Advocate | Owner | Owner | Owner | Owner | Owner | Owner | Owner | Owner | Owner | Legislative Advocate | Owner/Legilsative Advocate | Owner | Owner | Owner | Owner/Legislative Advocate | Owner | Owner | Owner | Owner | Owner | Owner | Owner | Owner | Owner | Owner | Owner | Owner | Owner | Owner | Owner | Owner | Owner | Owner | Owner | Owner | Owner | Owner | Owner | Owner | Legislative Advocate | Owner | Owner | Owner | Owner | Owner | Owner | Owner | Owner | OWNER | OWNER | Owner | Owner | OWNER | Owner | Owner | Owner | Owner | Owner | Owner | Owner | Owner | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | 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 | 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 | 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 | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
ctrib_n_cb | X | X | X | None | None | 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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_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 | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
lobby_n_cb | X | X | X | None | None | 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 | 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 | 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 | 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 | 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 | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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_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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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_id | 1386738 | 1554202 | 1717045 | 1918657 | 1918655 | 1918656 | 1922783 | 1922783 | 1922783 | 2120247 | 2332981 | 2558130 | 2558130 | 2558130 | 2558130 | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
amend_id | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 2 | 0 | 0 | 1 | 0 | 2 | 3 | |||||||||||||||
rec_type | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | |||||||||||||||
form_type | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | |||||||||||||||
sender_id | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | |||||||||||||||
filer_id | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | |||||||||||||||
entity_cd | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | FRM | |||||||||||||||
filer_naml | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | HOUSING ADVOCATES | AUGUSTA AND ASSOCIATES; BRIAN | HOUSING ADVOCATES | HOUSING ADVOCATES | PUBLIC INTEREST ADVOCATES | PUBLIC INTEREST ADVOCATES | PUBLIC INTEREST ADVOCATES | PUBLIC INTEREST ADVOCATES | |||||||||||||||
filer_namf | 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 | |||||||||||||||
filer_nams | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
report_num | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 001 | 002 | 000 | 000 | 001 | 000 | 002 | 003 | |||||||||||||||
rpt_date | 2008-12-30 00:00:00 | 2010-12-27 00:00:00 | 2012-12-13 00:00:00 | 2014-12-16 00:00:00 | 2014-12-16 00:00:00 | 2014-12-16 00:00:00 | 2015-01-04 00:00:00 | 2016-09-23 00:00:00 | 2016-09-23 00:00:00 | 2017-01-17 00:00:00 | 2019-01-08 00:00:00 | 2021-05-11 00:00:00 | 2021-02-16 00:00:00 | 2021-05-11 00:00:00 | 2021-11-12 00:00:00 | |||||||||||||||
ls_beg_yr | 2009 | 2011 | 2013 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2017 | 2019 | 2021 | 2021 | 2021 | 2021 | |||||||||||||||
ls_end_yr | 2010 | 2012 | 2014 | 2016 | 2016 | 2016 | 2016 | 2016 | 2016 | 2018 | 2020 | 2022 | 2022 | 2022 | 2022 | |||||||||||||||
qual_date | 2009-01-01 00:00:00 | 2011-01-01 00:00:00 | None | 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 | 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 | |||||||||||||||
eff_date | 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 | |||||||||||||||
bus_st | 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 | |||||||||||||||
bus_phon | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | |||||||||||||||
bus_fax | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
bus_email | 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 | |||||||||||||||
mail_st | 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 | |||||||||||||||
mail_phon | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
sig_date | 2008-12-15 00:00:00 | 2010-12-05 00:00:00 | 2013-12-13 00:00:00 | 2014-12-16 00:00:00 | 2014-12-16 00:00:00 | 2014-12-16 00:00:00 | 2014-12-16 00:00:00 | 2016-09-23 00:00:00 | 2016-09-23 00:00:00 | 2016-12-31 00:00:00 | 2018-12-31 00:00:00 | 2021-04-15 00:00:00 | 2021-01-01 00:00:00 | 2021-04-15 00:00:00 | 2021-11-12 00:00:00 | |||||||||||||||
sig_loc | None | None | None | None | None | None | None | Sacramento, CA | Sacramento, CA | None | None | Sacramento, CA | None | Sacramento, CA | Sacramento, CA | |||||||||||||||
sig_naml | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | AUGUSTA | Augusta | Augusta | |||||||||||||||
sig_namf | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | BRIAN | Brian | Brian | |||||||||||||||
sig_namt | 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 | |||||||||||||||
prn_naml | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | Augusta | AUGUSTA | Augusta | Augusta | |||||||||||||||
prn_namf | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | Brian | BRIAN | Brian | Brian | |||||||||||||||
prn_namt | 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 | |||||||||||||||
sig_title | Owner | Owner | Owner | Owner | Owner | Owner | Owner | Owner | Owner | Owner | Owner | Owner | OWNER | Owner | Owner | |||||||||||||||
stmt_firm | Brian Augusta and Associates | Brian Augusta and Associaties | Brian Augusta & Associates | Brian Augusta & Associates | Brian Augusta & Associates | Brian Augusta & Associates | Brian Augusta & Associates | Housing Advocates | Housing Advocates | Housing Advocates | Housing Advocates | PUBLIC INTEREST ADVOCATES | PUBLIC INTEREST ADVOCATES | PUBLIC INTEREST ADVOCATES | PUBLIC INTEREST ADVOCATES | |||||||||||||||
ind_cb | 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 | |||||||||||||||
trade_cb | 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 | |||||||||||||||
a_b_name | 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 | |||||||||||||||
a_b_st | 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 | |||||||||||||||
descrip_1 | 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 | |||||||||||||||
c_less50 | 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 | |||||||||||||||
ind_class | 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 | |||||||||||||||
bus_class | 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 | |||||||||||||||
auth_name | 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 | |||||||||||||||
auth_st | 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 | |||||||||||||||
lobby_int | 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 | |||||||||||||||
firm_name | 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 | |||||||||||||||
rencert_cb | 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 | |||||||||||||||
lby_reg_cb | 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 | |||||||||||||||
st_leg_yn | 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 | |||||||||||||||
lobby_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
l_firm_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None |
filer_id | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
adrid | 2117661 | 2159256 | 2204601 | 2225563 | 2412495 | 2546181 | 2507440 | 2465940 | 2277981 | 2379288 | 2338940 | |||||||||||
effect_dt | 2007-01-01 00:00:00 | 2009-01-01 00:00:00 | 2011-01-01 00:00:00 | 2012-01-18 00:00:00 | 2017-01-01 00:00:00 | 2023-01-01 00:00:00 | 2021-01-01 00:00:00 | 2019-01-01 00:00:00 | 2013-01-01 00:00:00 | 2015-11-02 00:00:00 | 2015-01-01 00:00:00 | |||||||||||
add_type | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | |||||||||||
session_id | 2007 | 2009 | 2011 | 2011 | 2017 | 2023 | 2021 | 2019 | 2013 | 2015 | 2015 |
filer_id | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 1255777 | 1237952 | 1261180 | 1261180 | 1280969 | 1306098 | 1298966 | 1293887 | 1779822 | 1789451 | 1964541 | 1968006 | 1968088 | 1867230 | 1798814 | 1937612 | 1945412 | 1937612 | 1918657 | 1909244 | 1328884 | 1306098 | 1261180 | 1280969 | 1315659 | 1349344 | 1374625 | 1386738 | 1420802 | 1408472 | 1396438 | 1437271 | 1452568 | 1452568 | 1437271 | 1463098 | 1484645 | 1506916 | 1539830 | 1569637 | 1560190 | 1554202 | 1585244 | 1586780 | 1591312 | 1624378 | 1635365 | 1607541 | 1621661 | 1641131 | 1656614 | 1677949 | 1825278 | 1815251 | 1918655 | 1918656 | 1922783 | 1707066 | 1717045 | 1878367 | 1728676 | 1735678 | 1843216 | 1764281 | 1994162 | 1978363 | 2002820 | 2188067 | 2177344 | 2553262 | 2377457 | 2488220 | 2365148 | 2018417 | 2024413 | 2024460 | 2009979 | 2033805 | 2043271 | 2060847 | 1922783 | 1922783 | 2088887 | 2088558 | 2100328 | 2088884 | 2120247 | 2130405 | 2157837 | 2136237 | 2177344 | 2240493 | 2345439 | 2420147 | 2391294 | 2443705 | 2482777 | 2380756 | 2473127 | 2461125 | 2461126 | 2470519 | 2470535 | 2558130 | 2470699 | 2529808 | 2553262 | 2558130 | 2209988 | 2332981 | 2317553 | 2273131 | 2211451 | 2443705 | 2589180 | 2529808 | 2558130 | 2581895 | 2470699 | 2695316 | 2482777 | 2708915 | 2613186 | 2558130 | 2655754 | 2624680 | 2646019 | 2678378 | 2630801 | 2602060 | 2678378 | 2646019 | 2753658 | 2624680 | 2749700 | 2708915 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
period_id | None | None | 189 | 189 | 190 | 192 | None | 191 | 214 | None | 221 | None | None | 218 | 215 | 220 | None | 220 | 220 | 219 | 193 | 192 | 189 | 190 | None | 194 | 195 | 196 | 197 | None | 196 | 198 | 198 | 199 | 198 | 200 | 201 | 202 | 203 | 204 | None | 204 | None | None | 205 | None | 208 | 206 | 207 | None | 209 | 210 | None | 216 | 220 | 220 | 221 | 211 | 212 | None | None | 212 | 217 | 213 | 223 | 222 | None | 231 | 230 | 244 | None | None | None | None | None | None | 224 | 225 | None | 226 | 227 | 227 | None | None | 227 | None | 229 | 228 | 229 | None | 230 | 233 | 236 | 239 | 238 | 240 | 242 | 237 | None | None | None | None | None | 246 | 241 | 243 | 244 | 246 | None | 237 | 235 | 234 | 232 | 240 | None | 243 | 245 | 245 | 241 | None | 242 | 250 | None | 248 | None | 247 | 248 | 249 | None | 246 | 249 | 248 | None | 247 | 251 | 250 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F605 | F601 | F625 | F625 | F625 | F625 | F605 | F625 | F625 | F605 | F625 | F605 | F605 | F625 | F625 | F625 | F601 | F625 | F601 | F625 | F625 | F625 | F625 | F625 | F605 | F625 | F625 | F601 | F625 | F601 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F601 | F601 | F602 | F605 | F625 | F605 | F625 | F625 | F625 | F605 | F625 | F625 | F605 | F625 | F601 | F601 | F601 | F625 | F601 | F605 | F601 | F625 | F625 | F625 | F625 | F625 | F605 | F625 | F625 | F625 | F605 | F605 | F601 | F605 | F605 | F605 | F625 | F625 | F602 | F625 | F601 | F601 | F605 | F605 | F625 | F605 | F601 | F625 | F625 | F601 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F625 | F605 | F605 | F605 | F605 | F605 | F601 | F625 | F625 | F625 | F601 | F605 | F601 | F625 | F625 | F625 | F625 | F601 | F625 | F601 | F625 | F625 | F605 | F625 | F625 | F605 | F601 | F605 | F625 | F625 | F625 | F605 | F625 | F625 | F625 | F605 | F625 | F625 | F625 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_sequence | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_date | 2007-03-02 00:00:00 | 2006-10-24 00:00:00 | 2007-05-03 00:00:00 | 2007-04-29 00:00:00 | 2007-07-26 00:00:00 | 2008-01-24 00:00:00 | 2007-11-08 00:00:00 | 2007-10-22 00:00:00 | 2013-07-29 00:00:00 | 2013-08-27 00:00:00 | 2015-04-29 00:00:00 | 2015-04-16 00:00:00 | 2015-04-16 00:00:00 | 2014-07-28 00:00:00 | 2013-10-29 00:00:00 | 2015-02-03 00:00:00 | 2015-01-06 00:00:00 | 2015-02-02 00:00:00 | 2014-12-16 00:00:00 | 2014-10-30 00:00:00 | 2008-04-29 00:00:00 | 2008-04-17 00:00:00 | 2007-09-04 00:00:00 | 2007-09-04 00:00:00 | 2008-02-14 00:00:00 | 2008-07-30 00:00:00 | 2008-10-29 00:00:00 | 2008-12-30 00:00:00 | 2009-04-30 00:00:00 | 2008-12-31 00:00:00 | 2009-01-31 00:00:00 | 2009-07-30 00:00:00 | 2009-11-01 00:00:00 | 2010-01-22 00:00:00 | 2010-01-22 00:00:00 | 2010-01-29 00:00:00 | 2010-04-29 00:00:00 | 2010-07-31 00:00:00 | 2010-10-31 00:00:00 | 2011-01-29 00:00:00 | 2010-12-30 00:00:00 | 2010-12-27 00:00:00 | 2011-03-22 00:00:00 | 2011-03-22 00:00:00 | 2011-05-01 00:00:00 | 2011-10-31 00:00:00 | 2012-01-30 00:00:00 | 2011-07-31 00:00:00 | 2011-10-30 00:00:00 | 2012-01-18 00:00:00 | 2012-04-29 00:00:00 | 2012-07-30 00:00:00 | 2014-01-27 00:00:00 | 2014-01-29 00:00:00 | 2014-12-16 00:00:00 | 2014-12-16 00:00:00 | 2015-01-04 00:00:00 | 2012-10-29 00:00:00 | 2012-12-13 00:00:00 | 2014-07-30 00:00:00 | 2012-12-31 00:00:00 | 2013-01-30 00:00:00 | 2014-04-29 00:00:00 | 2013-04-30 00:00:00 | 2015-10-26 00:00:00 | 2015-07-28 00:00:00 | 2015-11-09 00:00:00 | 2017-10-17 00:00:00 | 2017-10-17 00:00:00 | 2021-02-01 00:00:00 | 2019-02-11 00:00:00 | 2020-07-20 00:00:00 | 2019-01-11 00:00:00 | 2016-02-22 00:00:00 | 2016-03-23 00:00:00 | 2016-03-23 00:00:00 | 2016-01-29 00:00:00 | 2016-04-27 00:00:00 | 2016-05-16 00:00:00 | 2016-07-28 00:00:00 | 2016-09-23 00:00:00 | 2016-09-23 00:00:00 | 2016-10-12 00:00:00 | 2016-10-12 00:00:00 | 2016-10-29 00:00:00 | 2016-10-12 00:00:00 | 2017-01-17 00:00:00 | 2017-01-31 00:00:00 | 2017-05-01 00:00:00 | 2017-01-19 00:00:00 | 2017-07-31 00:00:00 | 2018-04-30 00:00:00 | 2019-01-30 00:00:00 | 2019-10-31 00:00:00 | 2019-07-19 00:00:00 | 2020-01-31 00:00:00 | 2020-07-29 00:00:00 | 2019-04-30 00:00:00 | 2020-04-20 00:00:00 | 2020-03-03 00:00:00 | 2020-03-03 00:00:00 | 2020-04-20 00:00:00 | 2020-04-20 00:00:00 | 2021-05-11 00:00:00 | 2021-07-06 00:00:00 | 2021-07-06 00:00:00 | 2021-07-06 00:00:00 | 2021-05-11 00:00:00 | 2018-01-30 00:00:00 | 2019-01-08 00:00:00 | 2018-10-30 00:00:00 | 2018-07-30 00:00:00 | 2018-01-31 00:00:00 | 2020-03-11 00:00:00 | 2021-02-19 00:00:00 | 2020-11-01 00:00:00 | 2021-02-16 00:00:00 | 2021-04-30 00:00:00 | 2020-04-30 00:00:00 | 2022-06-16 00:00:00 | 2021-07-06 00:00:00 | 2022-08-01 00:00:00 | 2021-05-13 00:00:00 | 2021-11-12 00:00:00 | 2022-02-23 00:00:00 | 2021-11-01 00:00:00 | 2022-01-31 00:00:00 | 2022-05-02 00:00:00 | 2021-11-23 00:00:00 | 2021-08-01 00:00:00 | 2022-10-30 00:00:00 | 2022-10-30 00:00:00 | 2022-10-26 00:00:00 | 2022-10-29 00:00:00 | 2022-10-31 00:00:00 | 2022-10-31 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_type | 10005 | 10005 | 10002 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10006 | 10001 | 10005 | 10005 | 10001 | 10001 | 10002 | 10005 | 10001 | 10001 | 10001 | 10001 | 10002 | 10002 | 10002 | 10005 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10002 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10005 | 10006 | 10001 | 10006 | 10001 | 10001 | 10001 | 10006 | 10001 | 10001 | 10006 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10006 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10006 | 10001 | 10002 | 10001 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10001 | 10001 | 10005 | 10001 | 10002 | 10002 | 10005 | 10005 | 10001 | 10005 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10005 | 10005 | 10005 | 10005 | 10002 | 10002 | 10002 | 10002 | 10002 | 10005 | 10001 | 10001 | 10001 | 10001 | 10002 | 10005 | 10001 | 10001 | 10001 | 10001 | 10005 | 10002 | 10001 | 10002 | 10002 | 10005 | 10001 | 10001 | 10001 | 10002 | 10001 | 10002 | 10002 | 10005 | 10002 | 10001 | 10002 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_status | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 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 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
session_id | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2013 | 2013 | 2015 | 2015 | 2015 | 2013 | 2013 | 2013 | 2015 | 2013 | 2015 | 2013 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2009 | 2009 | 2009 | 2007 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2013 | 2013 | 2015 | 2015 | 2015 | 2011 | 2013 | 2013 | 2013 | 2011 | 2013 | 2013 | 2015 | 2015 | 2015 | 2017 | 2017 | 2019 | 2019 | 2019 | 2019 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2017 | 2015 | 2017 | 2017 | 2017 | 2017 | 2017 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2021 | 2019 | 2019 | 2019 | 2021 | 2017 | 2019 | 2017 | 2017 | 2017 | 2019 | 2021 | 2019 | 2021 | 2021 | 2019 | 2021 | 2019 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
user_id | GPEREZ | CFLAGG | YRODRIGU | YRODRIGU | LTHIBAUL | LTHIBAUL | GPEREZ | LTHIBAUL | ASAETERN | YRODRIGU | AGLADNEY | SARRIAGA | SARRIAGA | ASAETERN | ASAETERN | AGLADNEY | YRODRIGU | AGLADNEY | YRODRIGU | ASAETERN | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | GPEREZ | MGUERRA | MGUERRA | YRODRIGU | YRODRIGU | SARRIAGA | MGUERRA | YRODRIGU | YRODRIGU | YRODRIGU | YRODRIGU | YRODRIGU | CFLAGG | ASAETERN | ASAETERN | ASAETERN | GPEREZ | YRODRIGU | ASAETERN | PBANFORD | ASAETERN | ASAETERN | ASAETERN | ASAETERN | ASAETERN | YRODRIGU | ASAETERN | AGLADNEY | YRODRIGU | ASAETERN | YRODRIGU | YRODRIGU | YRODRIGU | JINGRAM | SARRIAGA | PBANFORD | SARRIAGA | ASAETERN | ASAETERN | ASAETERN | AGLADNEY | AGLADNEY | YRODRIGU | AGLADNEY | AGLADNEY | MKIRKHAM | SARRIAGA | GPEREZ | SARRIAGA | GPEREZ | GPEREZ | GPEREZ | AGLADNEY | AGLADNEY | GPEREZ | AGLADNEY | GPEREZ | GPEREZ | GPEREZ | GPEREZ | AGLADNEY | GPEREZ | PBANFORD | AGLADNEY | AGLADNEY | PBANFORD | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | MKIRKHAM | AGLADNEY | GPEREZ | GPEREZ | GPEREZ | GPEREZ | GPEREZ | CAFILER | CAFILER | CAFILER | CAFILER | MKIRKHAM | GPEREZ | SARRIAGA | AGLADNEY | AGLADNEY | AGLADNEY | AROJAS | MKIRKHAM | MKIRKHAM | MKIRKHAM | CHATRIDGE | MKIRKHAM | SARRIAGA | CAFILER | CAFILER | MKIRKHAM | CVANLIEW | SARRIAGA | CHATRIDGE | CAFILER | CAFILER | CVANLIEW | CHATRIDGE | CAFILER | CAFILER | SARRIAGA | CAFILER | 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fine_audit | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_start | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2007-01-01 00:00:00 | 2007-01-01 00:00:00 | 2007-04-01 00:00:00 | 2007-10-01 00:00:00 | 1900-01-01 00:00:00 | 2007-07-01 00:00:00 | 2013-04-01 00:00:00 | 1900-01-01 00:00:00 | 2015-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2014-04-01 00:00:00 | 2013-07-01 00:00:00 | 2014-10-01 00:00:00 | 1900-01-01 00:00:00 | 2014-10-01 00:00:00 | 2014-12-16 00:00:00 | 2014-07-01 00:00:00 | 2008-01-01 00:00:00 | 2007-10-01 00:00:00 | 2007-01-01 00:00:00 | 2007-04-01 00:00:00 | 1900-01-01 00:00:00 | 2008-04-01 00:00:00 | 2008-07-01 00:00:00 | 2008-12-30 00:00:00 | 2009-01-01 00:00:00 | 1900-01-01 00:00:00 | 2008-10-01 00:00:00 | 2009-04-01 00:00:00 | 2009-07-01 00:00:00 | 2009-07-01 00:00:00 | 2009-04-01 00:00:00 | 2009-10-01 00:00:00 | 2010-01-01 00:00:00 | 2010-04-01 00:00:00 | 2010-07-01 00:00:00 | 2010-10-01 00:00:00 | 1900-01-01 00:00:00 | 2010-12-27 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2011-01-01 00:00:00 | 1900-01-01 00:00:00 | 2011-10-01 00:00:00 | 2011-04-01 00:00:00 | 2011-07-01 00:00:00 | 1900-01-01 00:00:00 | 2012-01-01 00:00:00 | 2012-04-01 00:00:00 | 1900-01-01 00:00:00 | 2013-10-01 00:00:00 | 2014-12-16 00:00:00 | 2014-12-16 00:00:00 | 2015-01-04 00:00:00 | 2012-07-01 00:00:00 | 2012-12-13 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2012-10-01 00:00:00 | 2014-01-01 00:00:00 | 2013-01-01 00:00:00 | 2015-07-01 00:00:00 | 2015-04-01 00:00:00 | 1900-01-01 00:00:00 | 2017-07-01 00:00:00 | 2017-04-01 00:00:00 | 2020-10-01 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 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2015-10-01 00:00:00 | 2016-01-01 00:00:00 | 1900-01-01 00:00:00 | 2016-04-01 00:00:00 | 2016-09-23 00:00:00 | 2016-09-23 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2016-07-01 00:00:00 | 1900-01-01 00:00:00 | 2017-01-17 00:00:00 | 2016-10-01 00:00:00 | 2017-01-01 00:00:00 | 1900-01-01 00:00:00 | 2017-04-01 00:00:00 | 2018-01-01 00:00:00 | 2018-10-01 00:00:00 | 2019-07-01 00:00:00 | 2019-04-01 00:00:00 | 2019-10-01 00:00:00 | 2020-04-01 00:00:00 | 2019-01-01 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 | 1900-01-01 00:00:00 | 2021-05-11 00:00:00 | 2020-01-01 00:00:00 | 2020-07-01 00:00:00 | 2020-10-01 00:00:00 | 2021-05-11 00:00:00 | 1900-01-01 00:00:00 | 2019-01-08 00:00:00 | 2018-07-01 00:00:00 | 2018-04-01 00:00:00 | 2017-10-01 00:00:00 | 2019-10-01 00:00:00 | 1900-01-01 00:00:00 | 2020-07-01 00:00:00 | 2021-02-16 00:00:00 | 2021-01-01 00:00:00 | 2020-01-01 00:00:00 | 1900-01-01 00:00:00 | 2020-04-01 00:00:00 | 2022-04-01 00:00:00 | 1900-01-01 00:00:00 | 2021-11-12 00:00:00 | 1900-01-01 00:00:00 | 2021-07-01 00:00:00 | 2021-10-01 00:00:00 | 2022-01-01 00:00:00 | 1900-01-01 00:00:00 | 2021-04-01 00:00:00 | 2022-01-01 00:00:00 | 2021-10-01 00:00:00 | 1900-01-01 00:00:00 | 2021-07-01 00:00:00 | 2022-07-01 00:00:00 | 2022-04-01 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_end | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2007-03-31 00:00:00 | 2007-03-31 00:00:00 | 2007-06-30 00:00:00 | 2007-12-31 00:00:00 | 1900-01-01 00:00:00 | 2007-09-30 00:00:00 | 2013-06-30 00:00:00 | 1900-01-01 00:00:00 | 2015-03-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2014-06-30 00:00:00 | 2013-09-30 00:00:00 | 2014-12-31 00:00:00 | 1900-01-01 00:00:00 | 2014-12-31 00:00:00 | 2014-12-16 00:00:00 | 2014-09-30 00:00:00 | 2008-03-31 00:00:00 | 2007-12-31 00:00:00 | 2007-03-31 00:00:00 | 2007-06-30 00:00:00 | 1900-01-01 00:00:00 | 2008-06-30 00:00:00 | 2008-09-30 00:00:00 | 2008-12-30 00:00:00 | 2009-03-31 00:00:00 | 1900-01-01 00:00:00 | 2008-12-31 00:00:00 | 2009-06-30 00:00:00 | 2009-06-30 00:00:00 | 2009-09-30 00:00:00 | 2009-06-30 00:00:00 | 2009-12-31 00:00:00 | 2010-03-31 00:00:00 | 2010-06-30 00:00:00 | 2010-09-30 00:00:00 | 2010-12-31 00:00:00 | 1900-01-01 00:00:00 | 2010-12-27 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2011-03-31 00:00:00 | 1900-01-01 00:00:00 | 2011-12-31 00:00:00 | 2011-06-30 00:00:00 | 2011-09-30 00:00:00 | 1900-01-01 00:00:00 | 2012-03-31 00:00:00 | 2012-06-30 00:00:00 | 1900-01-01 00:00:00 | 2013-12-31 00:00:00 | 2014-12-16 00:00:00 | 2014-12-16 00:00:00 | 2015-01-04 00:00:00 | 2012-09-30 00:00:00 | 2012-12-13 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2012-12-31 00:00:00 | 2014-03-31 00:00:00 | 2013-03-31 00:00:00 | 2015-09-30 00:00:00 | 2015-06-30 00:00:00 | 1900-01-01 00:00:00 | 2017-09-30 00:00:00 | 2017-06-30 00:00:00 | 2020-12-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 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2015-12-31 00:00:00 | 2016-03-31 00:00:00 | 1900-01-01 00:00:00 | 2016-06-30 00:00:00 | 2016-09-23 00:00:00 | 2016-09-23 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2016-09-30 00:00:00 | 1900-01-01 00:00:00 | 2017-01-17 00:00:00 | 2016-12-31 00:00:00 | 2017-03-31 00:00:00 | 1900-01-01 00:00:00 | 2017-06-30 00:00:00 | 2018-03-31 00:00:00 | 2018-12-31 00:00:00 | 2019-09-30 00:00:00 | 2019-06-30 00:00:00 | 2019-12-31 00:00:00 | 2020-06-30 00:00:00 | 2019-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 | 1900-01-01 00:00:00 | 2021-05-11 00:00:00 | 2020-03-31 00:00:00 | 2020-09-30 00:00:00 | 2020-12-31 00:00:00 | 2021-05-11 00:00:00 | 1900-01-01 00:00:00 | 2019-01-08 00:00:00 | 2018-09-30 00:00:00 | 2018-06-30 00:00:00 | 2017-12-31 00:00:00 | 2019-12-31 00:00:00 | 1900-01-01 00:00:00 | 2020-09-30 00:00:00 | 2021-02-16 00:00:00 | 2021-03-31 00:00:00 | 2020-03-31 00:00:00 | 1900-01-01 00:00:00 | 2020-06-30 00:00:00 | 2022-06-30 00:00:00 | 1900-01-01 00:00:00 | 2021-11-12 00:00:00 | 1900-01-01 00:00:00 | 2021-09-30 00:00:00 | 2021-12-31 00:00:00 | 2022-03-31 00:00:00 | 1900-01-01 00:00:00 | 2021-06-30 00:00:00 | 2022-03-31 00:00:00 | 2021-12-31 00:00:00 | 1900-01-01 00:00:00 | 2021-09-30 00:00:00 | 2022-09-30 00:00:00 | 2022-06-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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_type | None | None | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | None | 22006 | None | None | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | None | None | 22006 | None | 22006 | 22006 | 22006 | None | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | None | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | None | None | None | None | None | None | 22006 | 22006 | None | 22006 | 22006 | 22006 | None | None | 22006 | None | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | None | None | None | None | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | None | 22006 | None | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 |
filer_id | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_type | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | |||||||||
active | Y | Y | Y | Y | Y | Y | Y | Y | N | |||||||||
race | 0 | None | None | None | None | None | None | None | None | |||||||||
session_id | 2007 | 2011 | 2013 | 2009 | 2021 | 2015 | 2017 | 2019 | 2023 | |||||||||
category | 0 | None | None | None | None | None | None | None | None | |||||||||
category_type | 0 | None | None | None | None | None | None | None | None | |||||||||
sub_category | 0 | None | None | None | None | None | None | None | None | |||||||||
effect_dt | 2007-01-01 00:00:00 | 2011-01-01 00:00:00 | 2013-01-01 00:00:00 | 2009-01-01 00:00:00 | 2021-01-01 00:00:00 | 2015-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 | None | None | None | None | None | None | None | None | |||||||||
election_type | 0 | None | None | None | None | None | None | None | None | |||||||||
sub_category_a | None | None | None | None | None | None | None | None | None | |||||||||
nyq_dt | None | None | None | None | None | None | None | None | None | |||||||||
party_cd | 0 | None | None | None | None | None | None | None | None | |||||||||
county_cd | 0 | None | None | None | None | None | None | None | None | |||||||||
district_cd | 0 | None | None | None | None | None | None | None | None |
filer_id | 1294588 | |
---|---|---|
xref_id | 1294588 | |
effect_dt | 2007-01-31 00:00:00 | |
migration_source | CLAIMS |
xref_filer_id | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_id | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | 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 | 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 | 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 | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | HOUSING ADVOCATES | HOUSING ADVOCATES | HOUSING ADVOCATES | HOUSING ADVOCATES | HOUSING ADVOCATES | HOUSING ADVOCATES | HOUSING ADVOCATES | HOUSING ADVOCATES | HOUSING ADVOCATES | HOUSING ADVOCATES | HOUSING ADVOCATES | HOUSING ADVOCATES | HOUSING ADVOCATES | HOUSING ADVOCATES | HOUSING ADVOCATES | HOUSING ADVOCATES | HOUSING ADVOCATES | HOUSING ADVOCATES | HOUSING ADVOCATES | HOUSING ADVOCATES | HOUSING ADVOCATES | HOUSING ADVOCATES | HOUSING ADVOCATES | HOUSING ADVOCATES | HOUSING ADVOCATES | HOUSING ADVOCATES | HOUSING ADVOCATES | HOUSING ADVOCATES | HOUSING ADVOCATES | HOUSING ADVOCATES | HOUSING ADVOCATES | HOUSING ADVOCATES | HOUSING ADVOCATES | PUBLIC INTEREST ADVOCATES | PUBLIC INTEREST ADVOCATES | PUBLIC INTEREST ADVOCATES | PUBLIC INTEREST ADVOCATES | PUBLIC INTEREST ADVOCATES | PUBLIC INTEREST ADVOCATES | PUBLIC INTEREST ADVOCATES | PUBLIC INTEREST ADVOCATES | PUBLIC INTEREST ADVOCATES | PUBLIC INTEREST ADVOCATES | PUBLIC INTEREST ADVOCATES | PUBLIC INTEREST ADVOCATES | PUBLIC INTEREST ADVOCATES | PUBLIC INTEREST ADVOCATES | PUBLIC INTEREST ADVOCATES | PUBLIC INTEREST ADVOCATES | PUBLIC INTEREST ADVOCATES | PUBLIC INTEREST ADVOCATES | PUBLIC INTEREST ADVOCATES | PUBLIC INTEREST ADVOCATES | PUBLIC INTEREST ADVOCATES | PUBLIC INTEREST ADVOCATES | PUBLIC INTEREST ADVOCATES | PUBLIC INTEREST ADVOCATES | PUBLIC INTEREST ADVOCATES | PUBLIC INTEREST ADVOCATES | PUBLIC INTEREST ADVOCATES | PUBLIC INTEREST ADVOCATES | PUBLIC INTEREST ADVOCATES | PUBLIC INTEREST ADVOCATES | PUBLIC INTEREST ADVOCATES | PUBLIC INTEREST ADVOCATES | PUBLIC INTEREST ADVOCATES | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
nams | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
adr1 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
adr2 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
city | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
st | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
zip4 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
phon | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | 9164469241 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fax | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | 1294588 |
---|
filer_id | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | ||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
change_no | 1 | 0 | 2 | 3 | 4 | 5 | 6 | 8 | 7 | 9 | 10 | 11 | 12 | 13 | 14 | 17 | 15 | 16 | 18 | 19 | ||||||||||||||||||||
session_id | 2007 | 2007 | 2007 | 2011 | 2011 | 2011 | 2011 | 2013 | 2013 | 2013 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2017 | 2019 | ||||||||||||||||||||
log_dt | 2007-03-02 00:00:00 | 2007-11-19 00:00:00 | 2008-02-14 00:00:00 | 2011-03-22 00:00:00 | 2011-10-31 00:00:00 | 2011-10-31 00:00:00 | 2012-01-18 00:00:00 | 2014-01-27 00:00:00 | 2013-08-27 00:00:00 | 2014-07-30 00:00:00 | 2015-04-16 00:00:00 | 2015-04-16 00:00:00 | 2015-04-16 00:00:00 | 2016-02-22 00:00:00 | 2015-11-09 00:00:00 | 2016-10-12 00:00:00 | 2016-03-23 00:00:00 | 2016-03-23 00:00:00 | 2018-01-30 00:00:00 | 2020-04-20 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 | ||||||||||||||||||||
correction_flg | Y | Y | Y | Y | None | None | Y | None | None | None | Y | Y | Y | Y | Y | None | Y | Y | Y | None | ||||||||||||||||||||
action | ADDED | ADDED | DELETED | ADDED | DELETED | DELETED | ADDED | ADDED | DELETED | ADDED | ADDED | ADDED | ADDED | DELETED | DELETED | CHANGED | ADDED | ADDED | ADDED | CHANGED | ||||||||||||||||||||
attribute_changed | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | FIRM | CLIENT | EMPLOYER | CLIENT | CLIENT | CLIENT | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | NAME | EMPLOYER | EMPLOYER | EMPLOYER | NAME | ||||||||||||||||||||
ethics_dt | 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 | ||||||||||||||||||||
filer_full_name | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | AUGUSTA AND ASSOCIATES; BRIAN | HOUSING ADVOCATES | HOUSING ADVOCATES | ||||||||||||||||||||
filer_city | None | None | None | None | None | None | SACRAMENTO | None | None | None | SACRAMENTO | SACRAMENTO | SACRAMENTO | None | SACRAMENTO | None | SACRAMENTO | SACRAMENTO | SACRAMENTO | None | ||||||||||||||||||||
filer_st | None | None | None | None | None | None | CA | None | None | None | CA | CA | CA | None | CA | None | CA | CA | CA | None | ||||||||||||||||||||
filer_zip | None | None | None | None | None | None | 95814 | None | None | None | 95814 | 95814 | 95814 | None | 95814 | None | 95814 | 95814 | 95814 | None | ||||||||||||||||||||
filer_phone | None | None | None | None | None | None | 9164469241 | None | None | None | 9164469241 | 9164469241 | 9164469241 | None | 9164469241 | None | 9164469241 | 9164469241 | 9164469241 | None | ||||||||||||||||||||
entity_type | 2 | 2 | 2 | 2 | 3 | 1 | 2 | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 2 | 3 | 2 | 2 | 2 | 3 | ||||||||||||||||||||
entity_name | KEEPING OUR FAMILIES TOGETHER | CALIFORNIA REINVESTMENT COALITION | KEEPING OUR FAMILIES TOGETHER | CARSON; CITY OF | MONTGOMERY CONSULTING LLC | CARSON; CITY OF | WESTERN CENTER ON LAW & POVERTY, INC. | SANTA MONICA RENT CONTROL BOARD | CALIFORNIA CONTINUING CARE RESIDENTS ASSOCIATION | BERKELEY RENT STABILIZATION BOARD; CITY OF | CALIFORNIA COALITION FOR RURAL HOUSING | CALIFORNIA RURAL LEGAL ASSISTANCE FOUNDATION | RURAL COMMUNITY ASSISTANCE CORPORATION | GOLDEN STATE MANUFACTURED-HOME OWNERS LEAGUE, INC. (GSMOL) | WESTERN CENTER ON LAW & POVERTY, INC. | HOUSING ADVOCATES, | SELF-HELP ENTERPRISES | CALIFORNIA CALLS ACTION FUND | RURAL COMMUNITY ASSISTANCE CORPORATION | PUBLIC INTEREST ADVOCATES, | ||||||||||||||||||||
entity_city | 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 | ||||||||||||||||||||
entity_zip | 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 | ||||||||||||||||||||
entity_id | 1297282 | 1302329 | 1297282 | 1254962 | 1303301 | 1254962 | None | 1143026 | 1145584 | 1144229 | None | None | None | 1142970 | None | 0 | None | None | None | 0 | ||||||||||||||||||||
responsible_officer | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||
effect_dt | 2007-02-15 00:00:00 | 2007-10-25 00:00:00 | 2008-02-01 00:00:00 | 2011-03-10 00:00:00 | 2011-09-30 00:00:00 | 2011-10-30 00:00:00 | 2012-01-03 00:00:00 | 2014-01-15 00:00:00 | 2013-06-30 00:00:00 | 2014-07-25 00:00:00 | 2015-04-01 00:00:00 | 2015-04-06 00:00:00 | 2015-04-06 00:00:00 | 2015-02-19 00:00:00 | 2015-11-02 00:00:00 | 2016-09-23 00:00:00 | 2016-02-29 00:00:00 | 2016-03-17 00:00:00 | 2018-01-01 00:00:00 | 2020-03-12 00:00:00 |
filer_id | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | 1294588 | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_file_name | 1554202_0.cal | 1386738_0.cal | 1717045_0.cal | 1922783_2.cal | 1922783_1.cal | 2120247_0.cal | 1922783_0.cal | 2332981_0.cal | 2558130_0.cal | 2558130_2.cal | 2558130_1.cal | 2558130_3.cal | ||||||||||||
received_date | 2010-12-27 00:00:00 | 2008-12-30 00:00:00 | 2012-12-13 00:00:00 | 2016-09-23 00:00:00 | 2016-09-23 00:00:00 | 2017-01-17 00:00:00 | 2015-01-04 00:00:00 | 2019-01-08 00:00:00 | 2021-02-16 00:00:00 | 2021-05-11 00:00:00 | 2021-05-11 00:00:00 | 2021-11-12 00:00:00 | ||||||||||||
filing_directory | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | ||||||||||||
filing_id | 1554202 | 1386738 | 1717045 | 1922783 | 1922783 | 2120247 | 1922783 | 2332981 | 2558130 | 2558130 | 2558130 | 2558130 | ||||||||||||
form_id | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | F601 | ||||||||||||
receive_comment | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted |