Usage & Publication License: database price dollar sign669.00

1985-2021 US Auto Parts Catalog Database

521,648 Car Parts & 139.85G Part Images by 217 Brands, 59 Makes, 17,299 Models, 63,076 Vehicles

database structure screenshot of 1985-2021 US Auto Parts Catalog Database

Description: With 521,648 parts by 37 years, 59 makes, 17,299 models, 41,064 sub-models or trims, 63,076 engines, and 217 manufacturers, this is the latest (1985 to 2021) and highly comprehensive United States auto parts database for your auto parts software, app, or website. Parts are also categorized by 8 tier 1 categories, further by 158 tier 2 categories, and eventually by 5,698 tier 3 categories, which all come with a large cover image each.

Other than general part fields, the part_attributes (99.4%) field carry further details of 642 unique part attributes: warranty (94.8%), location (62.0%), product fit (51.8%), series (49.5%), recommended use (45.9%), notes (35.2%), replaces OE number (28.7%), material (25.8%), type (20.9%), interchange part number (20.7%), color finish (19.5%), returns policy (19.4%), design (9.3%), components (8.7%), etc.. This data set also comes with 520,830 auto part images (139.85G) that are of high resolutions with no watermarks, averaging about 246KB per JPEG image, ready for your part store and inventory management. There are 16 tables in this database.

Data Samples
By Table / Parts (Desktop) / JSON / XML / Excel / CSV (Download)
By Table / Vehicles (Desktop) / JSON / XML / Excel / CSV (Download)

Database APIs
https://songer.datasn.com/data/api/v1/u_2926417bef71d25521f5/auto_parts_united_states/ (By Table)

Media Files
category_1_image -- Bytes: 220.58K / Files: 8
category_2_image -- Bytes: 36.74M / Files: 145
category_3_image -- Bytes: 603.09M / Files: 5,183
part_image -- Bytes: 139.85G / Files: 520,830

Data Samples (JSON, CSV, XML, Excel):
https://songer.datasn.com/data/api/v1/u_2926417bef71d25521f5/auto_parts_united_states/by_table/

Related DBs:

Database Statistics

  • Size: 10.66 GB
  • Tables: 12
  • Records: 521,648
  • Formats: MySQL, CSV, MS Excel, MS Access, XML (See Downloads for sure.)

Database Categories

Images Statistics

  • Images: 0.14T
  • Dimensions: 1200 x 1200 on average
  • Image formats: JPEG
  • Images count: 520,830
  • Reference field: {part_image.path} by {part_image.part_id} to {part.id}

Database Structure

Table Records Fields
brand 217
  1. id
  2. ts
  3. title
  4. slug
  5. count_parts
category_1 8
  1. id
  2. ts
  3. title
  4. slug
  5. count_parts
category_2 158
  1. id
  2. ts
  3. title
  4. slug
  5. category_1_id
  6. count_parts
category_3 5,698
  1. id
  2. ts
  3. title
  4. slug
  5. category_2_id
  6. count_parts
engine 63,076
  1. id
  2. ts
  3. cylinders
  4. liter
  5. year
  6. make
  7. model
  8. submodel
  9. submodel_id
  10. count_parts
make 1,608
  1. id
  2. ts
  3. title
  4. slug
  5. year_id
  6. count_parts
model 17,299
  1. id
  2. ts
  3. title
  4. slug
  5. year
  6. make
  7. make_id
  8. count_parts
part 521,648
  1. id
  2. ts
  3. part_number
  4. manufacturer_number
  5. description
  6. part_name
  7. brand
  8. brand_id
  9. category_1
  10. category_2
  11. category_3
  12. category_1_id
  13. category_2_id
  14. category_3_id
  15. is_universal
  16. price_regular
  17. price_list
  18. price_shipping
  19. price_handling
  20. price_special
  21. price_core
  22. part_title
  23. part_attributes
  24. is_best_seller
  25. is_made_to_order
  26. fit_notes
submodel 41,064
  1. id
  2. ts
  3. title
  4. slug
  5. year
  6. make
  7. model
  8. model_id
  9. count_parts
vehicle 63,076
  1. id
  2. ts
  3. year
  4. make
  5. model
  6. submodel
  7. cylinders
  8. liter
  9. year_id
  10. make_id
  11. model_id
  12. submodel_id
  13. engine_id
  14. _url
  15. count_parts
