carsforsale_com
Catalog of vehicle makes, models, listing categories, vehicle details, prices, options, and associated images from CarsForSale.com. automotive e-commerce
README
This database captures a CarsForSale.com vehicle catalog, including make and model taxonomy, vehicle listings, pricing and option terms, and image references. The sample data is from July–September 2017 and includes a test dealership record, so some values should be treated as representative catalog data rather than current production inventory.
Catalog organization
The category tables represent a hierarchy from vehicle makes to models and model-year listing categories. category_1 contains top-level makes such as Acura, while category_2 contains model names such as Acura CL. category_3 adds a year-specific category and uses _total and _total_worked to record listing totals and processing progress. Slugs provide URL-oriented identifiers for each level.
A typical path through the taxonomy is:
Acura→Acura CL→2016 Acura CL- The corresponding vehicle record uses a listing-oriented
_yf_slug, such as31022368
Vehicle and listing data
The vehicle table contains listing-level information, including the displayed title, description, mileage, engine, transmission, fuel, fuel economy, drivetrain, colors, and dealer contact details. The sample description contains HTML entity encoding, and some values such as mileage and fuel economy use placeholders like Email for Mileage and N/A.
The price and option tables store normalized display values such as $9,999,999 and Front Air Conditioning. The supplied schema does not show linking columns for associating those values with individual vehicles, so those relationships should not be assumed without additional join tables or metadata.
Images
The image table associates an image URL with a vehicle through vehicle_id. vehicle_image stores harvested file metadata for an image, including its source URL, MIME type, content hash, file size, local storage path, and image_id. The content hash and generated path support deduplication and local asset management.
Identifiers and timestamps
Each record includes an internal id and a timestamp indicating when it was captured or processed. Slugs and source URLs preserve external catalog references, while fields such as category_1_id, category_2_id, vehicle_id, and image_id provide the visible relationships between taxonomy, listings, and image assets.
Database Stats:
Database APIs:
- /auto_1/ Autos 1