PremiumDB showing the highlights and colors

Premium Vehicle Database Download All Models 1904+ (Year, Make, Model, Trim, Colors, Engine, VIN, Equipment, Options)

$149.00

 

This vehicle database shows Year, Make, Model, Trim & Highlights + Features for the years 1904-Present.

Note: Highlights and Features only available for vehicles between 1990 – Present.

 

SKU: MSSQL01. Category: . Tag: .

Product Description

 

Superior Premium Vehicle Database Download

& ASP.Net Web Application for years 1904-Present

Database Updated

  • Photos for associated models now available for purchase (see bottom of optional demo), scroll below to view associated PhotoDB product.
  • Download your files via incredibly fast file shares. All files are located in one location after you order. Updates are automatically posted to your account download page and we send out newsletter notifications. See screenshot below.
  • Vehicle VIN and Engine Data (Can be set up to do reverse lookups – Reverse VIN and Reverse Engine Code – Look Up). VIN data is not comprehensive (We do not pull from DMV)
  • The compressed internet download size of the MSSQL database (SQL Server 2014 .mdf & log files) is 166MB
  • The compressed internet download size of the MySQL database (SQL dump file) is 47MB
  • The decompressed archived size is just Over 2GB! Not your average vehicle database
  • Download Microsoft SQL Server 2014 Express* for free HERE to use this database (*10GB Max).
  • View the database samples and field definitions on the “Sample data/Demo” tab
  • Full data/details in MSSQL and MySQL compressed RAR files provided
  • Full vehicle information for years 1990+ include Highlights, Options, Equipment, Engine, VIN, and Colors
  • Part Category table included (great tool for auto recyclers to bind vehicles to parts; parts data not included)
  • NOTE: Vehicle Years 1904-1989 only show Year, Make, Model, and Trim data fields
  • With our Superior Premium Vehicle Database Download, you get the most comprehensive vehicle data list compared to our competitor’s. Don’t settle for someone else trying to sell our data!
  • The provided demo Web Application uses ASP.Net 2.0 Application Pool.
  • Full C# Source Code Included written in ASP.Net C# 3.5 -web app can also be updated to your desired framework version online.
  • Customize the .Net Web Application template to suit your website! Integrate vehicle data right into your website; Cascading Drop Down lists with Year, Make, Model, & Trim, etc.
  • Indexes and Constraints already set for optimum performance and referential integrity.
  • Stored procedures are used by the web application to query corresponding data in the Feature’s tables
  • NOTE: The tables “Options, Equipment, and Color” are available in CSV but may not be useable due to the very large file sizes which most software cannot view/edit SEE SCREENSHOT ERROR. It is possible to export this data from our provided versions by you with other 3rd party tools.  
  • See what table fields are included such as Curb Weight, Engine Size (displacement also in CC’s), Engine Configuration & Code, Cylinders, Horsepower, Torque, Valves, Transmission Type, associated Reverse VIN numbers, and more… Click the “Sample Data” tab to view the actual data files.

Database Metrics

Total Previous Vehicle Records: 42,340

New Records as of May 31, 2015: This Update occurred on Vehicle Years 2015 to Present. Since there were significant updates to all model years, we have provided FULL database versions only (No Update/Changes scripts).

New 2015 models removed for updates: 2,634

New 2015 and 2016: 3,343

New 2016: 709

VEHICLES: 45,683

3,343 NEW/UPDATED

ENGINE: 45,683

3,343 NEW/UPDATED

COLORS: 444,920

513,608 NEW/UPDATED

EQUIPMENT: 10,217,838

1,017,251 NEW/UPDATED

ALL YMMT: 72,966

3,343 NEW VEHICLES (2015+)

VIN: 109,034

6,501 NEW/UPDATED

Option: 867,382

10,851 NEW/UPDATED

Blazing Fast Downloads

View the screenshots!

 


Additional Information

SQL Server Versions

2014; can be converted to 2008 / 2008 R2 / 2012

Database Download Size

Compressed to 166 Megabytes

Attached (.mdf) File Size

Uncompressed to 2.4 Gigabytes

Web Application

C# .Net 3.5 Language / App Pool 2.0 → Upgradable to C# .Net 4.0+ / App Pool 4.0

Sample Data / Demo / Database Field Schema

Haven’t looked through the demo yet? View Demo

Download a sample of the List with All associated data here: PremiumDB-Sample-Data.zip