vehicle_x_part 84,796,836
  1. id
  2. ts
  3. vehicle_id
  4. part_id
year 37
  1. id
  2. ts
  3. title
  4. slug

Database Attachments

Images: This database is attached with 520,830 images. See them under the Attachments tab.


Content Scope

Below are the categories / subjects / topics this database contains record entries about and the number of entries under each of them:

make

  • Acura - 615,762
  • Audi - 2,986,932
  • BMW - 2,256,679
  • Buick - 1,139,086
  • Cadillac - 1,460,251
  • Chevrolet - 8,556,303
  • Chrysler - 1,074,784
  • Daewoo - 38,616
  • Daihatsu - 14,928
  • Dodge - 3,557,803
  • Eagle - 82,639
  • Fiat - 295,758
  • Ford - 8,881,222
  • Freightliner - 4,703,587
  • Geo - 56,630
  • GMC - 5,769,303
  • Hino - 404,004
  • Honda - 2,108,435
  • Hummer - 59,386
  • Hyundai - 2,050,462
  • Infiniti - 704,391
  • International - 2,632,750
  • Isuzu - 577,718
  • Jaguar - 760,007
  • Jeep - 1,959,320
  • Kenworth - 1,424,372
  • Kia - 1,738,609
  • Land Rover - 614,247
  • Lexus - 990,952
  • Lincoln - 777,982
  • Mack - 827,657
  • Mazda - 1,736,058
  • Mercedes Benz - 2,184,737
  • Mercury - 499,970
  • Mini - 381,374
  • Mitsubishi - 1,235,909
  • Mitsubishi Fuso - 269,979
  • Nissan - 2,808,917
  • Oldsmobile - 412,339
  • Peterbilt - 1,497,827
  • Plymouth - 246,522
  • Pontiac - 731,090
  • Porsche - 964,111
  • Ram - 1,753,115
  • Saab - 206,371
  • Saleen - 5,247
  • Saturn - 272,846
  • Scion - 99,290
  • Shelby - 2,077
  • Smart - 116,447
  • SRT - 8,196
  • Sterling - 4,500
  • Subaru - 1,476,255
  • Suzuki - 561,706
  • Tesla - 80,389
  • Toyota - 3,718,554
  • UD - 196,101
  • Volkswagen - 2,460,504
  • Volvo - 1,745,830

year

  • 2021
  • 2020
  • 2019
  • 2018
  • 2017
  • 2016
  • 2015
  • 2014
  • 2013
  • 2012
  • 2011
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • 2004
  • 2003
  • 2002
  • 2001
  • 2000
  • 1999
  • 1998
  • 1997
  • 1996
  • 1995
  • 1994
  • 1993
  • 1992
  • 1991
  • 1990
  • 1989
  • 1988
  • 1987
  • 1986
  • 1985

