Manufacturing Quality Control Dataset

This dataset provides detailed manufacturing quality control records, including batch production information, inspection results, defect types and severities, and quality scores. It enables manufacturers to monitor process performance, identify recurring issues, and drive continuous improvement in product quality and operational efficiency.

  • opened 139 times
  • last updated 20 Aug 2025
  • by GoMask
The brief that made it

Root-cause analysis of production defects

Sample rows

preview · 8 of 200 rows · all 15 columns
batch_idstringshiftstringquality_scorefloatrework_requiredbooleandefect_typestringproduction_datedateproduct_codestringoperator_idstringinspection_idstringinspection_datedatetimeinspector_idstringdefect_severityintegerdefect_countintegerfactory_locationstringcommentsstring
A1234-20240601afternoon99.7falseblank2024-06-01PRD-02OP-5691INSP-00012024-06-01T15:22:17INS-2231blank0Factory-E1No issues detected. Batch meets all quality benchmarks.
B0876-20240602morning87.4falseblank2024-06-02PRD-03OP-1674INSP-00022024-06-02T09:18:43INS-9052blank0Factory-Y7Perfect batch. No defects observed.
C4218-20240603night81.1falsescratch2024-06-03PRD-01OP-2517INSP-00032024-06-04T00:43:11INS-034211Factory-Z3Minor scratch detected but within tolerance.
D3127-20240603afternoon94.3falseblank2024-06-03PRD-04OP-0033INSP-00042024-06-03T16:08:29INS-5961blank0Factory-X0Batch exceeded benchmarks.
E2098-20240604morning77.8falsemarking2024-06-04PRD-02OP-5691INSP-00052024-06-04T08:42:14INS-905222Factory-G9Spot marking observed. No rework required.
F5921-20240605afternoon61.4truemisalignment2024-06-05PRD-03OP-7777INSP-00062024-06-05T15:17:05INS-217837Factory-A2Batch failed due to misalignment. Requires full rework.
G7423-20240606night59.2truecontamination2024-06-06PRD-02OP-0033INSP-00072024-06-07T01:02:39INS-034235Factory-X0Contamination detected. Rework required.
H9305-20240607morning69.8truemislabel2024-06-07PRD-04OP-4178INSP-00082024-06-07T10:40:15INS-223123Factory-Y7Mislabel found, batch flagged for rework.

What the 200 rows show

from the 200-row sample

Night shift stands out: 47 of its 52 rows have rework_required = true, against 13 of 148 for the rest.

  • 30%rework_required = true
  • 81.2median quality_score
  • 4product codes
  • 6factory locations
  • 10operators
  • 27inspectors
Rework required rate by shiftrework_required = true
0%50%100%6%morning4 of 6811%afternoon9 of 8090%night47 of 52

Night shift's mean quality_score is 49.0, against 89.9 for morning and 81.0 for afternoon.

quality_score200 rows, in bands of 10
0357012100171218334067rework_required below 7005070100quality_score →

Every row with quality_score under 70 has rework_required = true. None above it.

defect_type111 rows with a value · 89 left blank
  1. scratch15
  2. contamination14
  3. cracking14
  4. misalignment12
  5. marking11
  6. major_crack11
  7. discoloration10
  8. mislabel9
  9. dent9
  10. foreign_object6
15 columns by typefrom the column list below
  • string 9
  • integer 2
  • float 1
  • date 1
  • datetime 1
  • boolean 1

Columns