Download a sample of the OPTIONAL PhotoDB List with associated data here: OPTIONAL – PhotoDB-Sample-Data.zip

Database Field Schema

Vehicle Table Colors Table
[styleId] [nvarchar](20) NOT NULL PRIMARY KEY
[year] [nvarchar](10) NOT NULL
[make] [nvarchar](150) NOT NULL
[model] [nvarchar](100) NOT NULL
[trim] [nvarchar](150) NULL
[trimShort] [nvarchar](50) NULL
[trimLong] [nvarchar](100) NULL
[vehicle] [nvarchar](255) NULL
[condition] [nvarchar](10) NULL
[vehicleType] [nvarchar](30) NULL
[vehicleSize] [nvarchar](30) NULL
[vehicleStyle] [nvarchar](30) NULL
[vehicleCategory] [nvarchar](50) NULL
[performance] [nvarchar](10) NULL
[luxury] [nvarchar](10) NULL
[market] [nvarchar](150) NULL
[engineCylinder] [nvarchar](5) NULL
[engineSize] [nvarchar](10) NULL
[engineForcedInduction] [nvarchar](50) NULL
[engineFuelType] [nvarchar](50) NULL
[transmissionType] [nvarchar](50) NULL
[transmissionGears] [nvarchar](50) NULL
[whereBuilt] [nvarchar](50) NULL
[manufactureCode] [nvarchar](20) NULL
[acceleration_0to60] [nvarchar](15) NULL
[curbWeight] [nvarchar](15) NULL
[grossWeight] [nvarchar](15) NULL
[numberOfDoors] [nvarchar](15) NULL
[fuelCapacity] [nvarchar](15) NULL
[mpgCity] [nvarchar](15) NULL
[mpgHighway] [nvarchar](15) NULL
[mpgCombined] [nvarchar](15) NULL
[price_baseMSRP] [nvarchar](15) NULL
[price_baseInvoice] [nvarchar](15) NULL
[price_usedRetail] [nvarchar](15) NULL
[price_usedPrivateParty] [nvarchar](15) NULL
[price_deliveryCharges] [nvarchar](15) NOT NULL

[styleId] [nvarchar](20) NOT NULL FOREIGN KEY to Vehicle Table
[colorType] [nvarchar](50) NOT NULL
[colorName] [nvarchar](125) NOT NULL
[colorR] [nvarchar](20) NOT NULL
[colorG] [nvarchar](20) NOT NULL
[colorB] [nvarchar](20) NOT NULL
[colorRGB] [nvarchar](20) NOT NULL
[colorHEX] [nvarchar](20) NOT NULL
[optionCode] [nvarchar](200) NULL

   
Engine Table Options Table

[styleId] [nvarchar](20) NOT NULL FOREIGN KEY to Vehicle Table
[compressionRatio] [nvarchar](20) NOT NULL
[compressionType] [nvarchar](20) NOT NULL
[horsepower] [nvarchar](20) NOT NULL
[name] [nvarchar](150) NOT NULL
[code] [nvarchar](20) NOT NULL
[totalValves] [nvarchar](20) NOT NULL
[fuelType] [nvarchar](150) NOT NULL
[torque] [nvarchar](20) NOT NULL
[cylinder] [nvarchar](20) NOT NULL
[size] [nvarchar](20) NOT NULL
[displacement] [nvarchar](20) NOT NULL
[configuration] [nvarchar](150) NOT NULL
[type] [nvarchar](150) NOT NULL

[styleId] [nvarchar](20) NOT NULL FOREIGN KEY to Vehicle Table
[manufactureOptionName] [nvarchar](255) NULL,
[price] [nvarchar](50) NULL
[equipmentType] [nvarchar](50) NULL
[availability] [nvarchar](600) NULL
[name] [nvarchar](255) NULL
[category] [nvarchar](50) NULL
[manufactureOptionCode] [nvarchar](50) NULL
[description] [nvarchar](max) NULL
   
Equipment Table VIN Table
[styleId] [nvarchar](20) NOT NULL FOREIGN KEY to Vehicle Table
[optionType] [nvarchar](50) NOT NULL,
[optionGroup] [nvarchar](255) NOT NULL,
[optionName] [nvarchar](255) NOT NULL,
[optionValue] [nvarchar](600) NULL
[styleId] [nvarchar](20) NOT NULL FOREIGN KEY to Vehicle Table
[vin] [nvarchar](50) NOT NULL

You may also like…