Smart Irrigation Device Uptime Metrics
This dataset provides detailed operational and performance metrics for smart irrigation devices deployed across distributed farms, including uptime, downtime, water dispensed, maintenance history, and device health indicators. It enables agriculture managers and IoT teams to optimize device reliability, schedule proactive maintenance, and improve water usage efficiency at scale. The dataset supports geospatial, temporal, and farm-level analysis for robust agricultural operations management.
Sample rows
preview · 8 of 80 rows · all 17 columns| device_idstring | operational_statusstring | battery_level_percentfloat | firmware_versionstring | farm_idstring | device_location_latitudefloat | device_location_longitudefloat | device_modelstring | status_timestampdatetime | uptime_secondsinteger | downtime_secondsinteger | last_maintenance_datedate | next_maintenance_due_datedate | water_dispensed_litersfloat | signal_strength_dbmfloat | error_codestring | notesstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| DEV-001 | online | 82.7 | v2.3.1 | FARM-NW-01 | 47.6132 | -122.3356 | AquaEdge X3 | 2024-06-01T08:20:21 | 85320 | 120 | 2024-05-10 | 2024-07-10 | 3200.4 | -65.4 | blank | Device running as expected. |
| DEV-002 | maintenance | 76.1 | v2.3.1 | FARM-SE-02 | 35.0428 | -90.0216 | AquaEdge X3 | 2024-06-01T09:12:55 | 72000 | 3600 | 2024-06-01 | 2024-08-01 | 2890 | -71.2 | blank | Filters replaced during routine check. |
| DEV-003 | offline | 49.8 | v1.9.6 | FARM-CN-03 | 40.7127 | -74.0059 | RainMaster 200 | 2024-06-01T07:51:34 | 0 | 14400 | 2024-05-20 | 2024-07-20 | 0 | -80.3 | blank | Awaiting technician visit. |
| DEV-004 | online | 89.2 | v2.3.1 | FARM-NW-01 | 47.6129 | -122.3361 | AquaEdge X3 | 2024-06-01T10:03:26 | 90220 | 30 | 2024-05-15 | 2024-07-15 | 3500.9 | -63.7 | blank | No issues detected. |
| DEV-005 | error | 16.2 | v1.5.3 | FARM-SE-02 | 35.0453 | -90.0197 | HydroPulse S | 2024-06-01T06:47:10 | 60000 | 8000 | 2024-05-11 | 2024-06-30 | 2100 | -85.6 | ERR-433 | Valve stuck, requires urgent fix. |
| DEV-006 | online | 92.5 | v1.9.8 | FARM-WEST-05 | 34.0522 | -118.2437 | RainMaster 200 | 2024-06-01T11:23:17 | 95120 | 60 | 2024-05-05 | 2024-07-05 | 3980.1 | -61.2 | blank | Excellent signal, battery fully charged. |
| DEV-007 | online | 77.3 | v1.5.1 | FARM-WEST-05 | 34.0533 | -118.2445 | HydroPulse S | 2024-06-01T07:05:51 | 80330 | 90 | 2024-05-04 | 2024-07-04 | 2750.8 | -68.9 | blank | Running normally. |
| DEV-008 | maintenance | 64.3 | v1.9.6 | FARM-CN-03 | 40.7131 | -74.0072 | RainMaster 200 | 2024-06-01T08:18:31 | 50000 | 10800 | 2024-06-01 | 2024-08-01 | 1100 | -78.4 | blank | Pump replaced during maintenance. |
| DEV-009 | online | 98.7 | v2.3.1 | FARM-NW-01 | 47.6118 | -122.3347 | AquaEdge X3 | 2024-06-01T10:48:19 | 98410 | 0 | 2024-05-12 | 2024-07-12 | 4100.7 | -59.8 | blank | Top performance. |
| DEV-010 | offline | 31.4 | v1.5.4 | FARM-SE-02 | 35.0401 | -90.0182 | HydroPulse S | 2024-06-01T09:31:11 | 0 | 7200 | 2024-05-09 | 2024-07-09 | 0 | -87.1 | blank | Device not responding to remote wake. |
| DEV-011 | online | 87.9 | v2.3.2 | FARM-NW-01 | 47.6147 | -122.3339 | AquaEdge X3 | 2024-06-01T11:02:55 | 92300 | 30 | 2024-05-17 | 2024-07-17 | 3700.2 | -67.2 | blank | All sensors calibrated. |
| DEV-012 | online | 68.4 | v1.9.7 | FARM-WEST-05 | 34.0548 | -118.2412 | RainMaster 200 | 2024-06-01T08:33:22 | 88000 | 240 | 2024-05-11 | 2024-07-11 | 2999.8 | -76 | blank | Routine check completed. |
| DEV-013 | error | 12.9 | v1.5.2 | FARM-SE-02 | 35.0461 | -90.0204 | HydroPulse S | 2024-06-01T07:19:29 | 51200 | 11400 | 2024-05-16 | 2024-07-16 | 1800.5 | -93.5 | ERR-512 | Connectivity failure detected. |
| DEV-014 | online | 73.6 | v1.9.8 | FARM-CN-03 | 40.7142 | -74.0043 | RainMaster 200 | 2024-06-01T09:14:48 | 84500 | 360 | 2024-05-14 | 2024-07-14 | 3260.6 | -71.7 | blank | Water flow consistent. |
| DEV-015 | online | 84.5 | v1.5.4 | FARM-WEST-05 | 34.0513 | -118.2451 | HydroPulse S | 2024-06-01T10:59:02 | 90120 | 120 | 2024-05-13 | 2024-07-13 | 3400.7 | -66.5 | blank | No error events logged. |
| DEV-016 | offline | 25.6 | v2.3.1 | FARM-NW-01 | 47.6159 | -122.3322 | AquaEdge X3 | 2024-06-01T07:56:47 | 0 | 18000 | 2024-05-18 | 2024-07-18 | 0 | -88.8 | blank | Power interruption from grid. |
| DEV-017 | online | 61.3 | v1.5.3 | FARM-SE-02 | 35.0477 | -90.023 | HydroPulse S | 2024-06-01T06:38:10 | 75000 | 600 | 2024-05-10 | 2024-07-10 | 2700.5 | -79.1 | blank | Sprinkler replaced last week. |
| DEV-018 | online | 91.1 | v2.3.2 | FARM-NW-01 | 47.6121 | -122.3352 | AquaEdge X3 | 2024-06-01T09:41:33 | 97000 | 0 | 2024-05-19 | 2024-07-19 | 4300.2 | -62.8 | blank | Firmware updated recently. |
| DEV-019 | offline | 41.5 | v1.9.8 | FARM-WEST-05 | 34.0556 | -118.2423 | RainMaster 200 | 2024-06-01T08:57:15 | 0 | 3600 | 2024-05-18 | 2024-07-18 | 0 | -86.7 | blank | Battery recharge scheduled. |
| DEV-020 | online | 95.8 | v1.9.9 | FARM-CN-03 | 40.7108 | -74.0032 | RainMaster 200 | 2024-06-01T11:15:02 | 96010 | 60 | 2024-05-22 | 2024-07-22 | 4000.8 | -64.1 | blank | All metrics within optimal range. |
What the 80 rows show
from the 80-row sampleError (operational status) stands out: mean battery_
- 73.8median battery_
level_ percent - 7device models
- 81,127median uptime_
seconds - 380.5median downtime_
seconds - 2,307median water_
dispensed_ liters - -70.8median signal_
strength_ dbm
Median 73.8, from 8.7 to 99.0.
- string 7
- integer 2
- float 5
- date 2
- datetime 1
Columns
17 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 7 columns | |||
device_id | string | Unique identifier for each smart irrigation device | DEV-001 |
farm_id | string | Unique identifier for the farm where the device is deployed | FARM-NW-01 |
device_model | string | Model name or number of the smart irrigation device7 models · optional | AquaEdge X3 |
firmware_version | string | Current firmware version installed on the deviceoptional | v2.3.1 |
operational_status | string | Current operational status of the deviceonline · offline · maintenance · error | online |
error_code | string | Error code reported by the device, if anyoptional | ERR-433 |
notes | string | Additional notes or comments about the device status or maintenanceoptional | No issues detected. |
| Numbers 7 columns | |||
device_location_latitude | float | Latitude coordinate of the device's physical location-90 to 90 | 47.6132 |
device_location_longitude | float | Longitude coordinate of the device's physical location-180 to 180 | -122.3356 |
uptime_seconds | integer | Total number of seconds the device has been operational since last reset0 or more | 85320 |
downtime_seconds | integer | Total number of seconds the device has been non-operational since last reset0 or more | 120 |
water_dispensed_liters | float | Total volume of water dispensed by the device (in liters) during the reporting period0 or more · optional | 3200.4 |
signal_strength_dbm | float | Wireless signal strength of the device in dBm at the time of status recordingoptional | -65.4 |
battery_level_percent | float | Battery level of the device as a percentage (0-100)0 to 100 · optional | 82.7 |
| Dates and times 3 columns | |||
status_timestamp | datetime | Date and time when the device status was recorded | 2024-06-01T08:20:21 |
last_maintenance_date | date | Date when the device last underwent maintenanceoptional | 2024-05-10 |
next_maintenance_due_date | date | Scheduled date for the device's next maintenanceoptional | 2024-07-10 |
Use it for
An agriculture dashboard
Battery_
level_ percent by operational_ status and a breakdown of firmware_ version. Excel, Power BI or Tableau. Why do the 11 error rows have a mean battery_
level_ percent of 24.3? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Devices80DEV-00182.7onlineDEV-00276.1maintena…DEV-00349.8offline
A software demo
Believable devices with farm_
id, device_ location_ latitude and device_ location_ longitude to fill a screen in front of a buyer.
This dataset80 rows17 columns
Yours10,000 rows17 columnsdevice_location_latitude: UK only
blueprint · smart-irrigation-device-uptime-metrics
Behind this dataset
Same schema. As many rows as you need.
These 80 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.
Rules it was built with
- Each device reports uptime status every day
- Include fault codes for downtime events
- Capture maintenance intervention timestamps
- Track water usage per operational hour
- Devices must be uniquely identifiable
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
- smart-irrigation-device-uptime-metrics