Auto Repair Jobs, De-identified

What Is in the File

What It Is

Each row is one job an independent auto repair business booked or quoted. Most are mobile repair at the customer's home or work in Riverside County, California, with jobs from other shops and pre-purchase inspections in other states. It covers 1,749 completed jobs, 484 cancelled jobs and 399 quotes the customer never booked, so you can see what sells and what does not.

Sources

• Supercanic mobile mechanic jobs, 2025-08 to 2026-10.
• Auto repair shops that run on Shop Desk, the shop software these jobs are recorded in. No row says which shop did the job.
• NHTSA vPIC, the free federal VIN decoder, for year, make, model, trim and engine on the 115 jobs with a VIN on file. Other jobs use the make and model the shop wrote down.

Jobs by Repair Category

Jobs by Job Type

Jobs by Make

Jobs by City

Mobile or Shop

Job Type by Make by State

Only combinations with 15 or more jobs.

Median paid is the paid final invoice before tax. Parts, labor and hours are on jobs written up with line items. Stats JSON at /api/auto-repair-jobs.json.

How It Was Checked

• The database pull returns finished fields only. Names, phones, emails, street addresses, plates, payment details, staff, photos, notes and messages never leave it.
• Job type is worked out inside the database from the job title and line items. Only the category comes back, so no free text is in the file.
• Place is cut to city, state and the first 3 ZIP digits. A city that is not a real Census place is blanked.
• Dates are cut to the month.
• No shop name, shop id or shop address is in any row, so a row does not say which shop did the work.
• VINs are cut to the first 11 characters. That is the maker, model, body, engine, model year and plant, with no serial number, so it points to a kind of car and not one car.
• Row numbers are random and do not map back to any job record. Training jobs, open jobs and duplicate entries are dropped.
• Every number on this page is for a group of 15 or more jobs.
• The free sample is a random 5 percent of jobs. A row stays only when its job type, make and state group has 15 or more jobs, and a city or ZIP3 with fewer than 15 jobs is blanked. 64 of 121 picked rows were dropped as rare.

Fields

• job_refRandom row number. It does not map back to any job record.
• vin11First 11 VIN characters: maker, model, body, engine, check digit, model year and plant. No serial number.
• model_yearModel year.
• makeMake.
• modelModel.
• trimTrim or series, from the VIN decode when there is one.
• engineEngine size and layout, from the VIN decode when there is one.
• vehicle_sourceVIN decode (NHTSA vPIC) or the shop record.
• mileage_bandOdometer band on file. Under 50k, 50k-100k, 100k-150k, 150k-200k, 200k+.
• job_typeWhat the job was, like Brake service or Battery replacement.
• repair_categoryBroader system, like Brakes or Starting and charging.
• parts_costParts billed, in dollars, when the job has line items.
• labor_costLabor billed, in dollars, when the job has line items.
• other_feesOther fees billed, like towing or storage.
• total_paidPaid final invoice subtotal before tax, completed jobs only.
• labor_hoursLabor hours billed, when labor was billed by the hour.
• cityCity of the job. Blank when we could not match it to a real place.
• stateState.
• zip3First 3 digits of the ZIP code.
• monthMonth of the job, YYYY-MM.
• service_settingmobile (at the customer) or shop. Blank when not recorded.
• outcomecompleted, cancelled, or estimate not booked.

Sample Preview

First 25 rows of the free sample. The CSV has every field.

Get the Data