INSITITUIONS | Dynamic | newInstitTable | Changed the Cusip/Sector/Shs Out? |
|
|||||||
Total Insititutions : | 293 | 249 | Update Insititution By Cusips | ||||||||
% Owned by Insititutions: | 97.85 % | 98.6 % | |||||||||
pricingQuarterAdminPageOn:
|
2024-03-31 | New % | |||||||||
|
|||||||||||
the compid is:152987 |
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 | ||
5542897 | 5542897 | DIVIDEND | ADD | 235825205 | 0 | 0 | 1 | 0 | .1 | 00 | 2024-05-09 | 2024-05-10 | 2024-05-31 | 2024-04-24 | 0 | 2024-04-24 | ? | 0 | 0006908429 | 20240424.ifs | 2024-04-24 | 2024-04-25 | |||||||
5498822 | 5498822 | DIVIDEND | ADD | 235825205 | 0 | 0 | 1 | 0 | .1 | 00 | 2024-02-29 | 2024-03-01 | 2024-03-22 | 2024-02-14 | 0 | 2024-02-14 | ? | 0 | 0006876841 | 20240214.ifs | 2024-02-14 | 2024-02-15 | |||||||
5400259 | 5400259 | DIVIDEND | ADD | 235825205 | 0 | 0 | 1 | 0 | .1 | 00 | 2023-11-09 | 2023-11-10 | 2023-12-01 | 2023-10-25 | 0 | 2023-10-25 | ? | 0 | 0006801323 | 20231025.ifs | 2023-10-25 | 2023-10-26 | |||||||
5339995 | 5339995 | DIVIDEND | ADD | 235825205 | 0 | 0 | 1 | 0 | .1 | 00 | 2023-08-10 | 2023-08-11 | 2023-09-01 | 2023-07-26 | 0 | 2023-07-26 | ? | 0 | 0006758872 | 20230726.ifs | 2023-07-26 | 2023-07-27 | |||||||
5277727 | 5277727 | DIVIDEND | ADD | 235825205 | 0 | 0 | 1 | 0 | .1 | 00 | 2023-05-11 | 2023-05-12 | 2023-06-02 | 2023-04-26 | 0 | 2023-04-26 | ? | 0 | 0006715670 | 20230426.ifs | 2023-04-26 | 2023-04-27 | |||||||
5230908 | 5230908 | DIVIDEND | ADD | 235825205 | 0 | 0 | 1 | 0 | .1 | 00 | 2023-03-02 | 2023-03-03 | 2023-03-24 | 2023-02-15 | 0 | 2023-02-15 | ? | 0 | 0006682858 | 20230215.ifs | 2023-02-15 | 2023-02-16 | |||||||
5126065 | 5126065 | DIVIDEND | ADD | 235825205 | 0 | 0 | 1 | 0 | .1 | 00 | 2022-11-09 | 2022-11-11 | 2022-12-02 | 2022-10-26 | 0 | 2022-10-26 | ? | 0 | 0006602616 | 20221026.ifs | 2022-10-26 | 2022-10-27 | |||||||
5064320 | 5064320 | DIVIDEND | ADD | 235825205 | 0 | 0 | 1 | 0 | .1 | 00 | 2022-08-11 | 2022-08-12 | 2022-09-02 | 2022-07-27 | 0 | 2022-07-27 | ? | 0 | 0006559235 | 20220727.ifs | 2022-07-27 | 2022-07-28 | |||||||
4995827 | 4995827 | DIVIDEND | ADD | 235825205 | 0 | 0 | 1 | 0 | .1 | 00 | 2022-05-05 | 2022-05-06 | 2022-05-27 | 2022-04-20 | 0 | 2022-04-20 | ? | 0 | 0006512231 | 20220420.ifs | 2022-04-20 | 2022-04-21 | |||||||
4954460 | 4954460 | DIVIDEND | ADD | 235825205 | 0 | 0 | 1 | 0 | .1 | 00 | 2022-03-03 | 2022-03-04 | 2022-03-25 | 2022-02-16 | 0 | 2022-02-16 | ? | 0 | 0006481742 | 20220216.ifs | 2022-02-16 | 2022-02-17 | |||||||
4829301 | 4829301 | DIVIDEND | ADD | 235825205 | 0 | 0 | 1 | 0 | .1 | 00 | 2021-11-04 | 2021-11-05 | 2021-11-26 | 2021-10-20 | 0 | 2021-10-20 | ? | 0 | 0006384880 | 20211020.ifs | 2021-10-20 | 2021-10-21 | |||||||
4766409 | 4766409 | DIVIDEND | ADD | 235825205 | 0 | 0 | 1 | 0 | .1 | 00 | 2021-08-12 | 2021-08-13 | 2021-09-03 | 2021-07-28 | 0 | 2021-07-28 | ? | 0 | 0006343296 | 20210728.ifs | 2021-07-28 | 2021-07-29 | |||||||
4685171 | 4685171 | DIVIDEND | ADD | 235825205 | 0 | 0 | 1 | 0 | .1 | 00 | 2021-05-06 | 2021-05-07 | 2021-05-28 | 2021-04-21 | 0 | 2021-04-21 | ? | 0 | 0006296119 | 20210421.ifs | 2021-04-21 | 2021-04-22 | |||||||
4647070 | 4647070 | DIVIDEND | ADD | 235825205 | 0 | 0 | 1 | 0 | .1 | 00 | 2021-03-04 | 2021-03-05 | 2021-03-26 | 2021-02-18 | 0 | 2021-03-03 | ? | 0 | 0006274889 | 20210303.ifs | 2021-03-03 | 2021-03-04 | |||||||
4290455 | 4290455 | DIVIDEND | ADD | 235825205 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2020-06-20 | 2020-04-16 | 0 | 2020-04-16 | ? | 0 | 0006085995 | 20200416.ifs | 2020-04-16 | 2020-04-17 | |||||||
4290766 | 4290766 | DIVIDEND | ADD | 235825205 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2020-06-20 | 2020-04-16 | 0 | 2020-04-16 | ? | 0 | 0006085995 | 20200416.ifs | 2020-04-16 | 2020-04-17 | |||||||
4203089 | 4203089 | DIVIDEND | ADD | 235825205 | 0 | 0 | 1 | 0 | .1 | 00 | 2020-02-27 | 2020-02-28 | 2020-03-20 | 2020-02-11 | 0 | 2020-02-11 | ? | 0 | 0006054624 | 20200211.ifs | 2020-02-11 | 2020-02-12 | |||||||
4203090 | 4203090 | DIVIDEND | ADD | 235825205 | 0 | 0 | 1 | 0 | .1 | 00 | 2020-02-27 | 2020-02-28 | 2020-03-20 | 2020-02-11 | 0 | 2020-02-11 | ? | 0 | 0006054624 | 20200211.ifs | 2020-02-11 | 2020-02-12 | |||||||
3980617 | 3980617 | DIVIDEND | ADD | 235825205 | 0 | 0 | 1 | 0 | .1 | 00 | 2019-11-07 | 2019-11-08 | 2019-11-29 | 2019-10-22 | 0 | 2019-10-22 | ? | 0 | 0005964060 | 20191022.ifs | 2019-10-22 | 2019-10-23 | |||||||
3980620 | 3980620 | DIVIDEND | ADD | 235825205 | 0 | 0 | 1 | 0 | .1 | 00 | 2019-11-07 | 2019-11-08 | 2019-11-29 | 2019-10-22 | 0 | 2019-10-22 | ? | 0 | 0005964060 | 20191022.ifs | 2019-10-22 | 2019-10-23 | |||||||
3853477 | 3853477 | DIVIDEND | ADD | 235825205 | 0 | 0 | 1 | 0 | .1 | 00 | 2019-08-15 | 2019-08-16 | 2019-09-06 | 2019-07-30 | 0 | 2019-07-30 | ? | 0 | 0005920936 | 20190730.ifs | 2019-07-30 | 2019-07-31 | |||||||
3853488 | 3853488 | DIVIDEND | ADD | 235825205 | 0 | 0 | 1 | 0 | .1 | 00 | 2019-08-15 | 2019-08-16 | 2019-09-06 | 2019-07-30 | 0 | 2019-07-30 | ? | 0 | 0005920936 | 20190730.ifs | 2019-07-30 | 2019-07-31 | |||||||
3712436 | 3712436 | DIVIDEND | ADD | 235825205 | 0 | 0 | 1 | 0 | .1 | 00 | 2019-05-16 | 2019-05-17 | 2019-06-07 | 2019-05-01 | 0 | 2019-05-01 | ? | 0 | 0005879429 | 20190501.ifs | 2019-05-01 | 2019-05-02 | |||||||
3712468 | 3712468 | DIVIDEND | ADD | 235825205 | 0 | 0 | 1 | 0 | .1 | 00 | 2019-05-16 | 2019-05-17 | 2019-06-07 | 2019-05-01 | 0 | 2019-05-01 | ? | 0 | 0005879429 | 20190501.ifs | 2019-05-01 | 2019-05-02 | |||||||
3582369 | 3582369 | DIVIDEND | ADD | 235825205 | 0 | 0 | 1 | 0 | .1 | 00 | 2019-02-28 | 2019-03-01 | 2019-03-22 | 2019-02-13 | 0 | 2019-02-13 | ? | 0 | 0005838110 | 20190213.ifs | 2019-02-13 | 2019-02-14 | |||||||
3582370 | 3582370 | DIVIDEND | ADD | 235825205 | 0 | 0 | 1 | 0 | .1 | 00 | 2019-02-28 | 2019-03-01 | 2019-03-22 | 2019-02-13 | 0 | 2019-02-13 | ? | 0 | 0005838110 | 20190213.ifs | 2019-02-13 | 2019-02-14 | |||||||
3338420 | 3338420 | DIVIDEND | ADD | 235825205 | 0 | 0 | 1 | 0 | .1 | 00 | 2018-11-08 | 2018-11-09 | 2018-11-30 | 2018-10-24 | 0 | 2018-10-24 | ? | 0 | 0005743395 | 20181024.ifs | 2018-10-24 | 2018-10-25 | |||||||
3338421 | 3338421 | DIVIDEND | ADD | 235825205 | 0 | 0 | 1 | 0 | .1 | 00 | 2018-11-08 | 2018-11-09 | 2018-11-30 | 2018-10-24 | 0 | 2018-10-24 | ? | 0 | 0005743395 | 20181024.ifs | 2018-10-24 | 2018-10-25 | |||||||
3203848 | 3203848 | DIVIDEND | ADD | 235825205 | 0 | 0 | 1 | 0 | .1 | 00 | 2018-08-09 | 2018-08-10 | 2018-08-31 | 2018-07-24 | 0 | 2018-07-24 | ? | 0 | 0005696595 | 20180724.ifs | 2018-07-24 | 2018-07-25 | |||||||
3203964 | 3203964 | DIVIDEND | ADD | 235825205 | 0 | 0 | 1 | 0 | .1 | 00 | 2018-08-09 | 2018-08-10 | 2018-08-31 | 2018-07-24 | 0 | 2018-07-24 | ? | 0 | 0005696595 | 20180724.ifs | 2018-07-24 | 2018-07-25 | |||||||
3055470 | 3055470 | DIVIDEND | ADD | 235825205 | 0 | 0 | 1 | 0 | .1 | 00 | 2018-05-10 | 2018-05-11 | 2018-06-01 | 2018-04-26 | 0 | 2018-04-26 | ? | 0 | 0005651119 | 20180426.ifs | 2018-04-26 | 2018-04-27 | |||||||
3055471 | 3055471 | DIVIDEND | ADD | 235825205 | 0 | 0 | 1 | 0 | .1 | 00 | 2018-05-10 | 2018-05-11 | 2018-06-01 | 2018-04-26 | 0 | 2018-04-26 | ? | 0 | 0005651119 | 20180426.ifs | 2018-04-26 | 2018-04-27 | |||||||
2988274 | 2988274 | DIVIDEND | CHANGE | 235825205 | 0 | 0 | 1 | 0 | .1 | 00 | 2018-03-01 | 2018-03-02 | 2018-03-23 | 2018-02-16 | 0 | 2018-02-16 | ? | 0 | 0005615982 | 20180312.ifs | 2018-03-12 | 2018-03-13 | |||||||
2988276 | 2988275 | DIVIDEND | CHANGE | 235825205 | 0 | 0 | 1 | 0 | .1 | 00 | 2018-03-01 | 2018-03-02 | 2018-03-23 | 2018-02-16 | 1 | 2018-02-16 | 2018-03-12 | 0 | 0005615982 | 20180312.ifs | 2018-03-12 | 2018-03-13 | |||||||
2988373 | 2988373 | DIVIDEND | CHANGE | 235825205 | 0 | 0 | 1 | 0 | .1 | 00 | 2018-03-01 | 2018-03-02 | 2018-03-23 | 2018-02-16 | 0 | 2018-02-16 | ? | 0 | 0005615982 | 20180312.ifs | 2018-03-12 | 2018-03-13 | |||||||
2988374 | 2988373 | DIVIDEND | CHANGE | 235825205 | 0 | 0 | 1 | 0 | .1 | 00 | 2018-03-01 | 2018-03-02 | 2018-03-23 | 2018-02-16 | 1 | 2018-02-16 | 2018-03-12 | 0 | 0005615982 | 20180312.ifs | 2018-03-12 | 2018-03-13 | |||||||
2955459 | 2955459 | DIVIDEND | ADD | 235825205 | 0 | 0 | 1 | 0 | .1 | 00 | 2018-03-01 | 2018-03-02 | 2018-03-23 | 2018-02-16 | 0 | 2018-02-16 | ? | 0 | 0005615982 | 20180216.ifs | 2018-02-16 | 2018-02-17 | |||||||
2956396 | 2956396 | DIVIDEND | ADD | 235825205 | 0 | 0 | 1 | 0 | .1 | 00 | 2018-03-01 | 2018-03-02 | 2018-03-23 | 2018-02-16 | 0 | 2018-02-16 | ? | 0 | 0005615982 | 20180216.ifs | 2018-02-16 | 2018-02-17 | |||||||
2735328 | 2735328 | DIVIDEND | ADD | 235825205 | 0 | 0 | 1 | 0 | .06 | 00 | 2017-11-09 | 2017-11-10 | 2017-12-01 | 2017-10-25 | 0 | 2017-10-25 | ? | 0 | 0005518385 | 20171025.ifs | 2017-10-25 | 2017-10-26 | |||||||
2735546 | 2735546 | DIVIDEND | ADD | 235825205 | 0 | 0 | 1 | 0 | .06 | 00 | 2017-11-09 | 2017-11-10 | 2017-12-01 | 2017-10-25 | 0 | 2017-10-25 | ? | 0 | 0005518385 | 20171025.ifs | 2017-10-25 | 2017-10-26 | |||||||
2631642 | 2631642 | DIVIDEND | ADD | 235825205 | 0 | 0 | 1 | 0 | .06 | 00 | 2017-08-09 | 2017-08-11 | 2017-09-01 | 2017-07-26 | 0 | 2017-07-26 | ? | 0 | 0005471600 | 20170726.ifs | 2017-07-26 | 2017-07-27 | |||||||
2549642 | 2549642 | DIVIDEND | ADD | 235825205 | 0 | 0 | 1 | 0 | .06 | 00 | 2017-05-10 | 2017-05-12 | 2017-06-02 | 2017-04-27 | 0 | 2017-04-27 | ? | 0 | 0005425008 | 20170427.ifs | 2017-04-27 | 2017-04-28 | |||||||
2491595 | 2491595 | DIVIDEND | ADD | 235825205 | 0 | 0 | 1 | 0 | .06 | 00 | 2017-03-01 | 2017-03-03 | 2017-03-24 | 2017-02-16 | 0 | 2017-02-16 | ? | 0 | 0005389152 | 20170216.ifs | 2017-02-16 | 2017-02-17 | |||||||
2436814 | 2436814 | EQUITY | CHANGE | 235825205 | COM | 0 | 0 | 2008-01-31 | ? | 0 | no | no | no | 2008-02-01 | 2008-02-01 | ? | 20170123.ifs | 2017-01-23 | 2017-01-24 | ||||||||||
2436815 | 2436814 | EQUITY | CHANGE | 235825205 | COM | 0 | 0 | 2008-01-31 | ? | 4 | no | no | no | 2008-02-01 | 2008-02-01 | ? | 20170123.ifs | 2017-01-23 | 2017-01-24 | ||||||||||
2328127 | 2328127 | DIVIDEND | ADD | 235825205 | 0 | 0 | 1 | 0 | .06 | 00 | 2016-11-08 | 2016-11-11 | 2016-12-02 | 2016-10-27 | 0 | 2016-10-27 | ? | 0 | 0005301745 | 20161027.ifs | 2016-10-27 | 2016-10-28 | |||||||
2258315 | 2258315 | DIVIDEND | ADD | 235825205 | 0 | 0 | 1 | 0 | .06 | 00 | 2016-08-17 | 2016-08-19 | 2016-09-09 | 2016-07-27 | 0 | 2016-07-27 | ? | 0 | 0005254785 | 20160727.ifs | 2016-07-27 | 2016-07-28 | |||||||
2181469 | 2181469 | DIVIDEND | ADD | 235825205 | 0 | 0 | 1 | 0 | .06 | 00 | 2016-05-11 | 2016-05-13 | 2016-06-03 | 2016-04-28 | 0 | 2016-04-28 | ? | 0 | 0005209485 | 20160428.ifs | 2016-04-28 | 2016-04-29 | |||||||
2117410 | 2117410 | DIVIDEND | ADD | 235825205 | 0 | 0 | 1 | 0 | .06 | 00 | 2016-03-09 | 2016-03-11 | 2016-04-01 | 2016-02-23 | 0 | 2016-02-23 | ? | 0 | 0005174826 | 20160223.ifs | 2016-02-23 | 2016-02-24 | |||||||
1998227 | 1998227 | DIVIDEND | ADD | 235825205 | 0 | 0 | 1 | 0 | .06 | 00 | 2015-11-10 | 2015-11-13 | 2015-12-04 | 2015-10-28 | 0 | 2015-10-28 | ? | 0 | 0005082948 | 20151028.ifs | 2015-10-28 | 2015-10-29 | |||||||
1925305 | 1925305 | DIVIDEND | ADD | 235825205 | 0 | 0 | 1 | 0 | .06 | 00 | 2015-08-19 | 2015-08-21 | 2015-09-11 | 2015-07-29 | 0 | 2015-07-29 | ? | 0 | 0005036653 | 20150729.ifs | 2015-07-29 | 2015-07-30 | |||||||
1852817 | 1852817 | DIVIDEND | ADD | 235825205 | 0 | 0 | 1 | 0 | .06 | 00 | 2015-05-13 | 2015-05-15 | 2015-06-05 | 2015-04-30 | 0 | 2015-04-30 | ? | 0 | 0004991053 | 20150430.ifs | 2015-04-30 | 2015-05-01 | |||||||
1795337 | 1795337 | DIVIDEND | ADD | 235825205 | 0 | 0 | 1 | 0 | .05 | 00 | 2015-03-11 | 2015-03-13 | 2015-04-03 | 2015-02-25 | 0 | 2015-02-25 | ? | 0 | 0004957718 | 20150225.ifs | 2015-02-25 | 2015-02-26 | |||||||
1666254 | 1666254 | DIVIDEND | ADD | 235825205 | 0 | 0 | 1 | 0 | .05 | 00 | 2014-11-12 | 2014-11-14 | 2014-12-05 | 2014-10-29 | 0 | 2014-10-30 | ? | 0 | 0004863384 | 20141030.ifs | 2014-10-30 | 2014-10-31 | |||||||
1599284 | 1599284 | DIVIDEND | ADD | 235825205 | 0 | 0 | 1 | 0 | .05 | 00 | 2014-08-20 | 2014-08-22 | 2014-09-12 | 2014-08-04 | 0 | 2014-08-04 | ? | 0 | 0004825711 | 20140804.ifs | 2014-08-04 | 2014-08-05 | |||||||
1516982 | 1516982 | DIVIDEND | ADD | 235825205 | 0 | 0 | 1 | 0 | .05 | 00 | 2014-05-14 | 2014-05-16 | 2014-06-06 | 2014-05-02 | 0 | 2014-05-02 | ? | 0 | 0004780403 | 20140502.ifs | 2014-05-02 | 2014-05-03 | |||||||
1450273 | 1450273 | DIVIDEND | ADD | 235825205 | 0 | 0 | 1 | 0 | .05 | 00 | 2014-03-12 | 2014-03-14 | 2014-04-04 | 2014-02-26 | 0 | 2014-02-26 | ? | 0 | 0004739846 | 20140226.ifs | 2014-02-26 | 2014-02-27 | |||||||
1323427 | 1323427 | DIVIDEND | ADD | 235825205 | 0 | 0 | 1 | 0 | .05 | 00 | 2013-11-06 | 2013-11-08 | 2013-11-29 | 2013-10-25 | 0 | 2013-10-25 | ? | 0 | 0004647937 | 20131025.ifs | 2013-10-25 | 2013-10-26 | |||||||
1245197 | 1245197 | DIVIDEND | ADD | 235825205 | 0 | 0 | 1 | 0 | .05 | 00 | 2013-08-07 | 2013-08-09 | 2013-08-30 | 2013-07-23 | 0 | 2013-07-23 | ? | 0 | 0004603549 | 20130723.ifs | 2013-07-23 | 2013-07-24 | |||||||
1165332 | 1165332 | DIVIDEND | ADD | 235825205 | 0 | 0 | 1 | 0 | .05 | 00 | 2013-05-08 | 2013-05-10 | 2013-05-31 | 2013-04-23 | 0 | 2013-04-23 | ? | 0 | 0004559894 | 20130423.ifs | 2013-04-23 | 2013-04-24 | |||||||
1119152 | 1119152 | DIVIDEND | ADD | 235825205 | 0 | 0 | 1 | 0 | .05 | 00 | 2013-03-13 | 2013-03-15 | 2013-04-05 | 2013-02-27 | 0 | 2013-02-27 | ? | 0 | 0004531300 | 20130227.ifs | 2013-02-27 | 2013-02-28 | |||||||
993566 | 993566 | DIVIDEND | ADD | 235825205 | 0 | 0 | 1 | 0 | .05 | 00 | 2012-11-07 | 2012-11-09 | 2012-11-30 | 2012-10-26 | 0 | 2012-10-26 | ? | 0 | 0004448197 | 20121026.ifs | 2012-10-26 | 2012-10-27 | |||||||
922076 | 922076 | DIVIDEND | ADD | 235825205 | 0 | 0 | 1 | 0 | .05 | 00 | 2012-08-08 | 2012-08-10 | 2012-08-31 | 2012-07-26 | 0 | 2012-07-26 | ? | 0 | 0004405337 | 20120726.ifs | 2012-07-26 | 2012-07-27 | |||||||
842826 | 842826 | DIVIDEND | ADD | 235825205 | 0 | 0 | 1 | 0 | .05 | 00 | 2012-05-09 | 2012-05-11 | 2012-06-01 | 2012-04-25 | 0 | 2012-04-25 | ? | 0 | 0004363910 | 20120425.ifs | 2012-04-25 | 2012-04-26 | |||||||
783275 | 783275 | DIVIDEND | ADD | 235825205 | 0 | 0 | 1 | 4 | .05 | 00 | 2012-03-07 | 2012-03-09 | 2012-03-30 | 2012-02-22 | 0 | 2012-02-22 | ? | 0 | 0004334766 | 20120222.ifs | 2012-02-22 | 2012-02-23 |
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 = 152987
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