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
5552770	5552770	DIVIDEND	ADD	29261A100		0	0	1	0	.15		00	2024-07-01	2024-07-01	2024-07-15	2024-05-02		0	2024-05-02	?	0	0006916595			20240502.ifs	2024-05-02	2024-05-03
5504444	5504444	DIVIDEND	ADD	29261A100		0	0	1	0	.15		00	2024-03-28	2024-04-01	2024-04-15	2024-02-27		0	2024-02-28	?	0	0006880151			20240228.ifs	2024-02-28	2024-02-29
5397531	5397531	DIVIDEND	ADD	29261A100		0	0	1	0	.15		00	2023-12-29	2024-01-02	2024-01-16	2023-10-19		0	2023-10-19	?	0	0006799630			20231019.ifs	2023-10-19	2023-10-20
5337575	5337575	DIVIDEND	ADD	29261A100		0	0	1	0	.15		00	2023-09-29	2023-10-02	2023-10-16	2023-07-20		0	2023-07-20	?	0	0006757163			20230720.ifs	2023-07-20	2023-07-21
5287571	5287571	DIVIDEND	ADD	29261A100		0	0	1	0	.15		00	2023-06-30	2023-07-03	2023-07-17	2023-05-04		0	2023-05-04	?	0	0006723594			20230504.ifs	2023-05-04	2023-05-05
5234256	5234256	DIVIDEND	ADD	29261A100		0	0	1	0	.15		00	2023-03-31	2023-04-03	2023-04-17	2023-02-23		0	2023-02-23	?	0	0006684775			20230223.ifs	2023-02-23	2023-02-24
5122710	5122710	DIVIDEND	ADD	29261A100		0	0	1	0	.15		00	2022-12-30	2023-01-03	2023-01-17	2022-10-19		0	2022-10-19	?	0	0006600563			20221019.ifs	2022-10-19	2022-10-20
5061038	5061038	DIVIDEND	ADD	29261A100		0	0	1	0	.15		00	2022-09-30	2022-10-03	2022-10-17	2022-07-20		0	2022-07-20	?	0	0006557241			20220720.ifs	2022-07-20	2022-07-21
5054727	5054727	SPLIT	ADD	29261A100	.7961641392	2022-07-01	20	?	2022-07-06																20220706.ifs	2022-07-06	2022-07-07
5038746	5038746	DIVIDEND	DELETE	29261A100		0	0	7	0	.5		20	2022-07-05	2022-06-24	2022-07-01	2022-06-08	29332G102	1	2022-06-14	2022-06-15	0	0006538040			20220622.ifs	2022-06-22	2022-06-23
5038747	5038747	DIVIDEND	ADD	29261A100		0	0	7	0	.5		20	2022-07-01	2022-06-24	2022-07-01	2022-06-08	29332G102	2	2022-06-14	2022-06-22	0	0006538040			20220622.ifs	2022-06-22	2022-06-23
5033707	5033707	DIVIDEND	CHANGE	29261A100		0	0	7	0	.5		20	2022-07-05	2022-06-24	2022-07-01	2022-06-08		0	2022-06-14	?	0	0006538040			20220615.ifs	2022-06-15	2022-06-16
5033708	5033707	DIVIDEND	CHANGE	29261A100		0	0	7	0	.5		20	2022-07-05	2022-06-24	2022-07-01	2022-06-08	29332G102	1	2022-06-14	2022-06-15	0	0006538040			20220615.ifs	2022-06-15	2022-06-16
5032728	5032728	DIVIDEND	ADD	29261A100		0	0	7	0	.5		20	2022-07-05	2022-06-24	2022-07-01	2022-06-08		0	2022-06-14	?	0	0006538040			20220614.ifs	2022-06-14	2022-06-15
5008738	5008738	DIVIDEND	ADD	29261A100		0	0	1	0	.28		00	2022-07-12	2022-07-13	2022-07-20	2022-05-05		0	2022-05-05	?	0	0006521927			20220505.ifs	2022-05-05	2022-05-06
4958667	4958667	DIVIDEND	ADD	29261A100		0	0	1	0	.28		00	2022-03-31	2022-04-01	2022-04-18	2022-02-25		0	2022-02-25	?	0	0006484014			20220225.ifs	2022-02-25	2022-02-26
4830080	4830080	DIVIDEND	ADD	29261A100		0	0	1	0	.28		00	2021-12-31	2022-01-03	2022-01-18	2021-10-21		0	2021-10-21	?	0	0006385024			20211021.ifs	2021-10-21	2021-10-22
4761893	4761893	DIVIDEND	ADD	29261A100		0	0	1	0	.28		00	2021-09-30	2021-10-01	2021-10-15	2021-07-20		0	2021-07-20	?	0	0006341075			20210720.ifs	2021-07-20	2021-07-21
4701153	4701153	DIVIDEND	ADD	29261A100		0	0	1	0	.28		00	2021-06-30	2021-07-01	2021-07-15	2021-05-06		0	2021-05-06	?	0	0006306135			20210506.ifs	2021-05-06	2021-05-07
4635878	4635878	DIVIDEND	ADD	29261A100		0	0	1	0	.28		00	2021-03-31	2021-04-01	2021-04-15	2021-02-24		0	2021-02-24	?	0	0006266644			20210224.ifs	2021-02-24	2021-02-25
4488484	4488484	DIVIDEND	ADD	29261A100		0	0	1	0	.28		00	2020-12-31	2021-01-04	2021-01-15	2020-10-20		0	2020-10-20	?	0	0006176069			20201020.ifs	2020-10-20	2020-10-21
4422080	4422080	DIVIDEND	ADD	29261A100		0	0	1	0	.28		00	2020-09-30	2020-10-01	2020-10-15	2020-07-21		0	2020-07-21	?	0	0006131827			20200721.ifs	2020-07-21	2020-07-22
4326622	4326622	DIVIDEND	ADD	29261A100		0	0	1	0	.28		00	2020-06-30	2020-07-01	2020-07-15	2020-05-06		0	2020-05-06	?	0	0006096931			20200506.ifs	2020-05-06	2020-05-07
4326625	4326625	DIVIDEND	ADD	29261A100		0	0	1	0	.28		00	2020-06-30	2020-07-01	2020-07-15	2020-05-06		0	2020-05-06	?	0	0006096931			20200506.ifs	2020-05-06	2020-05-07
4211170	4211170	DIVIDEND	ADD	29261A100		0	0	1	0	.28		00	2020-03-31	2020-04-01	2020-04-15	2020-02-20		0	2020-02-20	?	0	0006056683			20200220.ifs	2020-02-20	2020-02-21
4211299	4211299	DIVIDEND	ADD	29261A100		0	0	1	0	.28		00	2020-03-31	2020-04-01	2020-04-15	2020-02-20		0	2020-02-20	?	0	0006056683			20200220.ifs	2020-02-20	2020-02-21
3984536	3984536	DIVIDEND	ADD	29261A100		0	0	1	0	.28		00	2019-12-31	2020-01-02	2020-01-15	2019-10-25		0	2019-10-25	?	0	0005965033			20191025.ifs	2019-10-25	2019-10-26
3984537	3984537	DIVIDEND	ADD	29261A100		0	0	1	0	.28		00	2019-12-31	2020-01-02	2020-01-15	2019-10-25		0	2019-10-25	?	0	0005965033			20191025.ifs	2019-10-25	2019-10-26
3844818	3844818	DIVIDEND	ADD	29261A100		0	0	1	0	.28		00	2019-09-30	2019-10-01	2019-10-15	2019-07-23		0	2019-07-23	?	0	0005918542			20190723.ifs	2019-07-23	2019-07-24
3844819	3844819	DIVIDEND	ADD	29261A100		0	0	1	0	.28		00	2019-09-30	2019-10-01	2019-10-15	2019-07-23		0	2019-07-23	?	0	0005918542			20190723.ifs	2019-07-23	2019-07-24
3717479	3717479	DIVIDEND	ADD	29261A100		0	0	1	0	.27		00	2019-06-28	2019-07-01	2019-07-15	2019-05-03		0	2019-05-03	?	0	0005881453			20190503.ifs	2019-05-03	2019-05-04
3717494	3717494	DIVIDEND	ADD	29261A100		0	0	1	0	.27		00	2019-06-28	2019-07-01	2019-07-15	2019-05-03		0	2019-05-03	?	0	0005881453			20190503.ifs	2019-05-03	2019-05-04
3629138	3629138	EQUITY	CHANGE	29261A100	COM	0	0	2012-02-15	?	0	no	no		no		2017-12-28	?	?							20190315.ifs	2019-03-15	2019-03-16
3629140	3629139	EQUITY	CHANGE	29261A100	COM	0	0	2012-02-15	?	4	no	no		no		2017-12-28	?	?							20190315.ifs	2019-03-15	2019-03-16
3629143	3629143	EQUITY	CHANGE	29261A100	COM	0	0	2012-02-15	?	0	no	no		no		2017-12-28	?	?							20190315.ifs	2019-03-15	2019-03-16
3629145	3629144	EQUITY	CHANGE	29261A100	COM	0	0	2012-02-15	?	4	no	no		no		2017-12-28	?	?							20190315.ifs	2019-03-15	2019-03-16
3589798	3589798	DIVIDEND	ADD	29261A100		0	0	1	0	.27		00	2019-03-29	2019-04-01	2019-04-15	2019-02-21		0	2019-02-21	?	0	0005840237			20190221.ifs	2019-02-21	2019-02-22
3589799	3589799	DIVIDEND	ADD	29261A100		0	0	1	0	.27		00	2019-03-29	2019-04-01	2019-04-15	2019-02-21		0	2019-02-21	?	0	0005840237			20190221.ifs	2019-02-21	2019-02-22
3340914	3340914	DIVIDEND	ADD	29261A100		0	0	1	0	.27		00	2018-12-31	2019-01-02	2019-01-15	2018-10-26		0	2018-10-26	?	0	0005743933			20181026.ifs	2018-10-26	2018-10-27
3340915	3340915	DIVIDEND	ADD	29261A100		0	0	1	0	.27		00	2018-12-31	2019-01-02	2019-01-15	2018-10-26		0	2018-10-26	?	0	0005743933			20181026.ifs	2018-10-26	2018-10-27
3203740	3203740	DIVIDEND	ADD	29261A100		0	0	1	0	.27		00	2018-09-28	2018-10-01	2018-10-15	2018-07-24		0	2018-07-24	?	0	0005696281			20180724.ifs	2018-07-24	2018-07-25
3203859	3203859	DIVIDEND	ADD	29261A100		0	0	1	0	.27		00	2018-09-28	2018-10-01	2018-10-15	2018-07-24		0	2018-07-24	?	0	0005696281			20180724.ifs	2018-07-24	2018-07-25
3081231	3081231	DIVIDEND	ADD	29261A100		0	0	1	0	.25		00	2018-06-29	2018-07-02	2018-07-16	2018-05-04		0	2018-05-04	?	0	0005659016			20180504.ifs	2018-05-04	2018-05-05
3081237	3081237	DIVIDEND	ADD	29261A100		0	0	1	0	.25		00	2018-06-29	2018-07-02	2018-07-16	2018-05-04		0	2018-05-04	?	0	0005659016			20180504.ifs	2018-05-04	2018-05-05
2962941	2962941	DIVIDEND	ADD	29261A100		0	0	1	0	.25		00	2018-03-29	2018-04-02	2018-04-16	2018-02-23		0	2018-02-23	?	0	0005617734			20180223.ifs	2018-02-23	2018-02-24
2962942	2962942	DIVIDEND	ADD	29261A100		0	0	1	0	.25		00	2018-03-29	2018-04-02	2018-04-16	2018-02-23		0	2018-02-23	?	0	0005617734			20180223.ifs	2018-02-23	2018-02-24
2900090	2900090	EXCHANGE	ADD	29261A100	01	2018-01-02	2018-01-02	EHC	0	0	2018-01-02	?													20180102.ifs	2018-01-02	2018-01-03
2900303	2900303	EQUITY	CHANGE	29261A100	COM	N	0	2012-02-15	?	0	no	no		no		2017-12-28	?	?							20180102.ifs	2018-01-02	2018-01-03
2900304	2900303	EQUITY	CHANGE	29261A100	COM	0	0	2012-02-15	?	0	no	no		no		2017-12-28	?	?							20180102.ifs	2018-01-02	2018-01-03
2900469	2900469	EXCHANGE	ADD	29261A100	01	2018-01-02	2018-01-02	EHC	0	0	2018-01-02	?													20180102.ifs	2018-01-02	2018-01-03
2900670	2900670	EQUITY	CHANGE	29261A100	COM	N	0	2012-02-15	?	0	no	no		no		2017-12-28	?	?							20180102.ifs	2018-01-02	2018-01-03
2900672	2900671	EQUITY	CHANGE	29261A100	COM	0	0	2012-02-15	?	0	no	no		no		2017-12-28	?	?							20180102.ifs	2018-01-02	2018-01-03
2883587	2883587	EQUITY	ADD	29261A100	COM	N	0	2012-02-15	?	0	no	no		no		2017-12-28	?	?							20171228.ifs	2017-12-28	2017-12-29
2884363	2884363	EQUITY	ADD	29261A100	COM	N	0	2012-02-15	?	0	no	no		no		2017-12-28	?	?							20171228.ifs	2017-12-28	2017-12-29

