filing_id | 1616079 | 1600376 | 1586002 | 1626814 | 1697304 | 1670629 | 1651227 | 1723796 | 1792540 | 1792540 | 1775265 | 1756599 | 1808750 | 1892520 | 1860701 | 1834992 | 1925953 | 1990603 | 1972519 | 1955501 | 2002561 | 2087045 | 2054345 | 2027727 | 2116224 | 2165235 | 2149298 | 2186392 | 2199649 | 2306542 | 2262454 | 2228981 | 2370182 | 2388393 | 2334228 | 2427894 | 2411122 | 2465498 | 2476020 | 2571245 | 2542696 | 2509385 | 2613918 | 2632817 | 2590608 | 2632817 | 2730357 | 2662205 | 2696477 | |||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
amend_id | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||
rec_type | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | |||||||||||||||||||||||||||||||||||||||||||||||||
form_type | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | |||||||||||||||||||||||||||||||||||||||||||||||||
sender_id | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | |||||||||||||||||||||||||||||||||||||||||||||||||
filer_id | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | |||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||
filer_naml | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | |||||||||||||||||||||||||||||||||||||||||||||||||
filer_namf | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | |||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||
report_num | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 001 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 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 | |||||||||||||||||||||||||||||||||||||||||||||||||
rpt_date | 2011-10-03 00:00:00 | 2011-07-14 00:00:00 | 2011-04-13 00:00:00 | 2012-01-05 00:00:00 | 2012-10-11 00:00:00 | 2012-07-11 00:00:00 | 2012-04-09 00:00:00 | 2013-01-10 00:00:00 | 2013-10-02 00:00:00 | 2013-10-02 00:00:00 | 2013-07-15 00:00:00 | 2013-04-15 00:00:00 | 2014-01-06 00:00:00 | 2014-10-06 00:00:00 | 2014-07-01 00:00:00 | 2014-04-01 00:00:00 | 2015-01-15 00:00:00 | 2015-10-05 00:00:00 | 2015-07-01 00:00:00 | 2015-04-01 00:00:00 | 2016-01-06 00:00:00 | 2016-10-10 00:00:00 | 2016-07-11 00:00:00 | 2016-04-12 00:00:00 | 2017-01-02 00:00:00 | 2017-07-01 00:00:00 | 2017-04-04 00:00:00 | 2017-10-03 00:00:00 | 2018-01-02 00:00:00 | 2018-10-15 00:00:00 | 2018-07-03 00:00:00 | 2018-04-06 00:00:00 | 2019-04-04 00:00:00 | 2019-07-01 00:00:00 | 2019-01-14 00:00:00 | 2020-01-03 00:00:00 | 2019-10-01 00:00:00 | 2020-04-13 00:00:00 | 2020-07-02 00:00:00 | 2021-04-02 00:00:00 | 2021-01-06 00:00:00 | 2020-10-03 00:00:00 | 2021-10-04 00:00:00 | 2022-01-04 00:00:00 | 2021-07-01 00:00:00 | 2022-01-04 00:00:00 | 2022-10-08 00:00:00 | 2022-04-01 00:00:00 | 2022-07-05 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||
from_date | 2011-07-01 00:00:00 | 2011-04-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-07-01 00:00:00 | 2013-04-01 00:00:00 | 2013-01-01 00:00:00 | 2013-10-01 00:00:00 | 2014-07-01 00:00:00 | 2014-04-01 00:00:00 | 2014-01-01 00:00:00 | 2014-10-01 00:00:00 | 2015-07-01 00:00:00 | 2015-04-01 00:00:00 | 2015-01-01 00:00:00 | 2015-10-01 00:00:00 | 2016-07-01 00:00:00 | 2016-04-01 00:00:00 | 2016-01-01 00:00:00 | 2016-10-01 00:00:00 | 2017-04-01 00:00:00 | 2017-01-01 00:00:00 | 2017-07-01 00:00:00 | 2017-10-01 00:00:00 | 2018-07-01 00:00:00 | 2018-04-01 00:00:00 | 2018-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-04-01 00:00:00 | 2018-01-01 00:00:00 | 2019-10-01 00:00:00 | 2019-07-01 00:00:00 | 2020-01-01 00:00:00 | 2020-04-01 00:00:00 | 2021-01-01 00:00:00 | 2020-10-01 00:00:00 | 2020-07-01 00:00:00 | 2021-07-01 00:00:00 | 2021-10-01 00:00:00 | 2021-04-01 00:00:00 | 2021-10-01 00:00:00 | 2022-07-01 00:00:00 | 2022-01-01 00:00:00 | 2022-04-01 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||
thru_date | 2011-09-30 00:00:00 | 2011-06-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-09-30 00:00:00 | 2013-06-30 00:00:00 | 2013-03-31 00:00:00 | 2013-12-31 00:00:00 | 2014-09-30 00:00:00 | 2014-06-30 00:00:00 | 2014-03-31 00:00:00 | 2014-12-31 00:00:00 | 2015-09-30 00:00:00 | 2015-06-30 00:00:00 | 2015-03-31 00:00:00 | 2015-12-31 00:00:00 | 2016-09-30 00:00:00 | 2016-06-30 00:00:00 | 2016-03-31 00:00:00 | 2016-12-31 00:00:00 | 2017-06-30 00:00:00 | 2017-03-31 00:00:00 | 2017-09-30 00:00:00 | 2017-12-31 00:00:00 | 2018-09-30 00:00:00 | 2018-06-30 00:00:00 | 2018-03-31 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 | 2019-09-30 00:00:00 | 2020-03-31 00:00:00 | 2020-06-30 00:00:00 | 2021-03-31 00:00:00 | 2020-12-31 00:00:00 | 2020-09-30 00:00:00 | 2021-09-30 00:00:00 | 2021-12-31 00:00:00 | 2021-06-30 00:00:00 | 2021-12-31 00:00:00 | 2022-09-30 00:00:00 | 2022-03-31 00:00:00 | 2022-06-30 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||
cum_beg_dt | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||
firm_id | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | |||||||||||||||||||||||||||||||||||||||||||||||||
firm_name | Strategic Marketing Solutions Ltd, LLC | Strategic Marketing Solutions Ltd., LLC | Strategic Marketing Solutions Ltd., LLC | Strategic Marketing Solutions Ltd., LLC | Strategic Marketing Solutions Ltd, LLC | Strategic Marketing Solutions LTD, LLC | Strategic Marketing Solutions Ltd., LLC | Strategic Marketing Solutions Ltd., LLC | Strategic Marketing Solutions LTD. LLC | None | Strategic Marketing Solutions LTD. LLC | Strategic Marketing Solutions Ltd., LLC | Strategic Marketing Solutions LTD.,LLC | Strategic Marketing Solutions LTD.,LLC | Strategic Marketing Solutions, LTD., LLC | Strategic Marketing Solutions LTD.,LLC | Strategic Marketing Solutions LTD.,LLC | Strategic Marketing Solutions LTD., LLC | Strategic Marketing Solutions LTD., LLC | Strategic Marketing Solutions LTD., LLC | Strategic Marketing Solutions LTD., LLC | Strategic Marketing Solutions LTD.,LLC | Strategic Marketing Solutions LTD., LLC | Strategic Marketing Solutions LTD.,LLC | Strategic Marketing Solutions LTD., LLC | Strategic Marketing Solutions LTD.,LLC | 01/01/2017 | Strategic Marketing Solutions LTD., LLC | Strategic Marketing Solutions LTD., LLC | Strategic Marketing Solutions LTD, LLC | Strategic Marketing Solutions Ltd., LLC | Strategic Marketing Solutions LTD, LLC | Strategic Marketing Solutions Ltd., LLC | Strategic Marketing Solutions Ltd. LLC | Strategic Marketing Solutions | Strategic Marketing Solutions | Strategic Marketing Solutions | Strategic Marketing Solutions | Strategic Marketing Solutions | Strategic Marketing Solutions | Strategic Marketing Solutions | Strategic Marketing Solutions | Strategic Marketing Solutions | Strategic Marketing Solutions | Strategic Marketing Solutions | Strategic Marketing Solutions | Strategic Marketing Solutions | Strategic Marketing Solutions | Strategic Marketing Solutions | |||||||||||||||||||||||||||||||||||||||||||||||||
firm_city | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | |||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||
firm_zip4 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | |||||||||||||||||||||||||||||||||||||||||||||||||
firm_phon | 4153898908 | 4153898908 | 4153898908 | 4153898908 | 4153898908 | 4153898908 | 4153898908 | 4153898908 | 4153898908 | 4153898908 | 4153898908 | 4153898908 | 4153898908 | 4153898908 | 4153898908 | 4153898908 | 4153898908 | 4153898908 | 4153898908 | 4153898908 | 4153898908 | 4153898908 | 4153898908 | 4153898908 | 4153898908 | 4153898908 | 4153898908 | 4153898908 | 4153898908 | 4153898908 | 4153898908 | 4153898908 | 4153899401 | 4153899401 | 4153898908 | 4153899401 | 4153899401 | 4153899401 | 4153899401 | 4153899401 | 4153899401 | 4153899401 | 4153899401 | 4153899401 | 4153899401 | 4153899401 | 4153899401 | 4153899401 | 4153899401 | |||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||
sig_date | 2011-10-03 00:00:00 | 2011-07-14 00:00:00 | 2011-04-12 00:00:00 | 2012-01-05 00:00:00 | 2012-10-11 00:00:00 | 2012-07-11 00:00:00 | 2012-04-09 00:00:00 | 2013-01-10 00:00:00 | 2013-10-02 00:00:00 | 2013-10-02 00:00:00 | 2013-07-15 00:00:00 | 2013-04-15 00:00:00 | 2013-01-06 00:00:00 | 2014-10-06 00:00:00 | 2014-07-01 00:00:00 | 2014-04-01 00:00:00 | 2015-01-15 00:00:00 | 2015-10-05 00:00:00 | 2015-07-01 00:00:00 | 2015-04-01 00:00:00 | 2015-01-06 00:00:00 | 2016-10-10 00:00:00 | 2016-07-11 00:00:00 | 2016-04-12 00:00:00 | 2017-01-02 00:00:00 | 2017-07-01 00:00:00 | 2017-04-04 00:00:00 | 2017-10-03 00:00:00 | 2018-01-02 00:00:00 | 2018-10-15 00:00:00 | 2018-07-03 00:00:00 | 2018-04-06 00:00:00 | 2019-04-04 00:00:00 | 2019-07-01 00:00:00 | 2019-01-14 00:00:00 | 2020-01-03 00:00:00 | 2019-10-01 00:00:00 | 2020-04-14 00:00:00 | 2020-07-02 00:00:00 | 2021-04-02 00:00:00 | 2021-01-06 00:00:00 | 2020-10-03 00:00:00 | 2021-10-04 00:00:00 | 2022-01-04 00:00:00 | 2021-07-01 00:00:00 | 2021-01-04 00:00:00 | 2022-10-08 00:00:00 | 2022-04-01 00:00:00 | 2022-07-05 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||
sig_loc | Sausalito, CA | Sausalito, CA | Sausalito | Sausalito, CA | Sausalito, CA | Sausalito, CA | Sausalito, CA | Sausalito, CA | Sausalito, CA | Sausalito,CA | Sausalito,CA | Sausalito, CA | Sausalito, CA | Sausalito, CA | Sausalito, CA | Sausalito, CA | Sausalito, CA | Sausalito, CA | Sausalito, CA | Sausalito, CA | Sausalito, CA | Sausalito, CA | Sausalito, CA | Sausalito, CA | Sausalito, CA | Sausalito, CA | Sausalito, CA | Sausalito, CA | Sausalito, CA | Sausalito, CA | Sausalito, CA | Sausalito, CA | Sausalito, CA | Sausalito,CA | Sausalito, CA | Sausalito | Sausalito, Ca | Sausalito | Sausalito | Sausalito, CA | Sausalito, CA | Sausalito | Sausalito, CA | Sausalito | Sausalito, CA | Sausalito | Sausalito, CA | Sausalito, CA | Sausalito, CA | |||||||||||||||||||||||||||||||||||||||||||||||||
sig_naml | Ter Heun | Ter Heun | Ter Heun | Ter Heun | Ter Heun | Ter Heun | Ter Heun | Ter Heun | Ter Heun | Ter Heun | Ter Heun | Ter Heun | Ter Heun | Ter Heun | Ter Heun | Ter Heun | Ter Heun | Ter Heun | Ter Heun | Ter Heun | Ter Heun | Ter Heun | Ter Heun | Ter Heun | Ter Heun | Ter Heun | Ter Heun | Ter Heun | Ter Heun | Ter Huen | Ter Heun | Ter Heun | Ter Heun | Ter Heun | TerHeun | Ter Heun | Ter Heun | Ter Heun | Ter Heun | Ter Heun | Ter Heun | Ter Heun | Ter Heun | Ter Heun | Ter Heun | Ter Heun | Ter Heun | Ter Heun | Ter Heun | |||||||||||||||||||||||||||||||||||||||||||||||||
sig_namf | Patricia | Patricia | Patricia | Patricia | Patricia | Patricia | Patricia | Patricia | Patricia | Patricia | Patricia | Patricia | Patricia | Patricia | Patricia | Patricia | Patricia | Patricia | Patricia | Patricia | Patricia | Patricia | Patricia | Patricia | Patricia | Patricia | Patricia | Patricia | Patricia | Patricia | Patricia | Patricia | Patricia | Patricia | Patricia | Patricia | Patricia | Patricia | Patricia | Patricia | Patricia | Patricia | Patricia | Patricia | Patricia | Patricia | Patricia | Patricia | Patricia | |||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||
prn_naml | Ter Heun | Ter Heun | Ter Heun | Ter Heun | Ter Heun | Ter Heun | Ter Heun | Ter Heun | Ter Heun | Ter Heun | Ter Heun | Ter Heun | Ter Heun | Ter Heun | Ter Heun | Ter Heun | Ter Heun | Ter Heun | Ter Heun | Ter Heun | Ter Heun | Ter Heun | Ter Heun | Ter Heun | Ter Heun | Ter Heun | Ter Heun | Ter Heun | Ter Heun | Ter Huen | Ter Heun | Ter Heun | Ter Heun | Ter Heun | TerHeun | Ter Heun | Ter Heun | Ter Heun | Ter Heun | Ter Heun | Ter Heun | Ter Heun | Ter Heun | Ter Heun | Ter Heun | Ter Heun | Ter Heun | Ter Heun | Ter Heun | |||||||||||||||||||||||||||||||||||||||||||||||||
prn_namf | Patricia | Patricia | Patricia | Patricia | Patricia | Patricia | Patricia | Patricia | Patricia | Patricia | Patricia | Patricia | Patricia | Patricia | Patricia | Patricia | Patricia | Patricia | Patricia | Patricia | Patricia | Patricia | Patricia | Patricia | Patricia | Patricia | Patricia | Patricia | Patricia | Patricia | Patricia | Patricia | Patricia | Patricia | Patricia | Patricia | Patricia | Patricia | Patricia | Patricia | Patricia | Patricia | Patricia | Patricia | Patricia | Patricia | Patricia | Patricia | Patricia | |||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||
sig_title | Owner | Owner | Owner | Managing Member | Managing Member | Owner/Principal | Principal | Managing Member | Managing Member | Principal | Managing Member | Managing Member | Managing Member | Managing Member | Managing Member | Managing Member | Managing Member | Managing Member | Managing Member | Managing Member | Managing Member | Managing Member | Managing Member | Managing Member | Managing Member | Managing Member | Managing Member | Managing Member | Managing Member | Managing Member | Managing Member | Managing Member | Managing Member | Managing Member | Managing Partner | Managing Member | Managing Member | Managing Member | Managing Member | Managing Member | Managing Member | Managing Member | Managing Member | Managing Member | Managing Member | Managing Member | Managing Member | Managing Member | Managing Member | |||||||||||||||||||||||||||||||||||||||||||||||||
nopart1_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 | |||||||||||||||||||||||||||||||||||||||||||||||||
nopart2_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 | |||||||||||||||||||||||||||||||||||||||||||||||||
part1_1_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 | |||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||
ctrib_n_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 | |||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||
lobby_n_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 | |||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||
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 |
filer_id | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
adrid | 2210090 | 2411955 | 2471185 | 2443378 | 2276241 | 2512137 | 2551221 | 2346376 | ||||||||
effect_dt | 2011-01-01 00:00:00 | 2017-01-01 00:00:00 | 2019-01-01 00:00:00 | 2017-07-01 00:00:00 | 2013-01-01 00:00:00 | 2021-01-01 00:00:00 | 2023-01-01 00:00:00 | 2015-01-01 00:00:00 | ||||||||
add_type | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | ||||||||
session_id | 2011 | 2017 | 2019 | 2017 | 2013 | 2021 | 2023 | 2015 |
filer_id | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | |||||
---|---|---|---|---|---|---|---|---|---|---|
session_id | 2011 | 2013 | 2015 | 2017 | 2021 | |||||
ethics_date | 2011-04-21 00:00:00 | 2012-11-08 00:00:00 | 2014-11-13 00:00:00 | 2016-11-17 00:00:00 | 2020-11-12 00:00:00 |
filer_id | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 1775265 | 1972519 | 1860701 | 1808750 | 1792540 | 1792540 | 1773288 | 1951968 | 1955501 | 1571405 | 1590716 | 1586002 | 1616079 | 1626814 | 1600376 | 1651227 | 1670629 | 1697304 | 1925953 | 1892520 | 1756599 | 1723796 | 1723474 | 1834992 | 2002561 | 1990603 | 2370182 | 2411122 | 2388393 | 2228981 | 2306542 | 2427894 | 2027727 | 2054345 | 2087045 | 2126047 | 2116224 | 2149298 | 2165235 | 2199649 | 2347148 | 2186392 | 2465498 | 2571245 | 2509385 | 2334228 | 2262454 | 2476020 | 2466022 | 2590608 | 2662205 | 2550613 | 2542696 | 2613918 | 2696477 | 2632817 | 2632817 | 2730357 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
period_id | 214 | 222 | 218 | 216 | 215 | 215 | None | None | 221 | None | None | 205 | 207 | 208 | 206 | 209 | 210 | 211 | 220 | 219 | 213 | 212 | None | 217 | 224 | 223 | 237 | 239 | 238 | 233 | 235 | 240 | 225 | 226 | 227 | None | 228 | 229 | 230 | 232 | None | 231 | 241 | 245 | 243 | 233 | 234 | 242 | None | 246 | 249 | None | 244 | 247 | 250 | 248 | 248 | 251 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F604 | F615 | F604 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_sequence | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_date | 2013-07-15 00:00:00 | 2015-07-01 00:00:00 | 2014-07-01 00:00:00 | 2014-01-06 00:00:00 | 2013-10-02 00:00:00 | 2013-10-02 00:00:00 | 2013-06-28 00:00:00 | 2014-12-08 00:00:00 | 2015-04-01 00:00:00 | 2011-01-10 00:00:00 | 2011-04-28 00:00:00 | 2011-04-13 00:00:00 | 2011-10-03 00:00:00 | 2012-01-05 00:00:00 | 2011-07-14 00:00:00 | 2012-04-09 00:00:00 | 2012-07-11 00:00:00 | 2012-10-11 00:00:00 | 2015-01-15 00:00:00 | 2014-10-06 00:00:00 | 2013-04-15 00:00:00 | 2013-01-10 00:00:00 | 2012-11-09 00:00:00 | 2014-04-01 00:00:00 | 2016-01-06 00:00:00 | 2015-10-05 00:00:00 | 2019-04-04 00:00:00 | 2019-10-01 00:00:00 | 2019-07-01 00:00:00 | 2018-04-06 00:00:00 | 2018-10-15 00:00:00 | 2020-01-03 00:00:00 | 2016-04-12 00:00:00 | 2016-07-11 00:00:00 | 2016-10-10 00:00:00 | 2016-11-22 00:00:00 | 2017-01-02 00:00:00 | 2017-04-04 00:00:00 | 2017-07-01 00:00:00 | 2018-01-02 00:00:00 | 2018-12-31 00:00:00 | 2017-10-03 00:00:00 | 2020-04-13 00:00:00 | 2021-04-02 00:00:00 | 2020-10-03 00:00:00 | 2019-01-14 00:00:00 | 2018-07-03 00:00:00 | 2020-07-02 00:00:00 | 2020-04-06 00:00:00 | 2021-07-01 00:00:00 | 2022-04-01 00:00:00 | 2020-12-10 00:00:00 | 2021-01-06 00:00:00 | 2021-10-04 00:00:00 | 2022-07-05 00:00:00 | 2022-01-04 00:00:00 | 2022-01-04 00:00:00 | 2022-10-08 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_type | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10006 | 10005 | 10001 | 10005 | 10006 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_status | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11003 | 11002 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
session_id | 2013 | 2015 | 2013 | 2013 | 2013 | 2013 | 2013 | 2015 | 2015 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2013 | 2013 | 2013 | 2011 | 2013 | 2013 | 2015 | 2015 | 2019 | 2019 | 2019 | 2017 | 2017 | 2019 | 2015 | 2015 | 2015 | 2017 | 2015 | 2017 | 2017 | 2017 | 2019 | 2017 | 2019 | 2021 | 2019 | 2017 | 2017 | 2019 | 2019 | 2021 | 2021 | 2021 | 2019 | 2021 | 2021 | 2021 | 2021 | 2021 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
user_id | ASAETERN | JINGRAM | ASAETERN | ASAETERN | ASAETERN | ASAETERN | PBANFORD | PBANFORD | JINGRAM | YRODRIGU | YRODRIGU | JINGRAM | ASAETERN | ASAETERN | ASAETERN | ASAETERN | AGLADNEY | ASAETERN | AGLADNEY | ASAETERN | ASAETERN | ASAETERN | PBANFORD | ASAETERN | AGLADNEY | JINGRAM | SUSHAKOV | GTAYLOR | VUKSTINA | AGLADNEY | JFRONEFIELD | CAFILER | AGLADNEY | AGLADNEY | AGLADNEY | PBANFORD | AGLADNEY | AGLADNEY | SMCCONNAN | AGLADNEY | AROJAS | SMCCONNAN | CAFILER | CHARTRIDGE | CAFILER | JFRONEFIELD | AGLADNEY | CAFILER | AROJAS | CHATRIDGE | CHATRIDGE | MMERCHANT | CAFILER | MKIRKHAM | CAFILER | RATTIYEH | RATTIYEH | 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fine_audit | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_start | 2013-04-01 00:00:00 | 2015-04-01 00:00:00 | 2014-04-01 00:00:00 | 2013-10-01 00:00:00 | 2013-07-01 00:00:00 | 2013-07-01 00:00:00 | 1900-01-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 | 2011-01-01 00:00:00 | 2011-07-01 00:00:00 | 2011-10-01 00:00:00 | 2011-04-01 00:00:00 | 2012-01-01 00:00:00 | 2012-04-01 00:00:00 | 2012-07-01 00:00:00 | 2014-10-01 00:00:00 | 2014-07-01 00:00:00 | 2013-01-01 00:00:00 | 2012-10-01 00:00:00 | 1900-01-01 00:00:00 | 2014-01-01 00:00:00 | 2015-10-01 00:00:00 | 2015-07-01 00:00:00 | 2019-01-01 00:00:00 | 2019-07-01 00:00:00 | 2019-04-01 00:00:00 | 2018-01-01 00:00:00 | 2018-07-01 00:00:00 | 2019-10-01 00:00:00 | 2016-01-01 00:00:00 | 2016-04-01 00:00:00 | 2016-07-01 00:00:00 | 1900-01-01 00:00:00 | 2016-10-01 00:00:00 | 2017-01-01 00:00:00 | 2017-04-01 00:00:00 | 2017-10-01 00:00:00 | 1900-01-01 00:00:00 | 2017-07-01 00:00:00 | 2020-01-01 00:00:00 | 2021-01-01 00:00:00 | 2020-07-01 00:00:00 | 2018-01-01 00:00:00 | 2018-04-01 00:00:00 | 2020-04-01 00:00:00 | 1900-01-01 00:00:00 | 2021-04-01 00:00:00 | 2022-01-01 00:00:00 | 1900-01-01 00:00:00 | 2020-10-01 00:00:00 | 2021-07-01 00:00:00 | 2022-04-01 00:00:00 | 2021-10-01 00:00:00 | 2021-10-01 00:00:00 | 2022-07-01 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_end | 2013-06-30 00:00:00 | 2015-06-30 00:00:00 | 2014-06-30 00:00:00 | 2013-12-31 00:00:00 | 2013-09-30 00:00:00 | 2013-09-30 00:00:00 | 1900-01-01 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 | 2011-03-31 00:00:00 | 2011-09-30 00:00:00 | 2011-12-31 00:00:00 | 2011-06-30 00:00:00 | 2012-03-31 00:00:00 | 2012-06-30 00:00:00 | 2012-09-30 00:00:00 | 2014-12-31 00:00:00 | 2014-09-30 00:00:00 | 2013-03-31 00:00:00 | 2012-12-31 00:00:00 | 1900-01-01 00:00:00 | 2014-03-31 00:00:00 | 2015-12-31 00:00:00 | 2015-09-30 00:00:00 | 2019-03-31 00:00:00 | 2019-09-30 00:00:00 | 2019-06-30 00:00:00 | 2018-03-31 00:00:00 | 2018-09-30 00:00:00 | 2019-12-31 00:00:00 | 2016-03-31 00:00:00 | 2016-06-30 00:00:00 | 2016-09-30 00:00:00 | 1900-01-01 00:00:00 | 2016-12-31 00:00:00 | 2017-03-31 00:00:00 | 2017-06-30 00:00:00 | 2017-12-31 00:00:00 | 1900-01-01 00:00:00 | 2017-09-30 00:00:00 | 2020-03-31 00:00:00 | 2021-03-31 00:00:00 | 2020-09-30 00:00:00 | 2018-12-31 00:00:00 | 2018-06-30 00:00:00 | 2020-06-30 00:00:00 | 1900-01-01 00:00:00 | 2021-06-30 00:00:00 | 2022-03-31 00:00:00 | 1900-01-01 00:00:00 | 2020-12-31 00:00:00 | 2021-09-30 00:00:00 | 2022-06-30 00:00:00 | 2021-12-31 00:00:00 | 2021-12-31 00:00:00 | 2022-09-30 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_date | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_type | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | None | 22006 | None | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 |
filer_id | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_type | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | ||||||||
active | Y | Y | R | Y | Y | Y | Y | N | ||||||||
race | 0 | None | None | None | None | None | None | None | ||||||||
session_id | 2011 | 2013 | 2019 | 2015 | 2019 | 2021 | 2017 | 2023 | ||||||||
category | 0 | None | None | None | None | None | None | None | ||||||||
category_type | 0 | None | None | None | None | None | None | None | ||||||||
sub_category | 0 | None | None | None | None | None | None | None | ||||||||
effect_dt | 2011-01-01 00:00:00 | 2013-01-01 00:00:00 | 2019-06-30 00:00:00 | 2015-01-01 00:00:00 | 2019-01-01 00:00:00 | 2021-01-01 00:00:00 | 2017-01-01 00:00:00 | 2023-01-01 00:00:00 | ||||||||
sub_category_type | 0 | None | None | None | None | None | None | None | ||||||||
election_type | 0 | None | None | None | None | None | None | None | ||||||||
sub_category_a | None | None | None | None | None | None | None | None | ||||||||
nyq_dt | None | None | None | None | None | None | None | None | ||||||||
party_cd | 0 | None | None | None | None | None | None | None | ||||||||
county_cd | 0 | None | None | None | None | None | None | None | ||||||||
district_cd | 0 | None | None | None | None | None | None | None |
filer_id | 1335342 | |
---|---|---|
xref_id | 1335342 | |
effect_dt | 2011-01-20 00:00:00 | |
migration_source | CLAIMS |
xref_filer_id | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_id | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | 1335342 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filer_type | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
naml | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | TER HEUN | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
namf | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | PATRICIA | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
city | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | SAUSALITO | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
zip4 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | 94965 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
phon | 4153898908 | 4153898908 | 4153898908 | 4153898908 | 4153898908 | 4153899401 | 4153899401 | 4153899401 | 4153898908 | 4153898908 | 4153898908 | 4153898908 | 4153898908 | 4153899401 | 4153899401 | 4153899401 | 4153898908 | 4153898908 | 4153898908 | 4153898908 | 4153898908 | 4153899401 | 4153899401 | 4153899401 | 4153898908 | 4153898908 | 4153898908 | 4153898908 | 4153898908 | 4153899401 | 4153899401 | 4153899401 | 4153898908 | 4153898908 | 4153898908 | 4153898908 | 4153898908 | 4153899401 | 4153899401 | 4153899401 | 4153898908 | 4153898908 | 4153898908 | 4153898908 | 4153898908 | 4153899401 | 4153899401 | 4153899401 | 4153898908 | 4153898908 | 4153898908 | 4153898908 | 4153898908 | 4153899401 | 4153899401 | 4153899401 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fax | None | 4153898960 | None | 4153898960 | None | 4153898960 | None | 4153898960 | None | 4153898960 | None | 4153898960 | None | 4153898960 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] |
filer_id | 1335342 |
---|
filer_id | 1335342 | |
---|---|---|
change_no | 0 | |
session_id | 2021 | |
log_dt | 2020-12-10 00:00:00 | |
filer_type | 4 | |
correction_flg | Y | |
action | ADDED | |
attribute_changed | FIRM | |
ethics_dt | None | |
interests | None | |
filer_full_name | PATRICIA TER HEUN | |
filer_city | None | |
filer_st | None | |
filer_zip | None | |
filer_phone | None | |
entity_type | 3 | |
entity_name | STRATEGIC MARKETING SOLUTIONS LTD, LLC | |
entity_city | None | |
entity_st | None | |
entity_zip | None | |
entity_phone | None | |
entity_id | 1335339 | |
responsible_officer | None | |
effect_dt | 2021-01-01 00:00:00 |