free hit counter

Dec 31

Current databases for sale


European Car Models, Engines, Dimensions, All details

1970s/1980s-present, 100+ makes, 1600+ models, 18000+ versions.
56 columns of specs per model.
Last release: 6 March 2017.

European all car models database

Demo / sample Read more & BUY

 .


American
Year-Make-Model-Trim-SPECS

1990-2018, 62 makes, 50000+ rows (modes, trims and other variations).
83 columns of specs per model.
Last release: 26 May 2017.

Vehicle database Year Make Model Trim Specs

Demo / sample Read more & BUY

.


Indian
Full Specs Database

1990s-present, 50 makes, 600+ models, 3900+ versions.
188 columns of specs per model.
Last release: 1 July 2017.

India vehicle database

Demo / sample Read more & BUY

.


German car database

1970-2017, 79 makes, 90000+ versions, 179 columns of specs.
Last release: 22 June 2017.

Autodatenbank

Demo / sample Read more & BUY
.

Australia car database
Australia Car Database

1960-2017, 122 makes, 90000+ models, 97 columns of specs.
Last release: 16 June 2017.

Demo / sample Read more & BUY

.


Middle East Database

2000-present, 83 makes, 700+ models, 9000+ versions.
16 columns of specs per model.
Last release: 8 April 2017.

Middle East car database

Demo / sample Read more & BUY

 .

Motorcycles Database

1894-2017, 468 makes, 30000+ models.
72 columns of specs per model.
Last release: 24 March 2017.

Motorcycle database

Demo / sample Read more & BUY

.

Automobile production

Table and chart made in Excel with number of cars produced in each country from 1999 to 2016.
Does NOT contain makes and models.

Automobile production by country

FREE download Excel table & chart

Car sales figures

Table with number of cars sold in Europe, America and China, by make and model.
.

Car sales data

Demo / sample Read more & BUY


Car Models List XLS

1945-present, NO technical specs.
150+ makes, 4700+ models World
110+ makes, 2500+ models Europe
1 row = each model platform: BMW 3-Series E46, E90-E93, F30, etc.
Last release: 10 June 2017.

Car Models List Excel database

Demo / sample Read more & BUY

 .


Car Nameplates List

1945-present, 160+ makes, 2900+ nameplates. An alternative to Car Models List, single row for all models sharing same name and separate row for each name a model is sold.
Last release: December 2016.

Car Nameplates List spreadsheet

Demo / sample Read more & BUY

.


Year-Make-Model

Car Models List in American style with one row for each year the car was sold
1945-2018
, 90 makes, 15000+ rows (model years).
5 columns, NO technical specs.
Last release: 4 June 2017.

Year-Make-Model vehicle database for United States & Canada

Demo / sample Read more & BUY

.


Car Models List DOC

The original version of Car Models List in .DOC format. This is intended for consulting and reading only. Web developers are advised to purchase the above Car Models List in .XLS format that can be quickly dumped in a MySQL database.

Car Models List

Read more & request FREE

 .


Car Models Timeline

Same cars like in Car Models List but displayed in an easy-to-visualize timeline chart to study car models organization.
.
.
.

Car Models Timeline

Read more & request FREE

 .


Car Models Encyclopedia

The original book-style .DOC with car models, dimensions, weight, list of engines.
Europe 1945-present / World 1980-present. 360-page book with 1500+ models.
.

Car Models Encyclopedia

Demo / sample Read more & BUY

 .


Car Engines Database

1970s/1980s-present, 100+ makes, 1600+ models, 1700+ total rows. 1 row = engine / body / drivetrain combination: BMW 320i, 325d, 325d xDrive, etc.
9 columns of specs per model.
Last release: 6 March 2017.

Car Engines Database

Demo / sample Read more & BUY

 .


Car Tires Database

Same like Car Engines Database + one additional column: TIRES, finalized 1990-present as September 2015, 1970-1990 under construction.
11 columns of specs per model.
Last release: 6 March 2017.
.

Car Tires Database

Demo / sample Read more & BUY

.


Car Models, Engines, Dimensions, Performance Database

Same like Car Engines Database + 18 additional columns.
27 columns of specs per model.
Last release: 6 March 2017.
.

Car Models Engines Dimensions Database

Demo / sample Read more & BUY

.


Car Models Database

1945-present, 110+ makes, 2000+ models, 3400+ total rows. 1 row = model, platform and body style: BMW 3-Series E36, E46, Saloon, Touring, Coupe, Cabrio.
13 columns of specs per model.
Aimed for car dimensions.

Car Models Database for Europe

Demo / sample Read more & BUY

 .


Car length over history

Chart in PDF format made with AutoCAD, showing 640 most common car models produced in Europe 1945-present. Useful for garage builders and students researching car evolution.

Car Length Evolution
FREE download PDF chart

Proposed: Car Engines List

Alternative to Car Engines Database, simplified by having with one row per engine capacity regardless it is offered in multiple power options and multiple body styles.
Feel free to suggest changes BEFORE I start the work. Takes 1-2 weeks to complete and will cost 100 euro for 1st customer.
Demo / sample

Proposed: Car photo database

ON HOLD, due of controversy regarding what kind of photos should be offered, and possible copyright issues. You feedback is needed to continue the project!
Demo / sample Read more

 

FAQ & notes

Don’t have PayPal or Credit card? Are there other payment methods?

First, ask your friends, maybe someone have a credit card, pay him in cash and he can buy for you with his credit card.

Alternatively you can pay via MoneyBookers, Western Union (high fees!) and bank transfer (I will email you the file only after confirming that payment was received, may take 3 days).

If you get error “We’re sorry, but we can’t send your payment right now” you should ask me to send you an invoice requesting money via Paypal. This usually bypass errors at your side.

PRICES TOO HIGH! I am a student doing a non-profit research…

The price reflect my efforts and quality of work. Show me where you can find a cheaper auto database with comparable amount of data and updated regularly!
Most visitors of website are from companies, some offered me even 1000 euro to make a customized vehicle list in SQL. I cannot verify if you make profit or not. If you are a poor student or doing something non-profit, then probably we cannot make a deal. Sorry!

Do you provide updates?

Of course, I update all databases constantly, databases with higher sale volume are updates more often. Download links are set to expire in 1 year, you can click the link again anytime you want to download latest updates. Moreover each time I update a database I re-send the email with download link to each customer to notify you to re-download database.

Do you provide API to avoid needing re-downloading each time you update?

I do not have sufficient experience to create API. But YOU can help! Read more.

Do you provide invoices?

PayPal provide receipt for purchase and you can use it if needed. In 2014 and 2015 I also provided a DOC invoice if I was asked. But in 2015 someone told me that I cannot legally issue invoices if I am not a registered company. I am 1-person business with no employees so there is no reason to register a company. The CEO of one company got idea to pay from his personal account rather than company account, to avoid needing invoice to explain his purchase. You can do the same, tell to your boss to pay from personal account.

Can I buy a small database then upgrade to a bigger database by paying difference?

YES in case of vehicle databases with same table structure. For example if you bought Car Models & Engines 1995-present then you want want Car Models & Engines & Dimensions 1980-present, you can contact me and I will lower a price to the difference.

