| Name | n3a5_rockauto |
|---|---|
| Data | 44.52G (+ 0B) |
| Tables | 19 (+ 0) |
| Columns | 91 (+ 0) |
| Table Rows | 116,385,439 (+ 0) |
| Media | 76.03G (+ 0B) |
| Files | 2,331,507 (+ 0) |
| Last Commit | 2023-06-19 19:26:56 (+ 169 d) |
This is an auto parts catalog data set with a total of 1,543,458 auto parts for the North America markets, including parts for models, engines, and trims of United States, Canada, and Mexico. Parts have oem numbers, price, description, images, and are classified by 257 makes, 5,965 years, 33,449 models, 61,125 engines or trims, and 629 manufacturers, etc., and also by 28 top categories and further by 5,505 secondary categories.
There are 19 tables in this database. The part images table has 4,124,444 files.
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| category_1 | 28 | title |
100%
|
| params |
0%
|
||
| slug |
100%
|
||
| category_2 | 5,505 | title |
100%
|
| slug |
100%
|
||
| parttype |
100%
|
||
| description |
32.24%
|
||
| category_1_id |
100%
|
||
| engine | 61,125 | title |
100%
|
| model_id |
100%
|
||
| slug |
100%
|
||
| carcode |
99.99%
|
||
| make |
100%
|
||
| year |
100%
|
||
| model |
100%
|
||
| engine_x_category_1 | 1,124,730 | engine_id |
100%
|
| category_1_id |
100%
|
||
| engine_x_category_1_x_category_2 | 19,828,178 | engine_x_category_1_id |
100%
|
| category_2_id |
100%
|
||
| engine_x_category_1_x_category_2_x_part | 83,570,898 | engine_x_category_1_x_category_2_id |
100%
|
| part_id |
100%
|
||
| make | 257 | title |
100%
|
| slug |
100%
|
||
| manufacturer | 629 | title |
100%
|
| manufacturer_x_part | 1,587,720 | manufacturer_id |
100%
|
| part_id |
100%
|
||
| market | 3 | title |
100%
|
| abbr |
100%
|
||
| market_x_part | 792,439 | market_id |
100%
|
| part_id |
100%
|
||
| model | 33,449 | title |
100%
|
| year_id |
100%
|
||
| slug |
100%
|
||
| make |
100%
|
||
| year |
100%
|
||
| oem_number | 1,226,989 | title |
100%
|
| oem_number_x_part | 2,429,622 | oem_number_id |
100%
|
| part_id |
100%
|
||
| part | 1,543,458 | manufacturer |
100%
|
| part_number |
100%
|
||
| alternate_oem_numbers |
41.99%
|
||
| tagline |
60.41%
|
||
| list_price |
85.03%
|
||
| description |
83.33%
|
||
| info_essential |
100%
|
||
| info_supplemental |
100%
|
||
| category_1 |
100%
|
||
| category_2 |
100%
|
||
| partkey |
100%
|
||
| part_image | 4,124,444 | part_id |
100%
|
| part_number | 50,000 | part_number |
100%
|
| year | 5,965 | title |
100%
|
| make_id |
100%
|
||
| make |
100%
|
| Size (Bytes) | Files |
|---|---|
| 76.03G | 2,331,507 |
| Time | Data | Tables | Columns | Rows | Media | Files |
|---|---|---|---|---|---|---|
| 2023-06-19 (+ 169 d) | 44.52G (+ 0B) | 19 (+ 0) | 91 (+ 0) | 116,385,439 (+ 0) | 76.03G (+ 0B) | 2,331,507 (+ 0) |
| 2023-01-01 (+ 95 d) | 44.52G (+ 18.08M) | 19 (+ 0) | 91 (+ 0) | 116,385,439 (+ 0) | 76.03G (+ 0B) | 2,331,507 (+ 0) |
| 2022-09-27 (+ 271 d) | 44.50G (+ 257.61M) | 19 (+ 1) | 91 (+ 2) | 116,385,439 (+ 185,315) | 76.03G (+ 36.61G) | 2,331,507 (+ 981,394) |
| 2021-12-30 (+ 115 d) | 44.25G (+ 2.29G) | 18 (+ 0) | 89 (+ 0) | 116,200,124 (+ 1,793,310) | 39.42G (+ 26.45G) | 1,350,113 (+ 893,871) |
| 2021-09-05 (+ 150 d) | 41.96G (+ 1.61G) | 18 (+ 0) | 89 (+ 0) | 114,406,814 (+ 16,072,056) | 12.97G (+ 0B) | 456,242 (+ 0) |
| 2021-04-08 (+ 68 d) | 40.35G (+ 15M) | 18 (+ 0) | 89 (+ 0) | 98,334,758 (+ 11,243,475) | 12.97G (+ 0B) | 456,242 (+ 0) |
| 2021-01-29 (+ 120 d) | 40.34G (- 6.78G) | 18 (+ 0) | 89 (+ 1) | 87,091,283 (- 382,612,290) | 12.97G (- 0.38T) | 456,242 (- 13,362,257) |
| 2020-10-01 (+ 38 d) | 47.11G (+ 0B) | 18 (+ 0) | 88 (+ 0) | 469,703,573 (+ 33,486,492) | 403.21G (+ 30.21G) | 13,818,499 (+ 981,791) |
| 2020-08-23 (+ 141 d) | 47.11G (+ 0B) | 18 (+ 0) | 88 (+ 0) | 436,217,081 (+ 99,975,257) | 373G (+ 78.22G) | 12,836,708 (+ 2,536,791) |
| 2020-04-04 (+ 196 d) | 47.11G (+ 36.71G) | 18 (+ 0) | 88 (+ 0) | 336,241,824 (+ 69,298,888) | 294.78G (+ 81.29G) | 10,299,917 (+ 2,837,793) |
| 2019-09-21 (+ 197 d) | 10.40G (+ 0B) | 18 (+ 0) | 88 (+ 0) | 266,942,936 (+ 85,567,309) | 213.49G (+ 88.09G) | 7,462,124 (+ 3,058,455) |
| 2019-03-07 (+ 43 d) | 10.40G (+ 0B) | 18 (+ 0) | 88 (+ 0) | 181,375,627 (+ 21,019,177) | 125.40G (+ 29.57G) | 4,403,669 (+ 986,655) |
| 2019-01-23 (+ 44 d) | 10.40G (+ 0B) | 18 (+ 0) | 88 (+ 0) | 160,356,450 (+ 20,473,707) | 95.82G (+ 17.71G) | 3,417,014 (+ 613,128) |
| 2018-12-09 (+ 29 d) | 10.40G (+ 0B) | 18 (+ 0) | 88 (+ 0) | 139,882,743 (+ 13,603,420) | 78.11G (+ 14.08G) | 2,803,886 (+ 520,139) |
| 2018-11-09 (+ 27 d) | 10.40G (+ 6.74G) | 18 (+ 0) | 88 (+ 0) | 126,279,323 (+ 8,342,634) | 64.04G (+ 11.80G) | 2,283,747 (+ 427,662) |
| 2018-10-13 (+ 29 d) | 3.66G (+ 0B) | 18 (+ 0) | 88 (+ 0) | 117,936,689 (+ 9,450,315) | 52.24G (+ 16.20G) | 1,856,085 (+ 582,642) |
| 2018-09-13 (+ 34 d) | 3.66G (+ 0B) | 18 (+ 0) | 88 (+ 0) | 108,486,374 (+ 12,514,679) | 36.04G (+ 20.75G) | 1,273,443 (+ 730,162) |
| 2018-08-09 (+ 27 d) | 3.66G (+ 0B) | 18 (+ 0) | 88 (+ 0) | 95,971,695 (+ 8,755,670) | 15.29G (+ 7.71G) | 543,281 (+ 272,660) |
| 2018-07-12 (+ 31 d) | 3.66G (+ 0B) | 18 (+ 0) | 88 (+ 0) | 87,216,025 (+ 8,609,854) | 7.58G (+ 2.78G) | 270,621 (+ 100,470) |
| 2018-06-10 (+ 31 d) | 3.66G (+ 0B) | 18 (+ 0) | 88 (+ 0) | 78,606,171 (+ 14,408,147) | 4.81G (+ 2.54G) | 170,151 (+ 88,994) |
| 2018-05-10 (+ 28 d) | 3.66G (+ 5.95M) | 18 (+ 1) | 88 (+ 0) | 64,198,024 (+ 8,499,522) | 2.27G (+ 2.27G) | 81,157 (+ 81,157) |
| 2018-04-11 (+ 38 d) | 3.66G (+ 2.44G) | 17 (+ 0) | 88 (+ 0) | 55,698,502 (+ 12,478,819) | 0B (+ 0B) | 0 (+ 0) |
| 2018-03-03 (+ 35 d) | 1.22G (+ 16.52M) | 17 (+ 0) | 88 (+ 0) | 43,219,683 (+ 15,391,797) | 0B (+ 0B) | 0 (+ 0) |
| 2018-01-27 (+ 29 d) | 1.20G (+ 0B) | 17 (+ 0) | 88 (+ 0) | 27,827,886 (+ 8,512,015) | 0B (+ 0B) | 0 (+ 0) |
| 2017-12-29 (+ 20 d) | 1.20G (+ 0B) | 17 (+ 0) | 88 (+ 0) | 19,315,871 (+ 742,524) | 0B (+ 0B) | 0 (+ 0) |
| 2017-12-08 (+ 9 d) | 1.20G (+ 0B) | 17 (+ 0) | 88 (+ 0) | 18,573,347 (+ 1,670,353) | 0B (+ 0B) | 0 (+ 0) |
| 2017-11-28 (+ 19 d) | 1.20G (+ 777.72M) | 17 (+ 1) | 88 (+ 13) | 16,902,994 (+ 4,059,806) | 0B (+ 0B) | 0 (+ 0) |
| 2017-11-09 (+ 10 d) | 450.70M (+ 0B) | 16 (+ 0) | 75 (+ 0) | 12,843,188 (+ 392,697) | 0B (+ 0B) | 0 (+ 0) |
| 2017-10-29 (+ 19 d) | 450.70M (+ 0B) | 16 (+ 0) | 75 (+ 0) | 12,450,491 (+ 1,060,252) | 0B (+ 0B) | 0 (+ 0) |
| 2017-10-10 (+ 31 d) | 450.70M (+ 0B) | 16 (+ 0) | 75 (+ 0) | 11,390,239 (+ 1,596,183) | 0B (+ 0B) | 0 (+ 0) |
| 2017-09-08 | 450.70M | 16 | 75 | 9,794,056 | 0B | 0 |
Contact us for pricing to download the latest commit / release of this database.
In the same time, you can also access this data set via API.
Select a membership plan and sign up. Return to this page, click Online Query to access the API query maker. Create and open an API call to acquire the data.
The scanning and profiling of data size increments are done separately from those of the number of rows.
Subscribe to be notified of major data releases and updates.
STAY IN THE LOOP.
