Manufacturing
18 columns
200 rows
8 formats

Manufacturing Production Defect Rates

This dataset provides detailed records of defect rates in manufacturing production, including batch-level information on plant, production line, product, inspection methods, and defect types. It enables quality managers and process engineers to monitor, analyze, and optimize production quality, identify trends, and address recurring issues for improved operational efficiency.

opened 34 times
last updated 20 Aug 2025
by GoMask

The brief that made it

Quality control monitoring and reporting

Sample rows

preview · 8 of 200 rows · all 18 columns

record_idstring	inspection_methodstring	defect_ratefloat	defect_typestring	production_datedate	plant_idstring	plant_namestring	production_line_idstring	production_line_namestring	product_idstring	product_namestring	batch_numberstring	units_producedinteger	units_defectiveinteger	inspector_idstring	shiftstring	defect_descriptionstring	remarksstring
A12345-20230420	automated	0.0005	cosmetic	2023-04-20	PLT01	Midwest Assembly Plant	LINE-A1	Conveyor Assembly Line	PROD-01	GearBox X	BATCH-1001	8000	4	INSP-101	morning	Minor surface scratches on outer casing detected.	Low defect rate; routine batch. No further action required.
B54321-20240211	sampling	0	blank	2024-02-11	PLT02	Pacific Tech Plant	LINE-B2	Precision SMD Line	PROD-02	Chipster V2	BATCH-1002	3	0	INSP-102	night	blank	Prototype batch; special inspection. No defects found.
C67890-20231215	visual	0.02	functional	2023-12-15	PLT03	Eastern Components Facility	LINE-C3	Mechanical Drive Line	PROD-03	Widget Mini	BATCH-1003	1500	30	INSP-103	afternoon	Output speed variance exceeds tolerance in some units.	Defects within expected range; review scheduled.
D24680-20221006	automated	0.7	material	2022-10-06	PLT04	Southern Robotics Hub	LINE-D4	Servo Assembly Line	PROD-04	ServoDrive R	BATCH-1004	300	210	INSP-104	night	Plastic housing failed stress test on majority of units.	Batch failure; investigation initiated for supplier issue.
E13579-20210430	visual	0	blank	2021-04-30	PLT05	Northern Precision Plant	LINE-E1	PCB Print Line	PROD-05	PCB Matrix	BATCH-1005	700	0	INSP-105	morning	blank	Routine batch; no defects observed.
F11223-20230525	automated	0.02	cosmetic	2023-05-25	PLT06	Central Driveworks	LINE-F2	Die Cast Line	PROD-06	RotorMax S	BATCH-1006	2500	50	INSP-106	afternoon	Slight discoloration in paint finish detected.	Cosmetic defects within tolerance; no recall needed.
G33445-20230621	automated	0	blank	2023-06-21	PLT07	Western Machining Center	LINE-G7	Gear Machining	PROD-07	TurboGear XL	BATCH-1007	9000	0	INSP-107	morning	blank	High-volume batch; no defects, routine process.
A98765-20231103	visual	0.00033	cosmetic	2023-11-03	PLT01	Midwest Assembly Plant	LINE-A2	Packaging Line	PROD-08	Boxster Lite	BATCH-1008	6000	2	INSP-108	afternoon	Slight misprint on packaging label in two units.	Minor cosmetic issue; corrective action completed.
B87654-20230214	other	1	other	2023-02-14	PLT02	Pacific Tech Plant	LINE-B1	Assembly & Test Line	PROD-09	Tester Pro	BATCH-1009	8	8	INSP-109	night	Complete batch rejected due to incorrect firmware installation.	All units defective; special inspection for process error.
C76543-20230708	sampling	0.01	dimensional	2023-07-08	PLT03	Eastern Components Facility	LINE-C1	SMD Component Line	PROD-02	Chipster V2	BATCH-1010	1200	12	INSP-110	morning	Component height exceeds tolerance in subset of units.	Defects within expected range; batch approved.
D65432-20220816	automated	0.9	functional	2022-08-16	PLT04	Southern Robotics Hub	LINE-D1	Servo Test Line	PROD-04	ServoDrive R	BATCH-1011	500	450	INSP-111	night	Units failed startup sequence; firmware update required.	Major batch failure; recall issued for affected units.
E54321-20231201	visual	0	blank	2023-12-01	PLT05	Northern Precision Plant	LINE-E2	Precision Print Line	PROD-10	FlexiBoard S	BATCH-1012	500	0	INSP-112	morning	blank	Routine inspection; no defects found.
F43210-20230405	automated	0.005	cosmetic	2023-04-05	PLT06	Central Driveworks	LINE-F1	Rotor Assembly Line	PROD-11	RotorMax Q	BATCH-1013	2000	10	INSP-113	afternoon	Paint blemish detected on small percentage of units.	Minor cosmetic issue; resolved in subsequent batch.
G21098-20230116	visual	0.00014	cosmetic	2023-01-16	PLT07	Western Machining Center	LINE-G1	Machining Main Line	PROD-12	BoltFast T	BATCH-1014	7000	1	INSP-114	morning	Single unit with minor dent in housing.	Very low defect rate; batch meets standards.
A32109-20240402	automated	0	blank	2024-04-02	PLT01	Midwest Assembly Plant	LINE-A3	Drive Assembly Line	PROD-13	DriveChain Q	BATCH-1015	9500	0	INSP-115	afternoon	blank	Routine batch; no defects detected.
B01928-20210911	other	1	functional	2021-09-11	PLT02	Pacific Tech Plant	LINE-B3	Final Test Line	PROD-14	Tester Nano	BATCH-1016	60	60	INSP-116	night	Batch failed electrical safety test; all units defective.	Complete batch recall initiated; process review scheduled.
C92837-20240513	automated	0.0009	cosmetic	2024-05-13	PLT03	Eastern Components Facility	LINE-C2	Assembly Main Line	PROD-15	Widget Pro	BATCH-1017	10000	9	INSP-117	morning	Minor scuff marks found on several units.	Low defect rate; batch cleared for shipping.
D83726-20220722	automated	0.25	material	2022-07-22	PLT04	Southern Robotics Hub	LINE-D2	Servo Tuning Line	PROD-04	ServoDrive R	BATCH-1018	400	100	INSP-118	night	Faulty solder detected, affecting connectivity.	Defect rate high; supplier contacted for investigation.
E72635-20220610	visual	0	blank	2022-06-10	PLT05	Northern Precision Plant	LINE-E3	Flex Print Line	PROD-10	FlexiBoard S	BATCH-1019	150	0	INSP-119	afternoon	blank	Small batch, no defects detected.
F63524-20230409	automated	0.2	material	2023-04-09	PLT06	Central Driveworks	LINE-F3	Rotor QA Line	PROD-11	RotorMax Q	BATCH-1020	3000	600	INSP-120	night	Rotor shaft material below specification.	High defect rate; quality hold in place for investigation.