NO upgrade from Car Models Database to Car Models & Engines Database because they are totally different products aiming to different business types.

You can contact me also if you want to pay in another currency such as GBP to avoid conversion fee. Sometimes I go shopping on eBay.co.uk and having only EURO in Paypal I have to pay a conversion fee too.

What does mean 1995-present? Does it exclude first 2 years of Mercedes C-Class?

For people who do not want to pay full price for the full 1945-present, I offer 1995-present and 2005-present filtered data.

1995-present package include models that have the middle between production start and end year in 1995 or newer. I decide which model to include or exclude depending by major changes in manufacturer range. Renault Clio 1 (1991-1998) is included but all numerical Renaults up to 19 (1988-1996) are excluded. Mercedes is included after 1993 , Audi after 1994, etc. Volkswagen starts from 1994 Polo, 1991 Golf, 1992 Vento, 1993 Passat, exclude Corrado (1988-1995).

Usually there are NO partially included models, unless they have very long production (example Fiat Panda 1980-2003 which the package include versions after 1995 facelift), or Mercedes W124 (1985-1997) which is included the 1993-1997 versions sold under E-Class name.

Jun 30

Tire database

Free SAMPLE:
http://www.teoalida.com/cardatabase/samples/Tire-Database-SAMPLE.xls

Buy FULL database:

Along time, few people asked me for a database of tires, I usually said “I have databases of car models with tire size indicated, not database of tire models. However, in May 2017 Delgesh Shahab, a customer who purchased TireSize database told me to scrap data from DiscountTire.com but this turned impossible because every time I access website via scraper it gets redirected to store-locator page. A second customer also appeared asking me for a tire models database.

We studied few other tire websites and we decided to scrap from SimpleTire.com because it have large amount if tire brands and tire models, creating this tire database with 272 brands and 50000+ models in June 2017, took some time due to complexity, and the second customer did not purchased because was too late.

I publish database here so in case other people are interested too to purchase it.

Nov 06

Australian car database

Small database – see SAMPLE

BIG database – see SAMPLE

Contact me for custom packages! Price negotiable for first customers! For example you can ask for model naming, engine power and torque, wheels and tire dimensions. 1990-2017, 2000-2017 or whatever do you need. Price will be 0.3 eurocents / model.

Australia car database

I am making vehicle databases for Europe since 2003, for America since 2014, for India since 2015… what is next to do in 2016? Maybe Australia?

I created this page in May 2016 for marketing experiment to see how many people view Australia page and decide whenever worth my effort to create a car database for a country with such small population which may translate in just few sales of automobile database per year. The page got very low traffic for one year, but during last days of May 2017 I got 2 people interested in purchasing an Australian car database, so I started studying possible sources of data, another 2 people left comments on 3 and 4 June so I decided what website to scrap data from, scraping took about 10 days.

Database published on 16 June 2017.

Data fields included

Percentages calculated for 1960-2017 database. If you buy 1990-2017, 2000-2017, etc, you will get higher completion ratio. Certain data fields are available for recent cars only, for example Fuel Consumption is available starting from 2000s.

Naming: Full car name 100%, ID 100%, Make 100%, Model 100%, Year 100%, Price 97.16%, Image URL 69.76%.

Description: Body 100%, Engine 99.94%, Transmission and Drivetrain 100%, Fuel Type 100%, Fuel Consumption 52.84%.

Overview: Badge 100%, Series 100%, Body 100%, No. Doors 99.97%, Seat Capacity 98.53%, Transmission 100%, Number of Gears 99.99%, Drive 99.99%, FuelType 100%, Recommended RON Rating 55.10%, Release Year 100%, VIN 77.14%, Country of Origin 99.97%, ANCAP Safety Rating 29.29%, Overall Green Star Rating 32.33%, Text Description 25.81%.

Engine: Engine Type 99.99%, Engine Location 97.77%, Engine Size 99.92%, Induction 99.94%, Engine Configuration 78.95%, Cylinders 99.93%, Camshaft 86.72%, Valves/Ports per Cylinder 86.19%, Compression ratio 74.18%, Engine Code 58.01%, Power 85.10%, Torque 81.67%, Power to Weight Ratio 81.42%, Acceleration 0-100km/h 37.14%, Maximum Speed 0.39%.

Fuel Fuel Type 100%, Fuel Capacity 78.03%, RON Rating 55.10%, Maximum Ethanol Blend 78.03%, Fuel Delivery 99.92%, Method of Delivery 99.90%, Fuel Consumption Combined 52.84%, Fuel Consumption Extra Urban 56.27%, Fuel Consumption Urban 58.10%, Fuel Average Distance (km) 52.61%, Fuel Maximum Distance 55.69%, Fuel Minimum Distance 57.33%, CO2 Emissions Combined 51.83%, CO2 Extra Urban 30.36%, CO2 Urban 30.40%, Greenhouse Rating 32.05%, Air Pollution Rating 32.07%, Green Star Rating 32.32%, Emission Standard 25.57%.

Dimensions and weight: Length 83.34%, Width 83.31%, Height 83.03%, Wheelbase 83.64%, Track Front 77.29%, Track Rear 77.28%, Tare Mass 61.18%, Kerb Weight 75.25%, Gross Vehicle Mass 58.79%, Gross Combination Mass 31.62%, Payload 46.69%, Boot Load Space Min 9.93%, Boot Load Space Max 10.96%, Towing Capacity braked 62.81%, Towing Capacity Unbraked 59.22%, Load Length 4.22%, Load Width 4.17%, Width Between Wheel Arches 2.28%.

Warranty: Warranty in Years from First Registration 72.28%, Warranty in Km 70.45%, Warranty Customer Assistance 47.05%, Warranty Anti Corrosion from First Registration 13.23%, Free Scheduled Service 0.98%, First Service Due in Km 42.11%, First Service Due in Months 34.40%, Regular Service Interval in Km 43.86%, Regular Service Interval in Months 39.66%.

Steering and Wheels: Steering 65.04%, Rim Material 39.66%, Front Rim Description 79.46%, Rear Rim Description 79.46%, Front Tyre Description 75.54%, Rear Tyre Description 75.55%.

original writing

If this page gets at least 10 visitors per month I will think about creating a car database for Australia!

Been disappointed by sales in America (2 per month) and India (1 per month), compared with Europe (10+ per month)… Australia population is just 24 millions = 1/13 of United States population. If I create an automobile database for Australia from personal interest as I did for other 3 continents, how many sales I should expect? One sale per 6 months? Too low sale volume to cover my investment, creating manually an original database as I did for Europe is impossible, and in case of scrapping data from an existing website and sell for ~$200 (price of American database), it hardly cover the cost of programmer and time to arrange the data each update.

Another problem is that the ONLY reliable website for Australia I know is Redbook, which as I understand from some people, they are doing own research and also selling database at a very high price, and scrapping a competitor website for purpose of reselling its data would be a big copyright issue for me and maybe for my customers too. See Glass Australia vs CarListDB lawsuit.