brand

  • Hengst - 486
  • Replacement - 82,563
  • Flowmaster - 617
  • Energy Suspension - 1,145
  • Husky Liners - 1,567
  • Curt - 2,724
  • Weathertech - 15,192
  • MBRP - 646
  • Rancho - 488
  • KC Hilites - 164
  • Prothane - 374
  • Battery Doctor - 16
  • B&M - 114
  • Funnel King - 8
  • Air Lift - 297
  • Eastern - 1,432
  • Kool Vue - 7,027
  • Newark Auto Products - 7,282
  • Precision Parts - 805
  • Spectre - 345
  • Dynomax - 375
  • JC Whitney - 874
  • TrueDrive - 19,641
  • DriveWire - 1,623
  • SureStop - 3,544
  • Powerstop - 23,183
  • GPD - 13,347
  • Moog - 10,830
  • KYB - 4,025
  • DriveMotive - 1,356
  • Schrader - 124
  • K&N - 1,864
  • Centric - 23,841
  • Walker Products - 4,804
  • 4-Seasons - 5,291
  • AC Delco - 19,543
  • Standard - 12,672
  • Mevotech - 11,221
  • Philips - 38
  • Hastings - 621
  • Beck Arnley - 4,765
  • aFe - 3,094
  • VDO - 1,426
  • Magnaflow - 4,466
  • Bilstein - 1,822
  • Quality-Built - 3,729
  • A1 Cardone - 22,079
  • Denso - 3,184
  • Stant - 574
  • Monroe - 5,980
  • Ventshade - 2,350
  • Rhino-Rack - 454
  • Purolator - 703
  • Valeo - 1,036
  • Westin - 2,875
  • DSS - 1,292
  • Dorman - 25,596
  • AEM Air - 452
  • Airaid - 388
  • Access - 944
  • Extang - 959
  • Bosch - 3,440
  • NTK - 221
  • Fram - 870
  • Hitachi - 93
  • Delphi - 2,790
  • Truxedo - 497
  • EGR - 320
  • Borla - 570
  • Dayco - 4,152
  • Mahle - 498
  • Timken - 2,738
  • Gates - 8,689
  • ReplaceXL - 8,088
  • CSF - 977
  • Strong Arm - 1,317
  • Motorcraft - 9,418
  • NGK - 309
  • BAK Industries - 555
  • Felpro - 5,798
  • GenuineXL - 3,972
  • Pro Parts - 205
  • EBC - 13
  • Hellwig - 145
  • Davico - 1,124
  • GMB - 1,010
  • Febi - 942
  • Crown - 5,805
  • Evan Fischer - 435
  • Aries - 1,188
  • Titan Fuel Tanks - 43
  • Liland - 581
  • Dee Zee - 511
  • DNJ - 8,733
  • Luverne - 858
  • Edelmann - 997
  • Switch Pros - 12
  • Arnott - 378
  • AISIN - 256
  • Mann-Filter - 286
  • Bestop - 651
  • Bushwacker - 568
  • DEA - 1,920
  • Catco - 980
  • Go Rhino - 967
  • Seat Designs - 26,745
  • Item Auto - 789
  • Baum Tools - 31
  • Cloyes - 364
  • Anzo - 1,228
  • Hayden - 26
  • Airtex - 1,401
  • Accel - 177
  • Bostech - 716
  • Belltech - 958
  • Pacer - 6
  • Painless - 204
  • Hurst - 98
  • Proform - 91
  • RT Off-Road - 375
  • Transdapt - 139
  • Teraflex - 488
  • Walker - 3,551
  • Autometer - 2,921
  • Holley - 678
  • MSD - 399
  • SPAL - 3
  • OEMTOOLS - 965
  • FEY - 55
  • Flowtech - 222
  • Sachs - 22
  • Wade Auto - 45
  • StyleLine - 14
  • Skyjacker - 967
  • PIAA - 1
  • Mr Gasket - 6
  • Performance Tool - 2
  • Plasticolor - 3
  • Mile Marker - 61
  • Corsa - 670
  • Hypertech - 663
  • Dashtop - 931
  • Lisle - 104
  • Great Neck - 25
  • Edge Products - 156
  • Smittybilt - 2
  • Tuff Stuff Overland - 38
  • APEX - 3,183
  • Superchips - 50
  • Fox - 321
  • PPE Diesel - 9
  • Yukon Gear & Axle - 1,905
  • Key Parts - 1,762
  • N-Dure - 25
  • Diablo Sport - 1
  • AutoWheels - 163
  • 4WD Pros - 1
  • Kooks - 285
  • Pacesetter - 30
  • Haynes - 145
  • Eastern Exhaust - 464
  • Bosal - 1,968
  • Perfection Clutch - 752
  • StopTech - 12
  • JW Speaker - 22
  • Centerforce - 322
  • Chilton - 86
  • Putco - 8
  • Rugged Ridge - 1
  • Lemfoerder - 85
  • Automotive Lighting - 73
  • Rain-X - 52
  • Daystar - 3
  • JP Group Dansk - 86
  • Aceon - 159
  • Fairchild Industries - 375
  • Coverlay - 3,353
  • JL - 8
  • Scott Drake Legendary Wheels - 3
  • Griffin Thermal Products - 4
  • Kee Auto Top - 553
  • Bolton Premiere - 16
  • Accu Form - 222
  • Alliance - 138
  • Nolathane - 615
  • Whiteline - 354
  • FER - 10
  • LN Engineering - 6
  • SuperSprings - 153
  • Drake Automotive - 2
  • Metro Moulded - 23
  • FCS - 2
  • Odyssey Battery - 47
  • Champion - 6
  • Eibach - 2
  • FPD - 7
  • Warn - 4
  • Ansa - 8
  • SL - 1
  • Raybestos - 3,163
  • Liqui Moly - 5
  • Recochem - 12
  • DJM Suspension - 1
  • Premium Guard Filters - 3
  • Tub O Towels - 4
  • Hooker - 1
  • MTS - 3
  • C&M Hydraulics - 2
  • Pro Comp - 7
  • Bracketron - 2
  • POD - 1
  • USA Standard Gear - 9
  • Pierburg - 4
  • Zumbrota Drivetrain - 6
  • Rekon Off Road - 1
  • Fidanza - 1
  • Hella - 1