Old 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
2900084	2900084	CORPACTION	ADD	421924309	01	Q	2018-01-02	29261A100	01	?															20180102.ifs	2018-01-02	2018-01-03
2900086	2900086	EQUITY	CHANGE	421924309	COM NEW	0	0	2006-10-26	?	4	no	no		no		?	2006-10-26	?							20180102.ifs	2018-01-02	2018-01-03
2900088	2900087	EQUITY	CHANGE	421924309	COM NEW	Q	0	2006-10-26	2018-01-02	4	no	no	29261A100	no		?	2018-01-02	?							20180102.ifs	2018-01-02	2018-01-03
2900463	2900463	CORPACTION	ADD	421924309	01	Q	2018-01-02	29261A100	01	?															20180102.ifs	2018-01-02	2018-01-03
2900465	2900465	EQUITY	CHANGE	421924309	COM NEW	0	0	2006-10-26	?	4	no	no		no		?	2006-10-26	?							20180102.ifs	2018-01-02	2018-01-03
2900467	2900466	EQUITY	CHANGE	421924309	COM NEW	Q	0	2006-10-26	2018-01-02	4	no	no	29261A100	no		?	2018-01-02	?							20180102.ifs	2018-01-02	2018-01-03
2730602	2730602	DIVIDEND	ADD	421924309		0	0	1	0	.25		00	2017-12-29	2018-01-02	2018-01-16	2017-10-20		0	2017-10-20	?	0	0005516304			20171020.ifs	2017-10-20	2017-10-21
2730614	2730614	DIVIDEND	ADD	421924309		0	0	1	0	.25		00	2017-12-29	2018-01-02	2018-01-16	2017-10-20		0	2017-10-20	?	0	0005516304			20171020.ifs	2017-10-20	2017-10-21
2627537	2627537	DIVIDEND	ADD	421924309		0	0	1	0	.25		00	2017-09-29	2017-10-02	2017-10-16	2017-07-20		0	2017-07-20	?	0	0005469555			20170720.ifs	2017-07-20	2017-07-21
2561843	2561843	DIVIDEND	ADD	421924309		0	0	1	0	.24		00	2017-06-29	2017-07-03	2017-07-17	2017-05-04		0	2017-05-04	?	0	0005433185			20170504.ifs	2017-05-04	2017-05-05
2492185	2492185	DIVIDEND	ADD	421924309		0	0	1	0	.24		00	2017-03-30	2017-04-03	2017-04-17	2017-02-17		0	2017-02-17	?	0	0005389372			20170217.ifs	2017-02-17	2017-02-18
2323903	2323903	DIVIDEND	ADD	421924309		0	0	1	0	.24		00	2016-12-29	2017-01-03	2017-01-17	2016-10-20		0	2016-10-20	?	0	0005299438			20161020.ifs	2016-10-20	2016-10-21
2254906	2254906	DIVIDEND	ADD	421924309		0	0	1	0	.24		00	2016-09-29	2016-10-03	2016-10-17	2016-07-21		0	2016-07-21	?	0	0005253031			20160721.ifs	2016-07-21	2016-07-22
2191860	2191860	DIVIDEND	ADD	421924309		0	0	1	0	.23		00	2016-06-29	2016-07-01	2016-07-15	2016-05-05		0	2016-05-05	?	0	0005217422			20160505.ifs	2016-05-05	2016-05-06
2115007	2115007	DIVIDEND	ADD	421924309		0	0	1	0	.23		00	2016-03-30	2016-04-01	2016-04-15	2016-02-18		0	2016-02-18	?	0	0005173763			20160218.ifs	2016-02-18	2016-02-19
1995892	1995892	DIVIDEND	DELETE	421924309		0	0	1	0	.23		00	2015-12-30	2016-01-02	2016-01-15	2015-10-23		0	2015-10-23	?	0	0005081888			20151026.ifs	2015-10-26	2015-10-27
1995893	1995893	DIVIDEND	ADD	421924309		0	0	1	0	.23	0	00	2015-12-29	2015-12-31	2016-01-15	2015-10-23		0	?	2015-10-26	0	0005081888			20151026.ifs	2015-10-26	2015-10-27
1996337	1996337	DIVIDEND	DELETE	421924309		0	0	1	0	.23	0	00	2015-12-29	2015-12-31	2016-01-15	2015-10-23		0	?	2015-10-26	0	0005081888			20151026.ifs	2015-10-26	2015-10-27
1996338	1996338	DIVIDEND	ADD	421924309		0	0	1	0	.23	0	00	2015-12-29	2016-01-02	2016-01-15	2015-10-23		0	?	2015-10-26	0	0005081888			20151026.ifs	2015-10-26	2015-10-27
1995672	1995672	DIVIDEND	ADD	421924309		0	0	1	0	.23		00	2015-12-30	2016-01-02	2016-01-15	2015-10-23		0	2015-10-23	?	0	0005081888			20151023.ifs	2015-10-23	2015-10-24
1917974	1917974	DIVIDEND	ADD	421924309		0	0	1	0	.23		00	2015-09-29	2015-10-01	2015-10-15	2015-07-16		0	2015-07-16	?	0	0005033511			20150716.ifs	2015-07-16	2015-07-17
1859623	1859623	DIVIDEND	ADD	421924309		0	0	1	0	.21		00	2015-06-29	2015-07-01	2015-07-15	2015-05-07		0	2015-05-07	?	0	0004998860			20150507.ifs	2015-05-07	2015-05-08
1660485	1660485	DIVIDEND	ADD	421924309		0	0	1	0	.21		00	2014-12-30	2015-01-02	2015-01-15	2014-10-21		0	2014-10-21	?	0	0004860778			20141021.ifs	2014-10-21	2014-10-22
1581982	1581982	DIVIDEND	ADD	421924309		0	0	1	0	.21		00	2014-09-29	2014-10-01	2014-10-15	2014-07-17		0	2014-07-17	?	0	0004815542			20140717.ifs	2014-07-17	2014-07-18
1513597	1513597	DIVIDEND	ADD	421924309		0	0	1	0	.18		00	2014-06-27	2014-07-01	2014-07-15	2014-05-01		0	2014-05-01	?	0	0004776256			20140501.ifs	2014-05-01	2014-05-02
1444219	1444219	DIVIDEND	ADD	421924309		0	0	1	0	.18		00	2014-03-28	2014-04-01	2014-04-15	2014-02-14		0	2014-02-14	?	0	0004736598			20140214.ifs	2014-02-14	2014-02-15
1323329	1323329	DIVIDEND	ADD	421924309		0	0	1	0	.18		00	2013-12-30	2014-01-02	2014-01-15	2013-10-25		0	2013-10-25	?	0	0004647745			20131025.ifs	2013-10-25	2013-10-26
1246829	1246829	DIVIDEND	ADD	421924309		0	0	1	0	.18		35	2013-09-27	2013-10-01	2013-10-15	2013-07-25		0	2013-07-25	?	0	0004604618			20130725.ifs	2013-07-25	2013-07-26

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 = 130750
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