D3 Cloud

Total consumption per utility for one or more sites — electricity, gas, water and heat side by side, each in its own unit. Electricity and heat are in kWh and water and gas in their own metered units, so the figures share no common scale and no total across them is meaningful. Returns columns: site, utility, total, unit, meters, months, partMonths.

consumption_by_utility

The clients this login can see, with how many sites and meters each has. In D3 Cloud a client owns sites and a site contains meters, so a client name identifies an organisation rather than a building. Returns columns: client, sites, meters.

estate_clients

Every meter at a site ranked by consumption, month by month. Returns columns: meterId, meter, location, total, unit, isMain.

consumption_by_meter

A day-by-day series, reporting how many days were estimated rather than really read. Returns columns: day, usage, estimated.

consumption_daily_series

Consumption in 30-minute or hourly intervals for one meter, built from the readings the device sent. Use it for load shape, overnight baseload, out-of-hours running and for building your own aggregations. Thirty minutes is the finest interval available — raw individual transmissions are not served, because bucketed intervals survive a missed transmission and raw readings are cumulative registers rather than consumption. Returns columns: intervalStart, consumption, register, readings, coversMinutes.

consumption_interval_series

Consumption hour by hour for one meter, in UK local time. Each value is the kWh used during that hour, which is numerically the same as the average kW demand across it — so an hourly figure answers a question asked in kW without conversion. Useful for overnight baseload, load shape and weekday-versus-weekend comparison. Built from settled readings, so it covers any period with readings rather than only recent days. Recorded for most electricity meters and some heat meters, and not for gas or water. For finer detail than an hour, use the interval series, which buckets device readings to 30 minutes over a shorter window. Returns columns: hour, usage, exported.

consumption_hourly_profile

The collector behind each meter — LoRa, M-Bus, Modbus IoT and so on — with its device identifier and when that collector last heard from it. Use it to diagnose a meter that has stopped reporting, or to see what a site is instrumented with. Returns columns: meterId, meter, site, utility, collector, device, rawValueStore, commissioned.

estate_meter_sources

The readings recorded for a meter: the cumulative register, and the consumption booked for the period ending on each date. This is what an invoice is reconciled against. The consumption column is already the difference between consecutive registers rather than a running total. Returns columns: readingDate, register, periodFrom, consumption, source, newBaseline, registerMovement, agrees.

consumption_register_readings

Meters at one or more sites, with what each measures and how it is read. Returns columns: meterId, meter, site, utility, unit, hardware, serial, mpan, location.

estate_meters

Closed monthly totals per site, counted from supply meters so submeters are not added on top. Returns columns: site, period, utility, total, unit, estimatedMonths.

consumption_monthly_by_site