category_1

  • Auto Body Parts & Mirrors - 50,206
  • Headlights & Lighting - 21,442
  • Engine & Drivetrain - 188,010
  • Brakes, Suspension & Steering - 143,562
  • Interior Accessories - 55,935
  • Exterior Accessories - 60,595
  • Wheels - 296
  • Tools & Garage - 1,602

category_2

  • Air Filters & Intake Systems - 13,660
  • Air Suspension Components - 774
  • Auto Body Styling & Accessories - 253
  • Axles, Driveshaft & 4WD - 12,318
  • Ball Joints & Components - 4,322
  • Brake Discs, Pads & Calipers - 51,685
  • Brake Drums, Shoes & Components - 2,453
  • Brake Hoses, Lines & Components - 6,050
  • Brake Master Cylinders, Boosters & Components - 5,629
  • Bulbs - 441
  • Bumpers & Components - 24,893
  • Cams, Timing & Valvetrain - 17,025
  • Car Covers - 4
  • Cargo Accessories, Liners & Mats - 4,131
  • Carpet & Vinyl Floor Kits - 7,241
  • Catalytic Converters & Components - 8,811
  • Clutches, Flywheels & Components - 3,309
  • Coil Springs & Components - 1,223
  • Consoles & Organizers - 156
  • Control Arms, Thrust Arms & Components - 16,194
  • Convertible Tops, Soft Tops & Components - 784
  • Corner Lights & Components - 1,056
  • Cranks, Pistons, Oil & Components - 14,558
  • Dash & Dash Accessories - 3,390
  • Decals & Graphics - 4
  • Deflectors, Bras & Shields - 1,520
  • Door Handles, Locks & Accessories - 10,275
  • Door Panels & Accessories - 515
  • Door Sheet Metal - 209
  • Electronic Control Modules, Ignition & Distributors - 7,916
  • Emblems - 112
  • Emission & Components - 1,346
  • Engine & Transmission Assemblies - 1
  • Engine & Transmission Mounts - 3,136
  • Exhaust, Headers, Manifolds Mufflers & Components - 11,466
  • Fender Flares, Vents & Accessories - 1,305
  • Fenders & Components - 5,870
  • Floor Mats & Liners - 7,818
  • Fog Lights, Driving Lights, Components & Accessories - 2,920
  • Fuel Systems & Components - 11,607
  • Fuel Tanks & Components - 1,468
  • Garage Accessories - 217
  • Gas Caps, Fuel Doors & Components - 327
  • Gauges, Meters & Monitors - 2,654
  • Grille Guards & Bull Bars - 827
  • Grilles & Components - 4,021
  • Header Panels - 210
  • Headlights, Components & Accessories - 9,830
  • Headliners & Deck Covers - 19
  • Heating, Air Conditioning & Components - 26,049
  • Hitches, Winches & Trailers - 2,872
  • Home and Garden - 2
  • Hoods & Components - 3,560
  • Horns & Components - 1
  • Intercoolers, Superchargers, Turbos & Components - 701
  • Interior Lighting & Components - 26
  • Inverter Coolers & Components - 1
  • Jacks, Lifts & Stands - 29
  • Leaf Springs & Components - 602
  • License Plate Components & Accessories - 763
  • Lift Supports & Components - 2,662
  • Liftgate & Hatch Components - 80
  • Lighting Accessories & Components - 123
  • Lowering, Leveling & Lifting Kits - 1,236
  • Lug Nuts & Bolts - 234
  • Mirrors & Components - 8,688
  • Mobile Electronics - 671
  • Nerf Bars, Running Boards & Steps - 3,134
  • OE Replica Wheels - 346
  • Off-Road Lighting - 268
  • Other Auto Body Accessories - 699
  • Other Auto Body Replacement - 6,533
  • Other Gaskets & Seals - 294
  • Other Interior - 79
  • Outdoor & Camping Gear - 23
  • Oxygen Sensors & Components - 6,018
  • Parking Brake, ABS & Other Components - 6,047
  • Pedals & Accessories - 83
  • Pet Accessories - 34
  • PM Review - 14
  • Power Programmers, Tuners, Chips & Monitors - 940
  • Power Steering Pumps & Components - 4,017
  • Quarter Panels & Components - 216
  • Radiator Support & Components - 2,228
  • Radiators, Fans, Cooling Systems & Components - 19,954
  • Repair Manuals, Videos & Software - 231
  • Rocker Panels & Accessories - 625
  • Roof Racks & Cargo Carriers - 458
  • Rust Repair & Patch Panels - 524
  • Seals & Weatherstripping - 549
  • Seats, Seat Covers & Accessories - 27,089
  • Shifter Accessories - 77
  • Shocks, Struts & Components - 18,820
  • Spare Tire Accessories - 97
  • Spark Plugs, Wires & Components - 3,390
  • Speed Sensors - 454
  • Starters, Alternators, Batteries & Components - 6,723
  • Steering Systems & Components - 1,263
  • Steering Wheels & Accessories - 277
  • Sun Visors, Shields & Accessories - 1,666
  • Sunroof Components - 55
  • Suspension Links, Rods, Bars & Components - 1,691
  • Suspension System Components - 1,647
  • Sway Bars & Components - 7,938
  • Switches, Relays, Wiring & Components - 7,511
  • Tail Lights, Back Up Lights & Accessories - 5,870
  • Tailgates & Components - 1,021
  • Third Brake Lights & Components - 192
  • Tie Rods, Steering Racks, Gearboxes & Components - 10,641
  • Tire Pressure Monitoring Systems & Components - 496
  • Tires - 2
  • Tonneau Covers & Accessories - 3,179
  • Tools - 1,125
  • Transmissions & Shifters - 2,660
  • Truck Bed & Tailgate Accessories - 783
  • Trunks & Components - 142
  • Turn Signals, Side Markers & Other Lights - 3,298
  • Wheel Covers, Caps & Simulators - 92
  • Wheel Hubs, Bearings, and Components - 8,368
  • Window Visors - 4,058
  • Windows & Components - 9,716
  • Windshield, Wipers, Washers, Accessories & Components - 3,740

