Auto Parts (US), 3rd Edition

US market car parts database up to year 2010

Data Structure

brand [875]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
varchar(255)
+ slug (100%)
brand2subcategory [8,111]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
bigint(20) unsigned
+ brand_id (100%)
bigint(20) unsigned
+ subcategory_id (100%)
brand2subcategory2part [729,030]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
bigint(20) unsigned
+ brand2subcategory_id (100%)
bigint(20) unsigned
+ part_id (100%)
category [19]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
varchar(255)
+ slug (100%)
make [152]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
varchar(255)
+ slug (100%)
model [3,063]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
varchar(255)
+ slug (100%)
bigint(20) unsigned
+ make_id (100%)
model2year [21,777]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
bigint(20) unsigned
+ model_id (100%)
varchar(255)
+ year (100%)
model2year2category [268,738]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
bigint(20) unsigned
+ model2year_id (100%)
bigint(20) unsigned
+ category_id (100%)
model2year2part [15,012,595]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
bigint(20) unsigned
+ model2year_id (100%)
bigint(20) unsigned
+ part_id (100%)
part [728,534]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
bigint(20) unsigned
+ brand_id (100%)
varchar(255)
+ part_number (100%)
text
+ description (87.1%)
text
+ full_description (87.1%)
text
+ years_vehicles (67.9%)
subcategory [463]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
varchar(255)
+ slug (100%)
bigint(20) unsigned
+ category_id (100%)
year [110]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)

Description

This is the 3rd edition of The Data Planet Auto Parts database from the US automobile market for car makes, models and trims up to year 2010.
You may be interested in the 4th edition.

Data Profile

Size 2.58G
Tables 12
Last Commit 2017-04-17 00:47:27

Updates / Commits

Time Size Tables Columns Rows
2017-04-17 00:47:27 2.58G 12 53 16773467
2016-08-10 23:28:28 2.58G 12 53 16773467
2016-08-08 08:23:30 2.56G 12 53 16773467

Pricing

All prices are in Datactory Credits.

TableRowsPrice per Row (Credits)Subtotal (Credits)
brand 875 .001 0.875
brand2subcategory 8,111 .001 8.111
brand2subcategory2part 729,030 .001 729.03
category 19 .001 0.019
make 152 .001 0.152
model 3,063 .001 3.063
model2year 21,777 .001 21.777
model2year2category 268,738 .001 268.738
model2year2part 15,012,595 .001 15012.595
part 728,534 .001 728.534
subcategory 463 .001 0.463
year 110 .001 0.11
Total Credits 16773.467 Credits (1) (2)
(1). Plus cost by query time at 0.1 credits per second. A typical query takes about 0.001 seconds which would then charge you 0.0001 credits.
(2). This is the total amount of credits required for ALL rows in these tables. You are free to query for only a selected part of them, even a single row, and pay only for that.

How to Access

Click to see how to access this dataset.