15 columns in four groups
blueprint · 15 columns
columntypedescriptionexample
Text 9 columns
batch_idstringUnique identifier for the production batchuniqueA1234-20240601
product_codestringCode identifying the product type manufactured in the batch4 codesPRD-02
shiftstringProduction shift during which the batch was manufacturedmorning · afternoon · nightafternoon
operator_idstringUnique identifier for the operator responsible for the batch10 operatorsOP-5691
inspection_idstringUnique identifier for the inspection recorduniqueINSP-0001
inspector_idstringUnique identifier for the inspector who performed the inspectionINS-2231
defect_typestringType of defect found during inspection (if any)10 types · optionalscratch
commentsstringAdditional comments or notes from the inspectoroptionalBatch passed all tests.
factory_locationstringName or code of the factory where the batch was produced6 locationsFactory-E1
Numbers 3 columns
quality_scorefloatOverall quality score assigned to the batch during inspection (0-100)0 to 10099.7
defect_severityintegerSeverity level of the defect (1=minor, 2=moderate, 3=major, 4=critical)1 to 4 · optional1
defect_countintegerNumber of defects of the specified type found in the batch0 or more · optional0
Dates and times 2 columns
production_datedateDate when the batch was produced2024-06-01
inspection_datedatetimeDate and time when the inspection was performed2024-06-01T15:22:17
True or false 1 column
rework_requiredbooleanIndicates if the batch requires rework due to defectsfalse

15 SQL practice questions for the Manufacturing Quality Control Dataset

Written for this data and checked against it: 12 SQL and 3 Power BI exercises from beginner to advanced. Try the first three free; the practice kit has all 15, a starter .sql file and an answer key with every expected result.

  1. 01BeginnerFreeSELECT · WHERE · ORDER BY

    Low quality batches

    Return batch_id, product_code and quality_score for every batch with a quality_score below 50. Sort the rows by quality_score from lowest to highest, and use batch_id ascending to break ties.

    Tables: manufacturing_quality_control_dataset · your result: 3 columns, 30 rows
  2. 02BeginnerFreeDISTINCT · IS NOT NULL · ORDER BY

    Distinct defect types

    Return the distinct defect_type values that are not null, in a single column named defect_type, sorted alphabetically.

    Tables: manufacturing_quality_control_dataset · your result: 1 columns, 10 rows
  3. 03BeginnerFreeGROUP BY · COUNT

    Batches per factory

    Count the batches for each factory_location. Return factory_location and batch_count, sorted by batch_count from highest to lowest, then by factory_location ascending.

    Tables: manufacturing_quality_control_dataset · your result: 2 columns, 6 rows
  1. 04Average score by shiftBeginner
  2. 05Rework defects by productPower BI
  3. 06Operators with many reworksIntermediate
  4. 07Quality grade bucketsIntermediate
  5. 08Factories below overall averageIntermediate
  6. 09Monthly defect totalsIntermediate
  7. 10Rework rate by factoryPower BI
  8. 11Rank inspectors by average scoreAdvanced
  9. 12Score change vs previous batchAdvanced
  10. 13Running defect totalAdvanced
  11. 14Defect type share of totalAdvanced
  12. 15Score anomalies by productPower BI

Get the practice kit: the full dataset, all 15 exercises, a starter .sql and the answer key. One-time $3.99.

Get the practice kit · $3.99

Use it for

  • rework required30%60 of 200 rowsmean quality score by…89.9morning81.0aftern…49.0night

    A manufacturing dashboard

    The rework_required rate, quality_score by shift and a breakdown of defect_type. Excel, Power BI or Tableau.

  • Why do 60 of 200 rows have rework_required = true?

    A root-cause class exercise

    Hand out the rows and one question. The answer is in the data, not in the brief.

  • A software demo

    Believable batches with production_date, product_code and shift to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 15 columns, your size and your rules. See 20 rows before you pay.

Preview 20 rows free

1,000 rows: $1.99 · 10,000: $12.99One-time. No subscription. All prices

This dataset200 rows15 columns
Yours1,000 rows15 columnsfactory_location: UK only

blueprint · manufacturing-quality-control-dataset

Behind this dataset

Same schema. As many rows as you need.

These 200 rows came out of a blueprint — 15 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.

Rules it was built with
  • Batch and product info logged
  • Inspection date and type recorded
  • Defect types annotated
  • Quality score assigned per batch
Rows
Open the blueprint in Data Factory

1 credit per row. Preview 20 rows free. Buy rows for the full run.

Exports
CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
Licence
yours to use, including commercially
API slug
manufacturing-quality-control-dataset

What should your data show?

Preview 20 rows free
No signup. No card.