Does anyone know any Australian website that is reliable and allow scrapping and using their data for commercial purpose?

Alternatively I can offer scrapping service just for you, without public sale on website (since an Australian car database will hardly to get sales), I can scrap any website at your choice but you need to pay full cost of my programmer partner.

Oct 20

Year Make Model for United States & Canada

Year-Make-Model car databaseDownload SAMPLES (Ford and BMW):

Year-Make-Model.xls for general use
Year-Make-Model.csv for programming
Year-Make-Model.sql for web developers

Buy full database (all makes) + FREE updates for one year:

Last update: 4 June 2017, adding in advance all 2018 models that will be launched by end-2017.

There are NO TRIMS in this database (no BMW 320i sedan, 330d touring, etc, just model names BMW 3-Series).
If you want body styles, trims and more details, buy Year-Make-Model-Trim-Specs but it does not go beyond 1990.

Database coverage

New and used cars, light trucks, SUVs and vans, basically all vehicles that can be driven with car standard driving license, sold in North America from World War II to present, excluding automobile manufacturers that closed production before 1960s. The list of car models also include about 150 pre-war models MY 1926-1942 that have name connection to post-war models, example Chrysler Imperial (since 1926) and Chevrolet Suburban (since 1933).

To suit customers in both countries, I added notes regarding availability in Canada but not in United States.

See Changelog & version history.

Source of data

Mainly Wikipedia, which is pretty accurate for cars produced in USA and for cars imported from Japan, but not for cars imported from Europe, so to get higher accuracy I also verified with the highly-reliable Edmunds (1990-present only unfortunately), eBay Motors (unreliable, may model years that actually do not exist), Nada Guides (some missing models and messed up names, for example missing Suzuki after 1997 and incompleteness of Porsche 1998-2010, but best option for 1940-1990), and CarListDB.com (one of my competitors in data providing died in 2015).

There is some confusion at cars imported before 1990 regarding the model years each model was available for sale, in case of contradictory info I added notes in Excel table “possible non-existent model year, existent on CarListDB, non-existent on NadaGuides” so you have guarantee that you get a car and truck database with NO missing models.

Demo for 2 makes – buy and get all 90 makes

Oct 18

Motorcycle database

Download SAMPLE (one make): Motorcycle Database.XLS

Buy FULL database + FREE updates for one year:

The motorcycle database is the ONLY product on this website that is not “100% Made by Teoalida”. It resulted from a “work exchange” with a customer who needed both cars and bikes and we agreed to give him a discount for my manually-made biggest car database and he made a script to copy data automatically from www.bikez.com and put in a CSV file with permission to sell it on my website. However, few months later I made my own script which surprisingly works faster than his one, making it a product Made by Teoalida.

Bikez.com is a fan-made website, there are many data fields, but actual data is available for just a small amount of bike models. Fan-made website means less restrictive in terms of copyright. You are free to use this data on your own website. Already seen a website (motociclisti.ro) using same data from bikez.com, everything translated into Romanian.

Bikez.com website originally covered 1970-present, but was expanded to 1930-present during summer 2016 and to 1894-present during autumn.

My experience is limited to cars so I cannot tell how complete is for bikes sold in any specific country in the world, but with 30000+ bike models I assume that it is the most comprehensive website with bikes produced worldwide, even if in the early years there are much lower number of bikes per year, compared with 2000s and 2010s.

Motorcycle database was created and launched for sale in May 2016, with 43 fields (columns) found on common 2-wheeler models. After first release, I started browsing other bikes and found additional data fields which I included in the August 2016 update, having 62 columns, after this I re-started looking at bike models with most fields filled up and found that they have even more fields not yet included, so I released final version in September 2016 with 71 columns. For example, August 2016 release include 0-100 kmph available for 1% of bikes, and after this I found that other bikes contain also 1/4 mile and 60-140 kmph in highest gear. There is possible that Bikez.com to have even more data fields but they are available for so small amount of bikes that does not add any value to my bike database.

Bike data fields included

Naming: Make 100.00%, Model 100.00%, Year of launch 100.00%, Category 100.00%, Price as new (MSRP) 19.90%.

Engine and transmission: Displacement (cm³) 98.21%, Engine details 12.70%, Engine type 99.96%, Power (PS) 66.25%, Power (rpm) 58.45%, Torque (Nm) 38.57%, Torque (rpm) 35.67%, Top speed (kmph) 34.38%, 1/4 mil (sec) 0.24%, 0-100 km/h (sec) 0.99%, 60-140 km/h, highest gear (sec) 0.43%, Max RPM 1.65%, Compression 60.67%, Bore x stroke (mm) 74.43%, Valves per cylinder 41.40%, Fuel system 68.59%, Fuel control 56.28%, Ignition 39.51%, Lubrication system 24.41%, Cooling system 87.82%, Gearbox 84.70%, Transmission type, final drive 83.99%, Clutch 34.40%, Driveline 17.39%, Fuel consumption (l/100km) 11.80%, Greenhouse gases co2 (g/km) 11.80%, Emission details 6.76%, Exhaust system 14.24%.

Chassis, suspension, brakes and wheels: Frame type 39.30%, Rake (fork angle) 20.87%, Trail 15.62%, Front suspension 60.66%, Front wheel travel (mm) 26.73%, Rear suspension 59.40%, Rear wheel travel (mm) 26.11%, Front tyre 80.65%, Rear tyre 80.70%, Front brakes 95.04%, Front brakes diameter (mm) 43.51%, Rear brakes 94.31%, Rear brakes diameter (mm) 41.96%, Wheels 19.13%, Seat 12.36%.

Physical measures and capacities: Dry weight (kg) 59.41%, Weight incl. oil, gas, etc (kg) 36.73%, Power/weight ratio (HP/kg) 39.01%, Seat height (mm) 57.98%, Alternate seat height (mm) 1.60%, Front percentage of weight 0.64%, Rear percentage of weight 0.18%, Overall height (mm) 37.59%, Overall length (mm) 52.70%, Overall width (mm) 43.38%, Ground clearance (mm) 32.88%, Wheelbase (mm) 62.19%, Fuel capacity (litres) 80.98%, Reserve fuel capacity (litres) 8.62%, Oil capacity (litres) 7.75%.

Other specifications: Color options 55.04%, Starter 62.76%, Instruments 7.14%, Electrical 6.69%, Light 4.57%, Carrying capacity 5.74%, Factory warranty 10.16%, Comments 30.69%, Modifications compared to previous model 0.95%.

Completion percentages calculated in March 2017 edition.

Oct 16

Car Models List

Download SAMPLES:
Car Models List.XLS for general use
Car Models List.CSV for programming
Car Models List.SQL for web developers

FREE version include complete list of manufacturers and list of models for 4 manufacturers, one for each continent.
PAID version have 150+ makes, 4600+ models in Worldwide version / 110+ makes with 2400+ models in Europe version.
FREE updates for one year, then you need to pay 50% of price per year.
Last release: 10 June 2017Full change log.

Worldwide version
Car Models List

European version
List of car models

 

