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
5578002	5578002	DIVIDEND	ADD	902973866		0	0	1	0	16.70904		00	2024-06-28	2024-06-28	2024-07-15	2024-06-18		0	2024-06-18	?	0	0006934208			20240618.ifs	2024-06-18	2024-06-19
5515156	5515156	DIVIDEND	ADD	902973866		0	0	1	0	16.67221		00	2024-03-27	2024-03-29	2024-04-15	2024-03-12		0	2024-03-12	?	0	0006889138			20240312.ifs	2024-03-12	2024-03-13
5435902	5435902	DIVIDEND	ADD	902973866		0	0	1	0	17.05956		00	2023-12-28	2023-12-29	2024-01-16	2023-12-12		0	2023-12-12	?	0	0006828212			20231212.ifs	2023-12-12	2023-12-13
5371816	5371816	DIVIDEND	ADD	902973866		0	0	1	0	16.84		00	2023-09-28	2023-09-29	2023-10-16	2023-09-12		0	2023-09-12	?	0	0006782179			20230912.ifs	2023-09-12	2023-09-13
5310597	5310597	DIVIDEND	ADD	902973866		0	0	1	0	15.8752		00	2023-06-29	2023-06-30	2023-07-17	2023-06-13		0	2023-06-13	?	0	0006738482			20230613.ifs	2023-06-13	2023-06-14
5248117	5248117	DIVIDEND	ADD	902973866		0	0	1	0	14.62428		00	2023-03-30	2023-03-31	2023-04-17	2023-03-14		0	2023-03-14	?	0	0006695286			20230314.ifs	2023-03-14	2023-03-15
5163516	5163516	DIVIDEND	ADD	902973866		0	0	1	0	13.03114		00	2022-12-29	2022-12-30	2023-01-17	2022-12-13		0	2022-12-13	?	0	0006631299			20221213.ifs	2022-12-13	2022-12-14
5095791	5095791	DIVIDEND	ADD	902973866		0	0	1	0	9.02622		00	2022-09-29	2022-09-30	2022-10-17	2022-09-13		0	2022-09-13	?	0	0006583001			20220913.ifs	2022-09-13	2022-09-14
5032579	5032579	DIVIDEND	ADD	902973866		0	0	1	0	8.84722		00	2022-06-29	2022-06-30	2022-07-15	2022-06-14		0	2022-06-14	?	0	0006538032			20220614.ifs	2022-06-14	2022-06-15
4971204	4971204	DIVIDEND	ADD	902973866		0	0	1	0	8.75		00	2022-03-30	2022-03-31	2022-04-15	2022-03-15		0	2022-03-15	?	0	0006494682			20220315.ifs	2022-03-15	2022-03-16
4902521	4902521	DIVIDEND	ADD	902973866		0	0	1	0	8.94444		00	2021-12-30	2021-12-31	2022-01-18	2021-12-21		0	2021-12-21	?	0	0006439141			20211221.ifs	2021-12-21	2021-12-22
4801395	4801395	DIVIDEND	ADD	902973866		0	0	1	0	8.94444		00	2021-09-29	2021-09-30	2021-10-15	2021-09-14		0	2021-09-14	?	0	0006367287			20210914.ifs	2021-09-14	2021-09-15
4729591	4729591	DIVIDEND	ADD	902973866		0	0	1	0	8.84722		00	2021-06-29	2021-06-30	2021-07-15	2021-06-15		0	2021-06-15	?	0	0006322288			20210615.ifs	2021-06-15	2021-06-16
4653930	4653930	DIVIDEND	ADD	902973866		0	0	1	0	8.75		00	2021-03-30	2021-03-31	2021-04-15	2021-03-16		0	2021-03-16	?	0	0006277922			20210316.ifs	2021-03-16	2021-03-17
4530709	4530709	DIVIDEND	ADD	902973866		0	0	1	0	8.94444		00	2020-12-30	2020-12-31	2021-01-15	2020-12-08		0	2020-12-08	?	0	0006202669			20201208.ifs	2020-12-08	2020-12-09
4462142	4462142	DIVIDEND	ADD	902973866		0	0	1	0	8.94444		00	2020-09-29	2020-09-30	2020-10-15	2020-09-15		0	2020-09-15	?	0	0006159064			20200915.ifs	2020-09-15	2020-09-16
4392688	4392688	DIVIDEND	ADD	902973866		0	0	1	0	8.84722		00	2020-06-29	2020-06-30	2020-07-15	2020-06-16		0	2020-06-16	?	0	0006113311			20200616.ifs	2020-06-16	2020-06-17
4080117	4080117	DIVIDEND	ADD	902973866		0	0	1	0	8.94444		00	2019-12-30	2019-12-31	2020-01-15	2019-12-17		0	2019-12-17	?	0	0006004610			20191217.ifs	2019-12-17	2019-12-18
4080352	4080352	DIVIDEND	ADD	902973866		0	0	1	0	8.94444		00	2019-12-30	2019-12-31	2020-01-15	2019-12-17		0	2019-12-17	?	0	0006004610			20191217.ifs	2019-12-17	2019-12-18
3924676	3924676	DIVIDEND	ADD	902973866		0	0	1	0	8.94444		00	2019-09-27	2019-09-30	2019-10-15	2019-09-17		0	2019-09-17	?	0	0005946000			20190917.ifs	2019-09-17	2019-09-18
3924681	3924681	DIVIDEND	ADD	902973866		0	0	1	0	8.94444		00	2019-09-27	2019-09-30	2019-10-15	2019-09-17		0	2019-09-17	?	0	0005946000			20190917.ifs	2019-09-17	2019-09-18
3785346	3785346	DIVIDEND	ADD	902973866		0	0	1	0	9.14234		00	2019-06-27	2019-06-28	2019-07-15	2019-06-18		0	2019-06-18	?	0	0005899617			20190618.ifs	2019-06-18	2019-06-19
3785356	3785356	DIVIDEND	ADD	902973866		0	0	1	0	9.14234		00	2019-06-27	2019-06-28	2019-07-15	2019-06-18		0	2019-06-18	?	0	0005899617			20190618.ifs	2019-06-18	2019-06-19
3637091	3637091	DIVIDEND	ADD	902973866		0	0	1	0	9.51828		00	2019-03-28	2019-03-29	2019-04-15	2019-03-19		0	2019-03-19	?	0	0005854069			20190319.ifs	2019-03-19	2019-03-20
3637094	3637094	DIVIDEND	ADD	902973866		0	0	1	0	9.51828		00	2019-03-28	2019-03-29	2019-04-15	2019-03-19		0	2019-03-19	?	0	0005854069			20190319.ifs	2019-03-19	2019-03-20
3457113	3457113	DIVIDEND	ADD	902973866		0	0	1	0	8.94444		00	2018-12-28	2018-12-31	2019-01-15	2018-12-18		0	2018-12-18	?	0	0005786929			20181218.ifs	2018-12-18	2018-12-19
3457114	3457114	DIVIDEND	ADD	902973866		0	0	1	0	8.94444		00	2018-12-28	2018-12-31	2019-01-15	2018-12-18		0	2018-12-18	?	0	0005786929			20181218.ifs	2018-12-18	2018-12-19
3287870	3287870	DIVIDEND	ADD	902973866		0	0	1	0	8.94444		00	2018-09-27	2018-09-28	2018-10-15	2018-09-18		0	2018-09-18	?	0	0005724746			20180918.ifs	2018-09-18	2018-09-19
3287871	3287871	DIVIDEND	ADD	902973866		0	0	1	0	8.94444		00	2018-09-27	2018-09-28	2018-10-15	2018-09-18		0	2018-09-18	?	0	0005724746			20180918.ifs	2018-09-18	2018-09-19
3145480	3145480	DIVIDEND	ADD	902973866		0	0	1	0	8.84722		00	2018-06-28	2018-06-29	2018-07-16	2018-06-19		0	2018-06-19	?	0	0005676737			20180619.ifs	2018-06-19	2018-06-20
3145513	3145513	DIVIDEND	ADD	902973866		0	0	1	0	8.84722		00	2018-06-28	2018-06-29	2018-07-16	2018-06-19		0	2018-06-19	?	0	0005676737			20180619.ifs	2018-06-19	2018-06-20
2996554	2996554	DIVIDEND	ADD	902973866		0	0	1	0	8.75		00	2018-03-28	2018-03-29	2018-04-16	2018-03-19		0	2018-03-19	?	0	0005630723			20180319.ifs	2018-03-19	2018-03-20
2996561	2996561	DIVIDEND	ADD	902973866		0	0	1	0	8.75		00	2018-03-28	2018-03-29	2018-04-16	2018-03-19		0	2018-03-19	?	0	0005630723			20180319.ifs	2018-03-19	2018-03-20
2841732	2841732	DIVIDEND	ADD	902973866		0	0	1	0	8.94444		00	2017-12-28	2017-12-29	2018-01-16	2017-12-19		0	2017-12-19	?	0	0005564757			20171219.ifs	2017-12-19	2017-12-20
2841852	2841852	DIVIDEND	ADD	902973866		0	0	1	0	8.94444		00	2017-12-28	2017-12-29	2018-01-16	2017-12-19		0	2017-12-19	?	0	0005564757			20171219.ifs	2017-12-19	2017-12-20
2677128	2677128	DIVIDEND	ADD	902973866		0	0	1	0	8.94444		00	2017-09-28	2017-09-29	2017-10-16	2017-09-19		0	2017-09-19	?	0	0005499002			20170919.ifs	2017-09-19	2017-09-20
2677640	2677640	DIVIDEND	ADD	902973866		0	0	1	0	8.94444		00	2017-09-28	2017-09-29	2017-10-16	2017-09-19		0	2017-09-19	?	0	0005499002			20170919.ifs	2017-09-19	2017-09-20
2595687	2595687	DIVIDEND	ADD	902973866		0	0	1	0	8.84722		00	2017-06-28	2017-06-30	2017-07-17	2017-06-20		0	2017-06-20	?	0	0005451519			20170620.ifs	2017-06-20	2017-06-21
2517103	2517103	DIVIDEND	ADD	902973866		0	0	1	0	8.75		00	2017-03-29	2017-03-31	2017-04-17	2017-03-21		0	2017-03-21	?	0	0005404901			20170321.ifs	2017-03-21	2017-03-22
2446590	2446590	EQUITY	CHANGE	902973866	DEP SHS REPSTG 1/100TH PERP PFD SER A	0	1	2010-06-11	?	0	no	no		no		2010-06-11	2010-07-28	?							20170123.ifs	2017-01-23	2017-01-24
2446591	2446590	EQUITY	CHANGE	902973866	DEP SHS REPSTG 1/100TH PERP PFD SER A	0	1	2010-06-11	?	4	no	no		no		2010-06-11	2010-07-28	?							20170123.ifs	2017-01-23	2017-01-24
2383221	2383221	DIVIDEND	ADD	902973866		0	0	1	0	8.94444		00	2016-12-28	2016-12-30	2017-01-17	2016-12-19		0	2016-12-19	?	0	0005341493			20161219.ifs	2016-12-19	2016-12-20
2296895	2296895	DIVIDEND	ADD	902973866		0	0	1	0	8.94444		00	2016-09-28	2016-09-30	2016-10-17	2016-09-19		0	2016-09-19	?	0	0005282337			20160919.ifs	2016-09-19	2016-09-20
2220906	2220906	DIVIDEND	ADD	902973866		0	0	1	0	8.84772		00	2016-06-28	2016-06-30	2016-07-15	2016-06-15		0	2016-06-15	?	0	0005232649			20160615.ifs	2016-06-15	2016-06-16
2135210	2135210	DIVIDEND	ADD	902973866		0	0	1	0	8.84772		00	2016-03-29	2016-03-31	2016-04-15	2016-03-15		0	2016-03-15	?	0	0005186744			20160315.ifs	2016-03-15	2016-03-16
2039248	2039248	DIVIDEND	ADD	902973866		0	0	1	0	8.94444		00	2015-12-29	2015-12-31	2016-01-15	2015-12-15		0	2015-12-15	?	0	0005118052			20151215.ifs	2015-12-15	2015-12-16
1965738	1965738	DIVIDEND	ADD	902973866		0	0	1	0	8.94444		00	2015-09-28	2015-09-30	2015-10-15	2015-09-15		0	2015-09-15	?	0	0005062417			20150915.ifs	2015-09-15	2015-09-16
1887145	1887145	DIVIDEND	ADD	902973866		0	0	1	0	8.84722		00	2015-06-26	2015-06-30	2015-07-15	2015-06-16		0	2015-06-16	?	0	0005014008			20150616.ifs	2015-06-16	2015-06-17
1803960	1803960	DIVIDEND	ADD	902973866		0	0	1	0	8.75		00	2015-03-27	2015-03-31	2015-04-15	2015-03-03		0	2015-03-03	?	0	0004965309			20150303.ifs	2015-03-03	2015-03-04
1703969	1703969	DIVIDEND	ADD	902973866		0	0	1	0	8.94444		00	2014-12-29	2014-12-31	2015-01-15	2014-12-09		0	2014-12-09	?	0	0004887877			20141209.ifs	2014-12-09	2014-12-10
1630962	1630962	DIVIDEND	ADD	902973866		0	0	1	0	8.94444		00	2014-09-26	2014-09-30	2014-10-15	2014-09-16		0	2014-09-16	?	0	0004843309			20140916.ifs	2014-09-16	2014-09-17
1551307	1551307	DIVIDEND	ADD	902973866		0	0	1	0	8.84722		00	2014-06-26	2014-06-30	2014-07-15	2014-06-17		0	2014-06-17	?	0	0004797111			20140617.ifs	2014-06-17	2014-06-18
1464814	1464814	DIVIDEND	ADD	902973866		0	0	1	0	8.75		00	2014-03-27	2014-03-31	2014-04-15	2014-03-12		0	2014-03-12	?	0	0004749729			20140312.ifs	2014-03-12	2014-03-13
1361736	1361736	DIVIDEND	ADD	902973866		0	0	1	0	8.94444		00	2013-12-27	2013-12-31	2014-01-15	2013-12-10		0	2013-12-10	?	0	0004674854			20131210.ifs	2013-12-10	2013-12-11
1289148	1289148	DIVIDEND	ADD	902973866		0	0	1	0	8.94444		00	2013-09-26	2013-09-30	2013-10-15	2013-09-17		0	2013-09-17	?	0	0004629734			20130917.ifs	2013-09-17	2013-09-18
1211653	1211653	DIVIDEND	ADD	902973866		0	0	1	0	8.84722		00	2013-06-26	2013-06-28	2013-07-15	2013-06-18		0	2013-06-18	?	0	0004584815			20130618.ifs	2013-06-18	2013-06-19
1132902	1132902	DIVIDEND	ADD	902973866		0	0	1	0	8.75		00	2013-03-26	2013-03-28	2013-04-15	2013-03-14		0	2013-03-14	?	0	0004541462			20130314.ifs	2013-03-14	2013-03-15
1035231	1035231	DIVIDEND	ADD	902973866		0	0	1	0	8.94444		00	2012-12-27	2012-12-31	2013-01-15	2012-12-11		0	2012-12-11	?	0	0004474828			20121211.ifs	2012-12-11	2012-12-12
958246	958246	DIVIDEND	ADD	902973866		0	0	1	0	8.94444		00	2012-09-26	2012-09-28	2012-10-15	2012-09-18		0	2012-09-18	?	0	0004430150			20120918.ifs	2012-09-18	2012-09-19
888126	888126	DIVIDEND	ADD	902973866		0	0	1	0	8.84722		00	2012-06-27	2012-06-29	2012-07-16	2012-06-19		0	2012-06-19	?	0	0004387792			20120619.ifs	2012-06-19	2012-06-20
802001	802001	DIVIDEND	ADD	902973866		0	0	1	0	8.84722		00	2012-03-28	2012-03-30	2012-04-16	2012-03-13		0	2012-03-14	?	0	0004345464			20120314.ifs	2012-03-14	2012-03-15
720307	720307	DIVIDEND	ADD	902973866		0	0	1	0	8.9444		00	2011-12-28	2011-12-30	2012-01-17	2011-12-13		0	2011-12-13	?	0	0004286820			20111213.ifs	2011-12-13	2011-12-14
647870	647870	DIVIDEND	ADD	902973866		0	0	1	0	8.9444		00	2011-09-28	2011-09-30	2011-10-17	2011-09-20		0	2011-09-20	?	0	0004244034			20110920.ifs	2011-09-20	2011-09-21
565453	565453	DIVIDEND	ADD	902973866		0	0	1	0	8.84722		00	2011-06-28	2011-06-30	2011-07-15	2011-06-21		0	2011-06-21	?	0	0004203456			20110621.ifs	2011-06-21	2011-06-22
474593	474593	DIVIDEND	ADD	902973866		0	0	1	0	35.945		00	2011-03-29	2011-03-31	2011-04-15	2011-03-18		0	2011-03-18	?	0	0004161021			20110318.ifs	2011-03-18	2011-03-19
311875	311875	DIVIDEND	ADD	902973866		0	0	1	4	24.9618		00	2010-09-28	2010-09-30	2010-10-15	2010-09-21		0	2010-09-21	?	0	0004062424			20100921.ifs	2010-09-21	2010-09-22
260563	260563	CORPACTION	DELETE	902973866	01	D	2010-07-13			2010-07-15															20100728.ifs	2010-07-28	2010-07-29
260564	260564	EQUITY	CHANGE	902973866	DEP SHS REPSTG 1/100TH PERP PFD SER A	D	1	2010-06-11	2010-07-13	0	no	no		no		2010-06-11	2010-07-15	?							20100728.ifs	2010-07-28	2010-07-29
260565	260564	EQUITY	CHANGE	902973866	DEP SHS REPSTG 1/100TH PERP PFD SER A	0	1	2010-06-11	?	0	no	no		no		2010-06-11	2010-07-28	?							20100728.ifs	2010-07-28	2010-07-29
252215	252215	EXCHANGE	CHANGE	902973866	01	2010-06-11	2010-07-14	USB_PA	0	1	2010-06-11	?													20100716.ifs	2010-07-16	2010-07-17
252216	252215	EXCHANGE	CHANGE	902973866	01	2010-06-11	2010-07-12	USB_PA	0	1	2010-06-11	2010-07-15													20100716.ifs	2010-07-16	2010-07-17
252217	252217	CORPACTION	ADD	902973866	01	D	2010-07-13			2010-07-15															20100716.ifs	2010-07-16	2010-07-17
252218	252218	EQUITY	CHANGE	902973866	DEP SHS REPSTG 1/100TH PERP PFD SER A	0	1	2010-06-11	?	0	no	no		no		2010-06-11	2010-06-14	?							20100716.ifs	2010-07-16	2010-07-17
252219	252218	EQUITY	CHANGE	902973866	DEP SHS REPSTG 1/100TH PERP PFD SER A	D	1	2010-06-11	2010-07-13	0	no	no		no		2010-06-11	2010-07-15	?							20100716.ifs	2010-07-16	2010-07-17
217441	217441	EQUITY	ADD	902973866	DEP SHS REPSTG 1/100TH PERP PFD SER A	N	1	2010-06-11	?	0	no	no		no		2010-06-11	?	?							20100611.ifs	2010-06-11	2010-06-12
217442	217442	EXCHANGE	ADD	902973866	01	2010-06-11	2010-06-11	USB_PA	0	1	2010-06-11	?													20100611.ifs	2010-06-11	2010-06-12
217944	217944	EQUITY	CHANGE	902973866	DEP SHS REPSTG 1/100TH PERP PFD SER A	N	1	2010-06-11	?	0	no	no		no		2010-06-11	?	?							20100611.ifs	2010-06-11	2010-06-12
217945	217944	EQUITY	CHANGE	902973866	DEP SHS REPSTG 1/100TH PERP PFD SER A	0	1	2010-06-11	?	0	no	no		no		2010-06-11	?	?							20100611.ifs	2010-06-11	2010-06-12

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