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:159666 |
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 | ||
4626492 | 4626492 | CORPACTION | ADD | 165167784 | 66 | D | 2021-02-09 | ? | 20210209.ifs | 2021-02-09 | 2021-02-10 | ||||||||||||||||||
4626493 | 4626493 | EQUITY | CHANGE | 165167784 | PFD 5.75% 144A | 0 | 1 | 2010-06-21 | ? | 4 | no | no | no | ? | 2011-04-06 | ? | 20210209.ifs | 2021-02-09 | 2021-02-10 | ||||||||||
4626494 | 4626493 | EQUITY | CHANGE | 165167784 | PFD 5.75% 144A | D | 1 | 2010-06-21 | 2021-02-09 | 4 | no | no | no | ? | 2021-02-09 | ? | 20210209.ifs | 2021-02-09 | 2021-02-10 | ||||||||||
4404966 | 4404966 | CORPACTION | ADD | 165167784 | 66 | # | 2020-06-30 | 165167784 | 66 | ? | 20200630.ifs | 2020-06-30 | 2020-07-01 | ||||||||||||||||
4404967 | 4404967 | CORPACTIONAUX | ADD | 165167784 | 66 | 2020-06-30 | CKRGZ | CHESAPEAKE ENERGY CORP | PFD 5.75% 144A | CKRGQ | CHESAPEAKE ENERGY CORP | PFD 5.75% 144A | 2020-06-30 | ? | 20200630.ifs | 2020-06-30 | 2020-07-01 | ||||||||||||
4404968 | 4404968 | EXCHANGE | CHANGE | 165167784 | 66 | 2011-04-01 | 2011-04-05 | CKRGZ | 0 | 1 | 2011-04-01 | 2011-04-06 | 20200630.ifs | 2020-06-30 | 2020-07-01 | ||||||||||||||
4404969 | 4404968 | EXCHANGE | CHANGE | 165167784 | 66 | 2011-04-01 | 2011-04-05 | CKRGQ | 0 | 1 | 2011-04-01 | 2020-06-30 | 20200630.ifs | 2020-06-30 | 2020-07-01 | ||||||||||||||
4293192 | 4293192 | DIVIDEND | ADD | 165167784 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2020-05-15 | 2020-04-17 | 0 | 2020-04-17 | ? | 0 | 0006086280 | 20200417.ifs | 2020-04-17 | 2020-04-18 | |||||||
4293390 | 4293390 | DIVIDEND | ADD | 165167784 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2020-05-15 | 2020-04-17 | 0 | 2020-04-17 | ? | 0 | 0006086280 | 20200417.ifs | 2020-04-17 | 2020-04-18 | |||||||
4172496 | 4172496 | DIVIDEND | ADD | 165167784 | 0 | 0 | 1 | 0 | 14.375 | 00 | 2020-01-30 | 2020-02-01 | 2020-02-15 | 2020-01-17 | 0 | 2020-01-17 | ? | 0 | 0006043344 | 20200117.ifs | 2020-01-17 | 2020-01-18 | |||||||
4172546 | 4172546 | DIVIDEND | ADD | 165167784 | 0 | 0 | 1 | 0 | 14.375 | 00 | 2020-01-30 | 2020-02-01 | 2020-02-15 | 2020-01-17 | 0 | 2020-01-17 | ? | 0 | 0006043344 | 20200117.ifs | 2020-01-17 | 2020-01-18 | |||||||
3977913 | 3977913 | DIVIDEND | ADD | 165167784 | 0 | 0 | 1 | 0 | 14.375 | 00 | 2019-10-31 | 2019-11-01 | 2019-11-15 | 2019-10-18 | 0 | 2019-10-18 | ? | 0 | 0005963245 | 20191018.ifs | 2019-10-18 | 2019-10-19 | |||||||
3978005 | 3978005 | DIVIDEND | ADD | 165167784 | 0 | 0 | 1 | 0 | 14.375 | 00 | 2019-10-31 | 2019-11-01 | 2019-11-15 | 2019-10-18 | 0 | 2019-10-18 | ? | 0 | 0005963245 | 20191018.ifs | 2019-10-18 | 2019-10-19 | |||||||
3841944 | 3841944 | DIVIDEND | ADD | 165167784 | 0 | 0 | 1 | 0 | 14.375 | 00 | 2019-07-31 | 2019-08-01 | 2019-08-15 | 2019-07-19 | 0 | 2019-07-19 | ? | 0 | 0005917849 | 20190719.ifs | 2019-07-19 | 2019-07-20 | |||||||
3841945 | 3841945 | DIVIDEND | ADD | 165167784 | 0 | 0 | 1 | 0 | 14.375 | 00 | 2019-07-31 | 2019-08-01 | 2019-08-15 | 2019-07-19 | 0 | 2019-07-19 | ? | 0 | 0005917849 | 20190719.ifs | 2019-07-19 | 2019-07-20 | |||||||
3690502 | 3690502 | DIVIDEND | ADD | 165167784 | 0 | 0 | 1 | 0 | 14.375 | 00 | 2019-04-30 | 2019-05-01 | 2019-05-15 | 2019-04-19 | 0 | 2019-04-22 | ? | 0 | 0005871842 | 20190422.ifs | 2019-04-22 | 2019-04-23 | |||||||
3690503 | 3690503 | DIVIDEND | ADD | 165167784 | 0 | 0 | 1 | 0 | 14.375 | 00 | 2019-04-30 | 2019-05-01 | 2019-05-15 | 2019-04-19 | 0 | 2019-04-22 | ? | 0 | 0005871842 | 20190422.ifs | 2019-04-22 | 2019-04-23 | |||||||
3555570 | 3555570 | DIVIDEND | ADD | 165167784 | 0 | 0 | 1 | 0 | 14.375 | 00 | 2019-01-31 | 2019-02-01 | 2019-02-15 | 2019-01-18 | 0 | 2019-01-18 | ? | 0 | 0005826855 | 20190118.ifs | 2019-01-18 | 2019-01-19 | |||||||
3555598 | 3555598 | DIVIDEND | ADD | 165167784 | 0 | 0 | 1 | 0 | 14.375 | 00 | 2019-01-31 | 2019-02-01 | 2019-02-15 | 2019-01-18 | 0 | 2019-01-18 | ? | 0 | 0005826855 | 20190118.ifs | 2019-01-18 | 2019-01-19 | |||||||
3334743 | 3334743 | DIVIDEND | ADD | 165167784 | 0 | 0 | 1 | 0 | 14.375 | 00 | 2018-10-31 | 2018-11-01 | 2018-11-15 | 2018-10-19 | 0 | 2018-10-19 | ? | 0 | 0005742115 | 20181019.ifs | 2018-10-19 | 2018-10-20 | |||||||
3334747 | 3334747 | DIVIDEND | ADD | 165167784 | 0 | 0 | 1 | 0 | 14.375 | 00 | 2018-10-31 | 2018-11-01 | 2018-11-15 | 2018-10-19 | 0 | 2018-10-19 | ? | 0 | 0005742115 | 20181019.ifs | 2018-10-19 | 2018-10-20 | |||||||
3201579 | 3201579 | DIVIDEND | ADD | 165167784 | 0 | 0 | 1 | 0 | 14.375 | 00 | 2018-07-31 | 2018-08-01 | 2018-08-15 | 2018-07-20 | 0 | 2018-07-20 | ? | 0 | 0005695713 | 20180720.ifs | 2018-07-20 | 2018-07-21 | |||||||
3201658 | 3201658 | DIVIDEND | ADD | 165167784 | 0 | 0 | 1 | 0 | 14.375 | 00 | 2018-07-31 | 2018-08-01 | 2018-08-15 | 2018-07-20 | 0 | 2018-07-20 | ? | 0 | 0005695713 | 20180720.ifs | 2018-07-20 | 2018-07-21 | |||||||
3045994 | 3045994 | DIVIDEND | ADD | 165167784 | 0 | 0 | 1 | 0 | 14.375 | 00 | 2018-04-30 | 2018-05-01 | 2018-05-15 | 2018-04-20 | 0 | 2018-04-20 | ? | 0 | 0005648610 | 20180420.ifs | 2018-04-20 | 2018-04-21 | |||||||
3045995 | 3045995 | DIVIDEND | ADD | 165167784 | 0 | 0 | 1 | 0 | 14.375 | 00 | 2018-04-30 | 2018-05-01 | 2018-05-15 | 2018-04-20 | 0 | 2018-04-20 | ? | 0 | 0005648610 | 20180420.ifs | 2018-04-20 | 2018-04-21 | |||||||
2924841 | 2924841 | DIVIDEND | ADD | 165167784 | 0 | 0 | 1 | 0 | 14.375 | 00 | 2018-01-31 | 2018-02-01 | 2018-02-15 | 2018-01-19 | 0 | 2018-01-22 | ? | 0 | 0005603054 | 20180122.ifs | 2018-01-22 | 2018-01-23 | |||||||
2924842 | 2924842 | DIVIDEND | ADD | 165167784 | 0 | 0 | 1 | 0 | 14.375 | 00 | 2018-01-31 | 2018-02-01 | 2018-02-15 | 2018-01-19 | 0 | 2018-01-22 | ? | 0 | 0005603054 | 20180122.ifs | 2018-01-22 | 2018-01-23 | |||||||
2731070 | 2731070 | DIVIDEND | ADD | 165167784 | 0 | 0 | 1 | 0 | 14.375 | 00 | 2017-10-31 | 2017-11-01 | 2017-11-15 | 2017-10-20 | 0 | 2017-10-20 | ? | 0 | 0005516252 | 20171020.ifs | 2017-10-20 | 2017-10-21 | |||||||
2731073 | 2731073 | DIVIDEND | ADD | 165167784 | 0 | 0 | 1 | 0 | 14.375 | 00 | 2017-10-31 | 2017-11-01 | 2017-11-15 | 2017-10-20 | 0 | 2017-10-20 | ? | 0 | 0005516252 | 20171020.ifs | 2017-10-20 | 2017-10-21 | |||||||
2628728 | 2628728 | DIVIDEND | ADD | 165167784 | 0 | 0 | 1 | 0 | 14.375 | 00 | 2017-07-28 | 2017-08-01 | 2017-08-15 | 2017-07-21 | 0 | 2017-07-21 | ? | 0 | 0005470302 | 20170721.ifs | 2017-07-21 | 2017-07-22 | |||||||
2561956 | 2561956 | DIVIDEND | DELETE | 165167784 | 0 | 0 | 1 | 0 | 14.375 | 00 | 2017-04-27 | 2017-05-01 | 2017-05-15 | 2017-04-19 | 0 | 2017-04-21 | ? | 0 | 0005422968 | 20170504.ifs | 2017-05-04 | 2017-05-05 | |||||||
2561957 | 2561957 | DIVIDEND | ADD | 165167784 | 0 | 0 | 1 | 0 | 14.375 | 00 | 2017-04-27 | 2017-05-01 | 2017-05-15 | 2017-04-21 | 1 | 2017-04-21 | 2017-05-04 | 0 | 0005422968 | 20170504.ifs | 2017-05-04 | 2017-05-05 | |||||||
2545941 | 2545941 | DIVIDEND | ADD | 165167784 | 0 | 0 | 1 | 0 | 14.375 | 00 | 2017-04-27 | 2017-05-01 | 2017-05-15 | 2017-04-19 | 0 | 2017-04-21 | ? | 0 | 0005422968 | 20170421.ifs | 2017-04-21 | 2017-04-22 | |||||||
2475792 | 2475792 | DIVIDEND | CHANGE | 165167784 | 0 | 0 | 1 | 0 | 14.375 | 00 | 2017-01-30 | 2017-02-01 | 2017-02-15 | 2017-01-20 | 0 | 2017-01-20 | ? | 1 | 0005376613 | 20170130.ifs | 2017-01-30 | 2017-01-31 | |||||||
2475793 | 2475792 | DIVIDEND | CHANGE | 165167784 | 0 | 0 | 1 | 0 | 14.375 | 00 | 2017-01-30 | 2017-02-01 | 2017-02-15 | 2017-01-20 | 1 | 2017-01-20 | 2017-01-30 | 1 | 0005376613 | 20170130.ifs | 2017-01-30 | 2017-01-31 | |||||||
2475794 | 2475794 | DIVIDEND | DELETE | 165167784 | 0 | 0 | 1 | 9 | 57.5 | 03 | ? | 2017-02-01 | 2017-02-15 | 2017-01-20 | 0 | 2017-01-20 | ? | 0 | 0005376612 | 20170130.ifs | 2017-01-30 | 2017-01-31 | |||||||
2475795 | 2475795 | DIVIDEND | ADD | 165167784 | 0 | 0 | 1 | 9 | 57.5 | 03 | 2017-01-30 | 2017-02-01 | 2017-02-15 | 2017-01-20 | 1 | 2017-01-20 | 2017-01-30 | 0 | 0005376612 | 20170130.ifs | 2017-01-30 | 2017-01-31 | |||||||
2103088 | 2103088 | DIVIDEND | CHANGE | 165167784 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2016-02-15 | 2016-01-22 | 0 | 2016-01-22 | ? | 0 | 0005161615 | 20160129.ifs | 2016-01-29 | 2016-01-30 | |||||||
2103089 | 2103088 | DIVIDEND | CHANGE | 165167784 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2016-02-15 | 2016-01-22 | 1 | 2016-01-22 | 2016-01-29 | 0 | 0005161615 | 20160129.ifs | 2016-01-29 | 2016-01-30 | |||||||
2097062 | 2097062 | DIVIDEND | ADD | 165167784 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2016-02-15 | 2016-01-22 | 0 | 2016-01-22 | ? | 0 | 0005161615 | 20160122.ifs | 2016-01-22 | 2016-01-23 | |||||||
1994470 | 1994470 | DIVIDEND | ADD | 165167784 | 0 | 0 | 1 | 0 | 14.375 | 00 | 2015-10-28 | 2015-11-01 | 2015-11-15 | 2015-10-20 | 0 | 2015-10-21 | ? | 0 | 0005081072 | 20151021.ifs | 2015-10-21 | 2015-10-22 | |||||||
1920286 | 1920286 | DIVIDEND | ADD | 165167784 | 0 | 0 | 1 | 0 | 14.375 | 00 | 2015-07-29 | 2015-08-01 | 2015-08-15 | 2015-07-21 | 0 | 2015-07-21 | ? | 0 | 0005034102 | 20150721.ifs | 2015-07-21 | 2015-07-22 | |||||||
1812068 | 1812068 | DIVIDEND | ADD | 165167784 | 0 | 0 | 1 | 0 | 14.375 | 00 | 2015-04-29 | 2015-05-01 | 2015-05-15 | 2015-03-05 | 0 | 2015-03-13 | ? | 0 | 0004968049 | 20150313.ifs | 2015-03-13 | 2015-03-14 | |||||||
1717670 | 1717670 | DIVIDEND | ADD | 165167784 | 0 | 0 | 1 | 0 | 14.375 | 00 | 2015-01-28 | 2015-02-01 | 2015-02-15 | 2014-12-15 | 0 | 2014-12-15 | ? | 0 | 0004897229 | 20141215.ifs | 2014-12-15 | 2014-12-16 | |||||||
1635731 | 1635731 | DIVIDEND | ADD | 165167784 | 0 | 0 | 1 | 0 | 14.375 | 00 | 2014-10-30 | 2014-11-03 | 2014-11-17 | 2014-09-22 | 0 | 2014-09-22 | ? | 0 | 0004845834 | 20140922.ifs | 2014-09-22 | 2014-09-23 | |||||||
1557806 | 1557806 | DIVIDEND | ADD | 165167784 | 0 | 0 | 1 | 0 | 14.375 | 00 | 2014-07-30 | 2014-08-01 | 2014-08-15 | 2014-06-13 | 0 | 2014-06-23 | ? | 0 | 0004800184 | 20140623.ifs | 2014-06-23 | 2014-06-24 | |||||||
1464140 | 1464140 | DIVIDEND | ADD | 165167784 | 0 | 0 | 1 | 0 | 14.375 | 00 | 2014-04-29 | 2014-05-01 | 2014-05-15 | 2014-03-11 | 0 | 2014-03-11 | ? | 0 | 0004749324 | 20140311.ifs | 2014-03-11 | 2014-03-12 | |||||||
1375131 | 1375131 | DIVIDEND | ADD | 165167784 | 0 | 0 | 1 | 0 | 14.375 | 00 | 2014-01-30 | 2014-02-03 | 2014-02-17 | 2013-12-16 | 0 | 2013-12-16 | ? | 0 | 0004685231 | 20131216.ifs | 2013-12-16 | 2013-12-17 | |||||||
1294553 | 1294553 | DIVIDEND | ADD | 165167784 | 0 | 0 | 1 | 0 | 14.375 | 00 | 2013-10-30 | 2013-11-01 | 2013-11-15 | 2013-09-23 | 0 | 2013-09-23 | ? | 0 | 0004632424 | 20130923.ifs | 2013-09-23 | 2013-09-24 | |||||||
1241923 | 1241923 | DIVIDEND | ADD | 165167784 | 0 | 0 | 1 | 0 | 14.375 | 00 | 2013-07-30 | 2013-08-01 | 2013-08-15 | 2013-06-14 | 0 | 2013-07-17 | ? | 0 | 0004602208 | 20130717.ifs | 2013-07-17 | 2013-07-18 | |||||||
1156948 | 1156948 | DIVIDEND | ADD | 165167784 | 0 | 0 | 1 | 0 | 14.375 | 00 | 2013-04-29 | 2013-05-01 | 2013-05-15 | 2013-04-08 | 0 | 2013-04-08 | ? | 0 | 0004556673 | 20130408.ifs | 2013-04-08 | 2013-04-09 | |||||||
1045618 | 1045618 | DIVIDEND | ADD | 165167784 | 0 | 0 | 1 | 0 | 14.375 | 00 | 2013-01-30 | 2013-02-01 | 2013-02-15 | 2012-12-17 | 0 | 2012-12-17 | ? | 0 | 0004482633 | 20121217.ifs | 2012-12-17 | 2012-12-18 | |||||||
994419 | 994419 | DIVIDEND | DELETE | 165167784 | 0 | 0 | 1 | 0 | 14.375 | 00 | ? | 2012-11-01 | 2012-11-15 | 2012-09-24 | 1 | 2012-09-24 | 2012-10-29 | 0 | 0004432912 | 20121030.ifs | 2012-10-30 | 2012-10-31 | |||||||
994420 | 994420 | DIVIDEND | ADD | 165167784 | 0 | 0 | 1 | 0 | 14.375 | 0 | 00 | 2012-10-31 | 2012-11-01 | 2012-11-15 | 2012-09-24 | 0 | ? | 2012-10-30 | 0 | 0004432912 | 20121030.ifs | 2012-10-30 | 2012-10-31 | ||||||
994796 | 994796 | DIVIDEND | CHANGE | 165167784 | 0 | 0 | 1 | 0 | 14.375 | 0 | 00 | 2012-10-31 | 2012-11-01 | 2012-11-15 | 2012-09-24 | 0 | ? | 2012-10-30 | 0 | 0004432912 | 20121030.ifs | 2012-10-30 | 2012-10-31 | ||||||
994797 | 994796 | DIVIDEND | CHANGE | 165167784 | 0 | 0 | 1 | 0 | 14.375 | 0 | 00 | 2012-10-31 | 2012-11-01 | 2012-11-15 | 2012-09-24 | 0 | ? | 2012-10-30 | 0 | 0004432912 | 20121030.ifs | 2012-10-30 | 2012-10-31 | ||||||
994326 | 994326 | DIVIDEND | DELETE | 165167784 | 0 | 0 | 1 | 0 | 14.375 | 00 | 2012-10-30 | 2012-11-01 | 2012-11-15 | 2012-09-24 | 0 | 2012-09-24 | ? | 0 | 0004432912 | 20121029.ifs | 2012-10-29 | 2012-10-30 | |||||||
994327 | 994327 | DIVIDEND | ADD | 165167784 | 0 | 0 | 1 | 0 | 14.375 | 00 | ? | 2012-11-01 | 2012-11-15 | 2012-09-24 | 1 | 2012-09-24 | 2012-10-29 | 0 | 0004432912 | 20121029.ifs | 2012-10-29 | 2012-10-30 | |||||||
963582 | 963582 | DIVIDEND | ADD | 165167784 | 0 | 0 | 1 | 0 | 14.375 | 00 | 2012-10-30 | 2012-11-01 | 2012-11-15 | 2012-09-24 | 0 | 2012-09-24 | ? | 0 | 0004432912 | 20120924.ifs | 2012-09-24 | 2012-09-25 | |||||||
883848 | 883848 | DIVIDEND | ADD | 165167784 | 0 | 0 | 1 | 0 | 14.375 | 00 | 2012-07-30 | 2012-08-01 | 2012-08-15 | 2012-06-12 | 0 | 2012-06-12 | ? | 0 | 0004385561 | 20120612.ifs | 2012-06-12 | 2012-06-13 | |||||||
809860 | 809860 | DIVIDEND | ADD | 165167784 | 0 | 0 | 1 | 0 | 14.375 | 00 | 2012-04-27 | 2012-05-01 | 2012-05-15 | 2012-03-01 | 0 | 2012-03-23 | ? | 0 | 0004349146 | 20120323.ifs | 2012-03-23 | 2012-03-24 | |||||||
731290 | 731290 | DIVIDEND | ADD | 165167784 | 0 | 0 | 1 | 0 | 14.375 | 00 | 2012-01-30 | 2012-02-01 | 2012-02-15 | 2011-12-19 | 0 | 2011-12-19 | ? | 0 | 0004294126 | 20111219.ifs | 2011-12-19 | 2011-12-20 | |||||||
635118 | 635118 | DIVIDEND | ADD | 165167784 | 0 | 0 | 1 | 0 | 14.375 | 00 | 2011-10-28 | 2011-11-01 | 2011-11-15 | 2011-07-26 | 0 | 2011-09-01 | ? | 0 | 0004238319 | 20110901.ifs | 2011-09-01 | 2011-09-02 | |||||||
558697 | 558697 | DIVIDEND | ADD | 165167784 | 0 | 0 | 1 | 0 | 14.375 | 00 | 2011-07-28 | 2011-08-01 | 2011-08-15 | 2011-06-13 | 0 | 2011-06-13 | ? | 0 | 0004200319 | 20110613.ifs | 2011-06-13 | 2011-06-14 | |||||||
509999 | 509999 | DIVIDEND | DELETE | 165167784 | 0 | 0 | 1 | 0 | 14.375 | 00 | ? | 2011-05-02 | 2011-05-16 | 2011-03-07 | 0 | 2011-03-16 | ? | 0 | 0004159886 | 20110427.ifs | 2011-04-27 | 2011-04-28 | |||||||
510000 | 510000 | DIVIDEND | ADD | 165167784 | 0 | 0 | 1 | 0 | 14.375 | 00 | 2011-04-28 | 2011-05-02 | 2011-05-16 | 2011-03-07 | 1 | 2011-03-16 | 2011-04-27 | 0 | 0004159886 | 20110427.ifs | 2011-04-27 | 2011-04-28 | |||||||
497713 | 497713 | CORPACTION | ADD | 165167784 | 66 | # | 2011-04-06 | 165167784 | 66 | ? | 20110406.ifs | 2011-04-06 | 2011-04-07 | ||||||||||||||||
497714 | 497714 | CORPACTIONAUX | ADD | 165167784 | 66 | 2011-04-06 | CKRGP | CHESAPEAKE ENERGY CORP | PFD 5.75% 144A | CKRGZ | CHESAPEAKE ENERGY CORP | PFD 5.75% 144A | 2011-04-06 | ? | 20110406.ifs | 2011-04-06 | 2011-04-07 | ||||||||||||
497715 | 497715 | EXCHANGE | CHANGE | 165167784 | 66 | 2011-04-01 | 2011-04-05 | CKRGP | 0 | 1 | 2011-04-01 | ? | 20110406.ifs | 2011-04-06 | 2011-04-07 | ||||||||||||||
497716 | 497715 | EXCHANGE | CHANGE | 165167784 | 66 | 2011-04-01 | 2011-04-05 | CKRGZ | 0 | 1 | 2011-04-01 | 2011-04-06 | 20110406.ifs | 2011-04-06 | 2011-04-07 | ||||||||||||||
498094 | 498094 | EQUITY | CHANGE | 165167784 | PFD 5.75% 144A | N | 1 | 2010-06-21 | ? | 0 | no | no | no | ? | ? | ? | 20110406.ifs | 2011-04-06 | 2011-04-07 | ||||||||||
498095 | 498094 | EQUITY | CHANGE | 165167784 | PFD 5.75% 144A | 0 | 1 | 2010-06-21 | ? | 0 | no | no | no | ? | 2011-04-06 | ? | 20110406.ifs | 2011-04-06 | 2011-04-07 | ||||||||||
489588 | 489588 | EXCHANGE | ADD | 165167784 | 66 | 2011-04-01 | ? | CKRGP | 0 | 1 | 2011-04-01 | ? | 20110401.ifs | 2011-04-01 | 2011-04-02 | ||||||||||||||
387404 | 387404 | DIVIDEND | ADD | 165167784 | 0 | 0 | 1 | 0 | 14.375 | 00 | ? | 2011-02-01 | 2011-02-15 | 2010-12-20 | 0 | 2010-12-20 | ? | 0 | 0004111370 | 20101220.ifs | 2010-12-20 | 2010-12-21 | |||||||
298802 | 298802 | DIVIDEND | ADD | 165167784 | 0 | 0 | 1 | 0 | 14.375 | 00 | ? | 2010-11-01 | 2010-11-15 | 2010-09-01 | 0 | 2010-09-01 | ? | 0 | 0004056549 | 20100901.ifs | 2010-09-01 | 2010-09-02 | |||||||
224421 | 224421 | EQUITY | ADD | 165167784 | PFD 5.75% 144A | N | 1 | 2010-06-21 | ? | 0 | no | no | no | ? | ? | ? | 20100621.ifs | 2010-06-21 | 2010-06-22 | ||||||||||
224422 | 224422 | DIVIDEND | ADD | 165167784 | 0 | 0 | 1 | 4 | 14.375 | 00 | ? | 2010-08-02 | 2010-08-16 | 2010-06-21 | 0 | 2010-06-21 | ? | 0 | 0004020521 | 20100621.ifs | 2010-06-21 | 2010-06-22 |
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 = 159666
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