Coverage: World War II – present. Few pre-war classic automobiles are included too, if they are related with post-war ones.
All major (and few minor) manufacturers of Europe, United States, Australia, Japan, Korea, Malaysia, India, Brazil, Argentina.
Make, model, car classification, years produced or Model Years in case of cars sold in North America.

I guarantee that it is currently 100% COMPLETE for European and North American markets, plus for the market of the country of origin of each manufacturer. For example the Car Models List may not include any possible cars produced in Korea and sold somewhere else than EU, US, or Korea markets. This because Korea and Japan manufacturers often sell ONE car model under dozens of different names in various countries. There are over 200 countries in the world, making a global world complete database for every country is HARD JOB. But you can contribute!

Cars produced in China are not included yet (very few chinese cars are exported, Wikipedia and all the english internet offer confusing and incomplete info).

 

The Worldwide edition include also the sheet of Europe edition.
The Europe edition include all markets from United Kingdom to Russia and Turkey, does not focus only on Western Europe.
For North America I provide Year – Make – Model format instead of Make – Model – Start year – End year.

 

Source of data: mostly Wikipedia, the most comprehensive car database ever! I manually compiled the list of cars into an Excel database, creating an original product “Made by Teoalida” with no equivalent on internet! Excel allow for easy reading, sort, filter, as well as conversion to CSV and SQL database to be used in web building.

The list include model generations (example: VW Golf IV), platforms (example: BMW E46), chassis code (example: Mercedes W124), with exact years of production for each of them. If you want just model names, without separate row for each Golf I to Golf VII, you should use Car Nameplates List instead.

Commercial vehicles under 3.5t are included too. No concept cars or prototypes, only vehicles sold in world markets.

The list does also include a short description (company history) for some brands, as suggested by a customer in 2013, however the next customers did not liked the idea so I did not added description for remaining brands. Should I continue writing descriptions?

There is also a column for number of units produced, but I was able to find this info for only 8% of total models, mostly exotic cars, so if you are looking for a production figures for all cars, this Car Models List will NOT help you.

History

Original Car Models List was compiled in Word, it was not market specific, but instead showing the domestic market of every manufacturer (except Japan), for European manufacturers it showed models sold in Europe, for American manufacturers it showed models sold in America (years column displayed Model Years instead of production years), for Asian manufacturers it showed models sold in Europe plus few local models.

Since December 2012 offer the list of car models also in Excel format (4 columns) after I met a web developer looking for a Make / Model database in Excel format for quick import in MySQL database.

During 2013 I expanded the car make and model list to 8 columns, added “Sold in EU / US” and put Model Years for North American market on separate column from Production years, and made it complete also for American market, by adding Japanese and Korean models produced exclusively for America.

Due of the inevitable inaccuracy that you should expect in any WORLDWIDE global database, caused primarily by cars sold under multiple names in different markets or same name used in different markets for multiple unrelated cars, since May 2013 I provide also an accurate Europe-only version in same format, every few months, extracted from Worldwide database which I update constantly (every month).

In 2016 I finalized Japanese Domestic Market at the level of completion of Wikipedia. However we cannot know how complete is Wikipedia.

Big dilemmas! You can decide how I will improve the list of car models in the future

– Should include Brazil, Mexico, South Africa, etc, divisions of European manufacturers? They produce mostly SAME models but in DIFFERENT production years, currently European-designed models produced also in Latin America are not added (due of risk of being considered duplicate entries), but models designed and produced ONLY in Latin America were added in June 2013 edition.

– What is best thing to do when a vehicle is sold with multiple names in different countries? Currently the Excel table contains names used in European, American markets plus the country of origin (European name is shown the first). Example: Kia Magentis (Europe) = Kia Opirus (America) = Kia K5 (Korea), possible additional names from the rest of world are not included. This is getting a SERIOUS ISSUE since I am expanding the Car Models List beyond European and American markets. Would be good idea an additional column “Alternate names” while the main column to display ONLY the name from the country of origin?

One customer complained that is incomplete in the sense that I displayed Renault Clio III as 2005-2012, he claimed that was original model 2005-2008 and facelifted model 2008-2012. Car Models List excel database include only all-new models, NOT mid-life facelifts because of impossibility to identify all minor modifications of a car model. If you want breakdown by every minor change in body design, you can buy Car Models Database.

Oct 12

Car Models Database with body styles & dimensions

Download SAMPLES (one make):
Car Models Database.XLS for general use
Car Models Database.CSV (BETA) for programming
Car Models Database.SQL (BETA) for web developers
Feel free to test CSV and SQL, if they are OK I will sell the full database in these formats beside Excel format.

Buy FULL database + FREE updates for one year:

Car Models Database

Database contains separate row for each car body style, showing basic data:

Car dimensions (length, width, height, wheelbase, cube) with 99% completion for 1980-present and 75% for pre-1980.
Car weight range and cargo space with 99% completion for 1980-present.
Car engine range (displacement, horsepower and top speed), for 1980s-present (except for cars not sold in Europe).

Last release: 1 March 2017, including 33 models launched 2016 and 11 models launched 2017, see update history.

Coverage

European-produced cars 1945-present, Asian imports 1970/1980-present, American imports 1990-present, for more details see List of car manufacturers and years included.

Bonus: some Asian cars not imported in Europe, for example Malaysian cars (Proton’s all 15 models, not just the two imported in continental Europe, Perodua’s 10 models, none imported in continental Europe but few imported in United Kingdom). Add-on with cars produced in India, Brazil and Argentina (added during 2013).

This is NOT a database of Latin America / India market. I guarantee completion for European market ONLY. Indians and Latin Americans can buy European database + add-on of vehicles produced locally, delete yourself the vehicles not imported in your country and request me to add if there is any additional foreign models available in your country but not in European database!

Source of data: AutoKatalog for 1980s-present (99% data completion and accuracy guaranteed), and Wikipedia for older automobiles (expect some mess and missing data in pre-1980s). All data written manually in Excel, making an original product “Made by Teoalida”.

This vehicle database focus on model only and breakdown for body type (sedan, wagon, coupe, convertible, etc). There are NO list of car engines. For breakdown by individual engines, see Car Models & Engines Database.

Description & history

Started in 2005, originally a research-analysis to compare cars and study evolution in terms of dimensions, weight and engines. For example Golf 1 (3705 mm length, 1100-1800 cm³, 50-112 PS), vs Golf 5 (4204 mm length, 1400-3200 cm³, 75-250 PS). However, since started selling in 2012, its typical customers are car shipping companies pricing transport costs by car dimensions, or car cover manufacturers.

At least one customer bought this Car Body Specs Database (SURPRISE!) not for body specs, but just for list of car body types. Previously I was adding car models only when/if data of car dimensions was available, but since 2013 I choose as ultimate goal to add EVERY car manufactured after World War II, even if no dimensions are available, over time I may find the data and complete the table. Expect missing data ONLY in pre-1980s period.

Discontinued: Timeline database

Download SAMPLE: Car Models Database Timeline version.XLS

Same rows, but sorted by class and year instead of alphabetic by make, useful for my personal research but difficult to maintain and check for missing models.

