MOT data

[bouncer]

Last year i remember seeing an XL spreadsheet of vehicles that failed MOT. This data was release by VOSA due to a court ruling, but the data was for 2007.
Does anyone have a link or the spreadsheet that is up to date. i think the last one was maech 2010. I have looked on the VOSA site but can not for the life of me find it.

Thanks sTeVe

 

[Dieselman]

I would be interested in that too. Have you tried asking VOSA?

 

[npuk]

VOSA responses to FOI Requests 2010 There isnt one for 2011.

 

[bouncer]

Not yet. I thought someone on here may have converted it from pdf to XL data.
If i have no luck then i will ask VOSA. They make it extremely difficult to find on their site.

sTeVe

 

[Dieselman]

The link still has the 2006/2007 failure rate notifications, not more recent ones.

 

[Dieselman]

Not yet. I thought someone on here may have converted it from pdf to XL data.
If i have no luck then i will ask VOSA. They make it extremely difficult to find on their site.

sTeVe

I did it..last time but haven't seen the data since. I'll ask VOSA.

 

[bouncer]

Any Luck with this ?

sTeVe

 

[Dieselman]

Yes and No.

I was sent a link by VOSA but it opens as rubbish, but they say it's fine. Maybe I'm doing something wrong.

Have a go, I would like to see the results.

Anonymised MOT tests and results | data.gov.uk

 

[Sp!ke]

Link works for me.

 

[Dieselman]

The link works but the output tries to open in notepad or wordpad and is junk. What do you get?

 

[Sp!ke]

Hold on... will try

 

[Sp!ke]

I tried importing data into Excel but its just a whole load of random numbers?

 

[Dieselman]

It appears to be every MOT test performed, but isn't tabulated so won't export and isn't in summary.

I have asked VOSA to export their data as a summary to Excel and let me know.

 

[bouncer]

I’m sure they do this on purpose, I downloaded the file 146 meg and WinZip wont unpack it. It has the file type .GZ which I’ve never come across.

sTeVe

 

[wemorgan]

Isn't .gz the Unix gzip compressor?

 

[Dieselman]

I can unzip the file but it's a raw data set, not anything usable. It needs running through a conversion to export it to Excel.CSV.

Really it needs to be the summary, not every submitted test.

I've sent them the example of what I want so they should be able to have IT look at it and export the data.

 

[Sp!ke]

yes, but compatible with winzip so should be able to unzip ok.

Once unzipped its just a txt file but the data within is pretty unmanageable from what I can tell.

 

[Dieselman]

Bouncer.
What do you want to know and is the 2007 information a reasonable guide, I still have that and also there is a link on the page I linked to.

 

[bouncer]

I could use the figures to asses how many of each vehicle is still running in the UK rather than buying expensive data that only give me vehicles sold in Europe.
Easier to target product. Lots of vehicles get written off, stolen or just scrapped because of age. This data is usefull for what I do.

sTeVe

 

[Dieselman]

Can't the DVLA authorised suppliers provide that information. It will cost but it's not expensive and will be accurate.