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
5555613	5555613	DIVIDEND	ADD	020936100		A	0	2	0	.09		15	2024-05-31	2024-05-31	2024-06-14	2024-05-08		0	2024-05-08	?	0	0006918179			20240508.ifs	2024-05-08	2024-05-09
5514904	5514904	DIVIDEND	ADD	020936100		A	0	2	0	.08		15	2024-03-15	2024-03-18	2024-04-01	2024-03-11		0	2024-03-11	?	0	0006888939			20240311.ifs	2024-03-11	2024-03-12
5412393	5412393	DIVIDEND	ADD	020936100		A	0	2	0	.08		15	2023-11-29	2023-11-30	2023-12-15	2023-11-08		0	2023-11-08	?	0	0006810851			20231108.ifs	2023-11-08	2023-11-09
5353163	5353163	DIVIDEND	ADD	020936100		A	0	2	0	.08		15	2023-08-30	2023-08-31	2023-09-15	2023-08-09		0	2023-08-10	?	0	0006768867			20230810.ifs	2023-08-10	2023-08-11
5289535	5289535	DIVIDEND	ADD	020936100		A	0	2	0	.08		15	2023-06-14	2023-06-15	2023-06-30	2023-05-09		0	2023-05-10	?	0	0006724592			20230510.ifs	2023-05-10	2023-05-11
5247374	5247374	DIVIDEND	ADD	020936100		A	0	2	0	.08		15	2023-03-16	2023-03-17	2023-03-31	2023-03-09		0	2023-03-10	?	0	0006694631			20230310.ifs	2023-03-10	2023-03-11
5138205	5138205	DIVIDEND	ADD	020936100		A	0	2	0	.08		15	2022-11-29	2022-11-30	2022-12-15	2022-11-09		0	2022-11-09	?	0	0006611988			20221109.ifs	2022-11-09	2022-11-10
5076055	5076055	DIVIDEND	ADD	020936100		A	0	2	0	.08		15	2022-08-30	2022-08-31	2022-09-15	2022-08-08		0	2022-08-08	?	0	0006568762			20220808.ifs	2022-08-08	2022-08-09
5012745	5012745	DIVIDEND	ADD	020936100		A	0	2	0	.07		15	2022-06-14	2022-06-15	2022-06-30	2022-05-13		0	2022-05-16	?	0	0006524287			20220516.ifs	2022-05-16	2022-05-17
4970410	4970410	DIVIDEND	ADD	020936100		A	0	2	0	.07		15	2022-03-17	2022-03-18	2022-03-31	2022-03-10		0	2022-03-11	?	0	0006493430			20220311.ifs	2022-03-11	2022-03-12
4846618	4846618	DIVIDEND	ADD	020936100		A	0	2	0	.07		15	2021-11-29	2021-11-30	2021-12-15	2021-11-10		0	2021-11-10	?	0	0006396039			20211110.ifs	2021-11-10	2021-11-11
4779563	4779563	DIVIDEND	ADD	020936100		A	0	2	0	.07		15	2021-08-30	2021-08-31	2021-09-15	2021-08-09		0	2021-08-09	?	0	0006353023			20210809.ifs	2021-08-09	2021-08-10
4705187	4705187	DIVIDEND	ADD	020936100		A	0	2	0	.05		15	2021-05-28	2021-05-31	2021-06-15	2021-05-12		0	2021-05-13	?	0	0006307787			20210513.ifs	2021-05-13	2021-05-14
4652535	4652535	DIVIDEND	ADD	020936100		A	0	2	0	.05		15	2021-03-18	2021-03-19	2021-03-31	2021-03-05		0	2021-03-12	?	0	0006276960			20210312.ifs	2021-03-12	2021-03-13
4510282	4510282	DIVIDEND	ADD	020936100		A	0	2	0	.05		15	2020-11-27	2020-11-30	2020-12-15	2020-11-18		0	2020-11-19	?	0	0006189204			20201119.ifs	2020-11-19	2020-11-20
4443706	4443706	DIVIDEND	CHANGE	020936100		A	0	2	0	.05		15	2020-08-28	2020-08-31	2020-09-15	2020-08-06		0	2020-08-10	?	0	0006143416			20200820.ifs	2020-08-20	2020-08-21
4443707	4443706	DIVIDEND	CHANGE	020936100		A	0	2	0	.05		15	2020-08-28	2020-08-31	2020-09-15	2020-08-06		1	2020-08-10	2020-08-20	0	0006143416			20200820.ifs	2020-08-20	2020-08-21
4438393	4438393	DIVIDEND	ADD	020936100		A	0	2	0	.05		15	2020-08-28	2020-08-31	2020-09-15	2020-08-06		0	2020-08-10	?	0	0006143416			20200810.ifs	2020-08-10	2020-08-11
4344085	4344085	DIVIDEND	ADD	020936100		A	0	2	0	.05		15	2020-05-28	2020-05-29	2020-06-15	2020-05-19		0	2020-05-20	?	0	0006100248			20200520.ifs	2020-05-20	2020-05-21
4344281	4344281	DIVIDEND	ADD	020936100		A	0	2	0	.05		15	2020-05-28	2020-05-29	2020-06-15	2020-05-19		0	2020-05-20	?	0	0006100248			20200520.ifs	2020-05-20	2020-05-21
4240189	4240189	DIVIDEND	ADD	020936100		A	0	2	0	.05		15	2020-03-20	2020-03-23	2020-03-30	2020-03-12		0	2020-03-13	?	0	0006068662			20200313.ifs	2020-03-13	2020-03-14
4240190	4240190	DIVIDEND	ADD	020936100		A	0	2	0	.05		15	2020-03-20	2020-03-23	2020-03-30	2020-03-12		0	2020-03-13	?	0	0006068662			20200313.ifs	2020-03-13	2020-03-14
4009493	4009493	DIVIDEND	ADD	020936100		A	0	2	0	.05		15	2019-12-04	2019-12-05	2019-12-20	2019-11-07		0	2019-11-07	?	0	0005974303			20191107.ifs	2019-11-07	2019-11-08
4009662	4009662	DIVIDEND	ADD	020936100		A	0	2	0	.05		15	2019-12-04	2019-12-05	2019-12-20	2019-11-07		0	2019-11-07	?	0	0005974303			20191107.ifs	2019-11-07	2019-11-08
3881974	3881974	DIVIDEND	ADD	020936100		A	0	2	0	.05		15	2019-09-05	2019-09-06	2019-09-20	2019-08-15		0	2019-08-16	?	0	0005930800			20190816.ifs	2019-08-16	2019-08-17
3881975	3881975	DIVIDEND	ADD	020936100		A	0	2	0	.05		15	2019-09-05	2019-09-06	2019-09-20	2019-08-15		0	2019-08-16	?	0	0005930800			20190816.ifs	2019-08-16	2019-08-17
3763551	3763551	DIVIDEND	ADD	020936100		A	0	2	0	.05		15	2019-06-05	2019-06-06	2019-06-20	2019-05-31		0	2019-06-03	?	0	0005890693			20190603.ifs	2019-06-03	2019-06-04
3763774	3763774	DIVIDEND	ADD	020936100		A	0	2	0	.05		15	2019-06-05	2019-06-06	2019-06-20	2019-05-31		0	2019-06-03	?	0	0005890693			20190603.ifs	2019-06-03	2019-06-04
3639128	3639128	DIVIDEND	ADD	020936100		A	0	2	0	.04		15	2019-03-21	2019-03-22	2019-03-29	2019-03-18		0	2019-03-19	?	0	0005854021			20190319.ifs	2019-03-19	2019-03-20
3639138	3639138	DIVIDEND	ADD	020936100		A	0	2	0	.04		15	2019-03-21	2019-03-22	2019-03-29	2019-03-18		0	2019-03-19	?	0	0005854021			20190319.ifs	2019-03-19	2019-03-20
3379898	3379898	DIVIDEND	ADD	020936100		A	0	2	0	.04		15	2018-12-05	2018-12-06	2018-12-20	2018-11-21		0	2018-11-23	?	0	0005757177			20181123.ifs	2018-11-23	2018-11-24
3379901	3379901	DIVIDEND	ADD	020936100		A	0	2	0	.04		15	2018-12-05	2018-12-06	2018-12-20	2018-11-21		0	2018-11-23	?	0	0005757177			20181123.ifs	2018-11-23	2018-11-24
3234017	3234017	DIVIDEND	ADD	020936100		A	0	2	0	.04		15	2018-09-05	2018-09-06	2018-09-20	2018-08-08		0	2018-08-08	?	0	0005707100			20180808.ifs	2018-08-08	2018-08-09
3234037	3234037	DIVIDEND	ADD	020936100		A	0	2	0	.04		15	2018-09-05	2018-09-06	2018-09-20	2018-08-08		0	2018-08-08	?	0	0005707100			20180808.ifs	2018-08-08	2018-08-09
3107954	3107954	DIVIDEND	ADD	020936100		A	0	2	0	.04		15	2018-06-05	2018-06-06	2018-06-20	2018-05-29		0	2018-05-30	?	0	0005664851			20180530.ifs	2018-05-30	2018-05-31
3107957	3107957	DIVIDEND	ADD	020936100		A	0	2	0	.04		15	2018-06-05	2018-06-06	2018-06-20	2018-05-29		0	2018-05-30	?	0	0005664851			20180530.ifs	2018-05-30	2018-05-31
2995684	2995684	DIVIDEND	ADD	020936100		A	0	2	0	.04		15	2018-03-21	2018-03-22	2018-03-29	2018-03-15		0	2018-03-16	?	0	0005630184			20180316.ifs	2018-03-16	2018-03-17
2995687	2995687	DIVIDEND	ADD	020936100		A	0	2	0	.04		15	2018-03-21	2018-03-22	2018-03-29	2018-03-15		0	2018-03-16	?	0	0005630184			20180316.ifs	2018-03-16	2018-03-17
2823673	2823673	DIVIDEND	ADD	020936100		A	0	2	0	.04		15	2018-01-04	2018-01-05	2018-01-19	2017-12-12		0	2017-12-12	?	0	0005549349			20171212.ifs	2017-12-12	2017-12-13
2671426	2671426	DIVIDEND	ADD	020936100		A	0	2	0	.03		15	2017-10-05	2017-10-06	2017-10-20	2017-09-14		0	2017-09-14	?	0	0005497179			20170914.ifs	2017-09-14	2017-09-15
2671793	2671793	DIVIDEND	ADD	020936100		A	0	2	0	.03		15	2017-10-05	2017-10-06	2017-10-20	2017-09-14		0	2017-09-14	?	0	0005497179			20170914.ifs	2017-09-14	2017-09-15
2600446	2600446	DIVIDEND	DELETE	020936100		A	0	2	0	.03		15	2017-07-03	2017-07-06	2017-07-20	2017-06-21		0	2017-06-21	?	0	0005452885			20170623.ifs	2017-06-23	2017-06-24
2600447	2600447	DIVIDEND	ADD	020936100		A	0	2	0	.03		15	2017-07-04	2017-07-06	2017-07-20	2017-06-21		1	2017-06-21	2017-06-23	0	0005452885			20170623.ifs	2017-06-23	2017-06-24
2597877	2597877	DIVIDEND	ADD	020936100		A	0	2	0	.03		15	2017-07-03	2017-07-06	2017-07-20	2017-06-21		0	2017-06-21	?	0	0005452885			20170621.ifs	2017-06-21	2017-06-22
2513279	2513279	DIVIDEND	ADD	020936100		A	0	2	0	.03		15	2017-04-04	2017-04-06	2017-04-20	2017-03-15		0	2017-03-15	?	0	0005402744			20170315.ifs	2017-03-15	2017-03-16
2433948	2433948	EQUITY	CHANGE	020936100	COM	0	0	1997-10-31	?	0	no	no		no		2002-07-02	1997-11-03	?							20170123.ifs	2017-01-23	2017-01-24
2433949	2433948	EQUITY	CHANGE	020936100	COM	0	0	1997-10-31	?	4	no	no		no		2002-07-02	1997-11-03	?							20170123.ifs	2017-01-23	2017-01-24
2374616	2374616	DIVIDEND	ADD	020936100		A	0	2	0	.03		15	2017-01-04	2017-01-06	2017-01-20	2016-12-14		0	2016-12-14	?	0	0005333409			20161214.ifs	2016-12-14	2016-12-15
2293164	2293164	DIVIDEND	ADD	020936100		A	0	2	0	.03		15	2016-10-04	2016-10-06	2016-10-20	2016-09-13		0	2016-09-14	?	0	0005279813			20160914.ifs	2016-09-14	2016-09-15
2239968	2239968	DIVIDEND	DELETE	020936100		A	0	2	0	.03		15	2016-07-01	2016-07-06	2016-07-20	2016-06-23		0	2016-06-23	?	0	0005237341			20160630.ifs	2016-06-30	2016-07-01
2239969	2239969	DIVIDEND	ADD	020936100		A	0	2	0	.03		15	2016-07-04	2016-07-06	2016-07-20	2016-06-23		1	2016-06-23	2016-06-30	0	0005237341			20160630.ifs	2016-06-30	2016-07-01
2229443	2229443	DIVIDEND	ADD	020936100		A	0	2	0	.03		15	2016-07-01	2016-07-06	2016-07-20	2016-06-23		0	2016-06-23	?	0	0005237341			20160623.ifs	2016-06-23	2016-06-24
2141032	2141032	DIVIDEND	ADD	020936100		A	0	2	0	.03		15	2016-04-04	2016-04-06	2016-04-20	2016-03-21		0	2016-03-22	?	0	0005190151			20160322.ifs	2016-03-22	2016-03-23
2050046	2050046	DIVIDEND	ADD	020936100		A	0	2	0	.03		15	2016-01-04	2016-01-06	2016-01-20	2015-12-17		0	2015-12-17	?	0	0005123312			20151217.ifs	2015-12-17	2015-12-18
1968443	1968443	DIVIDEND	ADD	020936100		A	0	2	0	.03		15	2015-10-02	2015-10-06	2015-10-20	2015-09-17		0	2015-09-17	?	0	0005063917			20150917.ifs	2015-09-17	2015-09-18
1908879	1908879	DIVIDEND	CHANGE	020936100		A	0	2	0	.03		15	2015-07-02	2015-07-06	2015-07-20	2015-06-25		1	2015-06-25	2015-06-26	0	0005020133			20150701.ifs	2015-07-01	2015-07-02
1908880	1908879	DIVIDEND	CHANGE	020936100		A	0	2	0	.03		15	2015-07-02	2015-07-06	2015-07-20	2015-06-25		2	2015-06-25	2015-07-01	0	0005020133			20150701.ifs	2015-07-01	2015-07-02
1897433	1897433	DIVIDEND	CHANGE	020936100		A	0	2	0	.02		15	2015-07-02	2015-07-06	2015-07-20	2015-06-25		0	2015-06-25	?	0	0005020133			20150626.ifs	2015-06-26	2015-06-27
1897434	1897433	DIVIDEND	CHANGE	020936100		A	0	2	0	.03		15	2015-07-02	2015-07-06	2015-07-20	2015-06-25		1	2015-06-25	2015-06-26	0	0005020133			20150626.ifs	2015-06-26	2015-06-27
1895919	1895919	DIVIDEND	ADD	020936100		A	0	2	0	.02		15	2015-07-02	2015-07-06	2015-07-20	2015-06-25		0	2015-06-25	?	0	0005020133			20150625.ifs	2015-06-25	2015-06-26
1824813	1824813	DIVIDEND	DELETE	020936100		A	0	2	4	.02		15	2015-04-01	2015-04-06	2015-04-20	2015-03-26		0	2015-03-26	?	0	0004973754			20150330.ifs	2015-03-30	2015-03-31
1824814	1824814	DIVIDEND	ADD	020936100		A	0	2	4	.02		15	2015-04-02	2015-04-07	2015-04-20	2015-03-26		1	2015-03-26	2015-03-30	0	0004973754			20150330.ifs	2015-03-30	2015-03-31
1821966	1821966	DIVIDEND	ADD	020936100		A	0	2	4	.02		15	2015-04-01	2015-04-06	2015-04-20	2015-03-26		0	2015-03-26	?	0	0004973754			20150326.ifs	2015-03-26	2015-03-27

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

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