This was the only database format since 2005 to December 2012, when I re-sorted database alphabetically and sold both versions in same package but the timeline had a lag in updates. I updated the Timeline version and offered of sale both versions separately at main yearly update of November 2013, but due of customers preference for alphabetic version, I no longer updated Timeline version since May 2014 and removed from sale at end of 2014.

Timeline version’s purpose is to visualize car evolution over years, and in 1 year NOBODY bought for this purpose.

Car Models Database Timeline

Future of this database – I need your feedback!

I was thinking in March 2016 to offer a major update after Car Models & Engines Database will be fully expanded to 1970, this will happen most likely in 2017. I will recheck every car and add correct dimensions, weight and engine range from the expanded bigger database.

Until that, I will offer minor updates with new cars added and with dimensions only.

Some things that need to be decided:

– Cars that had a mid-life facelift that changed external dimensions only slightly do not have a separate row, instead they have in Notes column “Length X mm after year Y”, would be better if I make separate row for every slight variation of dimensions, or this will make unecessarily too many rows?

– Make & Model & Platform controversy: since I started this database in 2003, until I published on website and started selling in 2012, there was a single column “Car name”, starting from 2012 I made columns Make and Model, since 2014 I made 4 columns Make, Model-Platform, Model, Platform. MayI know how are you using these 4 columns? I am questioning if this is the best format or I can improve it even further, for example I am thinking to remove (facelift) from model names, and add instead production years to diferentiate pre- and post-facelift models

– If you have any better proposal, let me know!

Survey

Car specifications vary from country to country where a car is sold, but overall car dimensions are usually the same. If 90% of database sales are done by European customers, should I expand the database by including cars not sold in Europe (such as Japanese Domestic Market cars)?

NO! We are Europeans and we don’t want cars that are not sold in Europe. Or we are not Euopeans but if you cannot make a database complete worldwide, then don’t bother adding more cars, just stick on cars sold in Europe.
YES! Add as many cars is possible that are not sold in Europe, since June 2015 you offer a column “sold in Europe”, European buyers can delete themselves the cars that are not sold in Europe
YES! Add as many cars is possible that are not sold in Europe, even if you cannot add ALL cars sold all over the world, and sell Car Models Database Europe edition / Worldwide edition as you do with Car Models List
Other
Please Specify:

Poll Maker

Oct 10

Year Make Model Trim Specs for American Market

Download SAMPLES:
Year-Make-Model-Trim (7 columns)
Year-Make-Model-Trim-Basic-Specs (27 columns)
Year-Make-Model-Trim-Full-Specs (83 columns)
Year-Make-Model-Dimensions (unfinish-able, read below)

Alternate formats: CSV and SQL (Full Specs)

Buy FULL database + FREE updates for one year:

Last release: 26 May 2017, including 295 of 2018 models. Full changelog.

Year Make Model Specifications car database for American market

The trims database does have same number of rows but just first 5 columns, making duplicate rows for each trim due to differences such as FWD / 4WD, manual / automatic, different engine, different features, etc. A proper car trim database, filtered from trim duplicates, require additional dozens of hours of work too much considering how many sales it can get. Should do this job?

The dimensions database: there are some vehicles offered with multiple dimensions for same body style, example: Lexus LS short and long wheelbase, Ford F-150 short and long truck bed, etc. They have duplicate Year, Make, Model, Body which can pose a potential problem for integrating database in a website. Including trims would be NOT the right solution because would increase number of rows significantly for no reason and Ford F-150 have same trim in multiple bed lengths. Can someone suggest the best solution for these vehicles?

American car database coverage

Complete for all cars, trucks, SUVs and minivans sold in United States from Model Year 1990 to present. Exotic makes (Ferrari, Lotus, Maserati, etc) which are MY 2001 onward. Vehicles sold in Canada but not in United States are NOT included as they are included in Year-Make-Model which is based on Wikipedia. Certain technical data (valves, cam type) is available for MY 2001 onward. This is due to the website I based my database on.

Apparently they changed source of data for MY 2001 as some cars like Mercedes C43 AMG were listed as separate model for MY 2000 and as trim under C-Class for MY 2001, had to correct these model naming issues manually. The specs are consistent before and after MY 2001 change.

 Are you interested in cars older than 1990? I am interested too, for my personal research and for selling such database! Show me a website having older vehicles displaying at least car engine size, power and dimensions, and I will see if I can copy data from it!

Data fields included

There are 83 columns in this vehicle database, but unlike my well-known car databases for Europe with 99% completion ratio for most columns, this American car database have many columns with data available for just 50-90% of vehicles, due to the incompleteness of the website I used to source data from. While the database is 1990-present, the features columns, valve and cam type are available starting from 2001 only.

Beside 8 columns of model naming, there are 17 columns with completion ratio at least 98%. Hope this is enough for most applications. Feel free to delete the columns which are not available for most of cars.

Naming: ID 100%, Make 100%, Model 100%, Year 100%, Trim 100%, Description 100%, Class 100%, Image URL 99.55%.

Body: Body type 100%, Length 99.50%, Width 98.14%, Height 98.21%, Wheelbase 99.69%, Curb weight 61.51%, Gross weight 27.01%, Maximum payload 18.81%, Maximum towing capacity 27.16%.

Engine: Cylinders 99.60%, Base engine size 99.70%, Horsepower 98.77%, Horsepower rpm 98.77%, Torque 98.52%, Torque rpm 98.52%, Valves 74.66%, Valve timing 50.66%, Cam type 74.66%, Drive type 99.99%, Transmission 98.96%.

Fuel: Engine type 99.98%, Fuel type 99.98%, Fuel tank capacity 99.05%, EPA mileage 85.70%, Range 99.97%,

Interior dimensions: Front head room 80.37%, Front hip room 65.41%, Front leg room 80.01%, Front shoulder room 78.60%, Rear head room 79.89%, Rear hip room 65.03%, Rear leg room 79.51%, Rear shoulder room 77.89%, Front track 54.21%.

Other dimensions: Rear track 54.06%, Ground clearance 62.91%, Angle of approach 13.54%, Angle of departure 13.51%, Turning circle 86.27%, Drag coefficient 19.93%, EPA interior volume 29.80%, Cargo capacity 62.35%, Maximum cargo capacity 41.04%, Suspension 41.04%.

Warranty: Basic 73.58%, Drivetrain 72.43%, Roadside 54.92%, Rust 54.92%, Free maintenance 17.18%, Hybrid component 2.58%, EV battery 0.16%

Interior features: Front seats 73.15%, Rear seats 63.73%, Power features 74.60%, Instrumentation 74.76%, Convenience 69.83%, Comfort 72.54%, Memorized settings 17.94%, In car entertainment 72.94%, Telematics 0.00%.

Exterior features: Roof and glass 74.86%, Body 22.02%, Truck features 25.69%, Tires and wheels 74.96%, Doors 20.95%, Towing and hauling 42.81%,

Safety features: Safety features 63.99%,

Optional features: Packages 28.72%, Exterior options 31.89%, Interior options 31.89%, Mechanical options 22.46%.

