auto_parts_1 category_2
Detailed part classifications with type codes, descriptions, and links to primary categories.
You are browsing sample data.
| category_2.id | category_2.ts | category_2.title | category_2.slug | category_2.parttype | category_2.description | category_1.id | category_1.ts | category_1.title | category_1.params | category_1.slug |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 2017-05-12 07:10:30 | Brake Pad | brake+pad | 1684 | Brake pads, consisting of metal backing plates and friction material, are contained in the brake caliper. When the brakes are applied, the caliper presses the brake pads against the rotor to slow or stop the vehicle. | 1 | 2017-04-08 09:50:59 | Brake & Wheel Hub | brake+&+wheel+hub | |
| 2 | 2017-05-12 07:10:30 | Hydraulic Hose | hydraulic+hose | 1792 | A hydraulic hose is a high-pressure, reinforced hose that transports brake fluid from the master cylinder to the wheels. | 1 | 2017-04-08 09:50:59 | Brake & Wheel Hub | brake+&+wheel+hub | |
| 3 | 2017-04-28 07:14:03 | Headlamp Socket | headlamp+socket | 4056 | 2 | 2017-04-08 09:50:59 | Electrical-Bulb & Socket | electrical-bulb+&+socket | ||
| 4 | 2017-04-28 07:14:08 | Ignition Condenser / Capacitor Connector | ignition+condenser+/+capacitor+connector | 15925 | 3 | 2017-04-08 09:50:59 | Electrical-Connector | electrical-connector | ||
| 5 | 2017-04-28 07:14:11 | Ignition Coil | ignition+coil | 7060 | Cylindrical or flat and square part located on the engine with a large wire attached. The ignition coil provides spark to the spark plugs. | 4 | 2017-04-08 09:50:59 | Ignition | ignition | |
| 6 | 2017-04-28 07:14:11 | Spark Plug | spark+plug | 7212 | Electrical devices found in the cylinder head of internal combustion engines. They ignite fuel by means of electrical spark. | 4 | 2017-04-08 09:50:59 | Ignition | ignition | |
| 7 | 2017-04-28 07:14:13 | Windshield Washer Pump | windshield+washer+pump | 8840 | 5 | 2017-04-08 09:50:59 | Wiper & Washer | wiper+&+washer | ||
| 8 | 2017-05-12 07:10:17 | Wiper Blade | wiper+blade | 8852 | The wiper blade is connected to the wiper arm and is visible at the base of the windshield in its resting position. When activated, the wiper blades move across the windshield and clear it from rain, snow, and other debris. | 5 | 2017-04-08 09:50:59 | Wiper & Washer | wiper+&+washer | |
| 25 | 2017-04-28 23:47:11 | Wiper Arm | wiper+arm | 8848 | Wiper arms hold the wiper blades against the windshield and connect the blades to the wiper motor. | 5 | 2017-04-08 09:50:59 | Wiper & Washer | wiper+&+washer | |
| 63 | 2017-04-28 23:48:26 | Oil Pressure Sender / Switch | oil+pressure+sender+/+switch | 4588 | The switch that indicates when oil pressure falls below a certain threshold by sending a signal to a gauge or warning light. | 50 | 2017-04-08 10:13:25 | Electrical-Switch & Relay | electrical-switch+&+relay | |
| 81 | 2017-04-28 23:49:03 | Starter Solenoid | starter+solenoid | 4188 | The starter solenoid sends a large current from the battery to the starter motor when actuated by the ignition starter switch. | 63 | 2017-04-08 10:15:45 | Electrical | electrical | |
| 234 | 2017-04-30 00:27:23 | Wheel Bearing | wheel+bearing | 1672 | Usually located in the hub or brake drum or rotor. They allow the wheel to rotate freely. | 1 | 2017-04-08 09:50:59 | Brake & Wheel Hub | brake+&+wheel+hub | |
| 235 | 2017-04-30 00:27:23 | Thermostat / Thermostat Housing / Water Outlet Seal | thermostat+/+thermostat+housing+/+water+outlet+seal | 2136 | These gaskets/seals are used to prevent coolant from passing through the thermostat if it is not open. | 175 | 2017-04-08 10:28:59 | Cooling System | cooling+system | |
| 236 | 2017-04-30 00:27:23 | Water Pump Gasket | water+pump+gasket | 2148 | Seals the water pump to the engine | 175 | 2017-04-08 10:28:59 | Cooling System | cooling+system | |
| 237 | 2017-04-30 00:27:27 | Axle Shaft Bearing | axle+shaft+bearing | 1664 | Inner and outer bearings are located along the axle shaft to support the vehicle's weight and allow the wheels to spin freely. | 176 | 2017-04-08 10:28:59 | Drivetrain | drivetrain | |
| 238 | 2017-05-12 07:10:35 | Differential Bearing | differential+bearing | 2240 | Also called carrier bearings, these are located where the axle shafts meet the differential | 176 | 2017-04-08 10:28:59 | Drivetrain | drivetrain | |
| 239 | 2017-04-30 00:27:27 | Differential Pinion Bearing | differential+pinion+bearing | 2264 | Allows the pinion shaft to turn freely with the ring gear. | 176 | 2017-04-08 10:28:59 | Drivetrain | drivetrain | |
| 240 | 2017-04-30 00:27:27 | Differential Pinion Repair Sleeve | differential+pinion+repair+sleeve | 13976 | A sleeve can be used in place of a new seal to correct shaft wear if the seal is undamaged | 176 | 2017-04-08 10:28:59 | Drivetrain | drivetrain | |
| 241 | 2017-04-30 00:27:27 | Differential Pinion Seal | differential+pinion+seal | 2380 | Seals the pinion shaft into the differential housing | 176 | 2017-04-08 10:28:59 | Drivetrain | drivetrain | |
| 242 | 2017-04-30 00:27:27 | Transfer Case Main Shaft Pilot Bearing | transfer+case+main+shaft+pilot+bearing | 8724 | Internal bearing toward the front of the transfer case through which the main shaft runs | 176 | 2017-04-08 10:28:59 | Drivetrain | drivetrain | |
| 244 | 2017-04-30 00:27:31 | Crankshaft Repair Sleeve | crankshaft+repair+sleeve | 10524 | Covers the groove worn by a full circle rear main seal | 178 | 2017-04-08 10:28:59 | Engine | engine | |
| 245 | 2017-05-12 07:09:37 | Crankshaft Seal | crankshaft+seal | 5604 | Located on the front end of the crankshaft, the seal prevents oil from leaking where the crankshaft pushes through the engine block. | 178 | 2017-04-08 10:28:59 | Engine | engine | |
| 246 | 2017-04-30 00:27:31 | Cylinder Head Gasket / Head Gasket Set | cylinder+head+gasket+/+head+gasket+set | 5412 | The gasket that sits between the engine block and the cylinder head to prevent coolant or oil from getting into the cylinders. | 178 | 2017-04-08 10:28:59 | Engine | engine | |
| 247 | 2017-04-30 00:27:31 | Cylinder Head Spacer Shim | cylinder+head+spacer+shim | 5420 | Restores valve clearance, compression ratio and cam timing in cylinder heads that have been resurfaced below factory limits. | 178 | 2017-04-08 10:28:59 | Engine | engine | |
| 248 | 2017-05-12 07:12:04 | Engine Kit Gasket Set | engine+kit+gasket+set | 10392 | Kit containing various gaskets, seals and plugs for the engine. | 178 | 2017-04-08 10:28:59 | Engine | engine | |
| 249 | 2017-04-30 00:27:31 | Harmonic Balancer Repair Sleeve | harmonic+balancer+repair+sleeve | 5408 | 178 | 2017-04-08 10:28:59 | Engine | engine | ||
| 250 | 2017-04-30 00:27:31 | Intake Manifold Gasket | intake+manifold+gasket | 5424 | The gasket located between the upper and lower intake manifolds. | 178 | 2017-04-08 10:28:59 | Engine | engine | |
| 251 | 2017-04-30 00:27:31 | Oil Drain Plug Gasket | oil+drain+plug+gasket | 5428 | 178 | 2017-04-08 10:28:59 | Engine | engine | ||
| 252 | 2017-04-30 00:27:31 | Oil Filter | oil+filter | 5340 | Removes harmful debris from the engine oil before re-circulating it back through the engine. | 178 | 2017-04-08 10:28:59 | Engine | engine | |
| 253 | 2017-04-30 00:27:31 | Oil Filter Gasket | oil+filter+gasket | 5432 | Holds the spin-on filter to the engine and prevents leaking | 178 | 2017-04-08 10:28:59 | Engine | engine | |
| 254 | 2017-04-30 00:27:31 | Oil Pan Gasket | oil+pan+gasket | 5436 | Seals the oil pan to the lower part of the engine block to prevent oil from leaking out of the engine. | 178 | 2017-04-08 10:28:59 | Engine | engine | |
| 255 | 2017-04-30 00:27:31 | Oil Pump Gasket | oil+pump+gasket | 5444 | 178 | 2017-04-08 10:28:59 | Engine | engine | ||
| 256 | 2017-04-30 00:27:31 | Oil Pump Pickup Tube Gasket | oil+pump+pickup+tube+gasket | 12436 | 178 | 2017-04-08 10:28:59 | Engine | engine | ||
| 257 | 2017-04-30 00:27:31 | Timing Cover Gasket Set | timing+cover+gasket+set | 5484 | Seals the timing cover to the engine block to keep oil in and debris out. | 178 | 2017-04-08 10:28:59 | Engine | engine | |
| 258 | 2017-04-30 00:27:31 | Timing Cover Repair Sleeve | timing+cover+repair+sleeve | 5480 | Fixes the seal groove on the harmonic balancer | 178 | 2017-04-08 10:28:59 | Engine | engine | |
| 259 | 2017-04-30 00:27:31 | Timing Cover Repair Sleeve Tool | timing+cover+repair+sleeve+tool | 10421 | 178 | 2017-04-08 10:28:59 | Engine | engine | ||
| 260 | 2017-04-30 00:27:31 | Timing Cover Seal | timing+cover+seal | 5612 | Round seal that prevents oil from leaking past the harmonic balancer | 178 | 2017-04-08 10:28:59 | Engine | engine | |
| 261 | 2017-04-30 00:27:31 | Valve Cover Gasket | valve+cover+gasket | 10710 | Seals the valve cover to the cylinder head to keep oil in the engine and debris out. | 178 | 2017-04-08 10:28:59 | Engine | engine | |
| 262 | 2017-05-12 07:09:37 | Valve Stem Seal | valve+stem+seal | 5800 | Located inside the valve spring, the valve stem seal limits the amount of oil that gets into the combustion chamber | 178 | 2017-04-08 10:28:59 | Engine | engine | |
| 263 | 2017-04-30 00:27:32 | Exhaust Manifold Gasket | exhaust+manifold+gasket | 5400 | Prevents exhaust gas from leaking between the cylinder head and the exhaust manifold | 179 | 2017-04-08 10:28:59 | Exhaust & Emission | exhaust+&+emission | |
| 264 | 2017-05-12 07:11:02 | Pipe Flange Gasket / Seal | pipe+flange+gasket+/+seal | 5836 | Also referred to as the 'donut', this gasket goes between the exhaust pipe and the manifold | 179 | 2017-04-08 10:28:59 | Exhaust & Emission | exhaust+&+emission | |
| 265 | 2017-04-30 00:27:36 | Air Cleaner Gasket | air+cleaner+gasket | 10388 | 180 | 2017-04-08 10:28:59 | Fuel & Air | fuel+&+air | ||
| 266 | 2017-04-30 00:27:36 | Carburetor Mounting Gasket | carburetor+mounting+gasket | 10024 | 180 | 2017-04-08 10:28:59 | Fuel & Air | fuel+&+air | ||
| 267 | 2017-04-30 00:27:36 | Fuel Pump Bowl Gasket | fuel+pump+bowl+gasket | 6320 | 180 | 2017-04-08 10:28:59 | Fuel & Air | fuel+&+air | ||
| 268 | 2017-04-30 00:27:36 | Fuel Pump Gasket | fuel+pump+gasket | 6316 | 180 | 2017-04-08 10:28:59 | Fuel & Air | fuel+&+air | ||
| 269 | 2017-04-30 00:27:37 | Distributor Mounting Gasket | distributor+mounting+gasket | 7148 | The distributor mounting gasket creates a seal between the distributor and cylinder head. | 4 | 2017-04-08 09:50:59 | Ignition | ignition | |
| 271 | 2017-04-30 00:27:38 | Band | band | 8460 | Steel straps with friction material on the inside edge that wrap around the drums and stop movement. Bands are connected on one end to the transmission case and on the other end to a servo | 182 | 2017-04-08 10:28:59 | Transmission-Automatic | transmission-automatic | |
| 272 | 2017-05-12 07:11:30 | Bushings | bushings | 8468 | Various transmission bushings, noted by their description | 182 | 2017-04-08 10:28:59 | Transmission-Automatic | transmission-automatic | |
| 273 | 2020-11-07 10:15:43 | Clutch Plate | clutch+plate | 7748 | Friction or steel plates that are installed in the clutch packs within the transmission assembly | 182 | 2017-04-08 10:28:59 | Transmission-Automatic | transmission-automatic | |
| 274 | 2017-04-30 00:27:38 | Control Shaft Seal | control+shaft+seal | 8620 | 182 | 2017-04-08 10:28:59 | Transmission-Automatic | transmission-automatic | ||
| category_2.id | category_2.ts | category_2.title | category_2.slug | category_2.parttype | category_2.description | category_1.id | category_1.ts | category_1.title | category_1.params | category_1.slug |
Table Overview:
The category_2 table provides 5,505 secondary part classifications, such as Brake Pad, including a parttype code and an available description of the part's function, linked to category_1 through category_1_id. The title and slug identify the classification, while description explains its typical construction or use when available. The id and ts columns identify and timestamp each category record.
Table Stats:
Size 2.31M
Columns 7
Rows (screenshot) 5,505
Rows (engine) 5,372