I can safely say I've never seen rain or hailstones like it. It closed a few roads where I live but North Yorkshire has many areas where flooding is a problem. Thankfully all 9 people who were missing were rescued or found safe and well.
Some picures from Whitley Bay here...
http://tynephoto.smugmug.com/gallery/603683 including a shot of mine in the local paper. (Every cloud has a silver lining springs to mind

)