INSITITUIONS | Dynamic | newInstitTable | Changed the Cusip/Sector/Shs Out? |
|
|||||||
Total Insititutions : | 1344 | 1250 | Update Insititution By Cusips | ||||||||
% Owned by Insititutions: | 70.04 % | 72.7 % | |||||||||
pricingQuarterAdminPageOn:
|
2024-03-31 | New % | |||||||||
|
|||||||||||
the compid is:157898 |
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 | ||
5541326 | 5541326 | DIVIDEND | ADD | 37045V100 | 0 | 0 | 1 | 0 | .12 | 00 | 2024-06-07 | 2024-06-07 | 2024-06-20 | 2024-04-22 | 0 | 2024-04-22 | ? | 0 | 0006907752 | 20240422.ifs | 2024-04-22 | 2024-04-23 | |||||||
5486207 | 5486207 | DIVIDEND | ADD | 37045V100 | 0 | 0 | 1 | 0 | .12 | 00 | 2024-02-29 | 2024-03-01 | 2024-03-14 | 2024-01-29 | 0 | 2024-01-29 | ? | 0 | 0006867402 | 20240129.ifs | 2024-01-29 | 2024-01-30 | |||||||
5398746 | 5398746 | DIVIDEND | ADD | 37045V100 | 0 | 0 | 1 | 0 | .09 | 00 | 2023-11-30 | 2023-12-01 | 2023-12-14 | 2023-10-23 | 0 | 2023-10-23 | ? | 0 | 0006800268 | 20231023.ifs | 2023-10-23 | 2023-10-24 | |||||||
5338880 | 5338880 | DIVIDEND | ADD | 37045V100 | 0 | 0 | 1 | 0 | .09 | 00 | 2023-08-31 | 2023-09-01 | 2023-09-14 | 2023-07-24 | 0 | 2023-07-24 | ? | 0 | 0006758253 | 20230724.ifs | 2023-07-24 | 2023-07-25 | |||||||
5276289 | 5276289 | DIVIDEND | ADD | 37045V100 | 0 | 0 | 1 | 0 | .09 | 00 | 2023-06-01 | 2023-06-02 | 2023-06-15 | 2023-04-24 | 0 | 2023-04-24 | ? | 0 | 0006714840 | 20230424.ifs | 2023-04-24 | 2023-04-25 | |||||||
5223953 | 5223953 | DIVIDEND | ADD | 37045V100 | 0 | 0 | 1 | 0 | .09 | 00 | 2023-03-02 | 2023-03-03 | 2023-03-16 | 2023-02-01 | 0 | 2023-02-01 | ? | 0 | 0006676345 | 20230201.ifs | 2023-02-01 | 2023-02-02 | |||||||
5124495 | 5124495 | DIVIDEND | ADD | 37045V100 | 0 | 0 | 1 | 0 | .09 | 00 | 2022-12-01 | 2022-12-02 | 2022-12-15 | 2022-10-24 | 0 | 2022-10-24 | ? | 0 | 0006601590 | 20221024.ifs | 2022-10-24 | 2022-10-25 | |||||||
5080139 | 5080139 | DIVIDEND | ADD | 37045V100 | 0 | 0 | 1 | 0 | .09 | 00 | 2022-08-30 | 2022-08-31 | 2022-09-15 | 2022-08-16 | 0 | 2022-08-19 | ? | 0 | 0006570817 | 20220819.ifs | 2022-08-19 | 2022-08-20 | |||||||
4518183 | 4518183 | DIVIDEND | CHANGE | 37045V100 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2020-06-19 | 2020-04-27 | 0 | 2020-04-27 | ? | 0 | 0006088309 | 20201130.ifs | 2020-11-30 | 2020-12-01 | |||||||
4518184 | 4518183 | DIVIDEND | CHANGE | 37045V100 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2020-06-19 | 2020-04-27 | 1 | 2020-04-27 | 2020-11-30 | 0 | 0006088309 | 20201130.ifs | 2020-11-30 | 2020-12-01 | |||||||
4302915 | 4302915 | DIVIDEND | ADD | 37045V100 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2020-06-19 | 2020-04-27 | 0 | 2020-04-27 | ? | 0 | 0006088309 | 20200427.ifs | 2020-04-27 | 2020-04-28 | |||||||
4302916 | 4302916 | DIVIDEND | ADD | 37045V100 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2020-06-19 | 2020-04-27 | 0 | 2020-04-27 | ? | 0 | 0006088309 | 20200427.ifs | 2020-04-27 | 2020-04-28 | |||||||
4193826 | 4193826 | DIVIDEND | ADD | 37045V100 | 0 | 0 | 1 | 0 | .38 | 00 | 2020-03-05 | 2020-03-06 | 2020-03-20 | 2020-02-03 | 0 | 2020-02-03 | ? | 0 | 0006051627 | 20200203.ifs | 2020-02-03 | 2020-02-04 | |||||||
4194322 | 4194322 | DIVIDEND | ADD | 37045V100 | 0 | 0 | 1 | 0 | .38 | 00 | 2020-03-05 | 2020-03-06 | 2020-03-20 | 2020-02-03 | 0 | 2020-02-03 | ? | 0 | 0006051627 | 20200203.ifs | 2020-02-03 | 2020-02-04 | |||||||
3986470 | 3986470 | DIVIDEND | ADD | 37045V100 | 0 | 0 | 1 | 0 | .38 | 00 | 2019-12-05 | 2019-12-06 | 2019-12-19 | 2019-10-28 | 0 | 2019-10-28 | ? | 0 | 0005965617 | 20191028.ifs | 2019-10-28 | 2019-10-29 | |||||||
3986530 | 3986530 | DIVIDEND | ADD | 37045V100 | 0 | 0 | 1 | 0 | .38 | 00 | 2019-12-05 | 2019-12-06 | 2019-12-19 | 2019-10-28 | 0 | 2019-10-28 | ? | 0 | 0005965617 | 20191028.ifs | 2019-10-28 | 2019-10-29 | |||||||
3857604 | 3857604 | DIVIDEND | ADD | 37045V100 | 0 | 0 | 1 | 0 | .38 | 00 | 2019-09-05 | 2019-09-06 | 2019-09-20 | 2019-07-31 | 0 | 2019-07-31 | ? | 0 | 0005921342 | 20190731.ifs | 2019-07-31 | 2019-08-01 | |||||||
3857625 | 3857625 | DIVIDEND | ADD | 37045V100 | 0 | 0 | 1 | 0 | .38 | 00 | 2019-09-05 | 2019-09-06 | 2019-09-20 | 2019-07-31 | 0 | 2019-07-31 | ? | 0 | 0005921342 | 20190731.ifs | 2019-07-31 | 2019-08-01 | |||||||
3698929 | 3698929 | DIVIDEND | ADD | 37045V100 | 0 | 0 | 1 | 0 | .38 | 00 | 2019-06-06 | 2019-06-07 | 2019-06-21 | 2019-04-29 | 0 | 2019-04-29 | ? | 0 | 0005874223 | 20190429.ifs | 2019-04-29 | 2019-04-30 | |||||||
3698984 | 3698984 | DIVIDEND | ADD | 37045V100 | 0 | 0 | 1 | 0 | .38 | 00 | 2019-06-06 | 2019-06-07 | 2019-06-21 | 2019-04-29 | 0 | 2019-04-29 | ? | 0 | 0005874223 | 20190429.ifs | 2019-04-29 | 2019-04-30 | |||||||
3575723 | 3575723 | DIVIDEND | ADD | 37045V100 | 0 | 0 | 1 | 0 | .38 | 00 | 2019-03-07 | 2019-03-08 | 2019-03-22 | 2019-02-05 | 0 | 2019-02-05 | ? | 0 | 0005836518 | 20190205.ifs | 2019-02-05 | 2019-02-06 | |||||||
3575724 | 3575724 | DIVIDEND | ADD | 37045V100 | 0 | 0 | 1 | 0 | .38 | 00 | 2019-03-07 | 2019-03-08 | 2019-03-22 | 2019-02-05 | 0 | 2019-02-05 | ? | 0 | 0005836518 | 20190205.ifs | 2019-02-05 | 2019-02-06 | |||||||
3344223 | 3344223 | DIVIDEND | ADD | 37045V100 | 0 | 0 | 1 | 0 | .38 | 00 | 2018-12-06 | 2018-12-07 | 2018-12-20 | 2018-10-30 | 0 | 2018-10-30 | ? | 0 | 0005744851 | 20181030.ifs | 2018-10-30 | 2018-10-31 | |||||||
3344226 | 3344226 | DIVIDEND | ADD | 37045V100 | 0 | 0 | 1 | 0 | .38 | 00 | 2018-12-06 | 2018-12-07 | 2018-12-20 | 2018-10-30 | 0 | 2018-10-30 | ? | 0 | 0005744851 | 20181030.ifs | 2018-10-30 | 2018-10-31 | |||||||
3203664 | 3203664 | DIVIDEND | ADD | 37045V100 | 0 | 0 | 1 | 0 | .38 | 00 | 2018-09-06 | 2018-09-07 | 2018-09-21 | 2018-07-24 | 0 | 2018-07-24 | ? | 0 | 0005696662 | 20180724.ifs | 2018-07-24 | 2018-07-25 | |||||||
3203783 | 3203783 | DIVIDEND | ADD | 37045V100 | 0 | 0 | 1 | 0 | .38 | 00 | 2018-09-06 | 2018-09-07 | 2018-09-21 | 2018-07-24 | 0 | 2018-07-24 | ? | 0 | 0005696662 | 20180724.ifs | 2018-07-24 | 2018-07-25 | |||||||
3053327 | 3053327 | DIVIDEND | ADD | 37045V100 | 0 | 0 | 1 | 0 | .38 | 00 | 2018-06-07 | 2018-06-08 | 2018-06-22 | 2018-04-25 | 0 | 2018-04-25 | ? | 0 | 0005650176 | 20180425.ifs | 2018-04-25 | 2018-04-26 | |||||||
3053350 | 3053350 | DIVIDEND | ADD | 37045V100 | 0 | 0 | 1 | 0 | .38 | 00 | 2018-06-07 | 2018-06-08 | 2018-06-22 | 2018-04-25 | 0 | 2018-04-25 | ? | 0 | 0005650176 | 20180425.ifs | 2018-04-25 | 2018-04-26 | |||||||
3050216 | 3050216 | EQUITY | CHANGE | 37045V100 | COM | 0 | 0 | 2010-11-18 | ? | 4 | no | no | no | 2010-11-18 | 2017-11-30 | ? | 20180424.ifs | 2018-04-24 | 2018-04-25 | ||||||||||
3050218 | 3050217 | EQUITY | CHANGE | 37045V100 | COM | 0 | 0 | 2010-11-18 | ? | 4 | no | no | no | 2010-11-18 | 2018-04-24 | ? | 20180424.ifs | 2018-04-24 | 2018-04-25 | ||||||||||
3050220 | 3050220 | DIVIDEND | CHANGE | 37045V100 | 0 | 0 | 1 | 4 | .3 | 00 | 2014-03-14 | 2014-03-18 | 2014-03-28 | 2014-01-14 | 1 | 2014-01-14 | 2014-03-14 | 0 | 0004724110 | 20180424.ifs | 2018-04-24 | 2018-04-25 | |||||||
3050222 | 3050221 | DIVIDEND | CHANGE | 37045V100 | 0 | 0 | 1 | 4 | .3 | 00 | 2014-03-14 | 2014-03-18 | 2014-03-28 | 2014-01-14 | 1 | 2014-01-14 | 2018-04-24 | 0 | 0004724110 | 20180424.ifs | 2018-04-24 | 2018-04-25 | |||||||
3050224 | 3050224 | EXCHANGE | CHANGE | 37045V100 | 01 | 2010-11-18 | 2018-04-23 | GM | 0 | 0 | 2010-11-18 | 2018-04-24 | 20180424.ifs | 2018-04-24 | 2018-04-25 | ||||||||||||||
3050226 | 3050225 | EXCHANGE | CHANGE | 37045V100 | 01 | 2010-11-18 | 2018-04-23 | GM | 0 | 0 | 2010-11-18 | 2018-04-24 | 20180424.ifs | 2018-04-24 | 2018-04-25 | ||||||||||||||
3050237 | 3050237 | EQUITY | CHANGE | 37045V100 | COM | 0 | 0 | 2010-11-18 | ? | 4 | no | no | no | 2010-11-18 | 2017-11-30 | ? | 20180424.ifs | 2018-04-24 | 2018-04-25 | ||||||||||
3050239 | 3050238 | EQUITY | CHANGE | 37045V100 | COM | 0 | 0 | 2010-11-18 | ? | 4 | no | no | no | 2010-11-18 | 2018-04-24 | ? | 20180424.ifs | 2018-04-24 | 2018-04-25 | ||||||||||
3050241 | 3050241 | DIVIDEND | CHANGE | 37045V100 | 0 | 0 | 1 | 4 | .3 | 00 | 2014-03-14 | 2014-03-18 | 2014-03-28 | 2014-01-14 | 1 | 2014-01-14 | 2014-03-14 | 0 | 0004724110 | 20180424.ifs | 2018-04-24 | 2018-04-25 | |||||||
3050243 | 3050242 | DIVIDEND | CHANGE | 37045V100 | 0 | 0 | 1 | 4 | .3 | 00 | 2014-03-14 | 2014-03-18 | 2014-03-28 | 2014-01-14 | 1 | 2014-01-14 | 2018-04-24 | 0 | 0004724110 | 20180424.ifs | 2018-04-24 | 2018-04-25 | |||||||
3050245 | 3050245 | EXCHANGE | CHANGE | 37045V100 | 01 | 2010-11-18 | 2018-04-23 | GM | 0 | 0 | 2010-11-18 | 2018-04-24 | 20180424.ifs | 2018-04-24 | 2018-04-25 | ||||||||||||||
3050247 | 3050246 | EXCHANGE | CHANGE | 37045V100 | 01 | 2010-11-18 | 2018-04-23 | GM | 0 | 0 | 2010-11-18 | 2018-04-24 | 20180424.ifs | 2018-04-24 | 2018-04-25 | ||||||||||||||
2945670 | 2945670 | DIVIDEND | ADD | 37045V100 | 0 | 0 | 1 | 0 | .38 | 00 | 2018-03-08 | 2018-03-09 | 2018-03-23 | 2018-02-05 | 0 | 2018-02-05 | ? | 0 | 0005613222 | 20180205.ifs | 2018-02-05 | 2018-02-06 | |||||||
2732432 | 2732432 | DIVIDEND | ADD | 37045V100 | 0 | 0 | 1 | 0 | .38 | 00 | 2017-12-07 | 2017-12-08 | 2017-12-21 | 2017-10-23 | 0 | 2017-10-23 | ? | 0 | 0005516914 | 20171023.ifs | 2017-10-23 | 2017-10-24 | |||||||
2732444 | 2732444 | DIVIDEND | ADD | 37045V100 | 0 | 0 | 1 | 0 | .38 | 00 | 2017-12-07 | 2017-12-08 | 2017-12-21 | 2017-10-23 | 0 | 2017-10-23 | ? | 0 | 0005516914 | 20171023.ifs | 2017-10-23 | 2017-10-24 | |||||||
2629937 | 2629937 | DIVIDEND | ADD | 37045V100 | 0 | 0 | 1 | 0 | .38 | 00 | 2017-09-07 | 2017-09-08 | 2017-09-22 | 2017-07-24 | 0 | 2017-07-24 | ? | 0 | 0005470782 | 20170724.ifs | 2017-07-24 | 2017-07-25 | |||||||
2549492 | 2549492 | DIVIDEND | ADD | 37045V100 | 0 | 0 | 1 | 0 | .38 | 00 | 2017-06-07 | 2017-06-09 | 2017-06-23 | 2017-04-27 | 0 | 2017-04-27 | ? | 0 | 0005424682 | 20170427.ifs | 2017-04-27 | 2017-04-28 | |||||||
2486037 | 2486037 | DIVIDEND | ADD | 37045V100 | 0 | 0 | 1 | 0 | .38 | 00 | 2017-03-08 | 2017-03-10 | 2017-03-24 | 2017-02-06 | 0 | 2017-02-06 | ? | 0 | 0005386667 | 20170206.ifs | 2017-02-06 | 2017-02-07 | |||||||
2438754 | 2438754 | EQUITY | CHANGE | 37045V100 | COM | 0 | 0 | 2010-11-18 | ? | 0 | no | no | no | 2010-11-18 | ? | ? | 20170123.ifs | 2017-01-23 | 2017-01-24 | ||||||||||
2438755 | 2438754 | EQUITY | CHANGE | 37045V100 | COM | 0 | 0 | 2010-11-18 | ? | 4 | no | no | no | 2010-11-18 | ? | ? | 20170123.ifs | 2017-01-23 | 2017-01-24 | ||||||||||
2325547 | 2325547 | DIVIDEND | ADD | 37045V100 | 0 | 0 | 1 | 0 | .38 | 00 | 2016-12-05 | 2016-12-07 | 2016-12-22 | 2016-10-24 | 0 | 2016-10-24 | ? | 0 | 0005300364 | 20161024.ifs | 2016-10-24 | 2016-10-25 | |||||||
2254172 | 2254172 | DIVIDEND | ADD | 37045V100 | 0 | 0 | 1 | 0 | .38 | 00 | 2016-09-07 | 2016-09-09 | 2016-09-23 | 2016-07-20 | 0 | 2016-07-20 | ? | 0 | 0005252849 | 20160720.ifs | 2016-07-20 | 2016-07-21 | |||||||
2167819 | 2167819 | DIVIDEND | ADD | 37045V100 | 0 | 0 | 1 | 0 | .38 | 00 | 2016-06-08 | 2016-06-10 | 2016-06-23 | 2016-04-20 | 0 | 2016-04-20 | ? | 0 | 0005206581 | 20160420.ifs | 2016-04-20 | 2016-04-21 | |||||||
2108195 | 2108195 | DIVIDEND | ADD | 37045V100 | 0 | 0 | 1 | 0 | .38 | 00 | 2016-03-09 | 2016-03-11 | 2016-03-24 | 2016-02-02 | 0 | 2016-02-02 | ? | 0 | 0005170280 | 20160202.ifs | 2016-02-02 | 2016-02-03 | |||||||
2027929 | 2027929 | DIVIDEND | ADD | 37045V100 | 0 | 0 | 1 | 0 | .36 | 00 | 2015-12-16 | 2015-12-18 | 2015-12-29 | 2015-12-08 | 0 | 2015-12-08 | ? | 0 | 0005107535 | 20151208.ifs | 2015-12-08 | 2015-12-09 | |||||||
1958712 | 1958712 | DIVIDEND | ADD | 37045V100 | 0 | 0 | 1 | 0 | .36 | 00 | 2015-09-10 | 2015-09-14 | 2015-09-29 | 2015-09-02 | 0 | 2015-09-02 | ? | 0 | 0005058173 | 20150902.ifs | 2015-09-02 | 2015-09-03 | |||||||
1839380 | 1839380 | DIVIDEND | ADD | 37045V100 | 0 | 0 | 1 | 0 | .36 | 00 | 2015-06-08 | 2015-06-10 | 2015-06-23 | 2015-04-13 | 0 | 2015-04-13 | ? | 0 | 0004985763 | 20150413.ifs | 2015-04-13 | 2015-04-14 | |||||||
1772447 | 1772447 | DIVIDEND | ADD | 37045V100 | 0 | 0 | 1 | 0 | .3 | 00 | 2015-03-09 | 2015-03-11 | 2015-03-24 | 2015-01-21 | 0 | 2015-01-21 | ? | 0 | 0004942887 | 20150121.ifs | 2015-01-21 | 2015-01-22 | |||||||
1654707 | 1654707 | DIVIDEND | ADD | 37045V100 | 0 | 0 | 1 | 0 | .3 | 00 | 2014-12-08 | 2014-12-10 | 2014-12-23 | 2014-10-08 | 0 | 2014-10-08 | ? | 0 | 0004858793 | 20141008.ifs | 2014-10-08 | 2014-10-09 | |||||||
1605147 | 1605147 | DIVIDEND | ADD | 37045V100 | 0 | 0 | 1 | 0 | .3 | 00 | 2014-09-08 | 2014-09-10 | 2014-09-26 | 2014-08-12 | 0 | 2014-08-12 | ? | 0 | 0004828382 | 20140812.ifs | 2014-08-12 | 2014-08-13 | |||||||
1493401 | 1493401 | DIVIDEND | ADD | 37045V100 | 0 | 0 | 1 | 0 | .3 | 00 | 2014-06-06 | 2014-06-10 | 2014-06-26 | 2014-04-08 | 0 | 2014-04-08 | ? | 0 | 0004767273 | 20140408.ifs | 2014-04-08 | 2014-04-09 | |||||||
1467102 | 1467102 | DIVIDEND | CHANGE | 37045V100 | 0 | 0 | 1 | 4 | .3 | 00 | 2014-03-14 | 2014-03-18 | 2014-03-28 | 2014-01-14 | 0 | 2014-01-14 | ? | 0 | 0004724110 | 20140314.ifs | 2014-03-14 | 2014-03-15 | |||||||
1467103 | 1467102 | DIVIDEND | CHANGE | 37045V100 | 0 | 0 | 1 | 4 | .3 | 00 | 2014-03-14 | 2014-03-18 | 2014-03-28 | 2014-01-14 | 1 | 2014-01-14 | 2014-03-14 | 0 | 0004724110 | 20140314.ifs | 2014-03-14 | 2014-03-15 | |||||||
1422287 | 1422287 | DIVIDEND | ADD | 37045V100 | 0 | 0 | 1 | 4 | .3 | 00 | 2014-03-14 | 2014-03-18 | 2014-03-28 | 2014-01-14 | 0 | 2014-01-14 | ? | 0 | 0004724110 | 20140114.ifs | 2014-01-14 | 2014-01-15 | |||||||
357455 | 357455 | EQUITY | ADD | 37045V100 | COM | N | 0 | 2010-11-18 | ? | 0 | no | no | no | 2010-11-18 | ? | ? | 20101118.ifs | 2010-11-18 | 2010-11-19 | ||||||||||
357456 | 357456 | EXCHANGE | ADD | 37045V100 | 01 | 2010-11-18 | 2010-11-18 | GM | 0 | 0 | 2010-11-18 | ? | 20101118.ifs | 2010-11-18 | 2010-11-19 | ||||||||||||||
357619 | 357619 | EQUITY | CHANGE | 37045V100 | COM | N | 0 | 2010-11-18 | ? | 0 | no | no | no | 2010-11-18 | ? | ? | 20101118.ifs | 2010-11-18 | 2010-11-19 | ||||||||||
357620 | 357619 | EQUITY | CHANGE | 37045V100 | COM | 0 | 0 | 2010-11-18 | ? | 0 | no | no | no | 2010-11-18 | ? | ? | 20101118.ifs | 2010-11-18 | 2010-11-19 |
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 = 157898
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