[open-economics] Credit union failures

[Anders Pedersen]

Hi All,

I agree that the spreadsheet is a bit crowded. We have lots of columns and
many of them are still incomplete.

At the Open Interest day in London, we discussed some ideas for
visualizations - like this one:
http://graphicsweb.wsj.com/documents/Failed-US-Banks.html.

For such a visualization we would need data on these columns. As suggestedI
have updated these with *a star * *in the googledoc:
"Date of failure"
"City and country of operation"
"Home country"

With regards to amounts, it is difficult to find reliable data on bailouts,
state aid and government losses. I would suggest that we use the size of
the bank as the indicator. In the tracker we have a columns named:
"Total assets of balance sheet of bank at time of failure."

We would then be able to generate a chart indicating some proportional
differences between the size of the failures (ie. local credit union vs.
RBS).

The link for the Failed Bank Tracker is still:
https://docs.google.com/spreadsheet/ccc?key=0AkitojFFyvjCdC1lcmRhRU9WWExSdmJ6OFpySExzb3c#gid=0

Finally, in other bank news, the EBA has finally published the first list
of registered "credit institutions" within the EU. The full list of some
+7,000 banks, registered with national financial regulators (like FSA) is
available here:
http://www.eba.europa.eu/Publications/credit-institutions-register.aspx

Best,
Anders

On Sun, Dec 9, 2012 at 11:20 PM, Velichka Dimitrova <
velichka.dimitrova at okfn.org> wrote:

> Hey Anders,
>
> Since we have quite a lot of columns already, I am wondering whether we
> could put a star for the fields which we definitely need for this type of a
> visualisation, I guess this would be the date and the main city of
> operation?
>
> Do we need the amount that the bank received in state aid / for how much
> it was sold in a public auction? That would be the size of the bubble I
> guess, but probably we won't be able to complete this information for all
> entries?
>
>
> On Mon, Nov 26, 2012 at 4:18 PM, Anders Pedersen <anderspeders at gmail.com>wrote:
>
>> Hi John,
>>
>> That is great!
>>
>> During this weekend at the OKFN Hackdays in London more joined the work
>> got involved in the update of some the failed bank data.
>>
>> We were pointed us to this visualization, which could be a
>> useful template for a European failed banks map:
>> http://graphicsweb.wsj.com/documents/Failed-US-Banks.html
>> (on the left side you can choose "Value of assets at time of failure")
>>
>> Based on this visualization we have added a new column to the data set
>> called: "Total assets of the bank at the time failure". The purpose of this
>> column would be to enable us to visualize the proportional differences of
>> the individual bank failures (ie. the difference between Northern Rock and
>> a tiny local bank). The source would ideally be a financial statement from
>> the bank before its failure, like an annual report or a quarterly
>> statement.
>>
>> Let me know what you think.
>>
>> Best,
>> Anders
>>
>> On Mon, Nov 26, 2012 at 10:16 AM, John Levin <john at anterotesis.com>wrote:
>>
>>> about
>>
>>
>>
>> _______________________________________________
>> open-economics mailing list
>> open-economics at lists.okfn.org
>> http://lists.okfn.org/mailman/listinfo/open-economics
>> Unsubscribe: http://lists.okfn.org/mailman/options/open-economics
>>
>>
>
>
> --
> Velichka Dimitrova
> Coordinator of the Open Economics Working Group
> Open Knowledge Foundation
> http://okfn.org | http://openeconomics.net
>
>
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/open-economics/attachments/20121210/f32fb980/attachment-0001.html>