Colors: Colors exterior 91.95%, Colors interior 77.48%, Colors exterior RGB 84.41%, Colors interior RGB 84.41%.

Note: multiple features are listed in same column, while colors have separate column for color name and RGB value. Several customers reported that this format is unusable. Please double-check sample file BEFORE purchasing and make sure you can use the data in the format is provided, if you cannot use, feel free to delete Features and Colors columns and use the rest of columns, if these columns are crucial for your business, DO NOT PURCHASE and ask for refund afterwards, because I do NOT offer refunds for your inability to read this message.

Accuracy notes

This vehicle database is NOT a “scrap and sell data as it is”. I spent extra time and used my high automotive experience to correct errors and improve model hierarchy when compared with original source website. Probably this will also help you having an unique automobile database that do not exist on any website, and avoid copyright issues.

Example of corrections:
– Mercedes W202 C36 and C43 AMG were listed as separate model beside C-Class while W203 C32 AMG were listed as a trim under C-Class. To make things clearer I decided to list all AMG cars as trims, same for BMW M and Audi S models.
– Porsche Cayman was launched with S trim only so for MY 2006 was listed under model name “Cayman S” while for next years model name is “Cayman” with trims “Base” and “S”. I corrected and put MY 2006 “S” as trim.
– Subaru Impreza WRX was is listed as trim under Impreza for MY 2002-2012, as separate model “Impreza WRX” for MY 2013-2014 and as separate model “WRX” for MY 2015-2016. I modified and listed all WRX as trim under Impreza model.

Apr 01

Possible upcoming projects… waiting for feedback!

New database ideas are welcome, as well as suggestions for improving data structure! If there are multiple people interested, I will do them!
Having too many Excel vehicle lists means more time necessary to update each of them. Also, some customers get confused and complained that I already have too many products for sale, so… I will develop only products that people are demanding!

Supercars database

Fans of Ferrari, Porsche, Corvette, etc, as well of C63AMG, M3 and S4, can get what they wants without paying the high price of all cars database. Just tell me what amount of technical specs should be included the database for sport cars.

EuroNCAP crashtest database

Someone suggested this in November 2013. If more people are interested in this project, I will do it! Tell me if it should contain overall star rating or… how many details I need to include about each crash test?

Car photo database

Started in May 2013 and put on hold, due of controversy regarding what kind of photos should be offered, and possible copyright issues. You feedback is needed to continue the project! Check this page Car photo database.

Engine codes database

Someone asked this in 2013. I can add the codes in Car Engine Specs Database for BMW and Mercedes as Wikipedia provide them… but how about the rest of brands? From where I can take the codes?
As early 2015 I found websites like http://www.buycarparts.co.uk/ displaying engine codes for most of brands. Car model names are different than in my database, so will be a pain in the ass to add correct codes to correct models and impossible to reach more than 80-90% completion, I leave this job for a later time when I will have more free time.

Car Models + Simplified Engine List

Thank you to an Indian who gave me this idea in February 2013, unfortunately I do not have knowledge to make a complete list of cars sold in India at a reasonable data accuracy. I am looking for potential customers in Europe interested in this thing!
See SAMPLE, it is based on Car Models Encyclopedia.DOC and recompiled in .XLS format to be usable for webdesigners.

You can help me to take RIGHT decision! Do I should…
– add production years, per model or per each engine?
– Mercedes E320 changed from in-line-6 to V-6 in 1997, should be on same or separate rows?
– BMW 325d, 330d, 335d, all having 3.0 litres engine, different power versions, should be on same or separate rows?

Alternatively, I can scrap from Car Engine Database aka delete the duplicate engine rows caused by multiple body types and multiple transmission options, and let only engine data.

A web-based searchable automobile database

I came in December 2012 with the idea of making an automobile blog with 1 post per car model (see SAMPLE) something similar with Car Models Encyclopedia currently available in Word format. It may display car photos and an undecided amount of technical specs. This is a subject of DISCUSS, especially regarding photo format.
Few months later some visitor suggested that an online car database should store data in MySQL instead of static posts, to allow comparisons and car reviews. This exceed my abilities. That times I knew NOTHING about MySQL or how dynamic websites work.
Developing websites require time and money. Most of the customers who are buying vehicle database are businesses, auto parts shops, shipping companies, car classifieds websites, etc, they may use my database for their website but the cost of website is funded from their businesses. Personally I do NOT have any business in automotive industry so making a website just to offer info…. how I can make revenue to cover my time and expenses? (no Adsense please, it never produce significant income).

Feb 10

America vs Europe vs rest of world

Teoalida’s Car Database developed since 2003 is primarily based on German car magazines, although I live in Romania. It also include the cars sold only in United Kingdom as well as cars produced in former communist countries and never exported to the West, making it a complete database for whole Europe (unlike other databases that have only cars sold in United Kingdom, missing many cars sold in continental Europe).

Starting from 2013 I also provide dedicated database for North American market…. also add-ons for European database with cars produced in India and Latin America, however I cannot provide a database dedicated for these markets.

YOU can help in expanding the database to non-European/American markets!
Give me the list of models sold in your country but non existent in my European database, and I may give you back the models completed with technical specs! See full list of models included in Car Models & Engines Database.

Model year (America) vs production year (rest of world)

North American car market is tightly regulated by government, all car models sold here are organized by Model Years. Most important, two successive models DO NOT share same Model Year (with few exceptions). Traditionally car models launched in second half of year are considered Model Year of next year, but legally manufacturers are allowed to launch “2017 Model” starting from 2 January 2016. Every year, they launch the “next year model”, even if the car is unchanged from previous year. New trims also appear in middle of model year.

Europe (and rest of world) do not have officially a car model year system, the year of a particular car is used only informally, and it’s the calendar year. So a car model launched in December 2016 is still a 2016 model. European car websites should show Make – Model – production years (as a range, no individual years).

I have seen some cheap-made websites targeting Europe but using drop-down vehicle list with each year on separate row, but since Europe do not have regulated Model Year, they used each calendar year in which a car has been manufactured. This is WRONG and leads to errors and confusion, in the year of model replacement, their list include both old and new models or just one of them at random.

Check yourself ebay.com/motors and ebay.co.uk/motors, see the difference? This makes combination virtually impossible, unless you adapt American database to European / rest of world format, which is not on the taste of American customers.

Americans doing their business in Europe or worldwide, argued with me saying that my European database is WRONG. Actually it is CORRECT for us. Me too, I considered the american system strange and wrong, until 2013.

More differences between Europe and America markets

Many European and Japanese cars were sold in US with bigger bumpers, getting few extra inches in length.

Cars are sold in US with less engine choices, usually top of range. Example: the 2007-2012 BMW 3-Series E90 have versions 328i, 335i, 335d, M3, while in Europe the versions are 318i, 320i, 325i, 330i, 335i, 316d, 318d, 320d, 325d, 330d, 335d, M3.

Sometimes US engines do not exist in rest of world. Example: VW Golf 6 is sold in US with a 2.5 liters 5 cylinders 170 PS engine which do not exists in Europe where all engines are 4 cylinders, ranging from 1.4 to 2.0 liters turbo, 80 – 200 PS.

