Manufacturing Line Defect Counts

This dataset provides detailed, shift-level defect counts for each product type and manufacturing line, enabling granular quality control analysis and predictive modeling. With fields for defect categories, production volumes, and calculated defect rates, it supports both operational monitoring and advanced AI-driven analytics to improve manufacturing processes.

  • opened 48 times
  • last updated 5 Sept 2025
  • by GoMask
The brief that made it

Quality improvement and root cause analysis

Sample rows

preview · 8 of 200 rows · all 9 columns
record_idstringshiftstringdefect_ratefloatproduct_typestringdatedatedefect_typestringdefect_countintegerproduction_linestringtotal_units_producedinteger
AB12-CD34Morning0.01Widget-A2024-05-02Surface3Line-1300
EF56-GH78Afternoon0Widget-B2024-05-03Mechanical0Line-2120
IJ90-KL12Night0.12632Widget-C2024-05-04Electrical12Line-395
MN34-OP56Morning0.01481Widget-D2024-05-05Surface8Line-4540
QR78-ST90Afternoon0.0025Widget-E2024-05-06Mechanical1Line-5400
UV12-WX34Night0.04167Widget-F2024-05-07Electrical25Line-6600
YZ56-AB78MorningblankWidget-G2024-05-08Surface0Line-70
CD90-EF12Afternoon0.11Gizmo-S2024-05-09Electrical99Line-8900

What the 200 rows show

from the 200-row sample

Night shift stands out: mean defect_rate is 0.11, against 0.04 for the rest.

  • 0.03median defect_rate
  • 3defect types
  • 8production lines
  • 5median defect_count
  • 225median total_units_produced
Mean defect_rate by shift183 rows
00.510.02Morning61 rows0.06Afternoon64 rows0.11Night58 rows
defect_rate183 rows, in bands of 0.1
07515014232332100.30.6defect_rate →

Median 0.03, from 0.0 to 0.53.

product_type200 rows · 9 values
  1. Widget-A25
  2. Widget-B24
  3. Widget-C22
  4. Widget-D22
  5. Widget-F22
  6. Widget-G22
  7. Widget-E21
  8. Gizmo-S21
  9. Gizmo-T21
9 columns by typefrom the column list below
  • string 5
  • integer 2
  • float 1
  • date 1

Columns

9 columns in three groups
blueprint · 9 columns
columntypedescriptionexample
Text 5 columns
record_idstringUnique identifier for each defect count recorduniqueAB12-CD34
shiftstringProduction shift during which defects were counted (e.g., Morning, Afternoon, Night)Morning · Afternoon · NightMorning
product_typestringType or model of the product manufactured9 typesWidget-A
defect_typestringCategory or classification of the defect (e.g., Surface, Mechanical, Electrical)3 typesSurface
production_linestringIdentifier or name of the manufacturing line where the product was produced8 linesLine-1
Numbers 3 columns
defect_countintegerNumber of defects of the specified type found during the shift for the product type0 or more3
total_units_producedintegerTotal number of units produced for the product type during the shift on the production line0 or more300
defect_ratefloatCalculated rate of defects per unit produced (defect_count / total_units_produced)0 to 1 · optional0.01
Dates and times 1 column
datedateDate when the defect count was recorded2024-05-02

15 SQL practice questions for the Manufacturing Line Defect Counts

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

    High-defect records

    Return record_id, production_line and defect_count for every record where defect_count is greater than 500. Sort by defect_count from highest to lowest, then by record_id in ascending order.

    Tables: manufacturing_line_defect_counts · your result: 3 columns, 5 rows
  2. 02BeginnerFreeDISTINCT · ORDER BY

    Distinct product types

    Return each distinct product_type exactly once, sorted alphabetically.

    Tables: manufacturing_line_defect_counts · your result: 1 columns, 9 rows
  3. 03BeginnerFreeGROUP BY · COUNT

    Records per shift

    Count the records in each shift. Return shift and record_count, ordered by shift in ascending order.

    Tables: manufacturing_line_defect_counts · your result: 2 columns, 3 rows
  1. 04Total defects by lineBeginner
  2. 05Average defect rate by defect typePower BI
  3. 06Batch size bucketsIntermediate
  4. 07Defects per yearIntermediate
  5. 08Products above overall averageIntermediate
  6. 09Lines with many defectsIntermediate
  7. 10Defect ratio by shiftPower BI
  8. 11Rank lines by defectsAdvanced
  9. 12Change from previous dayAdvanced
  10. 13Running total of defectsAdvanced
  11. 14Share of defects by typeAdvanced
  12. 15Percent of total defects by linePower 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

  • median defect …0.03183 rowsmean defect rate by s…0.02Morning0.06Aftern…0.11Night

    A manufacturing dashboard

    Defect_rate by shift and a breakdown of product_type. Excel, Power BI or Tableau.

  • Why do the 58 Night rows have a mean defect_rate of 0.11?

    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 records with date, shift and product_type to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 9 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 rows9 columns
Yours1,000 rows9 columns

blueprint · manufacturing-line-defect-counts

Behind this dataset

Same schema. As many rows as you need.

These 200 rows came out of a blueprint — 9 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
  • Each entry includes shift and product type.
  • Defect count per shift required.
  • Line supervisor ID optionally included.
  • Defect reason categories flagged.
  • Zero defects allowed.
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-line-defect-counts

What should your data show?

Preview 20 rows free
No signup. No card.