North American Used Car Sales Data

Columns

• year: The manufacturing year of the vehicle, ranging from 1982 to 2015. Over 550,000 records are valid for this column.
• make: The brand or manufacturer of the car. The most common makes are Ford and Chevrolet. This column has 96 unique values.
• model: The specific model of the car, such as Altima or F-150. There are 973 unique models recorded.
• trim: Details about the vehicle's trim level, with common examples being Base and SE. This column has 1976 unique values.
• body: The body style of the car, including popular types like Sedan and SUV. There are 87 unique body styles.
• transmission: The type of transmission, predominantly automatic (85%). There are 4 unique transmission types.
• vin: The Vehicle Identification Number, a unique identifier for each car, with approximately 550,000 unique values.
• state: The US state where the car was sold, with Florida (FL) and California (CA) being frequently represented. There are 64 unique states.
• condition: A numerical rating of the car's condition, typically ranging from 1 to 5, with a mean of 3.42.
• odometer: The recorded mileage of the car at the time of sale, varying significantly from 1 to 1,000,000, with a mean of 68,300.
• color: The exterior colour of the car, with black (20%) and white (19%) being common. There are 46 unique colours.
• interior: The interior colour of the car, commonly black (44%) or grey (32%). There are 17 unique interior colours.
• seller: The name of the seller or auction house, such as Nissan-Infiniti LT and Ford Motor Credit Company, LLC. There are over 14,300 unique sellers.
• mmr: Market Mean Retail, a calculated market value for the vehicle, ranging from 25 to 182,000, with a mean of 13,800.
• sellingprice: The final price at which the car was sold at auction, ranging from 1 to 230,000, with a mean of 13,600.
• saledate: The date and time of the car's auction sale, with over 3,700 unique sale dates recorded.

Distribution

Usage

• Analysing historical pricing trends in the used car market over time and by location.
• Developing predictive models for used car values based on various vehicle attributes like year, make, model, mileage, and condition.
• Conducting market research to identify popular car makes, models, body types, and colours in the secondary market.
• Evaluating the impact of factors like mileage, condition, and transmission type on selling prices.
• (Please note: Specific use cases for this dataset were not explicitly provided in the source materials, these are derived examples based on the dataset's content.)

Coverage

License

Who Can Use It

• Data Scientists and Analysts working on machine learning models for pricing, demand forecasting, and market analysis in the automotive sector.
• Automotive Industry Professionals (e.g., dealers, manufacturers, financial services) seeking insights into auction market dynamics, competitive pricing, and vehicle depreciation.
• Researchers studying economic trends, consumer behaviour, or regional market differences in used vehicle sales.
• (Please note: Intended users and their specific use cases were not explicitly provided in the source materials, these are derived examples based on the dataset's nature.)

Dataset Name Suggestions

• Used Car Auction Sales History
• Historical Automotive Auction Prices
• North American Used Car Sales Data
• Vehicle Auction Price Records (1982-2015)
• Secondary Car Market Prices

Attributes