Farm IoT Device Reliability Metrics
This dataset provides granular reliability metrics for IoT devices deployed in precision agriculture, including uptime, failure types, maintenance history, and deployment context. It empowers AgriTech startups and farm managers to optimize device lifecycles, reduce downtime, and anticipate maintenance needs, supporting scalable and resilient smart farming operations.
Sample rows
preview · 8 of 121 rows · all 17 columns| device_idstring | device_typestring | downtime_hoursfloat | is_activeboolean | last_failure_typestring | farm_idstring | deployment_locationstring | installation_datedate | last_uptime_checkdatetime | uptime_hoursfloat | failure_countinteger | last_failure_datedate | maintenance_countinteger | last_maintenance_datedate | last_maintenance_typestring | device_modelstring | firmware_versionstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| WS-KJ7F9V | weather_station | 49.2 | true | sensor_error | FARM-101 | North Field | 2018-07-18 | 2024-06-03T10:34:57Z | 41820.5 | 1 | 2023-11-09 | 7 | 2024-05-16 | firmware_update | ClimaView WX-Edge | v3.1.2 |
| IC-42X8ZP | irrigation_controller | 9560.4 | false | hardware_fault | FARM-104 | Pump Station | 2015-10-21 | 2024-06-01T08:12:22Z | 23600 | 12 | 2023-03-26 | 15 | 2023-11-02 | replacement | HydroMax Legacy | legacy-1.0 |
| SS-8C5Q2R | soil_sensor | 1.2 | true | blank | FARM-109 | Greenhouse 1 | 2024-05-16 | 2024-06-02T14:10:00Z | 33.5 | 0 | blank | 0 | blank | blank | EdgeSoil 2024 | beta-0.9 |
| DR-AGF47X | drone | 7.9 | true | power_loss | FARM-107 | South Orchard | 2022-03-29 | 2024-06-03T16:20:14Z | 1240.8 | 2 | 2023-12-10 | 2 | 2024-04-14 | firmware_update | AgriFlyer DR-210 | v4.2.0 |
| CM-FWXC14 | camera | 210.6 | true | hardware_fault | FARM-115 | Barn Roof | 2019-09-11 | 2024-06-02T21:46:20Z | 43200 | 3 | 2023-08-14 | 7 | 2024-03-28 | cleaning | FarmWatch CamPro | v2.4.1 |
| OT-EXN9Q1 | other | 0 | true | blank | FARM-112 | Experimental Plot | 2024-05-19 | 2024-06-01T09:00:30Z | 12.3 | 0 | blank | 1 | 2024-05-28 | other | Experimental Node v3 | alpha-2 |
| WS-X6P8R2 | weather_station | 60.1 | true | sensor_error | FARM-108 | East Ridge | 2020-12-03 | 2024-06-03T04:29:10Z | 29010.5 | 2 | 2023-06-18 | 6 | 2024-01-19 | firmware_update | ClimaView WX-Lite | v2.9.8 |
| IC-6J9Y2Q | irrigation_controller | 7090.7 | false | hardware_fault | FARM-103 | Drip Zone 4 | 2016-07-25 | 2024-06-01T17:42:11Z | 30230.8 | 11 | 2023-07-23 | 16 | 2024-03-30 | repair | IC-5 | v1.1.0 |
| SS-YN23H6 | soil_sensor | 9.1 | true | sensor_error | FARM-118 | Field 9 | 2022-08-04 | 2024-06-02T15:55:45Z | 580.6 | 1 | 2024-02-21 | 2 | 2024-03-07 | routine_check | ProtoSense X | v0.5.2 |
| DR-AGF115 | drone | 2.3 | true | blank | FARM-106 | Crop Circle | 2023-05-25 | 2024-06-03T18:15:10Z | 395.1 | 0 | blank | 1 | 2024-05-08 | cleaning | AgriFlyer DR-305 | v5.0.0 |
| CM-X3ZL2A | camera | 1800.2 | false | software_error | FARM-110 | Packing Shed | 2020-02-12 | 2024-06-02T12:07:31Z | 30280.5 | 9 | 2024-01-14 | 8 | 2023-11-21 | repair | FarmWatch CamX | v1.8.2 |
| OT-M4L2R3 | other | 0 | true | blank | FARM-114 | Test Bed | 2024-05-01 | 2024-06-01T11:20:55Z | 8.8 | 0 | blank | 0 | blank | blank | Experimental Node v2 | alpha-1 |
| WS-VL4N2B | weather_station | 13.6 | true | blank | FARM-113 | West Hill | 2019-03-18 | 2024-06-03T06:45:13Z | 37620.7 | 0 | blank | 8 | 2023-12-21 | routine_check | ClimaView WX-Edge | v2.5.7 |
| IC-5U7K3N | irrigation_controller | 6811.9 | false | hardware_fault | FARM-119 | Irrigation Pit | 2017-08-30 | 2024-06-03T09:11:18Z | 26490.8 | 10 | 2023-11-21 | 12 | 2024-04-19 | repair | IC-6 | v1.0.2 |
| SS-7R2V8L | soil_sensor | 3 | true | blank | FARM-117 | Greenhouse 3 | 2023-12-30 | 2024-06-01T08:59:59Z | 88.6 | 0 | blank | 1 | 2024-05-22 | routine_check | EdgeSoil 2024 | beta-1.1 |
| DR-AGF287 | drone | 19.7 | true | network_issue | FARM-104 | Central Plot | 2021-05-14 | 2024-06-02T13:29:11Z | 1980.3 | 4 | 2023-07-15 | 5 | 2023-12-10 | cleaning | AgriFlyer DR-200 | v4.9.7 |
| CM-FWXC19 | camera | 120 | true | hardware_fault | FARM-113 | Perimeter Fence | 2018-11-22 | 2024-06-02T07:43:22Z | 36890 | 2 | 2023-02-15 | 6 | 2024-02-28 | cleaning | FarmWatch CamX | v2.1.3 |
| OT-EXP2M1 | other | 0.5 | true | blank | FARM-102 | Innovation Lab | 2023-06-09 | 2024-06-01T16:17:02Z | 132.9 | 0 | blank | 0 | blank | blank | Experimental Node v1 | beta-0.5 |
| WS-4H9G2L | weather_station | 11.2 | true | blank | FARM-105 | South Field | 2017-06-20 | 2024-06-03T18:35:45Z | 48655.2 | 0 | blank | 10 | 2024-02-14 | routine_check | ClimaView WX-Edge | v3.0.7 |
| IC-3F2S9P | irrigation_controller | 7931.1 | false | hardware_fault | FARM-107 | Reservoir East | 2015-12-15 | 2024-06-02T10:25:33Z | 28400.6 | 13 | 2023-09-20 | 17 | 2024-04-04 | repair | HydroMax Legacy | legacy-2.2 |
What the 121 rows show
from the 121-row sampleIrrigation_
- 71%is_
active = true - 20.2median downtime_
hours - 6last maintenance types
- 27device models
- 20,811median uptime_
hours - 1median failure_
count
Median 20.2, from 0.0 to 10,200.
- string 8
- integer 2
- float 2
- date 3
- datetime 1
- boolean 1
Columns
17 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 8 columns | |||
device_id | string | Unique identifier for the IoT device deployed on the farmunique | WS-KJ7F9V |
farm_id | string | Unique identifier for the farm where the device is deployed | FARM-101 |
deployment_location | string | Specific location or area within the farm where the device is installed (e.g., North Field, Greenhouse 2) | North Field |
device_type | string | Type of IoT device (e.g., soil sensor, weather station, irrigation controller)6 values | weather_station |
last_failure_type | string | Type of the most recent failure (e.g., power_loss, sensor_error, network_issue, hardware_fault)6 values · optional | sensor_error |
last_maintenance_type | string | Type of the most recent maintenance action (e.g., routine_check, repair, firmware_update, cleaning)6 values · optional | firmware_update |
device_model | string | Manufacturer and model of the IoT device | ClimaView WX-Edge |
firmware_version | string | Current firmware version installed on the deviceoptional | v3.1.2 |
| Numbers 4 columns | |||
uptime_hours | float | Total number of hours the device has been operational since installation0 or more | 41820.5 |
downtime_hours | float | Total number of hours the device has been non-operational since installation0 or more | 49.2 |
failure_count | integer | Total number of failures experienced by the device0 or more | 1 |
maintenance_count | integer | Total number of maintenance actions performed on the device0 or more | 7 |
| Dates and times 4 columns | |||
installation_date | date | Date when the device was installed on the farm | 2018-07-18 |
last_uptime_check | datetime | Timestamp of the most recent uptime status check for the device | 2024-06-03T10:34:57Z |
last_failure_date | date | Date of the most recent device failureoptional | 2023-11-09 |
last_maintenance_date | date | Date of the most recent maintenance action performed on the deviceoptional | 2024-05-16 |
| True or false 1 column | |||
is_active | boolean | Indicates whether the device is currently active and deployed | true |
Use it for
An agriculture dashboard
The is_
active rate, downtime_ hours by device_ type and a breakdown of last_ failure_ type. Excel, Power BI or Tableau. Why do the 23 irrigation_
controller rows have a mean downtime_ hours of 6,887? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Devices121WS-KJ7F9V49.2weather_…IC-42X8ZP9560.4irrigati…SS-8C5Q2R1.2soil_sen…
A software demo
Believable devices with farm_
id, deployment_ location and device_ type to fill a screen in front of a buyer.
blueprint · farm-iot-device-reliability-metrics
Behind this dataset
Same schema. As many rows as you need.
These 121 rows came out of a blueprint — 17 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.
- Includes device type, install date, and manufacturer
- Tracks uptime percentage over rolling 30-day periods
- Logs failure events with standardized codes
- Records maintenance actions and time-to-resolution
- Flags devices under warranty or due for replacement
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
- farm-iot-device-reliability-metrics