Farm IoT Sensor Failure Logs
This dataset provides granular logs of IoT sensor failures across agricultural farms, detailing device types, failure categories, downtime, resolution actions, and environmental context. It is designed to support predictive maintenance, minimize operational disruptions, and guide technology investments for sustainable farming. The schema enables startups and farm operators to analyze patterns, optimize sensor reliability, and improve farm data collection consistency.
Sample rows
preview · 8 of 60 rows · all 19 columns| failure_idstring | failure_severitystring | downtime_minutesinteger | resolvedboolean | technician_idstring | sensor_idstring | device_typestring | farm_idstring | farm_namestring | location_latitudefloat | location_longitudefloat | failure_datetimedatetime | failure_typestring | failure_descriptionstring | resolution_datetimedatetime | resolution_actionstring | preventive_action_flagboolean | environmental_conditionsstring | sensor_installation_datedate |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| F-8134ABCD | major | 180 | true | TECH-21 | S-1001XZ | soil-moisture | FARM-001 | River Valley Farms | 41.6724 | -93.6992 | 2024-05-01T08:17:00 | hardware | Sensor casing cracked due to prolonged exposure. | 2024-05-01T12:05:00 | replaced | true | High UV index, dry soil | 2023-04-14 |
| F-2938KLMP | minor | 22 | true | TECH-13 | S-1002YZ | temperature | FARM-002 | Green Acres | 38.9847 | -92.329 | 2024-05-03T16:34:00 | connectivity | Brief signal dropout detected. | 2024-05-03T16:56:00 | reset | false | Light rain, low signal | 2023-07-02 |
| F-9281QWER | critical | 492 | true | TECH-09 | S-1003JK | humidity | FARM-003 | Sunny Fields | 36.9932 | -86.4321 | 2024-05-07T11:09:00 | power | Sensor battery depleted unexpectedly. | 2024-05-07T19:21:00 | replaced | true | Cloudy, moderate temperature | 2023-10-10 |
| F-4567ZXCV | major | 0 | false | blank | S-1004RT | weather-station | FARM-004 | Prairie Orchards | 39.1832 | -91.2391 | 2024-05-11T07:22:00 | calibration | Wind speed readings out of expected range. | blank | none | false | Calm winds, clear sky | 2022-12-20 |
| F-7890FDGH | minor | 55 | true | TECH-19 | S-1005LM | ph-sensor | FARM-002 | Green Acres | 38.9871 | -92.328 | 2024-05-13T13:40:00 | environmental | Sensor flooded after heavy rainfall. | 2024-05-13T14:35:00 | repaired | true | Heavy rain, saturated soil | 2023-08-15 |
| F-8901GHJK | critical | 210 | true | TECH-06 | S-1006OP | soil-moisture | FARM-005 | Blue Sky Ranch | 40.2518 | -95.1192 | 2024-05-15T09:24:00 | hardware | Probe corroded, unable to measure moisture. | 2024-05-15T12:54:00 | replaced | true | Wet soil, recent irrigation | 2023-09-05 |
| F-1234MNBV | minor | 12 | true | TECH-17 | S-1007QR | temperature | FARM-001 | River Valley Farms | 41.6738 | -93.7012 | 2024-05-18T15:12:00 | connectivity | Sensor lost WiFi connection. | 2024-05-18T15:24:00 | reset | false | Mild wind, clear | 2023-07-19 |
| F-5678PLKM | major | 80 | true | TECH-01 | S-1008ST | other | FARM-006 | Orchard Lane Estate | 42.1247 | -94.2214 | 2024-05-21T06:45:00 | power | Unexpected power surge during maintenance. | 2024-05-21T08:05:00 | reset | false | Cloudy, low humidity | 2023-05-29 |
| F-2468QAZX | critical | 300 | true | TECH-09 | S-1009UV | humidity | FARM-003 | Sunny Fields | 36.9921 | -86.4311 | 2024-05-23T20:19:00 | environmental | Sensor damaged by hailstorm. | 2024-05-24T01:19:00 | replaced | true | Hail, extreme wind | 2022-11-02 |
| F-1357WSXC | minor | 24 | true | TECH-03 | S-1010WX | weather-station | FARM-004 | Prairie Orchards | 39.1841 | -91.2382 | 2024-05-26T13:03:00 | hardware | Loose wiring caused intermittent readings. | 2024-05-26T13:27:00 | repaired | false | Partly cloudy, moderate wind | 2023-02-14 |
| F-8642ASDF | major | 45 | true | TECH-10 | S-1011YZ | ph-sensor | FARM-005 | Blue Sky Ranch | 40.2533 | -95.1208 | 2024-05-28T10:40:00 | calibration | pH readings drifted, recalibration required. | 2024-05-28T11:25:00 | recalibrated | true | Mild temperature, low humidity | 2023-04-30 |
| F-9753GHJK | minor | 10 | true | TECH-15 | S-1012AB | soil-moisture | FARM-006 | Orchard Lane Estate | 42.1222 | -94.2221 | 2024-05-30T17:32:00 | unknown | Unexplained drop in readings. | 2024-05-30T17:42:00 | reset | false | Clear, average soil moisture | 2023-09-17 |
| F-3201LKJN | critical | 610 | true | TECH-22 | S-1013CD | temperature | FARM-007 | Hillside Gardens | 35.9924 | -85.0197 | 2024-05-31T05:14:00 | power | Complete power failure during hot spell. | 2024-05-31T15:24:00 | replaced | true | Extreme heat wave | 2023-06-01 |
| F-4802QAZW | major | 98 | true | TECH-07 | S-1014EF | humidity | FARM-007 | Hillside Gardens | 35.9919 | -85.0185 | 2024-05-30T22:38:00 | environmental | Condensation inside sensor reported. | 2024-05-31T00:16:00 | repaired | false | High humidity, recent rainfall | 2023-11-11 |
| F-5603EDRT | critical | 380 | true | TECH-21 | S-1015GH | weather-station | FARM-001 | River Valley Farms | 41.675 | -93.698 | 2024-05-29T19:55:00 | hardware | Motherboard failure, device unresponsive. | 2024-05-30T02:15:00 | replaced | true | Thunderstorm, high winds | 2022-10-12 |
| F-6904RFGT | minor | 14 | true | TECH-10 | S-1016IJ | ph-sensor | FARM-002 | Green Acres | 38.9855 | -92.3305 | 2024-05-17T11:17:00 | calibration | Periodic recalibration required. | 2024-05-17T11:31:00 | recalibrated | false | Dry weather, stable pH | 2022-06-22 |
| F-7405TGVC | major | 144 | true | TECH-04 | S-1017KL | soil-moisture | FARM-003 | Sunny Fields | 36.9945 | -86.4333 | 2024-05-22T06:30:00 | connectivity | Network outage, sensor offline. | 2024-05-22T09:54:00 | reset | false | Overcast, damp conditions | 2023-03-05 |
| F-8106UJKO | critical | 200 | true | TECH-03 | S-1018MN | weather-station | FARM-004 | Prairie Orchards | 39.1826 | -91.2403 | 2024-05-25T15:19:00 | calibration | Barometric sensor failed calibration. | 2024-05-25T18:39:00 | recalibrated | true | Low pressure, rain | 2022-08-03 |
| F-9217SDEW | minor | 17 | true | TECH-01 | S-1019OP | other | FARM-005 | Blue Sky Ranch | 40.2509 | -95.1217 | 2024-05-20T02:07:00 | power | Intermittent power flicker observed. | 2024-05-20T02:24:00 | reset | false | Calm, mild temperature | 2023-10-30 |
| F-1328VCXD | major | 49 | true | TECH-07 | S-1020PQ | humidity | FARM-006 | Orchard Lane Estate | 42.1251 | -94.2207 | 2024-05-19T21:28:00 | environmental | High humidity caused sensor lag. | 2024-05-19T22:17:00 | repaired | false | Foggy, high humidity | 2023-12-04 |
What the 60 rows show
from the 60-row sampleCritical (failure severity) stands out: mean downtime_
- 98%resolved = true
- 48.5median downtime_
minutes - 5resolution actions
- 6device types
- 6failure types
Median 48.5, from 0 to 610.
- string 11
- integer 1
- float 2
- date 1
- datetime 2
- boolean 2
Columns
19 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 11 columns | |||
failure_id | string | Unique identifier for each sensor failure eventunique | F-8134ABCD |
sensor_id | string | Unique identifier for the IoT sensor device | S-1001XZ |
device_type | string | Type of IoT device (e.g., soil-moisture, weather-station, temperature, humidity)6 values | soil-moisture |
farm_id | string | Unique identifier for the farm where the sensor is deployed | FARM-001 |
farm_name | string | Name of the farm where the sensor is locatedoptional | River Valley Farms |
failure_type | string | Category of failure (e.g., hardware, connectivity, power, calibration, environmental)6 values | hardware |
failure_severity | string | Severity level of the failure (e.g., minor, major, critical)minor · major · critical | major |
failure_description | string | Detailed description of the failure eventoptional | Sensor tip fractured. |
resolution_action | string | Action taken to resolve the failure (e.g., replaced, repaired, reset, recalibrated)6 values · optional | replaced |
technician_id | string | Identifier for the technician or team responsible for resolutionoptional | TECH-21 |
environmental_conditions | string | Summary of environmental conditions at the time of failure (e.g., rain, high humidity, extreme temperature)optional | High UV index, dry soil |
| Numbers 3 columns | |||
location_latitude | float | Latitude coordinate of the sensor's location-90 to 90 | 41.6724 |
location_longitude | float | Longitude coordinate of the sensor's location-180 to 180 | -93.6992 |
downtime_minutes | integer | Total downtime in minutes caused by the failure0 or more · optional | 180 |
| Dates and times 3 columns | |||
failure_datetime | datetime | Timestamp when the sensor failure was detected | 2024-05-01T08:17:00 |
resolution_datetime | datetime | Timestamp when the failure was resolvedoptional | 2024-05-01T12:05:00 |
sensor_installation_date | date | Date when the sensor was installedoptional | 2023-04-14 |
| True or false 2 columns | |||
resolved | boolean | Indicates whether the failure has been resolved | true |
preventive_action_flag | boolean | Indicates if a preventive action was taken post-failureoptional | true |
Use it for
An agriculture dashboard
The resolved rate, downtime_
minutes by failure_ severity and a breakdown of technician_ id. Excel, Power BI or Tableau. Why do the 16 critical rows have a mean downtime_
minutes of 245.6? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Failures60F-8134ABCD180majorF-2938KLMP22minorF-4567ZXCV0major
A software demo
Believable failures with sensor_
id, device_ type and farm_ id to fill a screen in front of a buyer.
This dataset60 rows19 columns
Yours1,000 rows19 columnslocation_latitude: UK only
blueprint · farm-iot-sensor-failure-logs
Behind this dataset
Same schema. As many rows as you need.
These 60 rows came out of a blueprint — 19 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 row represents a single sensor failure or anomaly event
- Include device type, location (field/block), and failure time
- Log root cause classification (hardware/software/environmental)
- Record resolution time and maintenance action taken
- Sensors must be active on commercial farms; exclude prototypes
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
- farm-iot-sensor-failure-logs