What the 200 rows show

from the 200-row sample

Other (inspection method) stands out: mean defect_rate is 0.79, against 0.06 for the rest.

0.01median defect_rate
3shifts
7plants
34plant names
42products
50production lines

Mean defect_rate by inspection_method200 rows

defect_rate200 rows, in bands of 0.1

Median 0.01, from 0.0 to 1.0.

defect_type140 rows with a value · 60 left blank

cosmetic47
material32
functional27
dimensional19
other15

18 columns by typefrom the column list below

string 14
integer 2
float 1
date 1

Columns

18 columns in three groups

blueprint · 18 columns
column	type	description	example
Text 14 columns
`record_id`	string	Unique identifier for each defect rate recordunique	A12345-20230420
`plant_id`	string	Unique identifier for the manufacturing plant7 plants	PLT01
`plant_name`	string	Name of the manufacturing plantoptional	Midwest Assembly Plant
`production_line_id`	string	Unique identifier for the production line	LINE-A1
`production_line_name`	string	Name or description of the production lineoptional	Conveyor Assembly Line
`product_id`	string	Unique identifier for the product manufactured	PROD-01
`product_name`	string	Name or description of the productoptional	GearBox X
`batch_number`	string	Identifier for the production batch	BATCH-1001
`defect_type`	string	Primary type of defect identified (e.g., cosmetic, functional, dimensional)cosmetic · functional · dimensional · material · other · optional	cosmetic
`defect_description`	string	Detailed description of the defect(s) found in the batchoptional	Minor surface scratches o…
`inspector_id`	string	Identifier for the quality inspector who performed the checkoptional	INSP-101
`inspection_method`	string	Method used for defect inspection (e.g., visual, automated, sampling)visual · automated · sampling · other · optional	automated
`shift`	string	Production shift during which the batch was producedmorning · afternoon · night · optional	morning
`remarks`	string	Additional notes or remarks about the batch or inspectionoptional	Low defect rate; routine …
Numbers 3 columns
`units_produced`	integer	Total number of units produced in the batch1 or more	8000
`units_defective`	integer	Number of defective units identified in the batch0 or more	4
`defect_rate`	float	Calculated defect rate for the batch (units_defective / units_produced)0 to 1	0.0005
Dates and times 1 column
`production_date`	date	Date when the production batch was completed	2023-04-20

Use it for

A manufacturing dashboard
Defect_rate by inspection_method and a breakdown of defect_type. Excel, Power BI or Tableau.
Why do the 21 other rows have a mean defect_rate of 0.79?
A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
Records200
A12345-202304200.0005automated
B54321-202402110sampling
C67890-202312150.02visual
A software demo
Believable records with production_date, plant_id and plant_name to fill a screen in front of a buyer.

This dataset200 rows18 columns

Yours10,000 rows18 columns

blueprint · manufacturing-production-defect-rates

Behind this dataset

Same schema. As many rows as you need.

These 200 rows came out of a blueprint — 18 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

Track defects by product type
Segment by batch and shift
Include defect cause
Flag high-defect periods

Rows1,000 rows10,000 rows100,000 rows1,000,000 rows

Open the blueprint in Data Factory

1 credit per row. New accounts start with 25 free credits.

Exports: CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
Licence: yours to use, including commercially
API slug: manufacturing-production-defect-rates

What should your data show?

No signup. No card.

Sample rows

What the 200 rows show

Columns

Use it for

A manufacturing dashboard

A root-cause class exercise

A software demo

Make it yours.

Same schema. As many rows as you need.

More in Manufacturing

What should your data show?