US measure horsepower according SAE rules, usually getting slightly higher power than measured in European DIN standard.

US EPA measure fuel efficiency as miles per gallon, Europe measure in liters per 100 km. Conversion is theoretically possible, but due of different system of averaging city/highway and speeds at which mileage is measured, any given car tested in US will eat 10-20% more gas than when tested in Europe, making comparison difficult.

Don’t trust any database claiming to be 100% complete worldwide!

European car market is 99%+ similar within European Union except United Kingdom and Ireland, and 90-95% similar for all 50 European countries. Eastern Europe have few additional cars produced locally, plus Russia gets few additional Asian cars which are not available in Western Europe, all them being included in my European database. United Kingdom car market is different by having less cars available, because not every manufacturer bother to produce cars in right-hand drive, also UK produce few additional cars sold only locally, again included in my European database.

Asia, Africa and Latin America car markets may be 60-80% similar with European market. If you do not have other options and don’t care about accuracy, buy European Database and tell me what other cars are available in your country, eventually delete the excess cars that are not sold in your country.

North American car market is unique. Most vehicles sold in US & Canada are not sold anywhere else. Many vehicles are sold with different specs in Europe and US even if they wear same name.

I offer Car Models List Worldwide including all models sold in Europe and North America and models sold in local market of non EU/US manufacturers, such as Japanese domestic market for Japan manufacturers (after a big effort in 2014). However it will be NEVER complete for all of the 200+ countries in the world, it DO NOT include cars manufactured in a given country and sold somewhere else but not in Europe, USA, neither in their own country’s market.

If do you need a database more detailed than a simple Make / Model list, things get very… COMPLEX. Car specs vary from one market to another. NOBODY can make a worldwide / global vehicle database for every 200+ countries in the world, at a reasonable accuracy.

The problem is that Japan and South Korea export SAME cars under dozens of different names in various countries. If this was not worse enough, same name is sometimes used in multiple countries for unrelated cars. For example: the Samsung SM3 produced in Korea is also sold in Mexico as Renault Scala and in Russia as Nissan Almera, unrelated with the well-known Japanese Nissan Almera sold all over Europe until 2007. This Russian Almera and its years (and dozens of other similar name changes) are NOT included in Car Models List. Ford do the same, see Ford Escort (Europe) and Ford Escort (North America).

People outside Europe and America are facing trouble finding a database suitable for their country

Some customers are saying “I need a global car database containing European cars (BMW, Skoda, etc) and Japanese cars (Nissan, Toyota, etc), we have all of them in Brazil”. My European database have Japanese models sold in Europe while American database have Japanese models sold in US. Japan manufacturers sell a line of models in Europe, another line of models in North America, another line of models in Latin America, and so on.

Example: Toyota sold the following models in calendar year 2015 / US MY 2016:
In United States: 4Runner, Avalon, Camry, Corolla, Highlander, Land Cruiser, Mirai, Prius, Prius c, Prius v, RAV4, Sequoia, Sienna, Tacoma, Tundra, Yaris.
In Europe: Auris, Avensis, Aygo, GT86, Hilux, iQ, Land Cruiser, Mirai, Prius, Prius+, RAV4, Urban Cruiser, Verso, Verso-S, Yaris.
In India: Corolla, Camry, Etios, Fortuner, Innova, Land Cruiser, Land Cruiser Prado, Prius.
In whatever other country: possible other models.

I got a customer from Arab world saying “I am looking for a car database that contains Nissan Patrol because most database I’ve seen miss it” this happens because most databases available online are for US market and Nissan Patrol is not sold there, my European database does contain Nissan Patrol, won’t help him either, because Nissan sell in Middle East also Altima which do not exist in European database but exist in American database.

Other customers asked me “if my database contain certain Asian cars that are missing from most car databases” and refused to purchase my European database because they are not containing there as well. Indeed, I do not recommend non-European/American customers to buy from me, but I am curious… what alternatives you can buy?

 

BEWARE of sites like www.carqueryapi.com which have both US models and non-US models but it is far away from having worldwide coverage. Actually their database is missing models even from American and European markets, and some of my happy customers informed me that bought previously CarQueryAPI and beside missing models, the data is messed up, some models are lowercase, others uppercase, certain values missing for random cars, etc.

Sadly, there are also people coming on my website and chatting with me then buying from CarQueryAPI just because is cheaper or website is simpler… stupid people who take cheap price over quality!

Best Car Speakers

Feb 01

Data scraping services

For many years, manual data entry in Excel (sourcing from books, as seen in this video) or manual copy-pasting from websites, was my only way of creating databases. A slow process which limited the size of the databases I could make. Even in this slow process I made about 40 databases about cars, geography, real estate, gaming, etc, from pure hobby.

Starting from 2015 I offer web scraping services… in ANY field, not limited to automobiles. Scraping usually means running a software to visit a list of given pages and copy specific data from each page and put it in a database automatically. If you need something very different than my current databases, I can create new databases as long you provide a source of data, a website where to extract data from. Do not expect me to get data that you cannot find yourself in any form, for example:

– Do not think that I can compile a table with dimensions of car lights, bumpers, windows, etc. Such dimensions are not provided in car manuals. If you sell such car parts, measuring yourself your own parts is the only solution.

– Do not think that I can compile a table with number of cars sold in your country, breakdown by model, if your government is not tracking sales and making them public on the internet. Data needs to be available somewhere in order to scrap it and put into a database.

– Theoretically I can scrap data from any website, but only websites having the particular data you are interested in a consistent structure from page to page, can produce a good usable database. After automatic scraping, less or more manual work is needed to make database usable.

Simple data scraping service

This apply on websites where each item have own URL and all data is in page HTML code.

There are few tools available online, usually free download but they are limited in functionality, limited in number of pages you can extract and in pages per second, unless you upgrade to paid subscription, which is ridiculously expensive for the number of pages you can extract. Although you can scrap yourself for free (small number of pages), may take few days to learn to use them efficiently. Most people do not have time to learn or money for monthly subscription. I can help you… my partner made in Visual Basic a scraping software comparable with the tools available online, but with no limit in number of pages, this allow me to scrap websites at lower price than you can do yourself.

Price: sum of the following 4 things:
Number of pages to be scraped: up to 1,000 pages = $20,  up to 10,000 pages = $50, up to 100,000 pages = $200.
Number of columns (pieces of data to scrap from each page): 20 cents for each column.
Complexity: $0 fee for websites where all items are accessible from an index page, extra $ fee if items are displayed with infinite scrolling, pagination, enter data in search boxes, etc.
Work after scraping: certain websites do not provide data in the format you need, I charge extra fee to manually arrange data in Excel.

Complex data scraping service

This apply on websites having drop-down lists, search boxes, JSON, data is behind login, or other actions are needed to display the data you want to scrap. In this case online scraping tools are useless, so my partner will make a custom data scraper made in PHP or Visual Basic, this may take few days depending by his available time.

Price: usually within $200 to $500 range which I share with my partner, price depends more by complexity of website than by number of pages to be scraped.

