Alan_uk
A2OC Donor
I've obtained from the DVLA a database of summary information on all the A2s ever registered in the UK and those still registered in Sept. 05. (I don't know the month when A2s stopped being sold, but I presume they either stopped then or that's the latest data DVLA could provide).
Over the next week I'm hoping to number crunch this data and provide some graphs, probably as a PDF report.
The data I have is as follows:
Model, Local Authority, Colour, Year of first registration, Imported?, Exported?, Engine Capacity and for each combination of these the Vehicles Nos.. I have this data in 2 sets: "Year First Registered" and as at "Sept 05"
Obvious analysis are nos. by model, by colour, by engine size, by year of registration, by location. Suggestions for other analysis (i.e. combinations) welcome but no promises
I'll expect folks will want to see numbers by traditional county names. Unfortunately the data I have is by Local Authority (LA). Now, there are 35 counties and 100 Unitary Authorities (UA) in the data. I'm searching for a table to convert LAs and UAs to traditional counties. Otherwise I shall be calling for a volunteer!
Unfortunately over 30% of the records have a LA listed as "Unknown". I asked the DVLA why this is so. They told me that this is due to invalid post codes in the database. I find that unbelievable but that's what they said.
Strangely there are over 2,000 vehicles with an engine capacity of 1422. Is that correct? Most are in 2001 to 2003 but some in 2004 and 2005.
Just to wet the appetite there have been 19,010 A2s register and as at Sept 05 there were still 18,360 left. So, 650 have either been written-off or exported less any imports.
Over the next week I'm hoping to number crunch this data and provide some graphs, probably as a PDF report.
The data I have is as follows:
Model, Local Authority, Colour, Year of first registration, Imported?, Exported?, Engine Capacity and for each combination of these the Vehicles Nos.. I have this data in 2 sets: "Year First Registered" and as at "Sept 05"
Obvious analysis are nos. by model, by colour, by engine size, by year of registration, by location. Suggestions for other analysis (i.e. combinations) welcome but no promises
I'll expect folks will want to see numbers by traditional county names. Unfortunately the data I have is by Local Authority (LA). Now, there are 35 counties and 100 Unitary Authorities (UA) in the data. I'm searching for a table to convert LAs and UAs to traditional counties. Otherwise I shall be calling for a volunteer!
Unfortunately over 30% of the records have a LA listed as "Unknown". I asked the DVLA why this is so. They told me that this is due to invalid post codes in the database. I find that unbelievable but that's what they said.
Strangely there are over 2,000 vehicles with an engine capacity of 1422. Is that correct? Most are in 2001 to 2003 but some in 2004 and 2005.
Just to wet the appetite
there have been 19,010 A2s register and as at Sept 05 there were still 18,360 left. So, 650 have either been written-off or exported less any imports.
