INSITITUIONS | Dynamic | newInstitTable | Changed the Cusip/Sector/Shs Out? |
|
||||||||||
Total Insititutions : | N/A | 0 | Update Insititution By Cusips | |||||||||||
% Owned by Insititutions: | N/A % | 0 % | ||||||||||||
pricingQuarterAdminPageOn:
|
2024-03-31 | New % | ||||||||||||
|
||||||||||||||
the compid is:159783 |
reportDate | ratio | endQuaterAffected | dayFrom | dayTo |
Cusip
entryId | groupId | EQUITY | CHANGE | CUSIP | DESCRIPTION | ISSUE STATUS CODE |
ISSUE TYPE CODE |
ADD DATE |
EXPIRATION DATE |
PAYMENT FREQUENCY CODE |
MARGIN FLAG |
OPTION FLAG |
CONVERTED CUSIP |
NASDAQ MARKET CODE |
INDEX ISSUER |
CHANGE DATE |
MERGENT CHANGE DATE |
MATURE DATE |
undefined1 | undefined2 | undefined3 | undefined4 | temp1 | temp2 | fileName | fileDate | processDate | ||
5098042 | 5098042 | DIVIDEND | ADD | 46625HHA1 | 0 | 0 | 1 | 0 | 16.387 | 00 | ? | 2022-09-30 | 2022-10-30 | 2022-09-15 | 0 | 2022-09-15 | ? | 0 | 0006583872 | 20220915.ifs | 2022-09-15 | 2022-09-16 | |||||||
5033340 | 5033340 | DIVIDEND | ADD | 46625HHA1 | 0 | 0 | 1 | 0 | 11.903 | 00 | ? | 2022-06-30 | 2022-07-30 | 2022-06-15 | 0 | 2022-06-15 | ? | 0 | 0006538566 | 20220615.ifs | 2022-06-15 | 2022-06-16 | |||||||
4888582 | 4888582 | DIVIDEND | ADD | 46625HHA1 | 0 | 0 | 1 | 0 | 9.396 | 00 | ? | 2021-12-31 | 2022-01-31 | 2021-12-15 | 0 | 2021-12-15 | ? | 0 | 0006424648 | 20211215.ifs | 2021-12-15 | 2021-12-16 | |||||||
4802288 | 4802288 | DIVIDEND | ADD | 46625HHA1 | 0 | 0 | 1 | 0 | 9.096 | 00 | ? | 2021-09-30 | 2021-10-30 | 2021-09-15 | 0 | 2021-09-15 | ? | 0 | 0006367708 | 20210915.ifs | 2021-09-15 | 2021-09-16 | |||||||
4729878 | 4729878 | DIVIDEND | ADD | 46625HHA1 | 0 | 0 | 1 | 0 | 9.24 | 00 | ? | 2021-06-30 | 2021-07-30 | 2021-06-15 | 0 | 2021-06-15 | ? | 0 | 0006322323 | 20210615.ifs | 2021-06-15 | 2021-06-16 | |||||||
4462373 | 4462373 | DIVIDEND | ADD | 46625HHA1 | 0 | 0 | 1 | 0 | 9.553 | 00 | ? | 2020-09-30 | 2020-10-30 | 2020-09-15 | 0 | 2020-09-15 | ? | 0 | 0006159000 | 20200915.ifs | 2020-09-15 | 2020-09-16 | |||||||
4391970 | 4391970 | DIVIDEND | ADD | 46625HHA1 | 0 | 0 | 1 | 0 | 10.693 | 00 | ? | 2020-06-30 | 2020-07-30 | 2020-06-15 | 0 | 2020-06-15 | ? | 0 | 0006112682 | 20200615.ifs | 2020-06-15 | 2020-06-16 | |||||||
4240011 | 4240011 | DIVIDEND | ADD | 46625HHA1 | 0 | 0 | 1 | 0 | 13.244 | 00 | ? | 2020-03-31 | 2020-04-30 | 2020-03-13 | 0 | 2020-03-13 | ? | 0 | 0006068766 | 20200313.ifs | 2020-03-13 | 2020-03-14 | |||||||
4240012 | 4240012 | DIVIDEND | ADD | 46625HHA1 | 0 | 0 | 1 | 0 | 13.244 | 00 | ? | 2020-03-31 | 2020-04-30 | 2020-03-13 | 0 | 2020-03-13 | ? | 0 | 0006068766 | 20200313.ifs | 2020-03-13 | 2020-03-14 | |||||||
3923200 | 3923200 | DIVIDEND | ADD | 46625HHA1 | 0 | 0 | 1 | 0 | 14.658 | 00 | ? | 2019-09-30 | 2019-10-30 | 2019-09-13 | 0 | 2019-09-13 | ? | 2 | 0005945600 | 20190913.ifs | 2019-09-13 | 2019-09-14 | |||||||
3923201 | 3923201 | DIVIDEND | ADD | 46625HHA1 | 0 | 0 | 1 | 0 | 14.658 | 00 | ? | 2019-09-30 | 2019-10-30 | 2019-09-13 | 0 | 2019-09-13 | ? | 2 | 0005945600 | 20190913.ifs | 2019-09-13 | 2019-09-14 | |||||||
3923202 | 3923202 | DIVIDEND | ADD | 46625HHA1 | 0 | 0 | 1 | 0 | 15.551 | 00 | ? | 2019-04-01 | 2019-04-30 | 2019-03-15 | 0 | 2019-09-13 | ? | 1 | 0005945599 | 20190913.ifs | 2019-09-13 | 2019-09-14 | |||||||
3923203 | 3923203 | DIVIDEND | ADD | 46625HHA1 | 0 | 0 | 1 | 0 | 15.551 | 00 | ? | 2019-04-01 | 2019-04-30 | 2019-03-15 | 0 | 2019-09-13 | ? | 1 | 0005945599 | 20190913.ifs | 2019-09-13 | 2019-09-14 | |||||||
3923204 | 3923204 | DIVIDEND | ADD | 46625HHA1 | 0 | 0 | 1 | 0 | 14.845 | 00 | ? | 2018-10-01 | 2018-10-30 | 2018-09-14 | 0 | 2019-09-13 | ? | 0 | 0005945598 | 20190913.ifs | 2019-09-13 | 2019-09-14 | |||||||
3923205 | 3923205 | DIVIDEND | ADD | 46625HHA1 | 0 | 0 | 1 | 0 | 14.845 | 00 | ? | 2018-10-01 | 2018-10-30 | 2018-09-14 | 0 | 2019-09-13 | ? | 0 | 0005945598 | 20190913.ifs | 2019-09-13 | 2019-09-14 | |||||||
2993330 | 2993330 | DIVIDEND | ADD | 46625HHA1 | 0 | 0 | 1 | 0 | 39.5 | 00 | ? | 2018-04-02 | 2018-04-30 | 2018-03-15 | 0 | 2018-03-15 | ? | 0 | 0005629534 | 20180315.ifs | 2018-03-15 | 2018-03-16 | |||||||
2993444 | 2993444 | DIVIDEND | ADD | 46625HHA1 | 0 | 0 | 1 | 0 | 39.5 | 00 | ? | 2018-04-02 | 2018-04-30 | 2018-03-15 | 0 | 2018-03-15 | ? | 0 | 0005629534 | 20180315.ifs | 2018-03-15 | 2018-03-16 | |||||||
2673845 | 2673845 | DIVIDEND | ADD | 46625HHA1 | 0 | 0 | 1 | 0 | 39.5 | 00 | ? | 2017-10-02 | 2017-10-30 | 2017-09-15 | 0 | 2017-09-15 | ? | 0 | 0005498059 | 20170915.ifs | 2017-09-15 | 2017-09-16 | |||||||
2674510 | 2674510 | DIVIDEND | ADD | 46625HHA1 | 0 | 0 | 1 | 0 | 39.5 | 00 | ? | 2017-10-02 | 2017-10-30 | 2017-09-15 | 0 | 2017-09-15 | ? | 0 | 0005498059 | 20170915.ifs | 2017-09-15 | 2017-09-16 | |||||||
2512931 | 2512931 | DIVIDEND | ADD | 46625HHA1 | 0 | 0 | 1 | 0 | 39.5 | 00 | ? | 2017-03-31 | 2017-05-01 | 2017-03-15 | 0 | 2017-03-15 | ? | 0 | 0005402613 | 20170315.ifs | 2017-03-15 | 2017-03-16 | |||||||
2294512 | 2294512 | DIVIDEND | ADD | 46625HHA1 | 0 | 0 | 1 | 0 | 39.5 | 00 | ? | 2016-09-30 | 2016-10-30 | 2016-09-15 | 0 | 2016-09-15 | ? | 0 | 0005280769 | 20160915.ifs | 2016-09-15 | 2016-09-16 | |||||||
2135544 | 2135544 | DIVIDEND | ADD | 46625HHA1 | 0 | 0 | 1 | 0 | 39.5 | 00 | ? | 2016-03-31 | 2016-04-30 | 2016-03-15 | 0 | 2016-03-15 | ? | 0 | 0005187093 | 20160315.ifs | 2016-03-15 | 2016-03-16 | |||||||
1965092 | 1965092 | DIVIDEND | ADD | 46625HHA1 | 0 | 0 | 1 | 0 | 39.5 | 00 | ? | 2015-09-30 | 2015-10-30 | 2015-09-14 | 0 | 2015-09-14 | ? | 0 | 0005062086 | 20150914.ifs | 2015-09-14 | 2015-09-15 | |||||||
1813357 | 1813357 | DIVIDEND | ADD | 46625HHA1 | 0 | 0 | 1 | 0 | 39.5 | 00 | ? | 2015-03-31 | 2015-04-30 | 2015-03-13 | 0 | 2015-03-16 | ? | 0 | 0004968664 | 20150316.ifs | 2015-03-16 | 2015-03-17 | |||||||
1629247 | 1629247 | DIVIDEND | ADD | 46625HHA1 | 0 | 0 | 1 | 0 | 39.5 | 00 | ? | 2014-09-30 | 2014-10-30 | 2014-09-12 | 0 | 2014-09-12 | ? | 0 | 0004842573 | 20140912.ifs | 2014-09-12 | 2014-09-13 | |||||||
1550820 | 1550820 | CORPACTION | ADD | 46625HHA1 | 66 | D | 2014-06-16 | 2014-06-17 | 20140617.ifs | 2014-06-17 | 2014-06-18 | ||||||||||||||||||
1467024 | 1467024 | DIVIDEND | ADD | 46625HHA1 | 0 | 0 | 1 | 0 | 39.5 | 00 | ? | 2014-03-31 | 2014-04-30 | 2014-03-14 | 0 | 2014-03-14 | ? | 0 | 0004750304 | 20140314.ifs | 2014-03-14 | 2014-03-15 | |||||||
1428985 | 1428985 | EQUITY | CHANGE | 46625HHA1 | DEP SHS REPSTG 1/10TH PFD SER I | 0 | 6 | 2009-09-16 | ? | 0 | no | no | no | ? | 2012-08-23 | ? | 20140129.ifs | 2014-01-29 | 2014-01-30 | ||||||||||
1428986 | 1428985 | EQUITY | CHANGE | 46625HHA1 | DEP SHS REPSTG 1/10TH PFD SER I | 0 | 1 | 2009-09-16 | ? | 0 | no | no | no | ? | 2014-01-29 | ? | 20140129.ifs | 2014-01-29 | 2014-01-30 | ||||||||||
1428987 | 1428987 | EQUITY | CHANGE | 46625HHA1 | DEP SHS REPSTG 1/10TH PFD SER I | 0 | 1 | 2009-09-16 | ? | 0 | no | no | no | ? | 2014-01-29 | ? | 20140129.ifs | 2014-01-29 | 2014-01-30 | ||||||||||
1428988 | 1428987 | EQUITY | CHANGE | 46625HHA1 | DEP SHS REPSTG 1/10TH PFD SER I | 0 | 6 | 2009-09-16 | ? | 0 | no | no | no | ? | 2014-01-29 | ? | 20140129.ifs | 2014-01-29 | 2014-01-30 | ||||||||||
1287243 | 1287243 | DIVIDEND | ADD | 46625HHA1 | 0 | 0 | 1 | 0 | 39.5 | 00 | ? | 2013-09-30 | 2013-10-30 | 2013-09-13 | 0 | 2013-09-13 | ? | 0 | 0004629277 | 20130913.ifs | 2013-09-13 | 2013-09-14 | |||||||
1134152 | 1134152 | DIVIDEND | ADD | 46625HHA1 | 0 | 0 | 1 | 0 | 39.5 | 00 | ? | 2013-04-01 | 2013-04-30 | 2013-03-15 | 0 | 2013-03-15 | ? | 0 | 0004541668 | 20130315.ifs | 2013-03-15 | 2013-03-16 | |||||||
956758 | 956758 | DIVIDEND | ADD | 46625HHA1 | 0 | 0 | 1 | 0 | 39.5 | 00 | ? | 2012-09-30 | 2012-10-30 | 2012-09-14 | 0 | 2012-09-14 | ? | 0 | 0004429455 | 20120914.ifs | 2012-09-14 | 2012-09-15 | |||||||
937607 | 937607 | EQUITY | CHANGE | 46625HHA1 | DEP SHS REPSTG 1/10TH PFD SER I | 0 | 1 | 2009-09-16 | ? | 0 | no | no | no | ? | 2011-11-10 | ? | 20120823.ifs | 2012-08-23 | 2012-08-24 | ||||||||||
937608 | 937607 | EQUITY | CHANGE | 46625HHA1 | DEP SHS REPSTG 1/10TH PFD SER I | 0 | 6 | 2009-09-16 | ? | 0 | no | no | no | ? | 2012-08-23 | ? | 20120823.ifs | 2012-08-23 | 2012-08-24 | ||||||||||
833500 | 833500 | EXCHANGE | CHANGE | 46625HHA1 | 66 | 2011-11-03 | 2012-04-09 | JFTTP | 0 | 1 | ? | 2011-11-10 | 20120411.ifs | 2012-04-11 | 2012-04-12 | ||||||||||||||
833501 | 833500 | EXCHANGE | CHANGE | 46625HHA1 | 66 | 2011-11-03 | 2012-04-09 | JFTTL | 0 | 1 | ? | 2012-04-11 | 20120411.ifs | 2012-04-11 | 2012-04-12 | ||||||||||||||
833502 | 833502 | CORPACTION | ADD | 46625HHA1 | 66 | # | 2012-04-11 | 46625HHA1 | 66 | 2012-04-11 | 20120411.ifs | 2012-04-11 | 2012-04-12 | ||||||||||||||||
833503 | 833503 | CORPACTIONAUX | ADD | 46625HHA1 | 66 | 2012-04-11 | JFTTP | JPMORGAN CHASE & CO | DEP SHS REPSTG | JFTTL | JPMORGAN CHASE & CO | DEP SHS REPSTG | ? | 2012-04-11 | 20120411.ifs | 2012-04-11 | 2012-04-12 | ||||||||||||
833504 | 833504 | EXCHANGE | CHANGE | 46625HHA1 | 66 | 2011-11-03 | 2012-04-09 | JFTTL | 0 | 1 | ? | 2012-04-11 | 20120411.ifs | 2012-04-11 | 2012-04-12 | ||||||||||||||
833505 | 833504 | EXCHANGE | CHANGE | 46625HHA1 | 66 | 2011-11-03 | 2012-04-09 | JFTTL | 0 | 1 | ? | 2012-04-11 | 20120411.ifs | 2012-04-11 | 2012-04-12 | ||||||||||||||
803178 | 803178 | DIVIDEND | ADD | 46625HHA1 | 0 | 0 | 1 | 0 | 39.5 | 00 | ? | 2012-03-31 | 2012-04-30 | 2012-03-15 | 0 | 2012-03-15 | ? | 0 | 0004345556 | 20120315.ifs | 2012-03-15 | 2012-03-16 | |||||||
692839 | 692839 | EXCHANGE | ADD | 46625HHA1 | 66 | 2011-11-03 | 2011-11-09 | JFTTP | 0 | 1 | ? | 2011-11-10 | 20111110.ifs | 2011-11-10 | 2011-11-11 | ||||||||||||||
692840 | 692840 | EQUITY | CHANGE | 46625HHA1 | DEP SHS REPSTG 1/10TH PFD SER I | N | 1 | 2009-09-16 | ? | 0 | no | no | no | ? | ? | ? | 20111110.ifs | 2011-11-10 | 2011-11-11 | ||||||||||
692841 | 692840 | EQUITY | CHANGE | 46625HHA1 | DEP SHS REPSTG 1/10TH PFD SER I | 0 | 1 | 2009-09-16 | ? | 0 | no | no | no | ? | 2011-11-10 | ? | 20111110.ifs | 2011-11-10 | 2011-11-11 | ||||||||||
644222 | 644222 | DIVIDEND | ADD | 46625HHA1 | 0 | 0 | 1 | 0 | 39.5 | 00 | ? | 2011-09-30 | 2011-10-30 | 2011-09-15 | 0 | 2011-09-15 | ? | 0 | 0004242316 | 20110915.ifs | 2011-09-15 | 2011-09-16 | |||||||
472055 | 472055 | DIVIDEND | ADD | 46625HHA1 | 0 | 0 | 1 | 0 | 39.5 | 00 | ? | 2011-03-31 | 2011-04-30 | 2011-03-15 | 0 | 2011-03-15 | ? | 0 | 0004159301 | 20110315.ifs | 2011-03-15 | 2011-03-16 | |||||||
307524 | 307524 | DIVIDEND | ADD | 46625HHA1 | 0 | 0 | 1 | 0 | 39.5 | 00 | ? | 2010-09-30 | 2010-10-30 | 2010-09-15 | 0 | 2010-09-15 | ? | 0 | 0004059855 | 20100915.ifs | 2010-09-15 | 2010-09-16 | |||||||
133369 | 133369 | DIVIDEND | ADD | 46625HHA1 | 0 | 0 | 1 | 0 | 39.5 | 00 | ? | 2010-03-31 | 2010-04-30 | 2010-03-16 | 0 | 2010-03-16 | ? | 0 | 0003978237 | 20100316.ifs | 2010-03-16 | 2010-04-07 |
entryId | groupId | EQUITY | CHANGE | CUSIP | DESCRIPTION | ISSUE STATUS CODE |
ISSUE TYPE CODE |
ADD DATE |
EXPIRATION DATE |
PAYMENT FREQUENCY CODE |
MARGIN FLAG |
OPTION FLAG |
CONVERTED CUSIP |
NASDAQ MARKET CODE |
INDEX ISSUER |
CHANGE DATE |
MERGENT CHANGE DATE |
MATURE DATE |
undefined1 | undefined2 | undefined3 | undefined4 | temp1 | temp2 | fileName | fileDate | processDate |
BACK UP Institutions before committing
SELECT institutionciklist.institutionid AS theinstitutionID, institutionciklist.institutionCik, institutionciklist.institutionName, institutionciklist.isGuru, all13ffilings. * , current13Fpositions. *
FROM current13Fpositions, all13ffilings, institutionciklist
WHERE current13Fpositions.compid = 159783
AND all13ffilings.entryId = current13Fpositions.linkID
AND all13ffilings.institutionid = institutionciklist.institutionid
AND institutionciklist.alive ='yes'
AND all13ffilings.done ='yes'
AND reportDate >='2012-06-30'
ORDER BY value ASC