1942 - 2015 Auto Car Makes, Models, Trims & Engines by Year

Database Description:

This automobiles database is comprised of 68 car makes, 3,090 car models, 8,832 trims, and 19,830 engines from 1942 through 2015.

Looking for a car parts database? Check out our Auto Parts DB for MySQL and CSV.

Database Meta:

• Size: 43.4 MB
• Last updated: Sep. 6th, 2014
• Formats Included: MySQL dump .sql text file, CSV, MS Excel
• Tables: 9

Buy Now & Download: $119.00 (USD)

phpMyAdmin Screenshots:

Table Details (Data Structure / Schema):

• engine

  Records:19,830

  The engine table containing all the different engines.

  Data fields

  1. id: int(11)
  2. title: varchar(255)
  3. make: varchar(255)
  4. model: varchar(255)
  5. trim: varchar(255)

• engine_to_year

  Records:74,259

  Associations of engine to year.

  Data fields

  1. id: int(11)
  2. make: varchar(255)
  3. model: varchar(255)
  4. trim: varchar(255)
  5. engine: varchar(255)
  6. engine_id: int(11)
  7. year: varchar(255)

• make

  Records:68

  Table containing all the vehicle makes.

  Data fields

  1. id: int(11)
  2. title: varchar(255)

• make_to_year

  Records:2,987

  Associations of make to year.

  Data fields

  1. id: int(11)
  2. make: varchar(255)
  3. make_id: int(11)
  4. year: varchar(255)

• model

  Records:3,090

  Automobile models of makes.

  Data fields

  1. id: int(11)
  2. title: varchar(255)
  3. make: varchar(255)

• model_to_year

  Records:22,654

  Associations of model to year.

  Data fields

  1. id: int(11)
  2. make: varchar(255)
  3. model: varchar(255)
  4. model_id: int(11)
  5. year: varchar(255)

• trim

  Records:8,832

  Automobile trims of models.

  Data fields

  1. id: int(11)
  2. title: varchar(255)
  3. make: varchar(255)
  4. model: varchar(255)

• trim_to_year

  Records:44,065

  Associations of trim to year.

  Data fields

  1. id: int(11)
  2. make: varchar(255)
  3. model: varchar(255)
  4. trim: varchar(255)
  5. trim_id: int(11)
  6. year: varchar(255)

• year

  Records:74

  From 1942 to 2015.

  Data fields

  1. id: int(11)
  2. title: varchar(255)

Buy Now & Download: $119.00 (USD)

Potential Applications / Usage:

• New & used auto parts online shopping store / affiliate site / dealer site
• Aftermarket automobile / automotive related website / wholesale manufacturer
• Automobile repair service site
• Automobile information site / community enhancement
• Auto body parts directory lookup and reference

Other Available Formats:

Some of these formats are available on extra charge, depending on the database.

• Plain CSV
• CSV for Microsoft Excel
• Microsoft Excel .XLS file (2008, 2007, 2003, 2000)
• Microsoft Word .DOC file (2008, 2007, 2003, 2000)
• LaTeX
• Open Document Spreadsheet
• Open Document Text
• PDF
• XML
• YAML
• WordPress Category / Post Database
• Single Table Format