For less than 200 records may be faster to copy-paste manually than coding a custom scraping software.

Impossible data scraping

Car classifieds websites usually hide seller phone number and contact email, which can be revealed by clicking a button, this is done specially to prevent scraping and protect emails from being spamming. The only solution is to have a human visiting each page and copy-pasting this hidden data, which require large amount of time. If you are an insurance company willing to do SMS or email marketing and you intend to hire me to make a database of car owners sourcing data from classifieds website, most likely I can’t help you because of time.

Anti-scraping

Some websites look simple to scrap, but they turn complex because of IP blocking, CAPTCHA or other measures made either to prevent someone copying data from them or just to prevent DDOS attacks. If you ask for price before starting the job, you should be prepared for price changes. Need to do part of job to be able to tell final price.

Notes

The main advantage of working with me is that once I create a database I can have multiple people purchasing it, so you will pay just a small part of the cost of scraping (if database is something of my personal interest – cars or real estate). If you want to keep private, I can sell it just for you at higher price and not publish on website, but the BIG question is what I should do if a second customer ask me to scrap same website and he agrees to publish on website to get cheaper price? I reserve the right to sell to other people if they ask. If you ask to scrap a website out of my personal interests and unrelated with the fields covered by website, I will not publish it because is unlikely anyone else to purchase it, and you need to pay the full cost of scraping.

The databases published on website include FREE updates for one year, with higher update frequency for products with higher sale volume. But if you ask me to scrap a website privately “just for you” you need to pay for each update, price depending by how much time takes each re-scraping.

Scraping software runs at a speed of 0.5-2 pages per second, depending by website. So I may not able to do very large databases, for example if you want to scrap 1 million records with monthly updates. The limit of how many records I can scrap depends by amount of customers in current month.

Data scraping is legal or not?

Usually scraping is legal, but using scraped data in a public website may be illegal.

Depends… if the data is added by volunteers, or by sellers in classifieds websites, scraping is probably legal. But if authors of website hardworked to compile data from sources like car brochures or manufacturer websites, scraping is probably illegal, especially if you use their data in making your own website or other commercial purpose. Most websites contains dummy data (example: a bunch of cars having +/- 1 horsepower than official value) and if you use data copied from them, they can prove from where you stole data and make a lawsuit against you. BEWARE!

For a moment I became concerned if my European car database sourced from AutoKatalog books is a copyright violation, but I came in conclusion that it is fine, as long as mine is an original compilation with different data structure than the book, and it target online audience, while the AutoKatalog is a book sold in shops targeting car hobbyists. I am doing each year over 100 sales without having a single person worrying about copyright.

In case of America, Year-Make-Model is my original compilation sourced from Wikipedia and 3 more websites, while Year-Make-Model-Trim-Specs is web scraping from Edmunds.com website who is also offering API thus allow other websites using their data, so again is legal.

But, since I created Indian car database in 2015 sourcing data from carwale.com I started being concerned that what I am doing may be illegal.

Country matters: I had many customers in India asking me to scrap data from various websites. However, when someone from Europe or America ask me certain data that I don’t have and I propose him to scrap data from a website, most told me legal issues of web scraping.

Funny case: someone offered me to sell a car database that he claimed to have been creating it by working for 4 months, 8 hours per day, copy-pasting data from a website. From copyright point of view does not matter if you scraped automatically or typed every letter manually, as long you copied from a website your work is not original. He was probably not aware of scraping software. If you wasted few months doing something that could have been done in few hours, you’re an idiot (I was an idiot too doing such jobs before 2015 being not aware of scraping software, but small jobs only) and I am still doing in case of European database because I source data from books (offline sources), making an original product on the web.

Example of scraping projects done and their price

All scraping software save data in CSV format, but when it is about publishing on website, I save it as XLS and add borders, colors, headers and other visual enhancements to match the style of other products “Made by Teoalida”.

India Car Database – source: www.carwale.com – Made from personal interest because of numerous people asking me about indian car database. Being my first scraping project, took initially about 7 days to figure out how to do it, and later figured out that can do it in 2 days. Price: 30-120 euro.

India Bike Database – source: www.bikewale.com – Made after 2nd person requested a database of bikes sold in India. One of easiest projects, having no drop-down boxes but plain links to each bike page. 250 records, price: 25 euro.

CarWale On-Road Prices – source: www.carwale.com – Made for a customer, a difficult project taking about 20 hours of work in Visual Basic to make an application sending javascript requests to CarWale website to get price of each car in each city, application works at a rate of 2 requests per second, so 3100 cars × 510 cities = 1632000 seconds = 226 hours needed to get all on-road prices, RTO tax and insurance. Price: $300 USD of which $200 goes to programmer and $100 my fee for keeping scraping application running daily for a month.

Skyscrapers Buildings Database – source: www.emporis.com – Made from personal interest, put for sale for $150 (15000 buildings) and turned into a marketing failure, 1 year passed and nobody purchased it (except a customer asking me for make US buildings database, see below). Took about 20 hours to compile manually list of cities with buildings over 100 meters, then list of buildings from these cities, then used a software to automatically extract data about each building. 15000+ buildings. Emporis block my IP for 2 days if I access more than 3000 pages in one day, so data extraction was limited to 3000 buildings per day, which took about 1 hour daily for 6 days.

US Buildings Database – source: www.emporis.com – Made for a customer seeing above Skyscrapers database told me to make a similar databases with all types of buildings from USA,. 160,000+ buildings, had to run scraper in over 100 batches of max 2000 buildings and change IP, running again and again blocked URLs until I was able to get all buildings. 60 hours of work. Price: $600.

Singapore Condo Database – source: www.singaporeexpats.com – Made for a customer, took 3 hours and sold database with 2809 condos for $140.50 SGD.

Singapore Condo Database II – source: www.propertyguru.com.sg – Made for a customer. Apparently an easy project, having plain links to all condos, it turned difficult because of a fucking CAPTCHA page appearing every 10 pages extracted. My programmer partner spend 5 days in Visual Basic and charged me $300 USD, and at final sold database with 3176 condos for $317.60 SGD (about 240 USD), leaving me in loss, unless I sell same database to a second customer.

Sulekha.xls – source: www.sulekha.com – A bit unusual data scraping, an one-time use database for SMS and email marketing, instead of creating a saleable product containing all car models, all buildings, all of something.

Postal code scraping – a customer gave me a list of postal codes which I input in www.streetdirectory.com to get building name and street address.

Flickr scraping – a customer downloaded a large amount of car images from Flickr and realized that to use in his website he needs to specify author name, link to source page and link to Creative Commons license. I scraped this info, 223,000 images for 223 euro at 0.6 seconds per page.

Used cars images  – a customer asked me to scrap an used cars website, to get image URL beside Make, Model, Year. Took only FEW HOURS and I got over 100.000 car images, all in same resolution. He told me to keep it private and do not publish or resell on website. So I am telling you only the idea. If anyone wants to scrap car images in this way, let me know what website to scrap!

I done few more databases but the customers told me to NOT publish on website, or they are in fields unrelated to topics covered by my website so even if published, they won’t get sales.

Page 1 of 512345