Lifetime updates. Come back once in a while to stay updated of new versions of this database.

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:

MySQL Database: 1942 - 2015 Auto Car Makes, Models, Trims & Engines by Year for Sale

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)



Download link will be sent to your PayPal email. Please check spam folder in case you didn't see it in your inbox. Do contact us if you didn't receive it 10 minutes after payment. We will manually send you the download details in 24 hours. Our support staff work in the time zone of GMT+8.

Instant download upon payment success, just press return button on PayPal website after finishing payment.

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

As we frequently enhance our databases for sale, make sure you revisit once in a while to stay updated of the databases you have purchased. Simply by clicking through the same URL we sent to you, you can download updated versions.