Posted: Tue Feb 13, 2007 12:02 pm
by nathanr
I have a car database listing all the current cars available the uk, it includes 11584 models, here's a snapshot of the csv (ignore the c_id field thats just an internal db primary key)
"long_name","bik_price","co2emissions","fuel_type","insurance_group","mpg_56","mpg_75","mpg_urban","euro_compliance","manufacturer","model_name","num_doors","release_year","base_model","variation","engine_size","c_id"
"Alfa Romeo 147 3dr Hatch 1.6 T Spark Lusso 06",1462200,194,"P",12,44,34,25,0,"Alfa Romeo","147",3,"06","147"," Hatch 1.6 T Spark Lusso","1.6",1
"Alfa Romeo 147 3dr Hatch 1.6 T Spark Ti Se 06A",1459700,194,"P",0,44,34,25,0,"Alfa Romeo","147",3,"06A","147"," Hatch 1.6 T Spark Ti Se","1.6",2
"Alfa Romeo 147 3dr Hatch 1.6 T Spark Turismo 06",1362200,194,"P",11,44,34,25,0,"Alfa Romeo","147",3,"06","147"," Hatch 1.6 T Spark Turismo","1.6",3
"Alfa Romeo 147 3dr Hatch 1.9 Jtdm 16v Lusso 06",1742700,157,"D",14,58,47,35,4,"Alfa Romeo","147",3,"06","147"," Hatch 1.9 Jtdm 16v Lusso","1.9",4
"Alfa Romeo 147 3dr Hatch 1.9 Jtdm Lusso 06",1582700,153,"D",12,60,48,36,4,"Alfa Romeo","147",3,"06","147"," Hatch 1.9 Jtdm Lusso","1.9",5
"Alfa Romeo 147 3dr Hatch 1.9 Jtdm Ti Se 06A",1742700,153,"D",0,60,48,36,4,"Alfa Romeo","147",3,"06A","147"," Hatch 1.9 Jtdm Ti Se","1.9",6
"Alfa Romeo 147 3dr Hatch 1.9 Jtdm Turismo 06",1482701,153,"D",11,60,48,36,4,"Alfa Romeo","147",3,"06","147"," Hatch 1.9 Jtdm Turismo","1.9",7
"Alfa Romeo 147 3dr Hatch 2.0 T Spark Lusso 06",1642200,211,"P",14,40,31,23,0,"Alfa Romeo","147",3,"06","147"," Hatch 2.0 T Spark Lusso","2.0",8
"Alfa Romeo 147 5dr Hatch 1.6 T Spark Lusso 06",1512200,194,"P",12,44,34,25,0,"Alfa Romeo","147",5,"06","147"," Hatch 1.6 T Spark Lusso","1.6",9
"Alfa Romeo 147 5dr Hatch 1.6 T Spark Ti Se 06A",1509700,194,"P",0,44,34,25,0,"Alfa Romeo","147",5,"06A","147"," Hatch 1.6 T Spark Ti Se","1.6",10
If you want it let me know and we'll agree a price