| filing_id | 1652472 | 1628943 | 1699586 | 1671588 | 1726852 | 1794206 | 1776573 | 1758005 | 1794206 | 1776573 | 1810467 | 1901174 | 1863074 | 1842080 | 1929444 | 1929444 | 1993612 | 1977700 | 1960776 | 1977700 | 1977700 | 2005917 | 2055016 | 2031841 | 2092164 | 2168122 | 2155162 | 2123065 | 2191580 | 2204212 | 2232318 | 2264254 | 2308890 | 2396409 | 2340273 | 2373231 | 2438169 | 2416745 | 2467830 | 2553318 | 2530672 | 2483494 | 2578938 | 2624256 | 2598333 | 2639058 | ||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| amend_id | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 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 | 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 | ||||||||||||||||||||||||||||||||||||||||||||||
| form_type | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | ||||||||||||||||||||||||||||||||||||||||||||||
| sender_id | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | ||||||||||||||||||||||||||||||||||||||||||||||
| filer_id | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | ||||||||||||||||||||||||||||||||||||||||||||||
| entity_cd | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | ||||||||||||||||||||||||||||||||||||||||||||||
| filer_naml | MELLON CAPITAL MANAGEMENT, INC. | MELLON CAPITAL MANAGEMENT, INC. | MELLON CAPITAL MANAGEMENT, INC. | MELLON CAPITAL MANAGEMENT, INC. | MELLON CAPITAL MANAGEMENT CORPORATION | MELLON CAPITAL MANAGEMENT CORPORATION | MELLON CAPITAL MANAGEMENT CORPORATION | MELLON CAPITAL MANAGEMENT CORPORATION | MELLON CAPITAL MANAGEMENT CORPORATION | MELLON CAPITAL MANAGEMENT CORPORATION | MELLON CAPITAL MANAGEMENT CORPORATION | MELLON CAPITAL MANAGEMENT CORPORATION | MELLON CAPITAL MANAGEMENT CORPORATION | MELLON CAPITAL MANAGEMENT CORPORATION | MELLON CAPITAL MANAGEMENT CORPORATION | MELLON CAPITAL MANAGEMENT CORPORATION | MELLON CAPITAL MANAGEMENT CORPORATION | MELLON CAPITAL MANAGEMENT CORPORATION | MELLON CAPITAL MANAGEMENT CORPORATION | MELLON CAPITAL MANAGEMENT CORPORATION | MELLON CAPITAL MANAGEMENT CORPORATION | MELLON CAPITAL MANAGEMENT CORPORATION | MELLON CAPITAL MANAGEMENT CORPORATION | MELLON CAPITAL MANAGEMENT CORPORATION | MELLON CAPITAL MANAGEMENT CORPORATION | MELLON CAPITAL MANAGEMENT CORPORATION | MELLON CAPITAL MANAGEMENT CORPORATION | MELLON CAPITAL MANAGEMENT CORPORATION | MELLON CAPITAL MANAGEMENT CORPORATION | MELLON CAPITAL MANAGEMENT CORPORATION | BNY MELLON ASSET MANAGEMENT NORTH AMERICA CORPORATION | BNY MELLON ASSET MANAGEMENT NORTH AMERICA CORPORATION | BNY MELLON ASSET MANAGEMENT NORTH AMERICA CORPORATION | MELLON INVESTMENTS CORPORATION | MELLON INVESTMENTS CORPORATION | MELLON INVESTMENTS CORPORATION | MELLON INVESTMENTS CORPORATION | MELLON INVESTMENTS CORPORATION | MELLON INVESTMENTS CORPORATION | MELLON INVESTMENTS CORPORATION | MELLON INVESTMENTS CORPORATION | MELLON INVESTMENTS CORPORATION | MELLON INVESTMENTS CORPORATION | MELLON INVESTMENTS CORPORATION | MELLON INVESTMENTS CORPORATION | MELLON INVESTMENTS CORPORATION | ||||||||||||||||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||||||||||||||||
| report_num | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 001 | 001 | 000 | 000 | 000 | 000 | 000 | 001 | 000 | 000 | 000 | 001 | 002 | 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 | ||||||||||||||||||||||||||||||||||||||||||||||
| rpt_date | 2012-04-17 00:00:00 | 2012-01-18 00:00:00 | 2012-10-18 00:00:00 | 2012-07-16 00:00:00 | 2013-01-16 00:00:00 | 2013-10-15 00:00:00 | 2013-07-19 00:00:00 | 2013-04-17 00:00:00 | 2013-11-14 00:00:00 | 2013-11-14 00:00:00 | 2014-01-16 00:00:00 | 2014-10-21 00:00:00 | 2014-07-15 00:00:00 | 2014-04-28 00:00:00 | 2015-01-26 00:00:00 | 2015-01-29 00:00:00 | 2015-10-23 00:00:00 | 2015-07-27 00:00:00 | 2015-04-23 00:00:00 | 2015-11-12 00:00:00 | 2015-11-24 00:00:00 | 2016-01-25 00:00:00 | 2016-07-14 00:00:00 | 2016-04-25 00:00:00 | 2016-10-20 00:00:00 | 2017-07-18 00:00:00 | 2017-04-28 00:00:00 | 2017-01-25 00:00:00 | 2017-10-30 00:00:00 | 2018-01-23 00:00:00 | 2018-04-18 00:00:00 | 2018-07-13 00:00:00 | 2018-10-19 00:00:00 | 2019-07-30 00:00:00 | 2019-01-25 00:00:00 | 2019-04-16 00:00:00 | 2020-01-29 00:00:00 | 2019-10-29 00:00:00 | 2020-04-27 00:00:00 | 2021-02-01 00:00:00 | 2020-11-02 00:00:00 | 2020-07-30 00:00:00 | 2021-04-29 00:00:00 | 2021-11-01 00:00:00 | 2021-07-28 00:00:00 | 2022-01-27 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||
| from_date | 2012-01-01 00:00:00 | 2011-10-01 00:00:00 | 2012-07-01 00:00:00 | 2012-04-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-07-01 00:00:00 | 2013-04-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 | 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-04-01 00:00:00 | 2015-04-01 00:00:00 | 2015-10-01 00:00:00 | 2016-04-01 00:00:00 | 2016-01-01 00:00:00 | 2016-07-01 00:00:00 | 2017-04-01 00:00:00 | 2017-01-01 00:00:00 | 2016-10-01 00:00:00 | 2017-07-01 00:00:00 | 2017-10-01 00:00:00 | 2018-01-01 00:00:00 | 2018-04-01 00:00:00 | 2018-07-01 00:00:00 | 2019-04-01 00:00:00 | 2018-10-01 00:00:00 | 2019-01-01 00:00:00 | 2019-10-01 00:00:00 | 2019-07-01 00:00:00 | 2020-01-01 00:00:00 | 2020-10-01 00:00:00 | 2020-07-01 00:00:00 | 2020-04-01 00:00:00 | 2021-01-01 00:00:00 | 2021-07-01 00:00:00 | 2021-04-01 00:00:00 | 2021-10-01 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||
| thru_date | 2012-03-31 00:00:00 | 2011-12-31 00:00:00 | 2012-09-30 00:00:00 | 2012-06-30 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-09-30 00:00:00 | 2013-06-30 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 | 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-06-30 00:00:00 | 2015-06-30 00:00:00 | 2015-12-31 00:00:00 | 2016-06-30 00:00:00 | 2016-03-31 00:00:00 | 2016-09-30 00:00:00 | 2017-06-30 00:00:00 | 2017-03-31 00:00:00 | 2016-12-31 00:00:00 | 2017-09-30 00:00:00 | 2017-12-31 00:00:00 | 2018-03-31 00:00:00 | 2018-06-30 00:00:00 | 2018-09-30 00:00:00 | 2019-06-30 00:00:00 | 2018-12-31 00:00:00 | 2019-03-31 00:00:00 | 2019-12-31 00:00:00 | 2019-09-30 00:00:00 | 2020-03-31 00:00:00 | 2020-12-31 00:00:00 | 2020-09-30 00:00:00 | 2020-06-30 00:00:00 | 2021-03-31 00:00:00 | 2021-09-30 00:00:00 | 2021-06-30 00:00:00 | 2021-12-31 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||
| cum_beg_dt | 2011-01-01 00:00:00 | 2011-01-01 00:00:00 | 2011-01-01 00:00:00 | 2011-01-01 00:00:00 | 2011-01-01 00:00:00 | 2013-01-01 00:00:00 | 2013-01-01 00:00:00 | 2013-01-01 00:00:00 | 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 | 2013-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017-01-01 00:00:00 | 2015-01-01 00:00:00 | 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 | 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 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||
| firm_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 | ||||||||||||||||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||||||||||||||||
| firm_city | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | BOSTON | BOSTON | BOSTON | BOSTON | BOSTON | BOSTON | BOSTON | BOSTON | BOSTON | BOSTON | BOSTON | BOSTON | BOSTON | ||||||||||||||||||||||||||||||||||||||||||||||
| 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 | MA | MA | MA | MA | MA | MA | MA | MA | MA | MA | MA | MA | MA | ||||||||||||||||||||||||||||||||||||||||||||||
| firm_zip4 | 94105 | 94105 | 94105 | 94105 | 94105 | 94105 | 94105 | 94105 | 94105 | 94105 | 94105 | 94105 | 94105 | 94105 | 94105 | 94105 | 94105 | 94105 | 94105 | 94105 | 94105 | 94105 | 94105 | 94105 | 94105 | 94105 | 94105 | 94105 | 94105 | 94105 | 94105 | 94105 | 94105 | 02108 | 02108 | 02108 | 02108 | 02108 | 02108 | 02108 | 02108 | 02108 | 02108 | 02108 | 02108 | 02108 | ||||||||||||||||||||||||||||||||||||||||||||||
| firm_phon | 4155466056 | 4155466056 | 4155466056 | 4155466056 | 4122367653 | 4122367653 | 4122367653 | 4122367653 | 4122367653 | 4122367653 | 4122367653 | 4122367653 | 4122367653 | 4122367653 | 4122367653 | 4122367653 | 4122367653 | 4122367653 | 4122367653 | 4122367653 | 4122367653 | 4122367653 | 4122367653 | 4122367653 | 4122367653 | 4122367653 | 4122367653 | 4122367653 | 4122367653 | 4122367653 | 4122367653 | 4122346199 | 4122346199 | 4122346199 | 4122346199 | 4122346199 | 4122346199 | 4122346199 | 4122346199 | 4122346199 | 4122346199 | 4122346199 | 4122342030 | 4122342030 | 4122342030 | 4122342030 | ||||||||||||||||||||||||||||||||||||||||||||||
| mail_city | PITTSBURGH | PITTSBURGH | PITTSBURGH | PITTSBURGH | PITTSBURGH | PITTSBURGH | PITTSBURGH | PITTSBURGH | PITTSBURGH | PITTSBURGH | PITTSBURGH | PITTSBURGH | PITTSBURGH | PITTSBURGH | PITTSBURGH | PITTSBURGH | PITTSBURGH | PITTSBURGH | PITTSBURGH | PITTSBURGH | PITTSBURGH | PITTSBURGH | PITTSBURGH | PITTSBURGH | PITTSBURGH | PITTSBURGH | PITTSBURGH | PITTSBURGH | PITTSBURGH | PITTSBURGH | PITTSBURGH | PITTSBURGH | PITTSBURGH | PITTSBURGH | PITTSBURGH | PITTSBURGH | PITTSBURGH | PITTSBURGH | PITTSBURGH | PITTSBURGH | PITTSBURGH | PITTSBURGH | PITTSBURGH | PITTSBURGH | PITTSBURGH | PITTSBURGH | ||||||||||||||||||||||||||||||||||||||||||||||
| mail_st | PA | PA | PA | PA | PA | PA | PA | PA | PA | PA | PA | PA | PA | PA | PA | PA | PA | PA | PA | PA | PA | PA | PA | PA | PA | PA | PA | PA | PA | PA | PA | PA | PA | PA | PA | PA | PA | PA | PA | PA | PA | PA | PA | PA | PA | PA | ||||||||||||||||||||||||||||||||||||||||||||||
| mail_zip4 | 15258 | 15258 | 15258 | 15258 | 15258 | 15258 | 15258 | 15258 | 15258 | 15258 | 15258 | 15258 | 15258 | 15258 | 15258 | 15258 | 15258 | 15258 | 15258 | 15258 | 15258 | 15258 | 15258 | 15258 | 15258 | 15258 | 15258 | 15258 | 15258 | 15258 | 15258 | 15258 | 15258 | 15258 | 15258 | 15258 | 15258 | 15258 | 15258 | 15258 | 15258 | 15258 | 15258 | 15258 | 15258 | 15258 | ||||||||||||||||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||||||||||||||||
| sig_date | 2012-04-17 00:00:00 | 2012-01-18 00:00:00 | 2012-10-18 00:00:00 | 2012-07-16 00:00:00 | 2013-01-16 00:00:00 | 2013-10-15 00:00:00 | 2013-07-19 00:00:00 | 2013-04-17 00:00:00 | 2013-11-14 00:00:00 | 2013-11-14 00:00:00 | 2014-01-16 00:00:00 | 2014-10-21 00:00:00 | 2014-07-15 00:00:00 | 2014-04-28 00:00:00 | 2015-01-26 00:00:00 | 2015-01-28 00:00:00 | 2015-10-23 00:00:00 | 2015-07-27 00:00:00 | 2015-04-23 00:00:00 | 2015-11-12 00:00:00 | 2015-11-24 00:00:00 | 2016-01-25 00:00:00 | 2016-07-14 00:00:00 | 2016-04-25 00:00:00 | 2016-10-20 00:00:00 | 2017-07-18 00:00:00 | 2017-04-28 00:00:00 | 2017-01-25 00:00:00 | 2017-10-30 00:00:00 | 2018-01-23 00:00:00 | 2018-04-18 00:00:00 | 2018-07-13 00:00:00 | 2018-10-19 00:00:00 | 2019-07-30 00:00:00 | 2019-01-25 00:00:00 | 2019-04-16 00:00:00 | 2020-01-29 00:00:00 | 2019-10-29 00:00:00 | 2020-04-27 00:00:00 | 2021-02-01 00:00:00 | 2020-11-02 00:00:00 | 2020-07-30 00:00:00 | 2021-04-29 00:00:00 | 2021-11-01 00:00:00 | 2021-07-28 00:00:00 | 2022-01-27 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||
| sig_loc | Pittsburgh, PA | Pittsburgh, PA | Pittsburgh, PA | Pittsburgh, PA | Pittsburgh, PA | Pittsburgh, PA | Pittsburgh, PA | Pittsburgh PA | Pittsburgh, PA | Pittsburgh, PA | Pittsburgh, PA | Pittsburgh, PA | Pittsburgh, PA | Pittsburgh, PA | Pittsburgh, PA | Pittsburgh, PA | Pittsburgh, PA | Pittsburgh, PA | Pittsburgh, PA | Pittsburgh, PA | Pittsburgh, PA | Pittsburgh, PA | Pittsburgh, PA | Pittsburgh, PA | Pittsburgh, PA | Pittsburgh, PA | Pittsburgh, PA | Pittsburgh, PA | Pittsburgh, PA | Pittsburgh, PA | Pittsburgh, PA | Pittsburgh, PA | Pittsburgh, PA | Pittsburgh, PA | Pittsburgh, PA | Pittsburgh, PA | pittsburgh, pa | Pittsburgh, PA | Pittsburgh, PA | Pittsburgh, PA | Pittsburgh | Pittsburgh, PA | Pittsburgh, PA | PITTSBURGH | Pittsburgh, PA | Pittsburgh, PA | ||||||||||||||||||||||||||||||||||||||||||||||
| sig_naml | Chulack | Chulack | Chulack | Chulack | Chulack | Chulack | Chulack | Chulack | Chulack | Chulack | Chulack | Chulack | Chulack | Chulack | Briggs | Briggs | Briggs | Briggs | Briggs | Briggs | Briggs | Briggs | Briggs | Briggs | Briggs | Briggs | Briggs | Briggs | Briggs | Briggs | Briggs | Yeager | Yeager | Joyce | Yeager | Yeager | Joyce | Joyce | Joyce | Stefanis | Stefanis | Stefanis | Stefanis | Koch | Koch | Koch | ||||||||||||||||||||||||||||||||||||||||||||||
| sig_namf | Kristin | Kristin | Kristin | Kristin | Kristin | Kristin | Kristin | Kristin | Kristin | Kristin | Kristin | Kristin | Kristin | Kristin | Kristin | Kristin | Kristin | Kristin | Kristin | Kristin | Kristin | Kristin | Kristin | Kristin | Kristin | Kristin | Kristin | Kristin | Kristin | Kristin | Kristin | Cassandra | Cassandra | Brian | Cassandra | Cassandra | Brian | Brian | Brian | Vasilea | Vasilea | Vasilea | Vasilea | Richard | Richard | Richard | ||||||||||||||||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||||||||||||||||
| prn_naml | Chulack | Chulack | Chulack | Chulack | Chulack | Chulack | Chulack | Chulack | Chulack | Chulack | Chulack | Chulack | Chulack | Chulack | Briggs | Briggs | Briggs | Briggs | Briggs | Briggs | Briggs | Briggs | Briggs | Briggs | Briggs | Briggs | Briggs | Briggs | Briggs | Briggs | Briggs | Yeager | Yeager | Joyce | Yeager | Yeager | Joyce | Joyce | Joyce | Stefanis | Stefanis | Stefanis | Stefanis | Koch | Koch | Koch | ||||||||||||||||||||||||||||||||||||||||||||||
| prn_namf | Kristin | Kristin | Kristin | Kristin | Kristin | Kristin | Kristin | Kristin | Kristin | Kristin | Kristin | Kristin | Kristin | Kristin | Kristin | Kristin | Kristin | Kristin | Kristin | Kristin | Kristin | Kristin | Kristin | Kristin | Kristin | Kristin | Kristin | Kristin | Kristin | Kristin | Kristin | Cassandra | Cassandra | Brian | Cassandra | Cassandra | Brian | Brian | Brian | Vasilea | Vasilea | Vasilea | Vasilea | Richard | Richard | Richard | ||||||||||||||||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||||||||||||||||
| sig_title | Vice President | Vice President | Vice President | Vice President | Vice President | Vice President, Compliance Officer | Vice President, Compliance Officer | Vice President | Vice President, Compliance Officer | Vice President, Compliance Officer | Vice President, Compliance Officer | Vice President, Compliance Officer | Vice President, Compliance Officer | Compliance Officer | Vice President | Vice President | VP & Compliance Officer | VP & Compliance Officer | Vice President, Compliance Officer | VP & Compliance Officer | VP & Compliance Officer | VP & Compliance Officer | VP & Compliance Officer | VP and Compliance Officer | VP & Compliance Officer | Compliance Manager | VP & Compliance Manager | Compliance Manager | VP & Compliance Manager | VP & Compliance Manager | VP & Compliance Manager | Compliance Officer | Compliance Officer | Managing Director | Compliance Officer | Compliance Officer | Director | Managing Director | Director | Vice President | Vice President | Vice President | Vice President | Vice President | Vice President | Vice President | ||||||||||||||||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||||||||||||||||
| ctrib_n_cb | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | 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 | ||||||||||||||||||||||||||||||||||||||||||||||
| lby_actvty | CalPERS, CalSTRS, University of California | CalPERS, CalSTRS, University of California | CalPERS, CalSTRS, University of California | CalPERS, CalSTRS, University of California | CalPERS | CallSTRS | CalPERS and University of California | CalSTRS and University of California | CallSTRS | CalPERS and University of California | CallSTRS | UC Regents & CalPERS | CallSTRS & CalPERS | CallSTRS & CalPERS | CalPERS | CalPERS & CalSTRS | CalSTRs | CalPERs & CalSTRs | none | CalPERs & CalSTRs | CalPERs & CalSTRs | CalSTRs | none | none | CalPers & CalStrs | CalPERS | CalPERS and CalSTRS | none | none | none | CalPERs & UC Retirement Systems/UC Regents | CalPERs | CalPERs | UC Regents & CalPERs | CalPERs | University of California | CalPERs | CalSTRs | UC Regents/University of California | None | CalPERS | 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 | ||||||||||||||||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||||||||||||||||
| 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 |
| filing_id | 2330505 | 2330505 | 2330505 | 2330505 | 2330505 | 2541294 | 2541294 | 2541294 | 2541294 | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| amend_id | 0 | 2 | 1 | 3 | 4 | 0 | 3 | 2 | 1 | |||||||||
| rec_type | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | |||||||||
| form_type | F603 | F603 | F603 | F603 | F603 | F603 | F603 | F603 | F603 | |||||||||
| sender_id | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | |||||||||
| filer_id | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | |||||||||
| entity_cd | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | LEM | |||||||||
| filer_naml | Mellon Investments Corporation | Mellon Investments Corporation | Mellon Investments Corporation | Mellon Investments Corporation | Mellon Investments Corporation | MELLON INVESTMENTS CORPORATION | MELLON INVESTMENTS CORPORATION | MELLON INVESTMENTS CORPORATION | MELLON INVESTMENTS CORPORATION | |||||||||
| filer_namf | None | None | None | None | None | None | None | None | None | |||||||||
| filer_namt | None | None | None | None | None | None | None | None | None | |||||||||
| filer_nams | None | None | None | None | None | None | None | None | None | |||||||||
| report_num | 000 | 002 | 001 | 003 | 004 | 000 | 003 | 002 | 001 | |||||||||
| rpt_date | 2018-12-28 00:00:00 | 2019-04-02 00:00:00 | 2019-04-02 00:00:00 | 2019-04-02 00:00:00 | 2019-04-02 00:00:00 | 2020-12-31 00:00:00 | 2021-11-16 00:00:00 | 2021-11-16 00:00:00 | 2021-11-16 00:00:00 | |||||||||
| ls_beg_yr | 2019 | 2019 | 2019 | 2019 | 2019 | 2021 | 2021 | 2021 | 2021 | |||||||||
| ls_end_yr | 2020 | 2020 | 2020 | 2020 | 2020 | 2022 | 2022 | 2022 | 2022 | |||||||||
| qual_date | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | |||||||||
| eff_date | None | None | None | None | None | None | None | None | None | |||||||||
| bus_city | BOSTON | BOSTON | BOSTON | BOSTON | BOSTON | BOSTON | BOSTON | BOSTON | BOSTON | |||||||||
| bus_st | MA | MA | MA | MA | MA | MA | MA | MA | MA | |||||||||
| bus_zip4 | 02108 | 02108 | 02108 | 02108 | 02108 | 02108 | 02108 | 02108 | 02108 | |||||||||
| bus_phon | 4122346199 | 4122346199 | 4122346199 | 4122346199 | 4122346199 | 4122362030 | 4122362030 | 4122362030 | 4122362030 | |||||||||
| bus_fax | None | None | None | None | None | None | None | None | None | |||||||||
| bus_email | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | |||||||||
| mail_city | PITTSBURGH | PITTSBURGH | PITTSBURGH | PITTSBURGH | PITTSBURGH | PITTSBURGH | PITTSBURGH | PITTSBURGH | PITTSBURGH | |||||||||
| mail_st | PA | PA | PA | PA | PA | PA | PA | PA | PA | |||||||||
| mail_zip4 | 15258 | 15258 | 15258 | 15258 | 15258 | 15258 | 15258 | 15258 | 15258 | |||||||||
| mail_phon | None | None | None | None | None | None | None | None | None | |||||||||
| sig_date | 2018-12-28 00:00:00 | 2019-04-02 00:00:00 | 2019-04-02 00:00:00 | 2019-04-02 00:00:00 | 2019-04-02 00:00:00 | 2020-12-31 00:00:00 | 2021-11-16 00:00:00 | 2021-11-16 00:00:00 | 2021-11-16 00:00:00 | |||||||||
| sig_loc | None | None | None | None | None | None | None | None | None | |||||||||
| sig_naml | Yeager | Yeager | Yeager | Yeager | Yeager | Stefanis | Koch | Koch | Koch | |||||||||
| sig_namf | Cassandra | Cassandra | Cassandra | Cassandra | Cassandra | Vasilea | Richard | Richard | Richard | |||||||||
| sig_namt | None | None | None | None | None | None | None | None | None | |||||||||
| sig_nams | None | None | None | None | None | None | None | None | None | |||||||||
| prn_naml | Yeager | Yeager | Yeager | Yeager | Yeager | Stefanis | Koch | Koch | Koch | |||||||||
| prn_namf | Cassandra | Cassandra | Cassandra | Cassandra | Cassandra | Vasilea | Richard | Richard | Richard | |||||||||
| prn_namt | None | None | None | None | None | None | None | None | None | |||||||||
| prn_nams | None | None | None | None | None | None | None | None | None | |||||||||
| sig_title | Vice President | Vice President | Vice President | Vice President | Vice President | Vice President | Vice President | Vice President | Vice President | |||||||||
| stmt_firm | None | None | None | None | None | None | None | None | None | |||||||||
| ind_cb | None | None | None | None | None | None | None | None | None | |||||||||
| bus_cb | X | X | X | X | X | X | X | X | X | |||||||||
| trade_cb | None | None | None | None | None | None | None | None | None | |||||||||
| oth_cb | None | None | None | None | None | None | None | None | None | |||||||||
| a_b_name | None | None | None | None | None | None | None | None | None | |||||||||
| a_b_city | None | None | None | None | None | None | None | None | None | |||||||||
| a_b_st | None | None | None | None | None | None | None | None | None | |||||||||
| a_b_zip4 | None | None | None | None | None | None | None | None | None | |||||||||
| descrip_1 | None | None | None | None | None | None | None | None | None | |||||||||
| descrip_2 | Financial Services | Financial Services | Financial Services | Financial Services | Financial Services | Financial Services | Financial Services | Financial Services | Financial Services | |||||||||
| c_less50 | None | None | None | None | None | None | None | None | None | |||||||||
| c_more50 | None | None | None | None | None | None | None | None | None | |||||||||
| ind_class | None | None | None | None | None | None | None | None | None | |||||||||
| ind_descr | None | None | None | None | None | None | None | None | None | |||||||||
| bus_class | FIN | FIN | FIN | FIN | FIN | FIN | FIN | FIN | FIN | |||||||||
| bus_descr | None | None | None | None | None | None | None | None | None | |||||||||
| auth_name | None | None | None | None | None | None | None | None | None | |||||||||
| auth_city | None | None | None | None | None | None | None | None | None | |||||||||
| auth_st | None | None | None | None | None | None | None | None | None | |||||||||
| auth_zip4 | None | None | None | None | None | None | None | None | None | |||||||||
| lobby_int | Selling or offering the sale of securities, assets, or asset management services. | Selling or offering the sale of securities, assets, or asset management services. | Selling or offering the sale of securities, assets, or asset management services. | Selling or offering the sale of securities, assets, or asset management services. | Selling or offering the sale of securities, assets, or asset management services. | Selling or offering the sale of securities, assets, or asset management services | Selling or offering the sale of securities, assets, or asset management services | Selling or offering the sale of securities, assets, or asset management services | Selling or offering the sale of securities, assets, or asset management services | |||||||||
| influen_yn | None | None | None | None | None | None | None | None | None | |||||||||
| firm_name | None | None | None | None | None | None | None | None | None | |||||||||
| newcert_cb | None | None | None | None | None | None | None | None | None | |||||||||
| rencert_cb | None | None | None | None | None | None | None | None | None | |||||||||
| complet_dt | None | None | None | None | None | None | None | None | None | |||||||||
| lby_reg_cb | None | None | None | None | None | None | None | None | None | |||||||||
| lby_604_cb | None | None | None | None | None | None | None | None | None | |||||||||
| st_leg_yn | None | None | None | None | None | None | None | None | None | |||||||||
| st_agency | None | None | None | None | None | None | None | None | None | |||||||||
| lobby_cb | None | None | None | None | None | None | None | None | None | |||||||||
| l_firm_cb | None | None | None | None | None | None | None | None | None |
| filer_id | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | ||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| adrid | 2209757 | 2209758 | 2464135 | 2464136 | 2413532 | 2413533 | 2257516 | 2257517 | 2465624 | 2337146 | 2337147 | 2473730 | 2505295 | 2505296 | ||||||||||||||
| effect_dt | 2011-01-01 00:00:00 | 2011-01-06 00:00:00 | 2018-06-27 00:00:00 | 2018-06-27 00:00:00 | 2017-01-01 00:00:00 | 2017-01-01 00:00:00 | 2013-01-01 00:00:00 | 2013-01-01 00:00:00 | 2019-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | 2019-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | ||||||||||||||
| add_type | 7051 | 7082 | 7082 | 7051 | 7051 | 7082 | 7051 | 7082 | 7082 | 7051 | 7082 | 7051 | 7051 | 7082 | ||||||||||||||
| session_id | 2011 | 2011 | 2017 | 2017 | 2017 | 2017 | 2013 | 2013 | 2019 | 2015 | 2015 | 2019 | 2021 | 2021 |
| filer_id | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| filing_id | 1776573 | 1863074 | 1776573 | 1810467 | 1794206 | 1794206 | 1960776 | 1901174 | 1585997 | 1597529 | 1560673 | 1619182 | 1628943 | 1609572 | 1642609 | 1652472 | 1659248 | 1671588 | 1699586 | 1926785 | 1929444 | 1929444 | 1899605 | 1724610 | 1726852 | 1842080 | 1840348 | 1758989 | 1758005 | 1993612 | 1977700 | 1977700 | 2330505 | 2340273 | 2217946 | 2330505 | 2438169 | 2330505 | 2330505 | 2578938 | 2214564 | 2214566 | 2262061 | 2483494 | 2264254 | 2416745 | 2005917 | 1977700 | 2055016 | 2031841 | 2092164 | 2119205 | 2123065 | 2155162 | 2168122 | 2318369 | 2373231 | 2336973 | 2232318 | 2371880 | 2371881 | 2371882 | 2371883 | 2409429 | 2541294 | 2571708 | 2204212 | 2530672 | 2308890 | 2191580 | 2457439 | 2219568 | 2396409 | 2330505 | 2467830 | 2553318 | 2639058 | 2541294 | 2541294 | 2624256 | 2541294 | 2598333 | 2629442 | 2629443 | 2629444 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| period_id | 214 | 218 | 214 | 216 | 215 | 215 | 221 | 219 | None | None | None | None | 208 | None | None | 209 | None | 210 | 211 | None | 220 | 220 | None | None | 212 | 217 | None | None | 213 | 223 | 222 | 222 | 238 | 236 | None | 236 | 240 | 238 | 238 | 245 | None | None | None | 242 | 234 | 239 | 224 | 222 | 226 | 225 | 227 | None | 228 | 229 | 230 | None | 237 | None | 233 | None | None | None | None | None | 244 | None | 232 | 243 | 235 | 231 | None | None | 238 | 238 | 241 | 244 | 248 | 248 | 248 | 247 | 248 | 246 | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| form_id | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F605 | F603 | F635 | F635 | F635 | F605 | F635 | F605 | F635 | F635 | F603 | F635 | F635 | F605 | F603 | F635 | F635 | F605 | F605 | F635 | F635 | F635 | F635 | F603 | F635 | F605 | F603 | F635 | F603 | F603 | F635 | F605 | F888 | F605 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F603 | F635 | F635 | F635 | F888 | F635 | F603 | F635 | F605 | F605 | F605 | F605 | F605 | F603 | F603 | F635 | F635 | F635 | F635 | F605 | F605 | F635 | F603 | F635 | F635 | F635 | F603 | F603 | F635 | F603 | F635 | F605 | F605 | F605 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| filing_sequence | 0 | 0 | 1 | 0 | 1 | 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 | 2 | 1 | 0 | 0 | 0 | 0 | 2 | 4 | 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 | 3 | 0 | 0 | 0 | 1 | 3 | 0 | 2 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| filing_date | 2013-07-19 00:00:00 | 2014-07-15 00:00:00 | 2013-11-14 00:00:00 | 2014-01-16 00:00:00 | 2013-11-14 00:00:00 | 2013-10-15 00:00:00 | 2015-04-23 00:00:00 | 2014-10-21 00:00:00 | 2011-04-11 00:00:00 | 2011-05-27 00:00:00 | 2011-01-10 00:00:00 | 2011-10-21 00:00:00 | 2012-01-18 00:00:00 | 2011-07-26 00:00:00 | 2012-02-21 00:00:00 | 2012-04-17 00:00:00 | 2012-04-16 00:00:00 | 2012-07-16 00:00:00 | 2012-10-18 00:00:00 | 2014-12-17 00:00:00 | 2015-01-26 00:00:00 | 2015-01-29 00:00:00 | 2014-10-16 00:00:00 | 2013-01-02 00:00:00 | 2013-01-16 00:00:00 | 2014-04-28 00:00:00 | 2014-04-18 00:00:00 | 2013-04-09 00:00:00 | 2013-04-17 00:00:00 | 2015-10-23 00:00:00 | 2015-07-27 00:00:00 | 2015-11-24 00:00:00 | 2019-04-02 00:00:00 | 2019-01-25 00:00:00 | 2018-02-21 00:00:00 | 2018-12-28 00:00:00 | 2020-01-29 00:00:00 | 2019-04-02 00:00:00 | 2019-04-02 00:00:00 | 2021-04-29 00:00:00 | 2018-02-02 00:00:00 | 2018-02-02 00:00:00 | 2018-06-29 00:00:00 | 2020-07-30 00:00:00 | 2018-07-13 00:00:00 | 2019-10-29 00:00:00 | 2016-01-25 00:00:00 | 2015-11-12 00:00:00 | 2016-07-14 00:00:00 | 2016-04-25 00:00:00 | 2016-10-20 00:00:00 | 2016-12-29 00:00:00 | 2017-01-25 00:00:00 | 2017-04-28 00:00:00 | 2017-07-18 00:00:00 | 2018-10-17 00:00:00 | 2019-04-16 00:00:00 | 2019-01-02 00:00:00 | 2018-04-18 00:00:00 | 2019-01-30 00:00:00 | 2019-03-15 00:00:00 | 2019-03-15 00:00:00 | 2019-03-15 00:00:00 | 2019-09-04 00:00:00 | 2020-12-31 00:00:00 | 2020-12-31 00:00:00 | 2018-01-23 00:00:00 | 2020-11-02 00:00:00 | 2018-10-19 00:00:00 | 2017-10-30 00:00:00 | 2020-02-21 00:00:00 | 2018-03-02 00:00:00 | 2019-07-30 00:00:00 | 2019-04-02 00:00:00 | 2020-04-27 00:00:00 | 2021-02-01 00:00:00 | 2022-01-27 00:00:00 | 2021-11-16 00:00:00 | 2021-11-16 00:00:00 | 2021-11-01 00:00:00 | 2021-11-16 00:00:00 | 2021-07-28 00:00:00 | 2021-11-16 00:00:00 | 2021-11-16 00:00:00 | 2021-11-16 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| stmnt_type | 10001 | 10001 | 10002 | 10001 | 10002 | 10001 | 10001 | 10001 | 10005 | 10006 | 10005 | 10005 | 10001 | 10005 | 10006 | 10001 | 10006 | 10001 | 10001 | 10005 | 10001 | 10002 | 10006 | 10005 | 10001 | 10001 | 10006 | 10005 | 10001 | 10001 | 10001 | 10002 | 10002 | 10001 | 10006 | 10001 | 10001 | 10002 | 10002 | 10001 | 10006 | 10005 | 10006 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10005 | 10005 | 10005 | 10005 | 10005 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10005 | 10006 | 10001 | 10002 | 10001 | 10001 | 10001 | 10002 | 10002 | 10001 | 10002 | 10001 | 10002 | 10002 | 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 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| session_id | 2013 | 2013 | 2013 | 2013 | 2013 | 2013 | 2015 | 2013 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2015 | 2013 | 2013 | 2013 | 2013 | 2011 | 2013 | 2013 | 2013 | 2013 | 2015 | 2015 | 2015 | 2019 | 2017 | 2017 | 2019 | 2019 | 2019 | 2019 | 2021 | 2017 | 2017 | 2017 | 2019 | 2017 | 2019 | 2015 | 2015 | 2015 | 2015 | 2015 | 2017 | 2015 | 2017 | 2017 | 2017 | 2019 | 2019 | 2017 | 2019 | 2019 | 2019 | 2019 | 2019 | 2021 | 2021 | 2017 | 2019 | 2017 | 2017 | 2019 | 2017 | 2019 | 2019 | 2019 | 2019 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| user_id | ASAETERN | ASAETERN | AGLADNEY | ASAETERN | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | YRODRIGU | DMCCASTL | AGLADNEY | ASAETERN | AGLADNEY | YRODRIGU | AGLADNEY | YRODRIGU | ASAETERN | AGLADNEY | GPEREZ | AGLADNEY | AGLADNEY | YRODRIGU | SARRIAGA | AGLADNEY | ASAETERN | SMCCONNAN | SARRIAGA | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | GPEREZ | AGLADNEY | YRODRIGU | SARRIAGA | SUSHAKOV | GPEREZ | GPEREZ | CAFILER | YRODRIGU | YRODRIGU | YRODRIGU | MKIRKHAM | AGLADNEY | VUKSTINA | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | PBANFORD | AGLADNEY | AGLADNEY | YRODRIGU | GPEREZ | VUKSTINA | SARRIAGA | AGLADNEY | GPEREZ | SARRIAGA | SARRIAGA | SARRIAGA | GPEREZ | JMENDOZA | JMENDOZA | AGLADNEY | MKIRKHAM | AGLADNEY | AGLADNEY | GPEREZ | YRODRIGU | AGLADNEY | GPEREZ | SUSHAKOV | MKIRKHAM | CAFILER | MMERCHANT | MMERCHANT | CAFILER | MMERCHANT | CAFILER | MMERCHANT | MMERCHANT | MMERCHANT | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| fine_audit | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| rpt_start | 2013-04-01 00:00:00 | 2014-04-01 00:00:00 | 2013-04-01 00:00:00 | 2013-10-01 00:00:00 | 2013-07-01 00:00:00 | 2013-07-01 00:00:00 | 2015-01-01 00:00:00 | 2014-07-01 00:00:00 | 2011-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2011-07-01 00:00:00 | 2011-10-01 00:00:00 | 2011-04-01 00:00:00 | 1900-01-01 00:00:00 | 2012-01-01 00:00:00 | 1900-01-01 00:00:00 | 2012-04-01 00:00:00 | 2012-07-01 00:00:00 | 1900-01-01 00:00:00 | 2014-10-01 00:00:00 | 2014-10-01 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 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2013-01-01 00:00:00 | 2015-07-01 00:00:00 | 2015-04-01 00:00:00 | 2015-04-01 00:00:00 | 2019-04-02 00:00:00 | 2018-10-01 00:00:00 | 1900-01-01 00:00:00 | 2018-12-28 00:00:00 | 2019-10-01 00:00:00 | 2019-04-02 00:00:00 | 2019-04-02 00:00:00 | 2021-01-01 00:00:00 | 1900-01-01 00:00:00 | None | 1900-01-01 00:00:00 | 2020-04-01 00:00:00 | 2018-04-01 00:00:00 | 2019-07-01 00:00:00 | 2015-10-01 00:00:00 | 2015-04-01 00:00:00 | 2016-04-01 00:00:00 | 2016-01-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 | None | 2019-01-01 00:00:00 | 1900-01-01 00:00:00 | 2018-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 | 2020-12-31 00:00:00 | 1900-01-01 00:00:00 | 2017-10-01 00:00:00 | 2020-07-01 00:00:00 | 2018-07-01 00:00:00 | 2017-07-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2019-04-01 00:00:00 | 2019-04-02 00:00:00 | 2020-01-01 00:00:00 | 2020-10-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-16 00:00:00 | 2021-11-16 00:00:00 | 2021-07-01 00:00:00 | 2021-11-16 00:00:00 | 2021-04-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| rpt_end | 2013-06-30 00:00:00 | 2014-06-30 00:00:00 | 2013-06-30 00:00:00 | 2013-12-31 00:00:00 | 2013-09-30 00:00:00 | 2013-09-30 00:00:00 | 2015-03-31 00:00:00 | 2014-09-30 00:00:00 | 2011-03-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2011-09-30 00:00:00 | 2011-12-31 00:00:00 | 2011-06-30 00:00:00 | 1900-01-01 00:00:00 | 2012-03-31 00:00:00 | 1900-01-01 00:00:00 | 2012-06-30 00:00:00 | 2012-09-30 00:00:00 | 1900-01-01 00:00:00 | 2014-12-31 00:00:00 | 2014-12-31 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 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2013-03-31 00:00:00 | 2015-09-30 00:00:00 | 2015-06-30 00:00:00 | 2015-06-30 00:00:00 | 2019-04-02 00:00:00 | 2018-12-31 00:00:00 | 1900-01-01 00:00:00 | 2018-12-28 00:00:00 | 2019-12-31 00:00:00 | 2019-04-02 00:00:00 | 2019-04-02 00:00:00 | 2021-03-31 00:00:00 | 1900-01-01 00:00:00 | None | 1900-01-01 00:00:00 | 2020-06-30 00:00:00 | 2018-06-30 00:00:00 | 2019-09-30 00:00:00 | 2015-12-31 00:00:00 | 2015-06-30 00:00:00 | 2016-06-30 00:00:00 | 2016-03-31 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 | None | 2019-03-31 00:00:00 | 1900-01-01 00:00:00 | 2018-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 | 2020-12-31 00:00:00 | 1900-01-01 00:00:00 | 2017-12-31 00:00:00 | 2020-09-30 00:00:00 | 2018-09-30 00:00:00 | 2017-09-30 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2019-06-30 00:00:00 | 2019-04-02 00:00:00 | 2020-03-31 00:00:00 | 2020-12-31 00:00:00 | 2021-12-31 00:00:00 | 2021-11-16 00:00:00 | 2021-11-16 00:00:00 | 2021-09-30 00:00:00 | 2021-11-16 00:00:00 | 2021-06-30 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| filing_type | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | None | None | None | 22006 | None | None | 22006 | None | 22006 | 22006 | None | 22006 | 22006 | None | None | 22006 | 22006 | None | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | None | None | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | None | 22006 | None | 22006 | None | None | None | None | None | 22006 | None | 22006 | 22006 | 22006 | 22006 | None | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | None | None |
| filer_id | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| session_id | 2011 | 2013 | 2017 | 2015 | 2019 | 2021 | ||||||
| interest_cd | 40304 | 40304 | 40304 | 40304 | 40304 | 40304 | ||||||
| effect_date | 2011-01-01 00:00:00 | 2013-01-01 00:00:00 | 2017-01-01 00:00:00 | 2015-01-01 00:00:00 | 2019-01-01 00:00:00 | 2021-01-01 00:00:00 |
| filer_id | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| filer_type | 2 | 2 | 2 | 2 | 2 | 2 | 2 | |||||||
| active | Y | Y | Y | Y | Y | Y | T | |||||||
| race | 0 | None | None | None | None | None | None | |||||||
| session_id | 2011 | 2013 | 2015 | 2017 | 2021 | 2019 | 2021 | |||||||
| category | 0 | None | None | None | None | None | None | |||||||
| category_type | 0 | None | None | None | None | None | None | |||||||
| sub_category | 0 | None | None | None | None | None | None | |||||||
| effect_dt | 2011-01-01 00:00:00 | 2013-01-01 00:00:00 | 2015-01-01 00:00:00 | 2017-01-01 00:00:00 | 2021-01-01 00:00:00 | 2019-01-01 00:00:00 | 2021-11-10 00:00:00 | |||||||
| sub_category_type | 0 | None | None | None | None | None | None | |||||||
| election_type | 0 | None | None | None | None | None | None | |||||||
| sub_category_a | None | None | None | None | None | None | None | |||||||
| nyq_dt | None | None | None | None | None | None | None | |||||||
| party_cd | 0 | None | None | None | None | None | None | |||||||
| county_cd | 0 | None | None | None | None | None | None | |||||||
| district_cd | 0 | None | None | None | None | None | None |
| filer_id | 1335120 | |
|---|---|---|
| xref_id | 1335120 | |
| effect_dt | 2011-01-14 00:00:00 | |
| migration_source | CLAIMS |
| xref_filer_id | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| filer_id | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| filer_type | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| status | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| effect_dt | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | 2021-11-10 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| naml | MELLON INVESTMENTS CORPORATION | MELLON INVESTMENTS CORPORATION | MELLON INVESTMENTS CORPORATION | MELLON INVESTMENTS CORPORATION | MELLON INVESTMENTS CORPORATION | MELLON INVESTMENTS CORPORATION | MELLON INVESTMENTS CORPORATION | MELLON INVESTMENTS CORPORATION | MELLON INVESTMENTS CORPORATION | MELLON INVESTMENTS CORPORATION | MELLON INVESTMENTS CORPORATION | MELLON INVESTMENTS CORPORATION | MELLON INVESTMENTS CORPORATION | MELLON INVESTMENTS CORPORATION | MELLON INVESTMENTS CORPORATION | MELLON INVESTMENTS CORPORATION | MELLON INVESTMENTS CORPORATION | MELLON INVESTMENTS CORPORATION | MELLON INVESTMENTS CORPORATION | MELLON INVESTMENTS CORPORATION | MELLON INVESTMENTS CORPORATION | MELLON INVESTMENTS CORPORATION | MELLON INVESTMENTS CORPORATION | MELLON INVESTMENTS CORPORATION | MELLON INVESTMENTS CORPORATION | MELLON INVESTMENTS CORPORATION | MELLON INVESTMENTS CORPORATION | MELLON INVESTMENTS CORPORATION | BNY MELLON ASSET MANAGEMENT NORTH AMERICA CORPORATION | BNY MELLON ASSET MANAGEMENT NORTH AMERICA CORPORATION | BNY MELLON ASSET MANAGEMENT NORTH AMERICA CORPORATION | BNY MELLON ASSET MANAGEMENT NORTH AMERICA CORPORATION | BNY MELLON ASSET MANAGEMENT NORTH AMERICA CORPORATION | BNY MELLON ASSET MANAGEMENT NORTH AMERICA CORPORATION | BNY MELLON ASSET MANAGEMENT NORTH AMERICA CORPORATION | BNY MELLON ASSET MANAGEMENT NORTH AMERICA CORPORATION | BNY MELLON ASSET MANAGEMENT NORTH AMERICA CORPORATION | BNY MELLON ASSET MANAGEMENT NORTH AMERICA CORPORATION | BNY MELLON ASSET MANAGEMENT NORTH AMERICA CORPORATION | BNY MELLON ASSET MANAGEMENT NORTH AMERICA CORPORATION | BNY MELLON ASSET MANAGEMENT NORTH AMERICA CORPORATION | BNY MELLON ASSET MANAGEMENT NORTH AMERICA CORPORATION | MELLON CAPITAL MANAGEMENT CORPORATION | MELLON CAPITAL MANAGEMENT CORPORATION | MELLON CAPITAL MANAGEMENT CORPORATION | MELLON CAPITAL MANAGEMENT CORPORATION | MELLON CAPITAL MANAGEMENT CORPORATION | MELLON CAPITAL MANAGEMENT CORPORATION | MELLON CAPITAL MANAGEMENT CORPORATION | MELLON CAPITAL MANAGEMENT CORPORATION | MELLON CAPITAL MANAGEMENT CORPORATION | MELLON CAPITAL MANAGEMENT CORPORATION | MELLON CAPITAL MANAGEMENT CORPORATION | MELLON CAPITAL MANAGEMENT CORPORATION | MELLON CAPITAL MANAGEMENT CORPORATION | MELLON CAPITAL MANAGEMENT CORPORATION | MELLON CAPITAL MANAGEMENT CORPORATION | MELLON CAPITAL MANAGEMENT CORPORATION | MELLON CAPITAL MANAGEMENT CORPORATION | MELLON CAPITAL MANAGEMENT CORPORATION | MELLON CAPITAL MANAGEMENT CORPORATION | MELLON CAPITAL MANAGEMENT CORPORATION | MELLON CAPITAL MANAGEMENT CORPORATION | MELLON CAPITAL MANAGEMENT CORPORATION | MELLON CAPITAL MANAGEMENT CORPORATION | MELLON CAPITAL MANAGEMENT CORPORATION | MELLON CAPITAL MANAGEMENT CORPORATION | MELLON CAPITAL MANAGEMENT CORPORATION | MELLON CAPITAL MANAGEMENT CORPORATION | MELLON CAPITAL MANAGEMENT CORPORATION | MELLON CAPITAL MANAGEMENT CORPORATION | MELLON CAPITAL MANAGEMENT CORPORATION | MELLON CAPITAL MANAGEMENT CORPORATION | MELLON CAPITAL MANAGEMENT CORPORATION | MELLON CAPITAL MANAGEMENT CORPORATION | MELLON CAPITAL MANAGEMENT CORPORATION | MELLON CAPITAL MANAGEMENT CORPORATION | MELLON CAPITAL MANAGEMENT CORPORATION | MELLON CAPITAL MANAGEMENT CORPORATION | MELLON CAPITAL MANAGEMENT CORPORATION | MELLON CAPITAL MANAGEMENT CORPORATION | MELLON CAPITAL MANAGEMENT CORPORATION | MELLON CAPITAL MANAGEMENT CORPORATION | MELLON CAPITAL MANAGEMENT CORPORATION | MELLON CAPITAL MANAGEMENT, INC. | MELLON CAPITAL MANAGEMENT, INC. | MELLON CAPITAL MANAGEMENT, INC. | MELLON CAPITAL MANAGEMENT, INC. | MELLON CAPITAL MANAGEMENT, INC. | MELLON CAPITAL MANAGEMENT, INC. | MELLON CAPITAL MANAGEMENT, INC. | MELLON CAPITAL MANAGEMENT, INC. | MELLON CAPITAL MANAGEMENT, INC. | MELLON CAPITAL MANAGEMENT, INC. | MELLON CAPITAL MANAGEMENT, INC. | MELLON CAPITAL MANAGEMENT, INC. | MELLON CAPITAL MANAGEMENT, INC. | MELLON CAPITAL MANAGEMENT, INC. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| city | SAN FRANCISCO | PITTSBURGH | SAN FRANCISCO | PITTSBURGH | SAN FRANCISCO | PITTSBURGH | SAN FRANCISCO | PITTSBURGH | PITTSBURGH | PITTSBURGH | PITTSBURGH | BOSTON | BOSTON | PITTSBURGH | SAN FRANCISCO | PITTSBURGH | SAN FRANCISCO | PITTSBURGH | SAN FRANCISCO | PITTSBURGH | SAN FRANCISCO | PITTSBURGH | PITTSBURGH | PITTSBURGH | PITTSBURGH | BOSTON | BOSTON | PITTSBURGH | SAN FRANCISCO | PITTSBURGH | SAN FRANCISCO | PITTSBURGH | SAN FRANCISCO | PITTSBURGH | SAN FRANCISCO | PITTSBURGH | PITTSBURGH | PITTSBURGH | PITTSBURGH | BOSTON | BOSTON | PITTSBURGH | SAN FRANCISCO | PITTSBURGH | SAN FRANCISCO | PITTSBURGH | SAN FRANCISCO | PITTSBURGH | SAN FRANCISCO | PITTSBURGH | PITTSBURGH | PITTSBURGH | PITTSBURGH | BOSTON | BOSTON | PITTSBURGH | SAN FRANCISCO | PITTSBURGH | SAN FRANCISCO | PITTSBURGH | SAN FRANCISCO | PITTSBURGH | SAN FRANCISCO | PITTSBURGH | PITTSBURGH | PITTSBURGH | PITTSBURGH | BOSTON | BOSTON | PITTSBURGH | SAN FRANCISCO | PITTSBURGH | SAN FRANCISCO | PITTSBURGH | SAN FRANCISCO | PITTSBURGH | SAN FRANCISCO | PITTSBURGH | PITTSBURGH | PITTSBURGH | PITTSBURGH | BOSTON | BOSTON | PITTSBURGH | SAN FRANCISCO | PITTSBURGH | SAN FRANCISCO | PITTSBURGH | SAN FRANCISCO | PITTSBURGH | SAN FRANCISCO | PITTSBURGH | PITTSBURGH | PITTSBURGH | PITTSBURGH | BOSTON | BOSTON | PITTSBURGH | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| st | CA | PA | CA | PA | CA | PA | CA | PA | PA | PA | PA | MA | MA | PA | CA | PA | CA | PA | CA | PA | CA | PA | PA | PA | PA | MA | MA | PA | CA | PA | CA | PA | CA | PA | CA | PA | PA | PA | PA | MA | MA | PA | CA | PA | CA | PA | CA | PA | CA | PA | PA | PA | PA | MA | MA | PA | CA | PA | CA | PA | CA | PA | CA | PA | PA | PA | PA | MA | MA | PA | CA | PA | CA | PA | CA | PA | CA | PA | PA | PA | PA | MA | MA | PA | CA | PA | CA | PA | CA | PA | CA | PA | PA | PA | PA | MA | MA | PA | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| zip4 | 94105 | 15258 | 94105 | 15258 | 94105 | 15258 | 94105 | 15258 | 15258 | 15258 | 15258 | 02108 | 02108 | 15258 | 94105 | 15258 | 94105 | 15258 | 94105 | 15258 | 94105 | 15258 | 15258 | 15258 | 15258 | 02108 | 02108 | 15258 | 94105 | 15258 | 94105 | 15258 | 94105 | 15258 | 94105 | 15258 | 15258 | 15258 | 15258 | 02108 | 02108 | 15258 | 94105 | 15258 | 94105 | 15258 | 94105 | 15258 | 94105 | 15258 | 15258 | 15258 | 15258 | 02108 | 02108 | 15258 | 94105 | 15258 | 94105 | 15258 | 94105 | 15258 | 94105 | 15258 | 15258 | 15258 | 15258 | 02108 | 02108 | 15258 | 94105 | 15258 | 94105 | 15258 | 94105 | 15258 | 94105 | 15258 | 15258 | 15258 | 15258 | 02108 | 02108 | 15258 | 94105 | 15258 | 94105 | 15258 | 94105 | 15258 | 94105 | 15258 | 15258 | 15258 | 15258 | 02108 | 02108 | 15258 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| phon | 4155466056 | 4122367653 | 4122367653 | 4122346199 | 4122346199 | 4122346199 | 4122342030 | 4155466056 | 4122367653 | 4122367653 | 4122346199 | 4122346199 | 4122346199 | 4122342030 | 4155466056 | 4122367653 | 4122367653 | 4122346199 | 4122346199 | 4122346199 | 4122342030 | 4155466056 | 4122367653 | 4122367653 | 4122346199 | 4122346199 | 4122346199 | 4122342030 | 4155466056 | 4122367653 | 4122367653 | 4122346199 | 4122346199 | 4122346199 | 4122342030 | 4155466056 | 4122367653 | 4122367653 | 4122346199 | 4122346199 | 4122346199 | 4122342030 | 4155466056 | 4122367653 | 4122367653 | 4122346199 | 4122346199 | 4122346199 | 4122342030 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| fax | None | None | 4122344467 | None | 4122344467 | None | 4122344467 | None | None | None | 4122344467 | None | 4122344467 | None | 4122344467 | None | None | None | 4122344467 | None | 4122344467 | None | 4122344467 | None | None | None | 4122344467 | None | 4122344467 | None | 4122344467 | None | None | None | 4122344467 | None | 4122344467 | None | 4122344467 | None | None | None | 4122344467 | None | 4122344467 | None | 4122344467 | None | None | None | 4122344467 | None | 4122344467 | None | 4122344467 | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| [email protected] | None | [email protected] | None | [email protected] | None | None | None | None | [email protected] | None | [email protected] | [email protected] | None | [email protected] | None | [email protected] | None | [email protected] | None | None | None | None | [email protected] | None | [email protected] | [email protected] | None | [email protected] | None | [email protected] | None | [email protected] | None | None | None | None | [email protected] | None | [email protected] | [email protected] | None | [email protected] | None | [email protected] | None | [email protected] | None | None | None | None | [email protected] | None | [email protected] | [email protected] | None | [email protected] | None | [email protected] | None | [email protected] | None | None | None | None | [email protected] | None | [email protected] | [email protected] | None | [email protected] | None | [email protected] | None | [email protected] | None | None | None | None | [email protected] | None | [email protected] | [email protected] | None | [email protected] | None | [email protected] | None | [email protected] | None | None | None | None | [email protected] | None | [email protected] | [email protected] | None |
| filer_id | 1335120 |
|---|
| filer_id | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | 1335120 | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| change_no | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 8 | 9 | 7 | 11 | 10 | ||||||||||||
| session_id | 2011 | 2011 | 2011 | 2013 | 2013 | 2013 | 2017 | 2017 | 2017 | 2017 | 2019 | 2019 | ||||||||||||
| log_dt | 2011-05-27 00:00:00 | 2012-04-16 00:00:00 | 2012-02-21 00:00:00 | 2013-04-09 00:00:00 | 2014-04-18 00:00:00 | 2014-10-16 00:00:00 | 2016-12-29 00:00:00 | 2018-02-02 00:00:00 | 2018-03-02 00:00:00 | 2018-02-21 00:00:00 | 2020-02-21 00:00:00 | 2019-09-04 00:00:00 | ||||||||||||
| filer_type | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | ||||||||||||
| correction_flg | Y | None | Y | Y | None | None | None | Y | Y | Y | None | None | ||||||||||||
| action | ADDED | DELETED | ADDED | ADDED | DELETED | DELETED | IN SUSPENSE | CHANGED | ADDED | ADDED | DELETED | DELETED | ||||||||||||
| attribute_changed | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | NAME FROM | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | ||||||||||||
| ethics_dt | 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 | ||||||||||||
| filer_full_name | MELLON CAPITAL MANAGEMENT, INC. | MELLON CAPITAL MANAGEMENT, INC. | MELLON CAPITAL MANAGEMENT, INC. | MELLON CAPITAL MANAGEMENT CORPORATION | MELLON CAPITAL MANAGEMENT CORPORATION | MELLON CAPITAL MANAGEMENT CORPORATION | MELLON CAPITAL MANAGEMENT CORPORATION | BNY MELLON ASSET MANAGEMENT NORTH AMERICA CORPORATION | BNY MELLON ASSET MANAGEMENT NORTH AMERICA CORPORATION | BNY MELLON ASSET MANAGEMENT NORTH AMERICA CORPORATION | MELLON INVESTMENTS CORPORATION | MELLON INVESTMENTS CORPORATION | ||||||||||||
| filer_city | None | None | SAN FRANCISCO | SAN FRANCISCO | None | None | None | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | None | None | ||||||||||||
| filer_st | None | None | CA | CA | None | None | None | CA | CA | CA | None | None | ||||||||||||
| filer_zip | None | None | 94105 | 94105 | None | None | None | 94105 | 94105 | 94105 | None | None | ||||||||||||
| filer_phone | None | None | 4155466056 | 4122367653 | None | None | None | 4155466056 | 4155466056 | 4155466056 | None | None | ||||||||||||
| entity_type | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 2 | 4 | 4 | 4 | 4 | ||||||||||||
| entity_name | MC CREA, FREDERICK | GREG B. LINDSEY | JACOBS, BRIAN | STIDHAM, ROBERT TIMOTHY | BRIAN JACOBS | ROBERT TIMOTHY STIDHAM | MC CREA, FREDERICK H. | MELON CAPITAL MANAGEMENT CORPORATION | MC CORMACK, DANIEL J. | BUCCI, MATTHEW J. | COSGROVE, GERALD | MATTHEW J. BUCCI | ||||||||||||
| entity_city | 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 | ||||||||||||
| entity_zip | 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 | ||||||||||||
| entity_id | 1339419 | 1335122 | None | None | 1345040 | 1334984 | 1339419 | None | None | None | 1417359 | 1359046 | ||||||||||||
| responsible_officer | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
| effect_dt | 2011-05-25 00:00:00 | 2012-04-01 00:00:00 | 2012-02-17 00:00:00 | 2013-04-01 00:00:00 | 2014-04-18 00:00:00 | 2014-07-16 00:00:00 | 2017-07-01 00:00:00 | 2018-01-31 00:00:00 | 2018-03-01 00:00:00 | 2018-01-31 00:00:00 | 2019-03-13 00:00:00 | 2019-07-14 00:00:00 |