Web Analytics Made Easy -
StatCounter

Year Make Model Trim Specs for American Market

Year-Make-Model-Trim-Specs is the best car database for people angry due to closure of Edmunds API or tired of CarQueryAPI’s missing cars, I sourced most fields from Edmunds, added 4 extra fields by myself, did few improvements in model hierarchy and created an Excel database with completeness and accuracy having no equivalent on internet.

Download free SAMPLES:
Year-Make-Model-Trim (7 columns)
Year-Make-Model-Trim-Basic-Specs (31 columns)
Year-Make-Model-Trim-Full-Specs (86 columns)
Alternate file format: CSV (Full Specs)

Buy FULL database + FREE updates for one year:

Last release: 22 September 2019, including 2949 “2019 models” and 1300 “2020 models”. Full changelog.

Contact me for custom packages, example 2010-present, SUV only, etc, useful for people deciding what used car to buy.

For people looking for more columns I offer since December 2017 second American car database, with 230 columns but less historical coverage and less accuracy. Choose which suit you better.

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) are MY 2001 onward. Vehicles sold in Canada but not in United States are NOT included here, as they are included in Year-Make-Model which is based on Wikipedia.

Apparently they changed source of data for MY 2001. The specs are consistent before and after MY 2001 except that certain fields (car price, valves, cam type) are available starting from MY 2001, and hierarchy is different, for example Mercedes C43 AMG was listed as separate model for MY 2000 and as trim under C-Class for MY 2001. I manually improved hierarchy to fix these issues.

Cars are sorted by make and model alphabetically, by year old to new (should put new cars at top?), then by trim from low to high. You are advised to NOT re-sort cars when importing in your application.

Looking for pre-1990 cars? You can use Year-Make-Model (1945-present, no trims or specs). However, I am interested to make a specs database with older cars, for my personal research and for selling to people dealing with older cars! Show me a website similar with Edmunds but with longer historical coverage, that include at least car engine size, power and dimensions, and I may create a new database for you!

List of car makes included

American domestic: AM General, Buick, Cadillac, Chevrolet, Chrysler, Dodge, Eagle, Fisker, Ford, Geo, GMC, Hummer, Jeep, Lincoln, Mercury, Oldsmobile, Panoz, Plymouth, Pontiac, Ram, Saturn, Tesla.

European imports: Alfa Romeo, Aston Martin, Audi, Bentley, BMW, Bugatti, Ferrari, Fiat, Jaguar, Lamborghini, Land Rover, Lotus, Maserati, Maybach, McLaren, Mercedes-Benz, Mini, Porsche, Rolls-Royce, Saab, Smart, Spyker, Volkswagen, Volvo.

Asian imports: Acura, Daewoo, Genesis, Honda, Hyundai, INFINITI, Isuzu, Kia, Lexus, Mazda, Mitsubishi, Nissan, Scion, Subaru, Suzuki, Toyota.

If you are not from USA and want to use this database in another country, first check list of models included in database.

See also: Analysis of American cars evolution 1990-2020.

Data fields included with % available

Naming: ID 100%, Make 100%, Model 100%, Year 100%, Trim (description) 100%.

Old naming: Trim 100%, (description) 100%.

Price, colors, image: Price 77.75%, Colors exterior 96.24%, Colors interior 81.03%, Image URL 77.47%.

Dimensions and weight: Body type 100%, Length 99.58%, Width 97.90%, Height 98.32%, Wheelbase 99.77%, Curb weight 89.59%, Gross weight 54.33%, Maximum payload 46.45%, Maximum towing capacity 53.74%.

Engine and transmission: Cylinders 99.54%, Engine size 99.56%, Horsepower 98.63%, Horsepower RPM 98.63%, Torque 98.31%, Torque RPM 98.31%, Valves 77.27%, Valve timing 54.70%, Cam type 77.21%, Drive type 100%, Transmission 99.08%.

Fuel and mileage: Engine type 99.98%, Fuel type 99.94%, Fuel tank capacity 98.92%, Combined MPG 85.44%, EPA mileage 85.18%, Range 84.29%.

Interior dimensions: Front head room 93.43%, Front hip room 76.16%, Front leg room 92.63%, Front shoulder room 90.38%, Rear head room 80.70%, Rear hip room 65.87%, Rear leg room 80.13%, Rear shoulder room 78.62%.

Other dimensions: Front track 48.61%, Rear track 48.47%, Ground clearance 63.40%, Angle of approach 26.50%, Angle of departure 26.51%, Turning circle 86.32%, Drag coefficient 19.28%, EPA interior volume 33.49%, Cargo capacity 63.38%, Maximum cargo capacity 42.07%.

Warranty: Basic 76.27%, Drivetrain 75.17%, Roadside 56.95%, Rust 29.18%, Free maintenance 18.94%, Hybrid component 2.74%, EV battery 0.28%.

Interior features: Front seats 77.70%, Rear seats 66.44%, Power features 77.38%, Instrumentation 77.51%, Convenience 77.65%, Comfort 77.23%, Memorized settings 20.19%, In car entertainment 77.49%, Telematics 0.00%.

Exterior features: Roof and glass 77.60%, Body 23.95%, Truck features 26.25%, Tires and wheels 77.71%, Doors 22.97%, Towing and hauling 45.08%.

Safety: Safety features 81.60%.

Optional features: Packages 38.15%, Exterior options 42.42%, Interior options 42.16%, Mechanical options 29.19%.

Bonus data (added from my own experience): Domestic / imported 100%, Country of origin 100%, Car classification 100%, Platform code / generation number 100%.

Percentages calculated at 15 May 2019 update (57169 trims, 86 columns).

Possible alternate databases

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?

Additional proposed format: Year-Make-Model-Dimensions, 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?

Year Make Model Specifications car database for American market

Poll

How often do you want updates? (Year-Make-Model-Trim-Specs)

Every month
Every 3 months
Every 6 months
Every year
One-time project, not interested in updates
Other
Please Specify:
Created with Poll Maker

33 comments

12 pings

Skip to comment form

    • Raman on February 15, 2019 at 2:25 am
    • Reply

    Hi

    I am looking for American Cars Database with below values only:

    Naming –> Make Model Year Trim
    Tires –>
    Wheels –>

    What will be the best option and price for these values.

    Thanks

    Raman

    1. Year-Make-Model-Trim-Specs do not have tires and wheels, for tires you can buy https://www.teoalida.com/cardatabase/american/ and for tires+wheels you can buy https://www.teoalida.com/cardatabase/wheels-and-tires-size/ (not specific to American cars)

    • Brad Carver on February 27, 2019 at 6:51 pm
    • Reply

    This data is awesome. We are using it to be able to properly spec out customers who need paint protection patterns cut for their vehicles and we would do a lot of back and forth. Now it is three questions, Make, Model and trim and most issues are resolved.

    • Matt Kruse on June 23, 2019 at 2:25 pm
    • Reply

    Awesome data set with a definitive list of trim level details. Especially helpful is the safety feature attribute. Super customer service (helped filter and create a custom package over the weekend in less than 5 minutes).

  1. […] Year-Make-Model-Trim-Specs (62 columns) […]

  2. […] Year-Make-Model-Trim-Specs (62 columns) […]

  3. […] of local people. Car Models & Engines Database collect data from European car dealers while Year-Make-Model-Trim-Specs collect data from American car […]

  4. […] 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 […]

  5. […] Year-Make-Model-Trim-Specs (86 columns) […]

Leave a Reply

Your email address will not be published.