Auto Parts (US)

Database of automobile parts in the US market

Data Structure

engine [76,690]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
bigint(20) unsigned
+ submodel_id (100%)
varchar(255)
+ year (100%)
varchar(255)
+ make (100%)
varchar(255)
+ model (100%)
varchar(255)
+ submodel (100%)
engine_x_part [81,653,338]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
bigint(20) unsigned
+ engine_id (100%)
bigint(20) unsigned
+ part_id (100%)
make [3,121]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
bigint(20) unsigned
+ year_id (100%)
varchar(255)
+ year (100%)
model [23,447]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
bigint(20) unsigned
+ make_id (100%)
varchar(255)
+ year (100%)
varchar(255)
+ make (100%)
part [1,150,238]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ part_number (100%)
varchar(255)
+ part_brand (100%)
tinyint(1) unsigned
+ is_universal (2%)
varchar(255)
+ title (100%)
varchar(255)
+ manufacturer_number (100%)
varchar(255)
+ list_price (100%)
varchar(255)
+ part_name (100%)
varchar(255)
+ part_location (49.6%)
varchar(255)
+ part_series (46.1%)
submodel [45,058]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
bigint(20) unsigned
+ model_id (100%)
varchar(255)
+ year (100%)
varchar(255)
+ make (100%)
varchar(255)
+ model (100%)
year [75]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)

Description

This is an auto parts catalog database that enables the search of a specific car part by year, make, model, submodel, and engine / trim. Parts in this database are primarily for the US market. You may also be interested in Auto Parts 3 and Auto Parts 4.

Data Profile

Size 11.65G
Tables 7
Last Commit 2017-04-12 00:45:09

Updates / Commits

Time Size Tables Columns Rows
2017-04-12 00:45:09 11.65G 7 44 82951967
2016-03-06 03:13:28 10.30G 7 44 72992329
2015-11-18 02:39:20 5.23G 7 44 36106124

Pricing

All prices are in Datactory Credits.

TableRowsPrice per Row (Credits)Subtotal (Credits)
engine 76,690 .001 76.69
engine_x_part 81,653,338 .0001 8165.3338
make 3,121 .001 3.121
model 23,447 .001 23.447
part 1,150,238 .001 1150.238
submodel 45,058 .001 45.058
year 75 .001 0.075
Total Credits 9463.9628 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.