INSITITUIONS | Dynamic | newInstitTable | Changed the Cusip/Sector/Shs Out? |
|
|||||||
Total Insititutions : | 78 | 70 | Update Insititution By Cusips | ||||||||
% Owned by Insititutions: | 23.09 % | 23.04 % | |||||||||
pricingQuarterAdminPageOn:
|
2024-03-31 | New % | |||||||||
|
|||||||||||
the compid is:151580 |
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 | ||
5559014 | 5559014 | DIVIDEND | ADD | 36246K103 | 0 | 0 | 1 | 0 | .15 | 00 | 2024-06-13 | 2024-06-13 | 2024-06-21 | 2024-05-16 | 0 | 2024-05-16 | ? | 0 | 0006920095 | 20240516.ifs | 2024-05-16 | 2024-05-17 | |||||||
5498789 | 5498789 | DIVIDEND | ADD | 36246K103 | 0 | 0 | 1 | 0 | .15 | 00 | 2024-03-13 | 2024-03-14 | 2024-03-21 | 2024-02-14 | 0 | 2024-02-14 | ? | 0 | 0006876614 | 20240214.ifs | 2024-02-14 | 2024-02-15 | |||||||
5415537 | 5415537 | DIVIDEND | ADD | 36246K103 | 0 | 0 | 1 | 0 | .15 | 00 | 2023-12-14 | 2023-12-15 | 2023-12-22 | 2023-11-15 | 0 | 2023-11-16 | ? | 0 | 0006812313 | 20231116.ifs | 2023-11-16 | 2023-11-17 | |||||||
5358419 | 5358419 | DIVIDEND | ADD | 36246K103 | 0 | 0 | 1 | 0 | .15 | 00 | 2023-09-14 | 2023-09-15 | 2023-09-22 | 2023-08-25 | 0 | 2023-08-25 | ? | 0 | 0006771525 | 20230825.ifs | 2023-08-25 | 2023-08-26 | |||||||
5293692 | 5293692 | DIVIDEND | ADD | 36246K103 | 0 | 0 | 1 | 0 | .15 | 00 | 2023-06-14 | 2023-06-15 | 2023-06-23 | 2023-05-18 | 0 | 2023-05-18 | ? | 0 | 0006726648 | 20230518.ifs | 2023-05-18 | 2023-05-19 | |||||||
5232205 | 5232205 | DIVIDEND | ADD | 36246K103 | 0 | 0 | 1 | 0 | .15 | 00 | 2023-03-16 | 2023-03-17 | 2023-03-24 | 2023-02-17 | 0 | 2023-02-17 | ? | 0 | 0006683377 | 20230217.ifs | 2023-02-17 | 2023-02-18 | |||||||
5139102 | 5139102 | DIVIDEND | ADD | 36246K103 | 0 | 0 | 1 | 0 | .15 | 00 | 2022-12-08 | 2022-12-09 | 2022-12-16 | 2022-11-11 | 0 | 2022-11-11 | ? | 0 | 0006612319 | 20221111.ifs | 2022-11-11 | 2022-11-12 | |||||||
5079556 | 5079556 | DIVIDEND | ADD | 36246K103 | 0 | 0 | 1 | 0 | .15 | 00 | 2022-09-15 | 2022-09-16 | 2022-09-23 | 2022-08-18 | 0 | 2022-08-18 | ? | 0 | 0006570278 | 20220818.ifs | 2022-08-18 | 2022-08-19 | |||||||
5011645 | 5011645 | DIVIDEND | ADD | 36246K103 | 0 | 0 | 1 | 0 | .15 | 00 | 2022-06-14 | 2022-06-15 | 2022-06-23 | 2022-05-13 | 0 | 2022-05-13 | ? | 0 | 0006523736 | 20220513.ifs | 2022-05-13 | 2022-05-14 | |||||||
4951212 | 4951212 | DIVIDEND | ADD | 36246K103 | 0 | 0 | 1 | 0 | .15 | 00 | 2022-03-16 | 2022-03-17 | 2022-03-24 | 2022-02-09 | 0 | 2022-02-09 | ? | 0 | 0006479329 | 20220209.ifs | 2022-02-09 | 2022-02-10 | |||||||
4847613 | 4847613 | DIVIDEND | ADD | 36246K103 | 0 | 0 | 1 | 0 | .15 | 00 | 2021-12-09 | 2021-12-10 | 2021-12-17 | 2021-11-12 | 0 | 2021-11-12 | ? | 0 | 0006396314 | 20211112.ifs | 2021-11-12 | 2021-11-13 | |||||||
4784050 | 4784050 | DIVIDEND | ADD | 36246K103 | 0 | 0 | 1 | 0 | .15 | 00 | 2021-09-15 | 2021-09-16 | 2021-09-23 | 2021-08-19 | 0 | 2021-08-19 | ? | 0 | 0006354460 | 20210819.ifs | 2021-08-19 | 2021-08-20 | |||||||
4705050 | 4705050 | DIVIDEND | ADD | 36246K103 | 0 | 0 | 1 | 0 | .15 | 00 | 2021-06-15 | 2021-06-16 | 2021-06-23 | 2021-05-13 | 0 | 2021-05-13 | ? | 0 | 0006307767 | 20210513.ifs | 2021-05-13 | 2021-05-14 | |||||||
4637060 | 4637060 | DIVIDEND | ADD | 36246K103 | 0 | 0 | 1 | 0 | .15 | 00 | 2021-03-16 | 2021-03-17 | 2021-03-24 | 2021-02-25 | 0 | 2021-02-25 | ? | 0 | 0006267211 | 20210225.ifs | 2021-02-25 | 2021-02-26 | |||||||
4506967 | 4506967 | DIVIDEND | ADD | 36246K103 | 0 | 0 | 1 | 0 | .15 | 00 | 2020-12-10 | 2020-12-11 | 2020-12-18 | 2020-11-13 | 0 | 2020-11-13 | ? | 0 | 0006188099 | 20201113.ifs | 2020-11-13 | 2020-11-14 | |||||||
4442623 | 4442623 | DIVIDEND | ADD | 36246K103 | 0 | 0 | 1 | 0 | .15 | 00 | 2020-09-15 | 2020-09-16 | 2020-09-23 | 2020-08-19 | 0 | 2020-08-19 | ? | 0 | 0006145289 | 20200819.ifs | 2020-08-19 | 2020-08-20 | |||||||
4336096 | 4336096 | DIVIDEND | ADD | 36246K103 | 0 | 0 | 1 | 0 | .14 | 00 | 2020-06-15 | 2020-06-16 | 2020-06-23 | 2020-05-14 | 0 | 2020-05-14 | ? | 0 | 0006099189 | 20200514.ifs | 2020-05-14 | 2020-05-15 | |||||||
4336154 | 4336154 | DIVIDEND | ADD | 36246K103 | 0 | 0 | 1 | 0 | .14 | 00 | 2020-06-15 | 2020-06-16 | 2020-06-23 | 2020-05-14 | 0 | 2020-05-14 | ? | 0 | 0006099189 | 20200514.ifs | 2020-05-14 | 2020-05-15 | |||||||
4204127 | 4204127 | DIVIDEND | ADD | 36246K103 | 0 | 0 | 1 | 0 | .14 | 00 | 2020-03-16 | 2020-03-17 | 2020-03-24 | 2020-02-12 | 0 | 2020-02-12 | ? | 0 | 0006054811 | 20200212.ifs | 2020-02-12 | 2020-02-13 | |||||||
4204245 | 4204245 | DIVIDEND | ADD | 36246K103 | 0 | 0 | 1 | 0 | .14 | 00 | 2020-03-16 | 2020-03-17 | 2020-03-24 | 2020-02-12 | 0 | 2020-02-12 | ? | 0 | 0006054811 | 20200212.ifs | 2020-02-12 | 2020-02-13 | |||||||
4016375 | 4016375 | DIVIDEND | ADD | 36246K103 | 0 | 0 | 1 | 0 | .14 | 00 | 2019-12-12 | 2019-12-13 | 2019-12-20 | 2019-11-15 | 0 | 2019-11-15 | ? | 0 | 0005975645 | 20191115.ifs | 2019-11-15 | 2019-11-16 | |||||||
4016378 | 4016378 | DIVIDEND | ADD | 36246K103 | 0 | 0 | 1 | 0 | .14 | 00 | 2019-12-12 | 2019-12-13 | 2019-12-20 | 2019-11-15 | 0 | 2019-11-15 | ? | 0 | 0005975645 | 20191115.ifs | 2019-11-15 | 2019-11-16 | |||||||
3888151 | 3888151 | DIVIDEND | ADD | 36246K103 | 0 | 0 | 1 | 0 | .14 | 00 | 2019-09-13 | 2019-09-16 | 2019-09-23 | 2019-08-22 | 0 | 2019-08-22 | ? | 0 | 0005931908 | 20190822.ifs | 2019-08-22 | 2019-08-23 | |||||||
3888196 | 3888196 | DIVIDEND | ADD | 36246K103 | 0 | 0 | 1 | 0 | .14 | 00 | 2019-09-13 | 2019-09-16 | 2019-09-23 | 2019-08-22 | 0 | 2019-08-22 | ? | 0 | 0005931908 | 20190822.ifs | 2019-08-22 | 2019-08-23 | |||||||
3730411 | 3730411 | DIVIDEND | ADD | 36246K103 | 0 | 0 | 1 | 0 | .14 | 00 | 2019-06-13 | 2019-06-14 | 2019-06-21 | 2019-05-16 | 0 | 2019-05-16 | ? | 0 | 0005884795 | 20190516.ifs | 2019-05-16 | 2019-05-17 | |||||||
3730430 | 3730430 | DIVIDEND | ADD | 36246K103 | 0 | 0 | 1 | 0 | .14 | 00 | 2019-06-13 | 2019-06-14 | 2019-06-21 | 2019-05-16 | 0 | 2019-05-16 | ? | 0 | 0005884795 | 20190516.ifs | 2019-05-16 | 2019-05-17 | |||||||
3591866 | 3591866 | DIVIDEND | ADD | 36246K103 | 0 | 0 | 1 | 0 | .14 | 00 | 2019-03-14 | 2019-03-15 | 2019-03-22 | 2019-02-22 | 0 | 2019-02-22 | ? | 0 | 0005840796 | 20190222.ifs | 2019-02-22 | 2019-02-23 | |||||||
3591867 | 3591867 | DIVIDEND | ADD | 36246K103 | 0 | 0 | 1 | 0 | .14 | 00 | 2019-03-14 | 2019-03-15 | 2019-03-22 | 2019-02-22 | 0 | 2019-02-22 | ? | 0 | 0005840796 | 20190222.ifs | 2019-02-22 | 2019-02-23 | |||||||
3373872 | 3373872 | DIVIDEND | ADD | 36246K103 | 0 | 0 | 1 | 0 | .13 | 00 | 2018-12-06 | 2018-12-07 | 2018-12-14 | 2018-11-16 | 0 | 2018-11-16 | ? | 0 | 0005755381 | 20181116.ifs | 2018-11-16 | 2018-11-17 | |||||||
3373887 | 3373887 | DIVIDEND | ADD | 36246K103 | 0 | 0 | 1 | 0 | .13 | 00 | 2018-12-06 | 2018-12-07 | 2018-12-14 | 2018-11-16 | 0 | 2018-11-16 | ? | 0 | 0005755381 | 20181116.ifs | 2018-11-16 | 2018-11-17 | |||||||
3093921 | 3093921 | DIVIDEND | ADD | 36246K103 | 0 | 0 | 1 | 0 | .13 | 00 | 2018-06-14 | 2018-06-15 | 2018-06-22 | 2018-05-17 | 0 | 2018-05-17 | ? | 0 | 0005662250 | 20180517.ifs | 2018-05-17 | 2018-05-18 | |||||||
3093930 | 3093930 | DIVIDEND | ADD | 36246K103 | 0 | 0 | 1 | 0 | .13 | 00 | 2018-06-14 | 2018-06-15 | 2018-06-22 | 2018-05-17 | 0 | 2018-05-17 | ? | 0 | 0005662250 | 20180517.ifs | 2018-05-17 | 2018-05-18 | |||||||
2962879 | 2962879 | DIVIDEND | ADD | 36246K103 | 0 | 0 | 1 | 0 | .13 | 00 | 2018-03-14 | 2018-03-15 | 2018-03-22 | 2018-02-23 | 0 | 2018-02-23 | ? | 0 | 0005617749 | 20180223.ifs | 2018-02-23 | 2018-02-24 | |||||||
2962880 | 2962880 | DIVIDEND | ADD | 36246K103 | 0 | 0 | 1 | 0 | .13 | 00 | 2018-03-14 | 2018-03-15 | 2018-03-22 | 2018-02-23 | 0 | 2018-02-23 | ? | 0 | 0005617749 | 20180223.ifs | 2018-02-23 | 2018-02-24 | |||||||
2769163 | 2769163 | DIVIDEND | ADD | 36246K103 | 0 | 0 | 1 | 0 | .13 | 00 | 2017-12-07 | 2017-12-08 | 2017-12-15 | 2017-11-17 | 0 | 2017-11-17 | ? | 0 | 0005530919 | 20171117.ifs | 2017-11-17 | 2017-11-18 | |||||||
2769845 | 2769845 | DIVIDEND | ADD | 36246K103 | 0 | 0 | 1 | 0 | .13 | 00 | 2017-12-07 | 2017-12-08 | 2017-12-15 | 2017-11-17 | 0 | 2017-11-17 | ? | 0 | 0005530919 | 20171117.ifs | 2017-11-17 | 2017-11-18 | |||||||
2654867 | 2654867 | DIVIDEND | ADD | 36246K103 | 0 | 0 | 1 | 0 | .13 | 00 | 2017-09-14 | 2017-09-15 | 2017-09-22 | 2017-08-25 | 0 | 2017-08-25 | ? | 0 | 0005485630 | 20170825.ifs | 2017-08-25 | 2017-08-26 | |||||||
2569889 | 2569889 | DIVIDEND | ADD | 36246K103 | 0 | 0 | 1 | 0 | .13 | 00 | 2017-06-14 | 2017-06-16 | 2017-06-23 | 2017-05-18 | 0 | 2017-05-18 | ? | 0 | 0005436246 | 20170518.ifs | 2017-05-18 | 2017-05-19 | |||||||
2494699 | 2494699 | DIVIDEND | ADD | 36246K103 | 0 | 0 | 1 | 0 | .13 | 00 | 2017-03-15 | 2017-03-17 | 2017-03-24 | 2017-02-23 | 0 | 2017-02-23 | ? | 0 | 0005391045 | 20170223.ifs | 2017-02-23 | 2017-02-24 | |||||||
2438690 | 2438690 | EQUITY | CHANGE | 36246K103 | SHS | 0 | 0 | 2007-06-19 | ? | 0 | no | no | no | 2007-06-29 | 2007-06-29 | ? | 20170123.ifs | 2017-01-23 | 2017-01-24 | ||||||||||
2438691 | 2438690 | EQUITY | CHANGE | 36246K103 | SHS | 0 | 0 | 2007-06-19 | ? | 4 | no | no | no | 2007-06-29 | 2007-06-29 | ? | 20170123.ifs | 2017-01-23 | 2017-01-24 | ||||||||||
2345863 | 2345863 | DIVIDEND | ADD | 36246K103 | 0 | 0 | 1 | 0 | .13 | 00 | 2016-12-07 | 2016-12-09 | 2016-12-16 | 2016-11-18 | 0 | 2016-11-18 | ? | 0 | 0005312528 | 20161118.ifs | 2016-11-18 | 2016-11-19 | |||||||
2199652 | 2199652 | DIVIDEND | ADD | 36246K103 | 0 | 0 | 1 | 0 | .13 | 00 | 2016-06-14 | 2016-06-16 | 2016-06-23 | 2016-05-19 | 0 | 2016-05-19 | ? | 0 | 0005220234 | 20160519.ifs | 2016-05-19 | 2016-05-20 | |||||||
2119290 | 2119290 | DIVIDEND | ADD | 36246K103 | 0 | 0 | 1 | 0 | .13 | 00 | 2016-03-14 | 2016-03-16 | 2016-03-23 | 2016-02-25 | 0 | 2016-02-25 | ? | 0 | 0005175862 | 20160225.ifs | 2016-02-25 | 2016-02-26 | |||||||
2012047 | 2012047 | DIVIDEND | ADD | 36246K103 | 0 | 0 | 1 | 0 | .13 | 00 | 2015-12-09 | 2015-12-11 | 2015-12-18 | 2015-11-19 | 0 | 2015-11-19 | ? | 0 | 0005094791 | 20151119.ifs | 2015-11-19 | 2015-11-20 | |||||||
1944076 | 1944076 | DIVIDEND | ADD | 36246K103 | 0 | 0 | 1 | 0 | .13 | 00 | 2015-09-14 | 2015-09-16 | 2015-09-23 | 2015-08-20 | 0 | 2015-08-20 | ? | 0 | 0005048445 | 20150820.ifs | 2015-08-20 | 2015-08-21 | |||||||
1868255 | 1868255 | DIVIDEND | ADD | 36246K103 | 0 | 0 | 1 | 0 | .13 | 00 | 2015-06-12 | 2015-06-16 | 2015-06-23 | 2015-05-21 | 0 | 2015-05-21 | ? | 0 | 0005002354 | 20150521.ifs | 2015-05-21 | 2015-05-22 | |||||||
1791646 | 1791646 | DIVIDEND | ADD | 36246K103 | 0 | 0 | 1 | 0 | .12 | 00 | 2015-03-13 | 2015-03-17 | 2015-03-24 | 2015-02-17 | 0 | 2015-02-17 | ? | 0 | 0004955266 | 20150217.ifs | 2015-02-17 | 2015-02-18 | |||||||
1697440 | 1697440 | DIVIDEND | DELETE | 36246K103 | 0 | 0 | 1 | 6 | 0 | 08 | 2014-12-10 | 2014-12-12 | 2014-12-19 | 2014-11-20 | 0 | 2014-11-20 | ? | 1 | 0004874844 | 20141202.ifs | 2014-12-02 | 2014-12-03 | |||||||
1697441 | 1697441 | DIVIDEND | ADD | 36246K103 | 0 | 0 | 1 | 0 | .14 | 00 | 2014-12-10 | 2014-12-12 | 2014-12-19 | 2014-12-02 | 1 | 2014-11-20 | 2014-12-02 | 1 | 0004874844 | 20141202.ifs | 2014-12-02 | 2014-12-03 | |||||||
1684862 | 1684862 | DIVIDEND | ADD | 36246K103 | 0 | 0 | 1 | 6 | 0 | 08 | 2014-12-10 | 2014-12-12 | 2014-12-19 | 2014-11-20 | 0 | 2014-11-20 | ? | 1 | 0004874844 | 20141120.ifs | 2014-11-20 | 2014-11-21 | |||||||
1684863 | 1684863 | DIVIDEND | ADD | 36246K103 | 0 | 0 | 1 | 0 | .12 | 00 | 2014-12-10 | 2014-12-12 | 2014-12-19 | 2014-11-20 | 0 | 2014-11-20 | ? | 0 | 0004874841 | 20141120.ifs | 2014-11-20 | 2014-11-21 | |||||||
1610788 | 1610788 | DIVIDEND | ADD | 36246K103 | 0 | 0 | 1 | 0 | .12 | 00 | 2014-09-12 | 2014-09-16 | 2014-09-23 | 2014-08-21 | 0 | 2014-08-21 | ? | 0 | 0004830561 | 20140821.ifs | 2014-08-21 | 2014-08-22 | |||||||
1451205 | 1451205 | DIVIDEND | ADD | 36246K103 | 0 | 0 | 1 | 0 | .12 | 00 | 2014-03-13 | 2014-03-17 | 2014-03-24 | 2014-02-27 | 0 | 2014-02-27 | ? | 0 | 0004739996 | 20140227.ifs | 2014-02-27 | 2014-02-28 | |||||||
1360985 | 1360985 | DIVIDEND | ADD | 36246K103 | 0 | 0 | 1 | 0 | .51 | 00 | 2013-12-11 | 2013-12-13 | 2013-12-19 | 2013-12-09 | 0 | 2013-12-09 | ? | 0 | 0004673896 | 20131209.ifs | 2013-12-09 | 2013-12-10 | |||||||
1342886 | 1342886 | DIVIDEND | ADD | 36246K103 | 0 | 0 | 1 | 0 | .1 | 00 | 2013-12-11 | 2013-12-13 | 2013-12-19 | 2013-11-20 | 0 | 2013-11-20 | ? | 0 | 0004659884 | 20131120.ifs | 2013-11-20 | 2013-11-21 | |||||||
1269405 | 1269405 | DIVIDEND | ADD | 36246K103 | 0 | 0 | 1 | 0 | .1 | 00 | 2013-09-12 | 2013-09-16 | 2013-09-23 | 2013-08-22 | 0 | 2013-08-22 | ? | 0 | 0004617024 | 20130822.ifs | 2013-08-22 | 2013-08-23 | |||||||
1188023 | 1188023 | DIVIDEND | ADD | 36246K103 | 0 | 0 | 1 | 0 | .1 | 00 | 2013-06-12 | 2013-06-14 | 2013-06-21 | 2013-05-17 | 0 | 2013-05-17 | ? | 0 | 0004571994 | 20130517.ifs | 2013-05-17 | 2013-05-18 | |||||||
1121509 | 1121509 | DIVIDEND | ADD | 36246K103 | 0 | 0 | 1 | 0 | .1 | 00 | 2013-03-12 | 2013-03-14 | 2013-03-21 | 2013-02-28 | 0 | 2013-02-28 | ? | 0 | 0004532178 | 20130228.ifs | 2013-02-28 | 2013-03-01 | |||||||
1025008 | 1025008 | DIVIDEND | ADD | 36246K103 | 0 | 0 | 1 | 0 | .81 | 00 | 2012-12-12 | 2012-12-14 | 2012-12-20 | 2012-12-03 | 0 | 2012-12-03 | ? | 0 | 0004465657 | 20121203.ifs | 2012-12-03 | 2012-12-04 | |||||||
1012086 | 1012086 | DIVIDEND | ADD | 36246K103 | 0 | 0 | 1 | 0 | .1 | 00 | 2012-12-12 | 2012-12-14 | 2012-12-20 | 2012-11-19 | 0 | 2012-11-19 | ? | 0 | 0004459135 | 20121119.ifs | 2012-11-19 | 2012-11-20 | |||||||
934271 | 934271 | DIVIDEND | ADD | 36246K103 | 0 | 0 | 1 | 0 | .1 | 00 | 2012-09-12 | 2012-09-14 | 2012-09-21 | 2012-08-16 | 0 | 2012-08-16 | ? | 0 | 0004416562 | 20120816.ifs | 2012-08-16 | 2012-08-17 | |||||||
797266 | 797266 | DIVIDEND | ADD | 36246K103 | 0 | 0 | 1 | 0 | .1 | 00 | 2012-06-13 | 2012-06-15 | 2012-06-22 | 2012-03-05 | 0 | 2012-03-05 | ? | 0 | 0004343521 | 20120305.ifs | 2012-03-05 | 2012-03-06 |
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 = 151580
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