PremiumDB showing the highlights and colors

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

$199.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 169MB
  • The compressed internet download size of the MySQL database (SQL dump file) is 47MB
  • The decompressed archived size is just under 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: 42784
New Records as of Jan 4, 2015: This Update occurred on Vehicle Years 2013 to Present. Since there were significant updates to all model years, we have provided FULL database versions only (No Update/Changes scripts).

VEHICLES: 44,974

2,044 UPDATED

2,190 NEW

4,234 TOTAL UPDATES

ENGINE:

2,202 UPDATED

2,900 NEW

5,102 TOTAL UPDATES

COLORS:

29,148 UPDATES

EQUIPMENT:

759,696 UPDATED

791,768 NEW

1,551,464 TOTAL UPDATES

ALL YMMT:

3,044 NEW VEHICLES (2014+)

72,292 TOTAL

VIN: 114,083

5,841 NEW VINS

Option:

158,093 UPDATED

Blazing Fast Downloads

View the screenshots!

 


Additional Information

SQL Server Versions

2008 / 2008 R2 / 2012

Database Download Size

Compressed to 113 Megabytes

Attached (.mdf) File Size

Uncompressed to 1.8 Gigabytes

Easy One Click Installer

Included – Download size: 9 Megabytes

Web Application

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

Sample Data / Demo

Haven’t looked through the demo yet? View Demo

Download a sample of the List with All associated data here: PremiumDB-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…