Miscellaneous

Notes:

  • All part images are original and large JPEG images with no watermarks.
  • All data fields are populated 92% or more.

Defects:

  • There are no defects regarding this parts database that we know of .

Lifetime Updates (fees may apply)

This database is being constantly updated with regards to both data volume and data structure, once every 0.5 - 5 years depending on niche, and you will be notified via our Blog or Twitter when new versions come out.

Other Formats upon Request

We include the most common, popular and usable formats readily accessible on the download page, but should you need the database in other formats such as:

  • Microsoft SQL Server
  • Microsoft SQL Server Compact Edition
  • Oracle
  • PostgreSQL
  • ODBC
  • Interbase / Firebird
  • WordPress
  • Single Table (multiple tables are combined into one)
  • Microsoft Word .DOC
  • PDF

Let us know and we'll see what we can do. Additional fees may apply.


Share This Page:

Follow us at @UsableDatabases to be notified of database (data sets, lists) releases and updates.

We blog as well. Stay tuned by your preferred means so we can keep you posted on what we are working on!

Contact Us

Need assistance? We can't wait to help you find the perfect database or provide for your custom data needs! Use Custom Data Project form for serious project inquiries. Email: info@UsableDatabases.com

  1. We will get back to you at this email.

  2. What is your inquiry?

  3. How many days are there in a week? Use 1, 2, 3, ... to answer.

    Please answer the question by common sense.

Back to Top

Subscribe to our Data Press feed to be notified when we release new databases!


Be notified when new data sets are released!
You would also receive running promo discounts and updates to current databases.

Worry Free: We use FeedBurner. You may receive periodic emails / posts from us but you can very easily unsubscribe anytime.