part_partrequest_com Used Auto Parts Marketplace: 3.6M Listings, 10.3M Images

A 2017–2018 used auto parts marketplace catalog with vehicle taxonomy, 3.6 million part listings, 10.3 million listing images, pricing, locations, image metadata, and listing attributes. automotive-parts e-commerce

  • DataBase

README

This database contains a large automotive parts catalog, combining vehicle-fitment navigation, marketplace-style part listings, images, downloaded image metadata, and key-value product details. It contains 79,986,731 rows and 10,480,746,496 bytes of data.

Catalog hierarchy

The fitment structure progresses from category_1 through accessory, type, and year. These tables provide titles and URL slugs such as catalog/wheels/volvo/xc90/2007. The year table contains 1,652,558 vehicles; its _total column is populated for 493,008 rows, while _total_worked is empty.

  • category_1: 250 top-level categories
  • accessory: 14,454 makes or accessory groupings
  • type: 285,720 vehicle models
  • year: model-year fitment records

Parts and media

The carpart table contains 3,626,980 listings with titles, slugs, prices, and shipping locations. Prices are stored as text values such as $106.25, and ships_from is populated for 3,540,350 listings. Vehicle-year records have a many-to-many relationship with parts, while parts also have a many-to-many relationship with detail records.

The image table contains 10,354,468 part-image references. Related carpart_image records provide downloaded-image metadata, including source URLs, content types, file sizes, content hashes, and storage paths; this table contains 9,997 rows. The detail table contains 4,843,002 key-value attributes, such as Designation and Manufacturer Part Number.

Most records include ingestion timestamps in ts, supporting historical or crawl-oriented analysis of the catalog.

Database Stats:

Size 9.76G
Tables 10
Columns 53
Rows 79,986,731

Database APIs:

  1. /used_auto_parts/ Used Auto Parts
    Main: /main/list/
    Main: /main/carpart_image/