Some interesting data from DVLA

This is the place for posts that don't fit into any other category.

Moderator: RichardW

Post Reply
Richard_C
(Donor 2016)
Posts: 535
Joined: 15 Oct 2011, 17:31
Location: Cambridge, England
My Cars: C4 Picasso 1.6 Blue Hdi 120 Manual Excl+ 2016
C3 1.2 Puretech 110 Auto Flair 2017
x 99

Some interesting data from DVLA

Post by Richard_C »

I stumbled on a list of statistical tables issued by DVLA, link here:

www.gov.uk/government/uploads/system/up ... -index.ods

(the .ods extension is open data spreadsheet so it will open in excel or almost anything else)

As you go down the list you think "oooh, that looks interesting". The only one I have dug about in so far is the SORN by make and model. I guess that includes unsold cars sitting in dealers various, plus the ones that people are restoring, repairing or just not using at the moment. Some are likely to belong to users of this forum. I was surprised by how many there are of some models, I wonder if people just SORN, put in shed and forget for a few decades. Some of the figures look barely believable - are there really 227 AX "Spree" rotting away quietly somewhere, hidden behind a huge pile of Saxos perhaps .....

www.gov.uk/government/uploads/system/up ... eh0121.ods

Some DS models show up as a subset of Citroen, others as DS in their own right if you scroll down.

Will the owner of the Ami 8 Luxe centrifugal please stand up ........
Richard_C

Current: , C4 Picasso 120 BlueHdi, C3 1.2 Auto
Past Citroens: Dyane (x2), 2CV, Visa, BX (x2), Xantia, Xsara Picasso, C3 (x2) C5 X7 Tourer, Synergie 1.9TD, C1
Others: Hillman Hunter, Cortina Mk 1, Maxi, VW Type 2, Granada, SAAB 900, SAAB 9-5, R5 Gordini
User avatar
Pug_XUD_KeenAmateur
(Donor 2018)
Posts: 1168
Joined: 22 Apr 2013, 17:24
Location: South Midlands / M4 / M5
My Cars: 405 naD Est
x 232

Re: Some interesting data from DVLA

Post by Pug_XUD_KeenAmateur »

If you're able to open it in Excel, any chance of a link to such a file, as I'm only getting a load of this
Attachments
Capture.JPG
Puxa
andy5
(Donor 2022)
Posts: 438
Joined: 05 Nov 2010, 13:40
Location:
My Cars:
x 104

Re: Some interesting data from DVLA

Post by andy5 »

I think you've run into source data used by third party websites like howmanyleft, howrareismycar, and similar.

The other day I found info on the .gov website about these various apps, but the pages seem to have been updated, =removed, since then, and you instead a page that there have been updates.

I wonder if other changes might be why the third party websites such as howmanyleft don't have info yet on the last two quarters.
Richard_C
(Donor 2016)
Posts: 535
Joined: 15 Oct 2011, 17:31
Location: Cambridge, England
My Cars: C4 Picasso 1.6 Blue Hdi 120 Manual Excl+ 2016
C3 1.2 Puretech 110 Auto Flair 2017
x 99

Re: Some interesting data from DVLA

Post by Richard_C »

I'm sure it is the source data used by other websites. Away at the moment will try to answer queries when home in a week or so.
Richard_C

Current: , C4 Picasso 120 BlueHdi, C3 1.2 Auto
Past Citroens: Dyane (x2), 2CV, Visa, BX (x2), Xantia, Xsara Picasso, C3 (x2) C5 X7 Tourer, Synergie 1.9TD, C1
Others: Hillman Hunter, Cortina Mk 1, Maxi, VW Type 2, Granada, SAAB 900, SAAB 9-5, R5 Gordini
User avatar
myglaren
Forum Admin Team
Posts: 25370
Joined: 02 Mar 2008, 13:30
Location: Washington
My Cars: Mazda 6
Ooops.
Previously:
2009 Honda Civic :(
C5, C5, Xantia, BX, GS, Visa.
R4, R11TXE, R14, R30TX
x 4889

Re: Some interesting data from DVLA

Post by myglaren »

Image

Klingon?
User avatar
GiveMeABreak
Forum Admin Team
Posts: 37015
Joined: 15 Sep 2015, 19:38
Location: West Wales
My Cars: C3 Aircross SUV HDi Flair Peperoncino Red (The Chili Hornet)
C5 X7 2.0 HDi Exclusive Mativoire Beige (The Golden Hornet)
C3 1.6 HDi Exclusive Aluminium Grey (The Silver Hornet)
C5 MK II 2.0 HDi Exclusive Obsidian Black
C5 MK I 2.0 HDi SX Wicked Red
Xantia S2 2.0 HDi SX Hermes Red
C15 Romahome White
XM 2.0 Turbo Prestige Emerald Green Pearlescent
XM 2.0 Turbo Prestige Polar White
XM 2.0 SX Polar White
CX 20 Polar White
GS 1220 Geranium Red
CX 2.4 Prestige C-Matic Nevada Beige
GS 1000 Cedreat Yellow
x 5648

Re: Some interesting data from DVLA

Post by GiveMeABreak »

I don't have an issue with it - if anyone wants the spreadsheet emailing, just tell me what spreadsheet software you have and I should be able to export it for you.
Click to focus:
Spreadsheet.PNG
Please Don't PM Me For Technical Help

Marc
User avatar
myglaren
Forum Admin Team
Posts: 25370
Joined: 02 Mar 2008, 13:30
Location: Washington
My Cars: Mazda 6
Ooops.
Previously:
2009 Honda Civic :(
C5, C5, Xantia, BX, GS, Visa.
R4, R11TXE, R14, R30TX
x 4889

Re: Some interesting data from DVLA

Post by myglaren »

Maybe it is just me but it is a heap of random symbols Marc
Tried a screenshot but it is too huge to post and the GIMP isn't helping.

ETA: the second one is legible.
User avatar
GiveMeABreak
Forum Admin Team
Posts: 37015
Joined: 15 Sep 2015, 19:38
Location: West Wales
My Cars: C3 Aircross SUV HDi Flair Peperoncino Red (The Chili Hornet)
C5 X7 2.0 HDi Exclusive Mativoire Beige (The Golden Hornet)
C3 1.6 HDi Exclusive Aluminium Grey (The Silver Hornet)
C5 MK II 2.0 HDi Exclusive Obsidian Black
C5 MK I 2.0 HDi SX Wicked Red
Xantia S2 2.0 HDi SX Hermes Red
C15 Romahome White
XM 2.0 Turbo Prestige Emerald Green Pearlescent
XM 2.0 Turbo Prestige Polar White
XM 2.0 SX Polar White
CX 20 Polar White
GS 1220 Geranium Red
CX 2.4 Prestige C-Matic Nevada Beige
GS 1000 Cedreat Yellow
x 5648

Re: Some interesting data from DVLA

Post by GiveMeABreak »

Both are fine with me Steve, maybe the download is corrupt..
Please Don't PM Me For Technical Help

Marc
Post Reply