Factory IoT Parts Traceability
This dataset provides detailed, event-level traceability for factory parts using IoT sensor data, capturing every stage of production, operator actions, and compliance status. It enables manufacturers to monitor supply chain transparency, manage recalls efficiently, and comply with traceability regulations, supporting risk analysis and operational optimization.
Sample rows
preview · 8 of 120 rows · all 18 columns| part_idstring | production_stagestring | sensor_valuefloat | recall_flagboolean | supplier_idstring | batch_idstring | production_order_idstring | manufacturer_idstring | part_typestring | serial_numberstring | timestampdatetime | sensor_idstring | sensor_typestring | location_zonestring | operator_idstring | compliance_flagboolean | event_descriptionstring | parent_part_idstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| PT-00001 | assembly | blank | false | SUP-IRONCO | BATCH-20240601 | PO-10001 | MFG-ALPHA | gearbox | SN0000001 | 2024-06-01T08:12:10Z | SENSOR-1001 | RFID | ZONE-A | OP-101 | true | Assembly completed successfully. | blank |
| PT-00002 | inspection | blank | false | SUP-STEELCO | BATCH-20240601 | PO-10001 | MFG-ALPHA | shaft | SN0000002 | 2024-06-01T09:21:45Z | SENSOR-1002 | barcode | ZONE-B | OP-102 | true | Inspection passed; no defects found. | blank |
| PT-00003 | packaging | 37.77 | false | blank | BATCH-20240601 | PO-10001 | MFG-ALPHA | casing | SN0000003 | 2024-06-01T10:13:29Z | SENSOR-1003 | temperature | ZONE-C | OP-103 | true | Packaged at controlled temperature. | blank |
| PT-00004 | other | 12345.67 | false | blank | BATCH-20240601 | PO-10001 | MFG-ALPHA | subassembly | SN0000004 | 2024-06-01T11:05:57Z | SENSOR-1004 | other | ZONE-D | OP-104 | true | Custom event: voltage spike recorded. | PT-00001 |
| PT-00005 | assembly | blank | false | SUP-BLUECO | BATCH-20240602 | PO-10002 | MFG-BETA | bolt | SN0000005 | 2024-06-02T08:31:15Z | SENSOR-1005 | RFID | ZONE-A | OP-105 | true | Bolt assembled and tagged. | blank |
| PT-00006 | inspection | blank | true | SUP-BLUECO | BATCH-20240602 | PO-10002 | MFG-BETA | nut | SN0000006 | 2024-06-02T09:42:18Z | SENSOR-1006 | barcode | ZONE-B | OP-106 | true | Inspection reveals thread mismatch defect. | blank |
| PT-00007 | packaging | 50.5 | false | blank | BATCH-20240602 | PO-10002 | MFG-BETA | washer | SN0000007 | 2024-06-02T10:54:41Z | SENSOR-1007 | humidity | ZONE-C | OP-107 | true | Packaged with humidity check. | blank |
| PT-00008 | other | 9999.99 | false | blank | BATCH-20240602 | PO-10002 | MFG-BETA | subcomponent | SN0000008 | 2024-06-02T11:16:53Z | SENSOR-1008 | vibration | ZONE-D | blank | true | Extreme vibration event detected. | PT-00005 |
| PT-00009 | packaging | -20.5 | false | blank | BATCH-20240603 | PO-10003 | MFG-GAMMA | circuit_board | SN0000009 | 2024-06-03T10:07:12Z | SENSOR-1009 | temperature | ZONE-E | OP-108 | true | Hot-pack protocol activated. | blank |
| PT-00010 | storage | 0 | false | blank | BATCH-20240603 | PO-10003 | MFG-GAMMA | panel | SN0000010 | 2024-06-03T13:46:07Z | SENSOR-1010 | humidity | ZONE-F | OP-109 | true | Stored in dry zone. | blank |
| PT-00011 | shipping | 1.234 | false | blank | BATCH-20240603 | PO-10003 | MFG-GAMMA | frame | SN0000011 | 2024-06-03T16:07:59Z | SENSOR-1011 | other | ZONE-G | blank | true | Shipped with custom tracking. | blank |
| PT-00012 | inspection | blank | false | SUP-VALVECO | BATCH-20240603 | PO-10003 | MFG-GAMMA | valve | SN0000012 | 2024-06-03T09:59:22Z | SENSOR-1012 | barcode | ZONE-B | blank | true | Manual inspection; sensor offline. | blank |
| PT-00013 | assembly | blank | false | SUP-BLUECO | BATCH-20240604 | PO-10004 | MFG-DELTA | nut | SN0000013 | 2024-06-04T08:16:09Z | SENSOR-1013 | RFID | ZONE-A | OP-110 | true | Nut assembled and tagged. | blank |
| PT-00014 | storage | 100 | false | blank | BATCH-20240604 | PO-10004 | MFG-DELTA | filter | SN0000014 | 2024-06-04T12:15:47Z | SENSOR-1014 | humidity | ZONE-F | OP-111 | true | Stored at maximum humidity. | blank |
| PT-00015 | shipping | 12345.67 | false | blank | BATCH-20240604 | PO-10004 | MFG-DELTA | frame | SN0000015 | 2024-06-04T16:11:23Z | SENSOR-1015 | other | ZONE-G | blank | true | Shipping event: expedited protocol. | blank |
| PT-00016 | other | 0.01 | false | blank | BATCH-20240604 | PO-10004 | MFG-DELTA | subcomponent | SN0000016 | 2024-06-04T11:13:30Z | SENSOR-1016 | vibration | ZONE-D | OP-112 | true | Low vibration event recorded. | PT-00013 |
| PT-00017 | assembly | blank | false | SUP-IRONCO | BATCH-20240605 | PO-10005 | MFG-EPSILON | gearbox | SN0000017 | 2024-06-05T08:02:13Z | SENSOR-1017 | RFID | ZONE-A | OP-113 | true | Gearbox assembled and scanned. | blank |
| PT-00018 | storage | -999.99 | false | blank | BATCH-20240605 | PO-10005 | MFG-EPSILON | panel | SN0000018 | 2024-06-05T13:18:55Z | SENSOR-1018 | humidity | ZONE-F | OP-114 | true | Stored in humidity anomaly zone. | blank |
| PT-00019 | inspection | blank | true | SUP-BLUECO | BATCH-20240605 | PO-10005 | MFG-EPSILON | nut | SN0000019 | 2024-06-05T09:33:00Z | SENSOR-1019 | barcode | ZONE-B | OP-115 | true | Defect detected: thread misalignment. | blank |
| PT-00020 | assembly | blank | false | SUP-BLUECO | BATCH-20240605 | PO-10005 | MFG-EPSILON | bolt | SN0000020 | 2024-06-05T08:40:16Z | SENSOR-1020 | RFID | ZONE-A | OP-116 | true | Bolt assembly completed. | blank |
What the 120 rows show
from the 120-row sampleInspection (production stage) stands out: 9 of its 21 rows have recall_
- 8%recall_
flag = true - 37.8median sensor_
value - 6sensor types
- 14part types
- 22batches
- 22production orders
Median 37.8, from -1000.0 to 12,346.
- string 14
- float 1
- datetime 1
- boolean 2
Columns
18 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 14 columns | |||
part_id | string | Unique identifier for each part tracked in the factoryunique | PT-00001 |
batch_id | string | Identifier for the production batch to which the part belongs | BATCH-20240601 |
production_order_id | string | Identifier for the production order associated with the part | PO-10001 |
manufacturer_id | string | Unique identifier for the manufacturer or factory | MFG-ALPHA |
part_type | string | Type or category of the part | gearbox |
serial_number | string | Serial number assigned to the part for traceabilityunique | SN0000001 |
production_stage | string | Current stage of production for the part (e.g., assembly, inspection, packaging)6 values | assembly |
sensor_id | string | Unique identifier of the IoT sensor capturing data for the part | SENSOR-1001 |
sensor_type | string | Type of IoT sensor (e.g., RFID, barcode, temperature, vibration)6 values | RFID |
location_zone | string | Zone or area within the factory where the part is located during the event | ZONE-A |
operator_id | string | Identifier for the operator or worker handling the part at the time of the eventoptional | OP-101 |
event_description | string | Detailed description of the event or action taken for the partoptional | Stored in dry zone. |
supplier_id | string | Identifier for the supplier who provided the part or subcomponentoptional | SUP-IRONCO |
parent_part_id | string | Identifier of the parent part if this part is a subcomponentoptional | PT-00001 |
| Numbers 1 column | |||
sensor_value | float | Value recorded by the sensor (e.g., temperature in Celsius, vibration in Hz)optional | 37.77 |
| Dates and times 1 column | |||
timestamp | datetime | Date and time when the IoT sensor event was recorded for the part | 2024-06-01T08:12:10Z |
| True or false 2 columns | |||
compliance_flag | boolean | Indicates if the part meets regulatory traceability requirements at this stage | true |
recall_flag | boolean | Indicates if the part is flagged for recall based on sensor data or inspectionoptional | false |
Use it for
A manufacturing dashboard
The recall_
flag rate, sensor_ value by production_ stage and a breakdown of supplier_ id. Excel, Power BI or Tableau. Why do 9 of 120 rows have recall_
flag = true? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Parts120PT-00001assemblyPT-00006inspecti…PT-00019inspecti…
A software demo
Believable parts with batch_
id, production_ order_ id and manufacturer_ id to fill a screen in front of a buyer.
blueprint · factory-iot-parts-traceability
Behind this dataset
Same schema. As many rows as you need.
These 120 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.
- Each part is assigned a unique digital ID
- IoT sensors log part location and status at each station
- Status updates include timestamp, operator ID, and machine ID
- Alerts are generated for missing or delayed parts
- Data integrity checks are performed at every transfer
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
- factory-iot-parts-traceability